SQL Server: Datagridview display column value from table

Question

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";
    }

Sasidharan · Accepted Answer · 2013-09-05 04:51:48Z

1

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;

    }

edited Sep 5, 2013 at 4:51

answered Sep 5, 2013 at 4:46

Sasidharan

3,7503 gold badges21 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

15 Comments

Sasidharan Over a year ago

give break points and check step by step..then you will know where you are lacking

xeLin xel Over a year ago

With dataGridView1.DataMember = "account"; shows all table but not what i want.

Sasidharan Over a year ago

if you want to filter values with textbox.text,then use SELECT * FROM user_account where account=" + textBox.Text + ";...this only will filter..But you have done code to diaply all..

xeLin xel Over a year ago

for textbox i got answay down. Beside I can't give break piont because it returns no error.

Sasidharan Over a year ago

use this...SELECT * FROM user_account where account=" + textBox.Text + ";

|

xeLin xel · Accepted Answer · 2013-09-05 09:17:47Z

Solution:

        private void button3_Click(object sender, EventArgs e)
    {
        string connectionString = @"Data Source=" + textBox4.Text + ";" + "Initial Catalog=" + "lin2db" + ";" + "User ID=" + textBox2.Text + ";" + "Password=" + textBox3.Text;
        string sql = "SELECT account ,pay_stat FROM user_account where account='" + textBox7.Text + "' ";          
        SqlConnection connection = new SqlConnection(connectionString) ;
        SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
        DataSet ds = new DataSet();
        connection.Open();
        dataadapter.Fill(ds, "pay_stat");
        connection.Close();
        dataGridView1.DataSource = ds;
        dataGridView1.DataMember = "pay_stat";


    }

Thank you for help.

Collectives™ on Stack Overflow

SQL Server: Datagridview display column value from table

2 Answers 2

15 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

15 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related