| Author: D.Jeya kumar(JK) 07 Sep 2008 | Member Level: Diamond | Rating:  Points: 6 |
Hi,
Using the Sqlclient or OLEDB
System.Data.SqlClient.SqlConnection
sc =
new System.Data.SqlClient.SqlConnection(@"Data Source=sourcename;Initial Catalog=Dbname;"+
"Integrated Security=True")
{
sc.Open();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()
{
com.CommandType = CommandType.Text;
com.Connection = sc;
string SQLStatement = "SELECT * FROM ExampleTable";
SqlDataAdapter SQLDataAdapter = new SqlDataAdapter(SQLStatement,sc);
DataTable dtResult = new DataTable();
SQLDataAdapter.Fill(dtResult);
}
}
Regards
JK
|
| Author: AbidiP 08 Sep 2008 | Member Level: Gold | Rating: Points: 1 |
www.connectionstrings.com
|
| Author: ramya 08 Sep 2008 | Member Level: Gold | Rating: Points: 3 |
using system.data.sqlclient;
in button_click ()
{
sqlconnection cn=new sqlconnection("user id=sa;database=master;server=.');
cn.open();
messagebox.show("connected to backend");
}
|