dataset自动生成
SELECT InfoName, InfoID FROM SultdBaseInfos WHERE (InfoType = 'department')
现在想生成
SELECT InfoName, InfoID FROM SultdBaseInfos WHERE (InfoType = @prame)
但prame应该在哪赋值?
SELECT InfoName, InfoID FROM SultdBaseInfos WHERE (InfoType = 'department')
现在想生成
SELECT InfoName, InfoID FROM SultdBaseInfos WHERE (InfoType = @prame)
但prame应该在哪赋值?
string str_Sql = "SELECT InfoName, InfoID FROM SultdBaseInfos WHERE (InfoType = @prame)"
SqlDataAdapter adapter = new SqlDataAdapter(str_Sql,dbConn);
adapter.SelectCommand.Parameters.Add("@name",SqlDbType.VarChar);
adapter.SelectCommand.Parameters["@name"].Value = XXX ;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet,"use");
adapter.SelectCommand.Parameters["@name"].Value = XXX ;
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
sda.SelectCommand .Parameters .AddWithValue ("@prame",yourValue);
"SELECT InfoName, InfoID FROM SultdBaseInfos WHERE (InfoType = " + "'this.textbox.text'")