search using multiple fields on search button click in a dat

hadoop hadoop

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.

3 Replies

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

Sreekanth Reddy11y ago
Accepted 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=@a,Todate=@b,recievername=@c and agentnm=@d",conobj);
cmd.parameters.addwithvalue("@a",frmdt) ;
cmd.parameters.addwithvalue("@b",todt) ;
cmd.parameters.addwithvalue("@c",recname) ;
cmd.parameters.addwithvalue("@d",agentnm) ;
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 hadoop11y ago
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!!!
Sreekanth Reddy11y ago
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=@a,Todate=@b,recievername=@c and agentnm=@d",conobj);
cmd.parameters.addwithvalue("@a",frmdt) ;
cmd.parameters.addwithvalue("@b",todt) ;
cmd.parameters.addwithvalue("@c",recname) ;
cmd.parameters.addwithvalue("@d",agentnm) ;
--------------------------
----------------------------
--------------------------

Accept the answer if it helps, Or come with query.
Thanks.