string sql = "select top 1 "column name1" from table where column name2= 123456"; using (SqlConnection conn = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand(sql, conn);
可能误会了 create table staff (staff_id varchar (13), staff_name varchar (15))insert INTO STAFF values ('1234','apple') insert INTO STAFF values ('1235','MAY') insert INTO STAFF values ('1236','ORANGE')select top 1 staff_name from STAFF where staff_id = ‘1236’ 输入正确的staff_id,则将orange显示在textbox.text上select top 1 staff_name from STAFF where staff_id = ‘1238’ 输入错误的staff_id,则显示"1238不是有效的staff_id"
string sql = "select top 1 "column name1" from table where column name2= 123456"; using (SqlConnection conn = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand(sq……
string sql = "select top 1 "column name1" from table where column name2= 123456";
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
TEXTBOX.TEXT =cmd.ExecuteScalar()==null?"":(string)cmd.ExecuteScalar();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
TEXTBOX.TEXT =String.IsNullOrEmpty(message)?message:"提示信息!";
create table staff
(staff_id varchar (13),
staff_name varchar (15))insert INTO STAFF values
('1234','apple')
insert INTO STAFF values
('1235','MAY')
insert INTO STAFF values
('1236','ORANGE')select top 1 staff_name from STAFF where staff_id = ‘1236’
输入正确的staff_id,则将orange显示在textbox.text上select top 1 staff_name from STAFF where staff_id = ‘1238’
输入错误的staff_id,则显示"1238不是有效的staff_id"
顶 +1
TEXTBOX.TEXT =cmd.ExecuteScalar()==null?"提示信息!":(string)cmd.ExecuteScalar();
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand(sq……