使用SqlParameter 传参数: SqlCommand.commandtext = "SELECT * whrere id = @ID"; SqlParameter para = new SqlParameter("@ID", ...) para.Value = xxx; SqlCommand.Parameters.Add(para)
唉…… [code=C#] SqlConnection con = new SqlConnection("server=.;database=XXX;uid=sa;pwd=;"); con.Open(); SqlCommand cmd = new SqlCommand; cmd.commandtext = "SELECT * from t whrere id ='"yourtxt.Text"'"; …………………… SqlDataReader sdr = cmd.ExecuteReader(); sdr.read(); ……………………[/code]
SqlCommand.commandtext = "SELECT * whrere id = @ID"; SqlParameter para = new SqlParameter("@ID", ...)
para.Value = xxx;
SqlCommand.Parameters.Add(para)
唉……
[code=C#]
SqlConnection con = new SqlConnection("server=.;database=XXX;uid=sa;pwd=;");
con.Open(); SqlCommand cmd = new SqlCommand;
cmd.commandtext = "SELECT * from t whrere id ='"yourtxt.Text"'"; …………………… SqlDataReader sdr = cmd.ExecuteReader();
sdr.read(); ……………………[/code]
----------------------------------------------------------SqlCommand.Parameters.AddWithValue(@ID,value);
怎么赋值呢?各位大虾们