ASP Web Hosting | Windows Hosting Technology News

How to Create Sql Database Connection in ASP.NET Application Using C#

Posted on: July 10, 2009

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 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 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“;

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

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


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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Web Hosting Categories

Top Clicks

  • None
July 2009
« Jun   Aug »
%d bloggers like this: