Sql Server: Datagridview Display Column Value From Table

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 i

Solution 1:

privatevoidbutton3_Click(object sender, EventArgs e)
    {
        stringconnectionString= @"Data Source=" + textBox4.Text + ";" + "Initial Catalog=" + textBox1.Text + ";" + "User ID=" + textBox2.Text + ";" + "Password=" + textBox3.Text;
        stringsql="SELECT account FROM user_account";
        SqlConnectionconnection=newSqlConnection(connectionString) ;
        SqlDataAdapterdataadapter=newSqlDataAdapter(sql, connection);
        DataSetds=newDataSet();
        connection.Open();
        dataadapter.Fill(ds, "account");
        connection.Close();
        dataGridView1.DataSource = ds;

    }

Solution 2:

Answer :

privatevoidbutton3_Click(object sender, EventArgs e)
    {
        stringconnectionString= @"Data Source=" + textBox4.Text + ";" + "Initial Catalog=" + "lin2db" + ";" + "User ID=" + textBox2.Text + ";" + "Password=" + textBox3.Text;
        stringsql="SELECT account ,pay_stat FROM user_account where account='" + textBox7.Text + "' ";          
        SqlConnectionconnection=newSqlConnection(connectionString) ;
        SqlDataAdapterdataadapter=newSqlDataAdapter(sql, connection);
        DataSetds=newDataSet();
        connection.Open();
        dataadapter.Fill(ds, "pay_stat");
        connection.Close();
        dataGridView1.DataSource = ds;
        dataGridView1.DataMember = "pay_stat";


    }

Thank you for help.