DataGridView and Search Query

Question

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.

Pravin Ghadge · 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 Hobbs · Answer

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 iqbal · Answer

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 Ghadge · Answer

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 iqbal · Answer

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 Nayak · Answer

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

wasif iqbal · Answer

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 Nayak · Answer

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

DataGridView and Search Query

Answers (8)