string connString="";
connString = @"Persist Security Info=False; PWD=sa; User ID=sa;Initial Catalog=northwind;Data Source=(local)";
this.sqlConnection1.ConnectionString = connString;
connString = @"Persist Security Info=False; PWD=sa; User ID=sa;Initial Catalog=northwind;Data Source=(local)";
this.sqlConnection1.ConnectionString = connString;
{
System.Data.SqlClient.SqlConnection conn =
new System.Data.SqlClient.SqlConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString =
"integrated security=SSPI;data source=SQL Server Name;" +
"persist security info=False;initial catalog=northwind";
try
{
conn.Open();
// Insert code to process data.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}
using System.Data.SqlClient;
SqlConnection mycnn= new SqlConnection("Server=ZHURONGj;Database=学生管理数据库;User id=dazhu2;Password=32010;trusted_connection=true");
mycnn.Open();
if(mycnn.State==System.Data.ConnectionState.Open)
{
MessageBox.Show(" 数据库连接成功!","提示",System.Windows.Forms.MessageBoxButtons.OK,System.Windows.Forms.MessageBoxIcon.Information);
SqlDataReader sdrSchema;
DataTable dtSchema;
SqlCommand cmdTemp=new SqlCommand("select * from 学生情况表",mycnn);
sdrSchema=cmdTemp.ExecuteReader (CommandBehavior.KeyInfo);
dtSchema=sdrSchema.GetSchemaTable (); //用SqlDataReader 获得一个架构表,表里的内容是一个查询返回的每个列的信息
this.dataGrid1.DataSource=dtSchema.DefaultView;
sdrSchema.Close ();
}
可以在后台代码中直接编程;2 knoros2005(JJYY)的方法也对;
可以在Form 窗体的设计器中,从工具箱(ToolBox)中直接拖进
一个Connection控件到Form 窗体的设计器中,通过属性面板设置
Connection的属性就可以了。