糖炒板栗加盟出名店:vb.net是怎么样实现与sql 2005的连接的?

来源:百度文库 编辑:高校问答 时间:2024/05/09 05:52:59
如果高手们能详细的回答。我真的是100分的感激

string cn = "Data Source=192.168.0.249;User ID=yydba;Password=yydbo;Initial Catalog=yydb"
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString = cn;
oSQLConn.Open();
string strInsert = " INSERT INTO login ( users,password) VALUES ( '";
strInsert += blacklist.Text + "', '";
strInsert += blacklist.Text + " ')";
SqlCommand inst = new SqlCommand(strInsert, oSQLConn);

inst.ExecuteNonQuery();