DataGridView and Search Query

wasif iqbal

I am making an windows application form for a resturant managment system which is connected with the access database(OLEDB) and i want to apply a query that is the selected value/name of the products in the combobox will show the result of the selected product in the datagridview box. I searched a lot from internet but cant get the proper code for this. Thanx in advance if anyone can help me.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pravin Ghadge14y ago
Accepted answer
hi just replace
double SumOfPrice=0;
for(int i=0;i{
SumOfPrice=SumOfPrice+ Convert.ToDouble(ds.Tables[0].Rows[i]["columnname"].ToString());
}
Label1.Text=SumOfPrice.ToString(); //Dispaly sum in label.
Sam Hobbs14y ago
Please don't post the same question more than once at the same time. I replied to your thread Datagridview Probblem but you already had an answer here.
wasif iqbal14y ago
Dude it gave me an error "Operator + cannot be applied to operands of type float and object" ... i think i m making a mistake and what should i do that the last record which i searched remain in the girdview so that i can sum all the Products ??? Thanx :)
Pravin Ghadge14y ago
Hi Wasif,

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from product where prodname='" + comboBox1.Text.Trim() + "'";
            com = new OleDbCommand(str, con);
            oda = new OleDbDataAdapter(com);
            ds = new DataSet();
            oda.Fill(ds, "product");
            dataGridView1.DataMember = "product";
            dataGridView1.DataSource = ds;

double SumOfPrice=0;
for(int i=0;i{
SumOfPrice=SumOfPrice+ds.Tables[0].Rows[i]["columnname"];
}
Label1.Text=SumOfPrice.ToString();   //Dispaly sum in label.
            con.Close();
        }
    }
wasif iqbal14y ago
HI , Thanx a lot Your code is working properly, actually i m doing a mistake while doing this . and now it works properly and can you do a one more favour for me . I want to SUM all the product price which come in the GRIDVIEW after search is complete. and right now this code clear the previous search record and how can i prevent to not clear the record in the DATAGRIDVIEW so that i can SUM all the products price. THANX ....
Satyapriya Nayak14y ago
Hi Wasif,

In oda.fill(ds,"product") line, product is the table name.

Thanks
wasif iqbal14y ago
Thanx for the Code but it does not work properly because it did not show me the results in the datagridview. and in the database i write the product name coloumn as only "Name" and i m searching using this name so can u tell me that in oda.fill(ds,"product") line, is product is the coloumn name or table name or something else.
Satyapriya Nayak14y ago
Hi Wasif,

Try this...

Run the attachments.

App.config




using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace Datagridview_bind
{
    public partial class Form1 : Form
    {
        string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
        OleDbCommand com;
        OleDbDataAdapter oda;
        DataSet ds;
        string str;
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from product";
            com = new OleDbCommand(str, con);
            OleDbDataReader reader = com.ExecuteReader();
            while (reader.Read())
            {
                comboBox1.Items.Add(reader["prodname"]);
            }
            reader.Close();
            con.Close();


        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from product where prodname='" + comboBox1.Text.Trim() + "'";
            com = new OleDbCommand(str, con);
            oda = new OleDbDataAdapter(com);
            ds = new DataSet();
            oda.Fill(ds, "product");
            dataGridView1.DataMember = "product";
            dataGridView1.DataSource = ds;
            con.Close();
        }
    }
}

Thanks
If this post helps you mark it as answer