0

i have a combobox ,three textbox and one button.when user choose one item in combobox, textboxes and press button,i want to filter corresponding data and show on datagridview!
Please help me!
Thank u so much!

2
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by thuyson
0

Hey,, You always can try the OnClickEvent of combo boxes to filter data.. i did it in my project as well.. its a simple task ...

1st you have to generate a query to select the items from the db and then filter the results with the items in your combo box.. just delete that button :D :D it will be more easy i guess//

0

i have 2 table in database,table1 and table2.On my form,i have 1 combobox and 3 textbox,data in combobox get from table1, data in 3 textbox is checked in table2. when user choose and input data,i want to get that data ,check in database then show on datagridview(datagrid referen to table2).My database is a MS access file.
Please help me!
Thank you!

0

Hey,, You always can try the OnClickEvent of combo boxes to filter data.. i did it in my project as well.. its a simple task ...

1st you have to generate a query to select the items from the db and then filter the results with the items in your combo box.. just delete that button :D :D it will be more easy i guess//

Yes,thank u! i generated a query and show data on combobox.But i don't know how to get results from 3 textbox and 1 combo,then assigned to ONE defaultview and show data on datagrid from this defaultview !
Please help me!

0

Simple task ,, after loading the DB using the query.. you can assign values to the text fields.. ill show you how ... this is just example that i used ;)

Heres the way to get data from a database via a combobox

string sql = "SELECT * FROM mobile WHERE MMANU = '" + cmbMobtyp.Text + "'";

And here is the way how you assign the SQL field values totext boxez

com = new OleDbCommand(sql, dbcon);
            dreader = com.ExecuteReader();
            dreader.Read();
            textBox1.Text = dreader["MID"].ToString();
            txtModel.Text = dreader["MMNO"].ToString();
            dreader.Close();

in here the MID is a field in my example database table :) and dreader is the data Reader :) Since im a newbie to C# , i cant help you on the GRID VIEW .. i dont have much knowledge about it ;( im sry,,

Hope its clear enough for you :)

Edited by g2gayan: n/a

0

Simple task ,, after loading the DB using the query.. you can assign values to the text fields.. ill show you how ... this is just example that i used ;)

Heres the way to get data from a database via a combobox

string sql = "SELECT * FROM mobile WHERE MMANU = '" + cmbMobtyp.Text + "'";

And here is the way how you assign the SQL field values totext boxez

com = new OleDbCommand(sql, dbcon);
            dreader = com.ExecuteReader();
            dreader.Read();
            textBox1.Text = dreader["MID"].ToString();
            txtModel.Text = dreader["MMNO"].ToString();
            dreader.Close();

in here the MID is a field in my example database table :) and dreader is the data Reader :) Since im a newbie to C# , i cant help you on the GRID VIEW .. i dont have much knowledge about it ;( im sry,,

Hope its clear enough for you :)

sorry g2gayan,i don't understand your codes.Now,i want to filter data from 3 textbox and 1 combobox and then show on datagrid.My database is a MS Access file not SQL.
Please help me!
Thank u!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.