Question

sql SqlParameter 怎么用的

Answer 1

string sqlcom = "select * from test where id =@id and name = @name";
SqlDataAdapter sqldataadapter = new SqlDataAdapter();
sqldataadapter.SelectCommand = sqlCmd;
SqlParameter para2 = new SqlParameter("id", SqlDbType.VarChar, 10);
para2.Value = "1";
SqlParameter para3 = new SqlParameter("name", "1");
SqlParameter[] para = { para2, para3 };
foreach (SqlParameter te in para)
{
sqldataadapter.SelectCommand.Parameters.Add(te);
}