How to connect to SQL Server with asp.net

Question

I want to connect to SQL Server with ASP.NET. Can any one give me some sample program to do so?

Answer 1

Here's an example

http://www.beansoftware.com/ASP.NET-Tutorials/ASP.NET-SQL-Server.aspx

Good Luck!

Answer 2

Simple example for this :-

More detail on link : http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson02.aspx

using System.Data;
using System.Data.SqlClient;

string Connection = "server=ALDAN; uid=sa; pwd=sa; database=GAZCAD; Connect Timeout=10000";

SqlConnection DataConnection = new SqlConnection(Connection);
// the string with T-SQL statement, pay attention: no semicolon at the end of //the statement
string Command = "INSERT INTO myTable VALUES (1,100)";
// create the SQLCommand instance
SQLCommand DataCommand = new SqlCommand(Command, DataConnection);
// open the connection with our database
DataCommand.Connection.Open();
// execute the statement and return the number of affected rows
int i = DataCommand.ExecuteNonQuery();
//close the connection
DataCommand.Connection.Close();

Answer 3

June R's example is inserting data.

using System.Data;
using System.Data.SqlClient;

string Connection = "server=ALDAN; uid=sa; pwd=sa; database=GAZCAD; Connect Timeout=10000";

SqlConnection DataConnection = new SqlConnection(Connection);
// the string with T-SQL statement, pay attention: no semicolon at the end of //the statement
string Command = "Select * from myTable";
// create the SQLCommand instance
SQLCommand DataCommand = new SqlCommand(Command, DataConnection);
// open the connection with our database
DataCommand.Connection.Open();
// Data adapter
SqlDataAdapter da = new SqlDataAdapter(DataCommand);
// To fill data, i need a datatable.
DataTable dt = new DataTable();
// Filling my table
da.Fill(dt);