原SQL:SELECT ID FROM SmsGuest WHERE (Type = @UserType) AND (UserName = @UserName)
//-----------------------------------------------------------
using (SqlConnection connection = new SqlConnection(SqlDataSource3.ConnectionString))
{
SqlCommand command = new SqlCommand(SqlDataSource3.SelectCommand.ToString (), connection);
SqlParameterCollection p;
//增加参数
command.Parameters.Add("UserName", "string");
command.Parameters.Add("UserType", "string");
//此例需要返回记录数,用了一个比较笨的方法,读入reader,再通过循环得到记录数。
SqlDataReader reader;
command .Parameters ["UserName"].Value =(object ) Label1.Text;
command.Parameters["UserType"].Value = Typelab.Text.Trim();
// command.CommandText = "Select * from SmsUserType where ((UserName='111') and (UserType='新员工'))";
connection.Open();
int i = 0;
//将数据导入reader中,并通过循环得到记录数i
reader = command.ExecuteReader();
while (reader.Read())
{
i++;
}
reader.Close();
connection.Close();
}