10--问、个简单的问题---菜鸟级别的!!-===================

[duan_jingyu]

if (dr.Read())
{
Label1.Text =Convert.ToString(dr["MenberID"].ToString()) ;
}


MenberID: 在数据库中是整型的, 帮我看看怎么写

[zhchg6666]

Label1.Text =dr["MenberID"].ToString() ;
这样就可以了

[duan_jingyu]

将 nvarchar 值 'gaojie' 转换为数据类型为 int 的列时发生语法错误

[duan_jingyu]

if (TextBox2.Text.Trim() == "") return;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["VConnectionString"].ToString()))
{
conn.Open();
SqlCommand comm = new SqlCommand("select MemberID from Member where Name="+TextBox2.Text.Trim(),conn);

SqlDataReader dr = comm.ExecuteReader();

if (dr.Read())
{
Label1.Text =dr["MenberID"].ToString();
}
else
{
Label1.Text = "您输入的会员名称无效";
}

}

[zhchg6666]

字符串不能转换成整型

[duan_jingyu]

我的代码 写的对吗?


MemberID int
Name nvarchar

[firsk]

SqlCommand comm = new SqlCommand("select MemberID from Member where Name='"+TextBox2.Text.Trim()+"'",conn);

sql中字符串要用''来括起来

[duan_jingyu]

哦了