How to add rows by code to a DataGridView that is filled with a query to a BD

Question

How to add rows by code to a DataGridView that is filled with a query to a BD

Navigation

#1 by (1 votes)

0

I have read several open cases of this type but I do not really see one that fits my case. Well I raise my case;

I have a DataGridview which, by consulting the BD, I filled it and I want to add rows through TextBox that are in the same form.

My code to add rows is:

string[] fila = new string[] { txtidproducto.Text, txtproducto.Text,txtmarca.Text,txtdescripcion.Text,txtcantidad.Text,txtprecio.Text};

                                dtgv.Rows.Add(fila);

If I execute that code it gives me an error that "Rows can not be programmatically added to the DataGridView's rows collection when the control is data-bound." The cases that I have seen of this is that the user tries to add rows to the DataGridView that already had rows added by means of query, then he wants to add other rows to him by another query and they realize it by means of array (really the subject of arrays do not handle it very well) And besides not wanting to make a second consultation but a direct insertion, I think those cases do not suit mine. Please help.

so I fill in the DataGridView:

string sql2 = @"SELECT DISTINCT cabeza.Id_producto,detalle.Producto,detalle.Marca,detalle.Descripcion,cabeza.Cantidad, cabeza.Precio FROM Tab_entrada_mercancia_detalle AS cabeza INNER JOIN Tab_productos AS detalle ON cabeza.Id_producto = detalle.Id_producto where cabeza.Id_entrada=@numeroentrada";

                SqlCommand cmd2 = new SqlCommand(sql2, cn);
                cmd2.Parameters.AddWithValue("@numeroentrada", txtSalidaEntrada.Text);


                SqlDataAdapter da = new SqlDataAdapter(cmd2);
                DataTable dt = new DataTable();
                da.Fill(dt);
                dtgv.DataSource = dt;

sql c#

asked by Samuel Ignacio Susana Confesor 16.12.2018 в 02:17

source

1 answer

Join split mutiples in a single variable Query Excluding duplicate records in SQL

score 1 · Accepted Answer

If you are showing information from a database you can not use the Rows.Add() you have to add the new data to the datatable

SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataTable dt = new DataTable();
da.Fill(dt);

DataRow row = dt.NewRow();
row["Id_producto"] = txtidproducto.Text;
row["Producto"] = txtproducto.Text;
//resto de las columnas
dt.Rows.Add(row);

dtgv.DataSource = dt;

As you will see the data is added to the datatable and then you assign it to the datagridview

If you need to add a row in some event you can get the datatable using

DataTable dt = dtgv.DataSource as DataTable;

you add the row and you return assign to the grid