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 = "您输入的会员名称无效"; }
}
我的代码 写的对吗? MemberID int Name nvarchar
SqlCommand comm = new SqlCommand("select MemberID from Member where Name='"+TextBox2.Text.Trim()+"'",conn);sql中字符串要用''来括起来
这样就可以了
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 = "您输入的会员名称无效";
}
}
MemberID int
Name nvarchar