在执行ExecuteReader()时出现异常Object must implement IConvertible.
this.cnn = _2hand.DataBase.getConn();
string sql="proc_checkPassword";
SqlCommand cm = new SqlCommand(sql,this.cnn);
cm.CommandType = CommandType.StoredProcedure;
cm.CommandTimeout = 15;
cm.Connection=this.cnn;
SqlParameter email = new SqlParameter("@email",SqlDbType.Char,40);
email.Value = this.txtUser;
cm.Parameters.Add(email);
SqlParameter psd = new SqlParameter("@psd",SqlDbType.Char,32);
string pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(this.txtPsd.Text, "MD5");
psd.Value = pwd;
cm.Parameters.Add(psd);
this.cnn.Open();
try
{
SqlDataReader rd = cm.ExecuteReader(); //这行出错,
if(rd.HasRows)
{
this.Label1.Text="asdf";
}
else
{
this.Label1.Text="<font color=red>Email或是密碼錯!</font>";
}
}
catch(Exception ex)
{
this.cnn.Close();
this.Label1.Text =ex.Message.ToString();
}
finally
{
this.cnn.Close();
}
各位老大,帮我一把
问题点数:55、回复次数:4Top
1 楼bushido(大饼)回复于 2003-12-04 09:48:58 得分 0
this.cnn.Open()是没有问题的,正确取到并打开SqlConnection对象Top
2 楼guoyan19811021(吉祥)回复于 2003-12-04 09:50:40 得分 40
email.Value = this.txtUser.Text;?Top
3 楼bushido(大饼)回复于 2003-12-04 09:51:11 得分 0
真不走運,剛貼出問題來,自己就找到答案了
是做在這一句
email.Value = this.txtUser;
哎,
誰回複一下就給他分,Top
4 楼acewang(龍芯*Inside!)回复于 2003-12-04 09:51:17 得分 15
email.Value = this.txtUser;?Top
相关问题
- [object]??
- 帮忙求教ExecuteReader()问题?
- Object reference not set to an instance of an object
- Object reference not set to an instance of an object.
- Object reference not set to an instance of an object.
- web中的 <object>...</object> +100分
- error Message:Object reference not set to an instance of an object.
- object 和 Object 有何区别???
- executeReader()中的singlerow是什么意思?
- Dynamic Timer Object of VB




