我现在写了一条语句,如下:
sql="select number form stu where name ='学生姓名'";
上面这条我是根据学生的"姓名"查出这个学生的"学号".
我现在想知道怎么才能把这个"学号",用MessageBox 输出来..
sql="select number form stu where name ='学生姓名'";
上面这条我是根据学生的"姓名"查出这个学生的"学号".
我现在想知道怎么才能把这个"学号",用MessageBox 输出来..
调试欢乐多
string SQL="select number from stu where name='学生姓名' ;
string connstring1 = "server=111;database=stu;user=sa;pwd=123";
SqlConnection conn1 = new SqlConnection(connstring1);
SqlCommand comm=new SqlCommand();
conn.open()
sting number = comm.comm.ExecuteScalar();
MessageBox.show(number.tostring());
conn.close();因为是新手,可能很多地方都不对,可能帮我修改一下吗??
SqlConnection conn1 = new SqlConnection(connstring1);
string SQL="select number from stu where name='学生姓名' ;
SqlCommand comm=new SqlCommand(SQL,conn1);
conn.open();
obj number = comm.ExecuteScalar();
conn.close();
MessageBox.show(number.tostring());
SqlConnection conn1 = new SqlConnection(connstring1);
string SQL="select number from stu where [name]='学生姓名'";
SqlCommand comm=new SqlCommand(SQL,conn1);
conn.open();
obj number = comm.ExecuteScalar();
conn.close();
MessageBox.show(number.tostring());
string connstring1 = "server=111;database=stu;user=sa;pwd=123";
SqlConnection conn1 = new SqlConnection(connstring1);
SqlCommand comm=new SqlCommand(SQL,conn1);//设置连接命令和连接
conn.Open(); //加分号 open--Open
string number = comm.ExecuteScalar(); //sting-->string
MessageBox.Show(number.ToString()); //show-->Show tostring()-->ToString()
conn.Close(); //close-->Close
DataSet myData = new DataSet();
string SQL="select number from stu where name='学生姓名' ;
string connstring1 = "server=111;database=stu;user=sa;pwd=123"; SqlDataAdapter myAdapter = new SqlDataAdapter(SQL,connstring1); myAdapter.Fill(myData);MessageBox.Show(myData.Rows[0]["number"].ToString());
string connstring1 = "server=111;database=stu;user=sa;pwd=123";
SqlConnection conn1 = new SqlConnection(connstring1);
SqlCommand comm=new SqlCommand(SQL,conn1);//设置连接命令和连接
conn.Open(); //加分号 open--Open
string number = comm.ExecuteScalar();//sting-->string
MessageBox.Show(number.ToString()); //show-->Show tostring()-->ToString()
conn.Close(); //close-->Close