Question

“System.Data.SqlClient.SqlParameterCollection.Add(string, object)”已过时: 如何解决，求高手帮帮！

//创建数据连接
string sql = "select count(*) from users where username=@username and password=@password";
String strConn = "Data Source =.\\sqlexpress; Initial Catalog = Forum;integrated security=SSPI";
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@username", username);
cmd.Parameters.Add("@password",password);
conn.Open();
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
//this.Hide();//隐藏当前页
Index shouye=new Index(username);
textBox1.Text = "";
textBox2.Text = "";
shouye.ShowDialog();

//Application.Run(shouye);
//MessageBox.Show("成功登陆");
//new Form2().InitializeComponent();
}

Answer 1

那两句改为这个试试 ：cmd.Parameters.Add(new SqlParameter(("@username", username));
cmd.Parameters.Add(new SqlParameter("@password",password));