public SqlDataReader GetUserLoginByProc(string sUserName, string sPassword)
{
///创建链接
SqlConnection myConnection = new SqlConnection(
ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);
///创建Command
SqlCommand myCommand = new SqlCommand("Pr_GetUserLogin" , myConnection);
///设置为执行存储过程
myCommand.CommandType = CommandType.StoredProcedure; ///添加存储过程的参数
SqlParameter pUserName = new SqlParameter("@UserName", SqlDbType.VarChar, 32);
pUserName.Value = sUserName;
myCommand.Parameters.Add(pUserName); SqlParameter pPassword = new SqlParameter("@Password", SqlDbType.VarChar, 255);
pPassword.Value = sPassword;
myCommand.Parameters.Add(pPassword); ///定义DataReader
SqlDataReader dr = null;
try
{
///打开链接
myConnection.Open();
///读取数据
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
///抛出异常
throw new Exception(ex.Message, ex);
}
///返回DataReader
return dr;
}提示错误为:找不到存储过程 Pr_GetUserLogin ,请高手指点一下!!!!!
{
///创建链接
SqlConnection myConnection = new SqlConnection(
ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);
///创建Command
SqlCommand myCommand = new SqlCommand("Pr_GetUserLogin" , myConnection);
///设置为执行存储过程
myCommand.CommandType = CommandType.StoredProcedure; ///添加存储过程的参数
SqlParameter pUserName = new SqlParameter("@UserName", SqlDbType.VarChar, 32);
pUserName.Value = sUserName;
myCommand.Parameters.Add(pUserName); SqlParameter pPassword = new SqlParameter("@Password", SqlDbType.VarChar, 255);
pPassword.Value = sPassword;
myCommand.Parameters.Add(pPassword); ///定义DataReader
SqlDataReader dr = null;
try
{
///打开链接
myConnection.Open();
///读取数据
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
///抛出异常
throw new Exception(ex.Message, ex);
}
///返回DataReader
return dr;
}提示错误为:找不到存储过程 Pr_GetUserLogin ,请高手指点一下!!!!!
已经提示你错误啦
@param1 varchar(20)
...
--传入的参数as--执行的sql语句