Manual Method for DataBase Connectivity to INSERT Record into DATABASE TABLE

By -
Following steps needs to be followed if you want to have a manual database connectivity
1. Dim cn as New Data.SqlClient.SqlConnection
2. Dim cm as New Data.SqlClient.SqlCommand
3. Dim str as String
4. cn.ConnectionString="Data Source = servername\sqlexpress;Initial Catalog=databasename;Integrated Security=True"
5. cm.Connection =cn
6. cm.CommandType=Data.CommandType.Text
7. str="your Insert SQL statement goes here"
8. cm.commandText=str
9. cn.open()
10. cm.ExecuteNonQuery
11. cn.Close()

I have given above statements taken into considerations your VB/ASP .net interface. You are required to change the statements accordingly, depending on the language you're working on












Comments

Post a Comment

Popular posts from this blog

How to merge Scenarios in EXCEL 2010

By -
Image
How to merge Scenarios in EXCEL 2010 Prior to starting about our title, lets have a quick recap of "What Scenario is". Scenario can be defined as " Set of combination of values, that can be created for any fixed range of cells and may be used as and when required" . Excel also offers, Scenario Summary to get values of all combinations at once, so that we may look at all available combination at a glance. Merge scenarios Select the worksheet in which to store the merged scenarios results. On the Data tab, in the Data Tools group, click What-If Analysis , and then click Scenario Manager . Click Merge . In the Merge Scenarios dialog box, click the arrow next to Book and select a workbook that contains scenarios that you want to merge in your results.   In the Sheet box, click the name of the worksheet that contains scenarios that you want to merge.  Click OK to merge the scenarios from the selected workshee...
Read more

Understanding Working of Text & Binary File in C

By -
Text file // assume that you have already created a   program file first.c and you want to display its contents on screen Ex 1: Program to show contents of any TEXT File on screen #include <stdio.h> main() {             FILE *fp;             char ch;             clrscr();             fp=fopen(“first.c”,”r”);             if (fp==NULL)             {                         printf("Cannot open file");                       ...
Read more

How to Creat a Passport Size PHOTO Sheet (32 Photos)

By -
Image
How to create a Passport size Photo Sheet Photoshop is a magic and it is a boon for designers. In Photo Studios They Also using this only. While you going to take a photo in a photo studio they will collect Maximum Rs.50 for 5 Photos. 1. Open Your Image In Photoshop  2. Now Goto Image–> Image Size Change The Image Size In The Document Size Are. Be Sure you might make changes in Cm. Also Resolution Might Be 200Pixels. Adjust The Passport size If You Need a Little bit change. (Don’t Forget To uncheck “ Constrain Proportions “) (Make Changes only inside the Document Size) 3. Edit–> Definition Pattern 4. Now Open a New Image. ( File –> New ) First Don’t care About The Image Size. After You Get a blank image in white color Goto Image–> Image Size Then Do Like The Below Image. (Make Changes only inside the Document Size) Here I choose The Size 12×8(WxH). Yo...
Read more