丙寅庚寅丙戌:vb.net是怎么样实现与sql 2005的连接的?

来源:百度文库 编辑:高考问答 时间:2024/05/05 05:20:17
如果高手们能详细的回答。我真的是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();