110,538
社区成员
发帖
与我相关
我的任务
分享
public SqlCommand SetCommandText(SqlCommand sqlCmd, string sqlCmdText)
{
sqlCmd.CommandText = sqlCmdText;
return sqlCmd;
}
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]) ;
}
}
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM YourTable WHERE City=@Value";
cmd.Parameters.Add("@Value", SqlDbType.VarChar, 40).Value = "北京";