ASP Web Hosting | Windows Hosting Technology News

Archive for the ‘MS SQL Server Know How’ Category

ASP.NET Application

Simple Steps to Create SQL Database Connection in ASP.NET

** This guide is ideal for using C# codes only. Other scripts such as VB.NET will be described in other posting.

1: Open visual studio 2008 and from FILE select NEW-> WebSite, then from pop-menu select asp.net website (Note: Language must be C#) , then press OK.

2: Now create three textboxes from the toolbox , to remove ambiguity I am using default name for that textboxes and that should be textbox1,textbox2 & textbox3. And also drag & drop the button to the asp.net application.

3: Meanwhile, Open SQL SERVER Management studio 2008 and open databasename(or you can create your own database by the Sql command CREATE DATABASE database_name)

4: Then create table by clicking right mouse button and form three column, Name them according to your requirement , for your information only I used EID,name,Address. And click save button, then you’ll get a pop up menu where you have to enter the Table Name, for this example I used students.

5: Now Come Back to Visual studio Application and write the following code in the button_click event

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection myConn = new SqlConnection();
myConn.ConnectionString = “Connection string(See Below for this — )COPY PASTE HERE“;

myConn.Open();
string strqry = “Insert into students values (” + TextBox1.Text +
“,’” + TextBox2.Text + “‘,’” + TextBox3.Text + “‘)”;

SqlCommand myCom = new SqlCommand(strqry, myConn);
int numrow = myCom.ExecuteNonQuery();
myConn.Close();

}

You are invited to include your comments on the steps mentioned above of please write in another methods of accomplishing the objective stated above. Thank you.

Advertisements

Follow SeekDotNet on Twitter

Web Hosting Categories

Top Clicks

  • None
December 2017
M T W T F S S
« Sep    
 123
45678910
11121314151617
18192021222324
25262728293031