Just Like This string conn_str = @"Data Source=(local);Initial Catalog=数据库名;UserID=用户名;Password=密码"; string show_str = string.Empty; using (SqlConnection conn = new SqlConnection(conn_str)) { conn.Open(); string sql = string.Format("select * from Table where 序号='{0}'",this.textBox1.Text.Trim()); using (SqlCommand com = new SqlCommand(sql,conn)) { SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { show_str = string.Format("{0} {1} {2} {3}",dr[0].ToString(),dr[1].ToString(),dr[2].ToString(),dr[3].ToString()); } dr.Close(); dr.Dispose(); } } this.textBox2.Text = show_str;//显示
string conn_str = @"Data Source=(local);Initial Catalog=数据库名;UserID=用户名;Password=密码";
string show_str = string.Empty;
using (SqlConnection conn = new SqlConnection(conn_str))
{
conn.Open();
string sql = string.Format("select * from Table where 序号='{0}'",this.textBox1.Text.Trim());
using (SqlCommand com = new SqlCommand(sql,conn))
{
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
show_str = string.Format("{0} {1} {2} {3}",dr[0].ToString(),dr[1].ToString(),dr[2].ToString(),dr[3].ToString());
}
dr.Close();
dr.Dispose();
}
}
this.textBox2.Text = show_str;//显示
这样应该可以吧
你连百度的能力都没有吗
string show_str = string.Empty;
using (SqlConnection conn = new SqlConnection(conn_str))
{
conn.Open();
string sql = string.Format("select * from Table where 序号='{0}'",this.textBox1.Text.Trim());
using (SqlCommand com = new SqlCommand(sql,conn))
{
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
show_str = string.Format("{0} {1} {2} {3}",dr[0].ToString(),dr[1].ToString(),dr[2].ToString(),dr[3].ToString());
}
dr.Close();
dr.Dispose();
}
}
this.textBox2.Text = show_str;//显示
我运行了这段代码,vs2010没有报错,当我输入010查询表格数据时文本框内什么数据也没有
string show_str = string.Empty;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string sql = string.Format("select userID,userName from tUSER where 4='{0}'", this.textBox_output.Text.Trim());
using (SqlCommand com = new SqlCommand(sql, connection))
{
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
show_str = string.Format("{0} {1} {2} {3}", dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString());
}
dr.Close();
dr.Dispose();
}
}
this.textBox_output.Text = show_str;//显示
这是修改以后代码