populate DataGridView from database and TextBox

Question

Basically I want to add another column from a TextBox along with values I have queried from the database. I want my datagridview to show something like

          |itemcode|Category|itemDescription|unitcost|quantity|

where itemcode, Category, itemDescription, unitcost is from database and quantity is from a text box input.

private void btnAddToCart_Click(object sender, EventArgs e)
{
    con.OpenConnection();
    MySqlCommand cmd = con.connection.CreateCommand();
    string search = txtSearchProduct.Text;
    string quantity = txtQuantity.Text;
    string query = "SELECT itemcode, Category, itemDescription, unitcost FROM tblprowareproducts WHERE itemDescription LIKE ?search";
    cmd.CommandText = query;
    cmd.Parameters.AddWithValue("?search", "%" + search + "%");
    using (MySqlDataAdapter mda = new MySqlDataAdapter(cmd))
    {
        DataTable dt = new DataTable();
        mda.Fill(dt);

        dgvCart.DataSource = dt;

    }
}

Is there a way to add another column after unitcost named quantity and the value of it comes from a TextBox?

And what's the problem? What's the expected result? What's the result which you received? — Reza Aghaei
– Reza Aghaei, Commented Sep 22, 2017 at 3:57

Reza Aghaei · Accepted Answer · 2017-09-22 04:52:12Z

1

There are different solutions for the problem, for example you can add the column to DataTable this way:

DataTable dt = new DataTable();
mda.Fill(dt);

var quantity = dt.Columns.Add("quantity", typeof(int));
quantity.DefaultValue = int.Parse(txtQuantity.Text);
dt.AsEnumerable().ToList().ForEach(r =>
{
    r[quantity] = quantity.DefaultValue;
});

dgvCart.DataSource = dt;

Note 1: You may want to use TryParse to get the integer value from text.

Note 2: Default value of column applies to the column when adding the row. So to apply it to existing rows, you need to use a loop like what I did. For new rows that you add after that, it will be applied automatically.

edited Sep 22, 2017 at 4:52

answered Sep 22, 2017 at 4:32

Reza Aghaei

126k18 gold badges239 silver badges447 bronze badges

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

Collectives™ on Stack Overflow

populate DataGridView from database and TextBox

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related