how to filetr data using cmbbox & 2 textboxs

Question

hai i have 3 tables as follows

select book_category,authers_names,book_name from bookmaster

select Publisher_Name from publishermaster

select quantity_available from BookStock how to bind these 3 tables column values to datagridview(what query should i use) and after selecting combobox value,textbox1 value,textbox2 value i want filter data in dgv.Thank you

Munesh Sharma · Answer

you do like this this code when you click on name (which is in combo box) data will be show in textbox. C lick on drop down list in write this code { string str = "server = MUNESH\SQL2008R2;Database=datastore;UID=sa;Password=123;" ; SqlConnection con = new SqlConnection(str); string query = "select * from tablename where name = '" + combobox1 .text+ "' " ; SqlCommand cmd = new SqlCommand( query,con); sqldatareader dbr; try { con.open(); dbr = cmd.executereader(); while (dbr.read()) { string sID = ( string ) dbr[ "ID" ].tostring; string sname = ( string ) dbr[ "name" ] // name is string value string sage = ( string ) dbr[ "age" ].tostring; textbox1.text = sid; textbox2.text = sname; textbox3.text = sage; } catch (execption es) { messagebox.show(es.message); } } }

Ashok · Answer

i have 3 controls(combobox,textbox1,textbox2) and button, datagridview, my requirement is after selecting combobox value and entering textboxe1 value,textbox2 value and when i click on submit_button data should be filtered based on these 3 selections and displayed in DGV control.

Munesh Sharma · Answer

explain briefly, i did not get...

Jignesh Trivedi · Answer

can you please provide more information? I cannot understand you question.

Abhay Shanker · Answer

Please clarify requirement.