SqlDataAdapter1.SelectCommand的第一个参数(存储在Parameters[0])的类型为VarChar,值是%...如果你的Sql语句中使用的是参数方式时,就需要添加这些参数...举个例子吧...SqlDataAdapter1.SelectCommand=new SqlCommand("select * from student where sname=@Sname",con);//con为连接,即SqlConnection类型//这种情况就要指定参数了...
再给你看个例子: public void CreateSqlCommand(SqlConnection myConnection, string queryString, SqlParameter[] paramArray) { SqlCommand command = new SqlCommand(queryString, myConnection); command.CommandText = "SELECT CustomerID, CompanyName FROM Customers " + "WHERE Country = @Country AND City = @City"; command.Parameters.Add(paramArray); for (int j=0; j<paramArray.Length; j++) { command.Parameters.Add(paramArray[j]) ; } string message = ""; for (int i = 0; i < command.Parameters.Count; i++) { message += command.Parameters[i].ToString() + "\n"; } Console.WriteLine(message); }
public void CreateSqlCommand(SqlConnection myConnection,
string queryString, SqlParameter[] paramArray)
{
SqlCommand command = new SqlCommand(queryString, myConnection);
command.CommandText =
"SELECT CustomerID, CompanyName FROM Customers "
+ "WHERE Country = @Country AND City = @City";
command.Parameters.Add(paramArray); for (int j=0; j<paramArray.Length; j++)
{
command.Parameters.Add(paramArray[j]) ;
} string message = "";
for (int i = 0; i < command.Parameters.Count; i++)
{
message += command.Parameters[i].ToString() + "\n";
}
Console.WriteLine(message);
}