search using multiple fields on search button click in a dat

Question

I've a data grid view where I am showing all my rows from a table. I want to do search on this data grid view based on the fields

FromDate, ToDate, ReceiverName and AgentName on "search" button click.

When searched on net, I can only found examples of search as you type where there is only search field present.

Please guide me how can I do search using multiple fields on search button click in a datagrid.

Srikanth Reddy · Answer

//-->Initially bring all your data to variables. datetime frmdt= //from date; datetime todt= //get to date; string recname=txtreceiver.text; string agentnm=txtagent.text; //-->Now frame the command. sqlcon........ sqlcommand cmd=new sqlcommand(select * from tblnm where Fromdt=@aTodate=@brecievername=@c and agentnm=@dconobj); cmd.parameters.addwithvalue(@afrmdt) ; cmd.parameters.addwithvalue(@btodt) ; cmd.parameters.addwithvalue(@crecname) ; cmd.parameters.addwithvalue(@dagentnm) ; sqldataadapter da=new sqldataadapter(cmd); dataset ds=new dataset(); da.Fill(ds); datagridview1.datasource=ds.tables[0]; datagridview1.databind(); Still any doubt.. come with query. If My answer ok Please ACCEPT. Thank you.

hadoop hadoop · Answer

Thanks for the quick response. Please can you elaborate your reply. Also please look into my previous issue :: http://www.c-sharpcorner.com/Forums/Thread/308093/make-the-datagrid-view-to-extend-to-buttom-of-the-form.aspx Thanks!!!

Srikanth Reddy · Answer

create a command based on your fields. //-->Initially bring all your data to variables. datetime frmdt= //from date; datetime todt= //get to date; string recname=txtreceiver.text; string agentnm=txtagent.text; //-->Now frame the command. sqlcon........ sqlcommand cmd=new sqlcommand(select * from tblnm where Fromdt=@aTodate=@brecievername=@c and agentnm=@dconobj); cmd.parameters.addwithvalue(@afrmdt) ; cmd.parameters.addwithvalue(@btodt) ; cmd.parameters.addwithvalue(@crecname) ; cmd.parameters.addwithvalue(@dagentnm) ; -------------------------- ---------------------------- -------------------------- Accept the answer if it helps Or come with query. Thanks.