在C#中制作的窗体怎么连接到数据库

来源:百度知道 编辑:UC知道 时间:2024/05/08 10:28:05

同web程序。代码块例:
private const string strConn=\"workstation id=E7E711B8FBAA478;packet size=4096;integrated security=SSPI;data source=.;persist security info=False;initial catalog=MusicManagment\";
private SqlConnection con=new SqlConnection(strConn);;
private SqlCommand cmd=con.CreateCommand();;
private SqlDataAdapter da;

String strSQL=\"Wea_SelCity\";
cmd.CommandText=strSQL;
cmd.CommandType=CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
con.Close();

using System.data.sqlClict;
Sqlconnection con=new SqlConnection("data source=.;uID=;password=;initial catalog=");
con.open();