TechArena Community

TechArena Community (http://forums.techarena.in/)
-   Software Development (http://forums.techarena.in/software-development/)
-   -   How to make Database connection in ASP.NET (http://forums.techarena.in/software-development/1135108.htm)

Neil'o 05-03-2009 12:06 PM

How to make Database connection in ASP.NET
 
Hello Friends,

Can anyone suggest me the procedure about how to make Database connection in ASP.Net, I wanted to apply it into my project so please help.


Thanks for your help

pancham 05-03-2009 02:18 PM

Re: How to make Database connection in ASP.NET
 
Hi,
please add the follwoing code in you aspx.cs page.

Step 1 : Add Namspace "using System.Data.SqlClient;"

Step 2 : Make Sql connection.

Write this code to create Sql connection.
SqlConnection con = new SqlConnection("Server=You server name or comp name;Database=Yourdatabasename;Trusted_Connectopn=True");
SqlCommand cmd = new SqlCommand("Write your sql query here eg. select * from Table name");
con.Open();
DataSet ds = new DataSet(cmd,con);
SqlDataAdapter da = new SqlDataAdapter();
da.Fill(ds);
con.Close();

i hope this should work

Alejandro 05-03-2009 02:26 PM

Re: How to make Database connection in ASP.NET
 
1: Open visual studio 2005 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 2005 and open adventureworks(or you can create your own database by the Sql command CREATE DATABASE database_name), but here I am using AdventureWorks database.

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.

Code:

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();

}


leveena 25-09-2011 12:07 PM

Re: How to make Database connection in ASP.NET
 
A simple database program in VB.NET and C# , hope this will help you.

neeraja 16-11-2011 11:06 AM

Re: How to make Database connection in ASP.NET and where we have to choose that path
 
how to connect microsoft access database to asp.net and where we have to choose that path


All times are GMT +5.5. The time now is 08:23 PM.