Error displaying data from DB to predefined columns of datagrid View on button click event

Question

I am using the following code:

string getinputs = "SELECT ir.plu_code PLU_Code,ir.barcode Barcode,ir.product_name Product_Name  FROM inventory_register ir,inventory_value iv WHERE ir.dept_id='" + textBox1.Text + "' AND ir.barcode = iv.barcode";
connection.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(getinputs, connection);
MySqlCommandBuilder cmdbuilder = new MySqlCommandBuilder(adapter);
DataTable dt = new DataTable();
adapter.Fill(dt);
BindingSource bindsrc = new BindingSource();
DataGridView datagridv = new DataGridView();
bindsrc.DataSource = dt;
datagridv.DataSource = bindsrc;
connection.Close();

I have three predefined columns in datagridview1 say 'PLU_Code', 'Barcode' and 'Product_Name'.

I want to display the result (more than one row) of the select query in the datagridview. But I am not getting any.

How do I achieve this?

Problem is when i click on the button there is no rows displayed in datagridview — Ameena, Feb 02 '15 at 12:28
are you sure you are getting some data when you do adpter.Fille(dt)? — fabricio, Feb 02 '15 at 12:28
@Ameena: no, check this answer for details: inserting your textbox data directly in your SQL statement is vulnerable for hackers. http://stackoverflow.com/questions/7505808/using-parameters-in-sql-statements — Stefan, Feb 02 '15 at 12:33
yea, I know that is not data displayed. What I meant to ask was if you know if the result DataTable has some rows in it. If you are getting data from your query. — fabricio, Feb 02 '15 at 12:33
yes the result of the query is two rows. but i dont think i am getting data in adapter.fill(dt). am i missing something in the code?! — Ameena, Feb 02 '15 at 12:41

score 0 · Answer 1 · answered Feb 02 '15 at 12:35

0

Try this code:

                string getinputs = "SELECT ir.plu_code PLU_Code,ir.barcode Barcode,ir.product_name Product_Name  FROM inventory_register ir,inventory_value iv WHERE ir.dept_id='" + textBox1.Text + "' AND ir.barcode = iv.barcode";
                connection.Open();

                MySqlDataAdapter dataAdapter = new MySqlDataAdapter(getinputs, connection);
                MySqlCommandBuilder commandBuilder = new MySqlCommandBuilder(dataAdapter);
                DataTable table = new DataTable();
                dataAdapter.Fill(table);

                datagridview1.DataSource = table;

                connection.Close();

answered Feb 02 '15 at 12:35

user4340666

1,453
15
36

Hi. result of the select query is two rows. After trying ur code, i am getting two empty rows in datagridview(no data in cells) – Ameena Feb 02 '15 at 12:38
1

Ok try to use parameters in SQL statements – user4340666 Feb 02 '15 at 12:40
u mean to say "cmd.parameters.add"? – Ameena Feb 02 '15 at 12:43

score 0 · Answer 2 · edited Feb 03 '15 at 10:46

0

Try this code:

string getinputs = "Select Query";
connection.Open();

MySqlCommandBuilder cmdbuilder = new MySqlCommandBuilder(getinputs,connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmdbuilder);

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

DataGridView datagridv = new DataGridView();
datagridv.DataSource = dt;

datagridv.DataBind();

connection.Close();

edited Feb 03 '15 at 10:46

Stefan

17,448
11
60
79

answered Feb 02 '15 at 12:54

vignesh

97
5

score 0 · Accepted Answer · answered Feb 02 '15 at 13:16

I got the result. I achieved two empty rows on using @user4340666 code. when i scrolled the grid i found the set of data's been added as new columns leaving predefined column cells empty. so i just cleared the columns.

            dataGridView1.Columns.Clear();
            string getinputs = "SELECT ir.plu_code PLU_Code,ir.barcode Barcode,ir.product_name Product_Name  FROM inventory_register ir,inventory_value iv WHERE ir.dept_id='" + textBox1.Text + "' AND ir.barcode = iv.barcode";
            connection.Open();

            MySqlDataAdapter dataAdapter = new MySqlDataAdapter(getinputs, connection);
            MySqlCommandBuilder commandBuilder = new MySqlCommandBuilder(dataAdapter);
            DataTable table = new DataTable();
            dataAdapter.Fill(table);

            datagridview1.DataSource = table;

            connection.Close();

Error displaying data from DB to predefined columns of datagrid View on button click event

3 Answers3