SQL Server:Datagridview显示表中的列值 [英] SQL Server: Datagridview display column value from table
本文介绍了SQL Server:Datagridview显示表中的列值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在datagridview中显示指定的列值.示例:从表 user_account
中我要显示和搜索datagridview
I want to display in datagridview a specified column value. Example: from table user_account
I want to display and search by textbox data from column account
in datagridview
这是到目前为止的代码:
Here is the code so far:
private void button3_Click(object sender, EventArgs e)
{
string connectionString = @"Data Source=" + textBox4.Text + ";" + "Initial Catalog=" + textBox1.Text + ";" + "User ID=" + textBox2.Text + ";" + "Password=" + textBox3.Text;
string sql = "SELECT * FROM user_account";
SqlConnection connection = new SqlConnection(connectionString) ;
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "account");
connection.Close();
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "account";
}
推荐答案
private void button3_Click(object sender, EventArgs e)
{
string connectionString = @"Data Source=" + textBox4.Text + ";" + "Initial Catalog=" + textBox1.Text + ";" + "User ID=" + textBox2.Text + ";" + "Password=" + textBox3.Text;
string sql = "SELECT account FROM user_account";
SqlConnection connection = new SqlConnection(connectionString) ;
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "account");
connection.Close();
dataGridView1.DataSource = ds;
}
这篇关于SQL Server:Datagridview显示表中的列值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文