将nvarchar值'Hedayatullah'转换为数据类型int时转换失败。 [英] Conversion failed when converting the nvarchar value 'Hedayatullah' to data type int.

问题描述

您好

我的数据库中有四个表，他们正在加入收集

我想在用户登录的用户的管理页面中从我的Education_TB中选择数据通过登录页面中的用户名和密码，并使用查询字符串ID重定向来管理页面。

现在，当我想要显示从我面对此错误的select语句的结果时

Hello
I have four Tables in my Database that they are join to gather
I want select data from my Education_TB in the manage page of user that the user logined by username and password from Login page and redirect with Query string ID to manage page.
Now when I want show the result of select statement in a from I face to this error
"

Conversion failed when converting the nvarchar value 'Hedayatullah' to data type int.

请帮助我做什么



这是我的Sql cod和C＃cod

"
Please help me what I do

Here is my Sql cod and C# cod

ALTER procedure [dbo].[Select_Education_TB_Full]
@Eid int
as

begin
  select Person_Name
  ,Field_name_english
  ,SubField_Name_english
  ,Degree_Education
  ,University_Name
  ,Date_Graduated
  ,Experience_Job
  ,CV_Path 
  from Education_Degree_TB 
  inner join  Person_TB 
  on Education_Degree_TB.Person_ID=Person_TB.Person_ID 
  join  Field_TB 
  on Education_Degree_TB.Field_ID=Field_TB.Field_ID 
  join SubField_TB 
  on Education_Degree_TB.SubField_ID=SubField_TB.SubField_ID 
  where Person_Name=@Eid
end

SqlCommand cmdEdrop = new SqlCommand("Select_Education_TB_Full",con);
cmdEdrop.CommandType = CommandType.StoredProcedure;
cmdEdrop.Parameters.AddWithValue("@Eid",Request.QueryString["id"]);
con.Open();
SqlDataReader dre;
dre = cmdEdrop.ExecuteReader();

while (dre.Read())
{

    LabelName.Text=dre["Person_Name"].ToString();
    DropDegree.SelectedValue=dre["Field_Name_English"].ToString();
    DropField.SelectedValue=dre["SubField_Name_English"].ToString();
    DropQualification.SelectedValue= dre["Degree_Education"].ToString();
    LabelUniversity.Text=dre["University_Name"].ToString();
    LabelGraduated.Text=dre["Date_Graduated"].ToString();
    DropExperience.Text=dre["Experience_Job"].ToString();
    LabelCV.Text=dre["CV_Path"].ToString();
}
con.Close();//------------------

推荐答案

@Eid int ... 其中Person_Name = @ Eid



我想你想改变参数的定义。

@Eid int ... where Person_Name=@Eid

I think you want to change the definition of the parameter.

这篇关于将nvarchar值'Hedayatullah'转换为数据类型int时转换失败。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！