Universal Search Form(windows desktop application)

Question

hello All Dabster,

i m new in .net so please help me to make univarsal search form.

i have 10 windows form sale,purchase,stock etc iw ant to make common cearch form. if i m click on sale form find button then open search form with all getdata to relted of sale table imean mentioned table data.

so please help me how to do..

Sachin Singh · Answer

step 1.create a generic method named UniversalSearch with string parameter as formName and SearchTerm. public class UniversalSearch where T: class public IEnumerable Search(string FormName, string searchTerm) { switch (FormName) { case Sales: tableName = "tblSales" ; break ; case Purchase: tableName = "tblPurchase" ; break ; ...so on... } // retrive data from respective table , cast it to appropriate class // i am using dapper using (var conn = new SqlConnection(constring)) { var res= await conn.Async ( "[dbo].[Search]" , new { @searchTerm = searchTerm, @tableName = tableName }, commandType: CommandType.StoredProcedure); } return res; } // stored procedure if (@tableName= 'tblSales' ) begin select * from tblSales where name like %@searchTerm%... end and so step 2. On find in each form send both search term and form name, and call via T=className for related form. ex:- on sales's find form. UniversalSearch obj= new UniversalSearch (); var res=obj.Search( "Sales" ,searchTerm);

Sachin Singh · Answer

Ye link follow karo step by step hai https://www.aspsnippets.com/questions/482249/Display-Bind-Crystal-Report-based-on-DropDownList-selection-using-C-and-VBNet-in-ASPNet/

Bhautik Joshi · Answer

thanx sir

Bhautik Joshi · Answer

Sir Is taras se muje report nikalne hai to kese bana sakte hai plz guide me sir... dropdown me report k name set kardunga or privew pe click karu to crystal report open ho plz ye dropdown se kaise set karna hai samaj nahi aaraha

Bhautik Joshi · Answer

thanx sir

Sachin Singh · Answer

Ek folder banao, common naam se, uske under ek class bana lo universal search, fir iss class ko pure project me use karo kahin bhi.

Bhautik Joshi · Answer

Hello Sachin Sir I m Understand. can i make universal class..? i m confuse ..! i m taliking to hindi mere paas purchase ka form hai usme ye bana na hai ya naya class bana k karna hai sir?

Srinivasan Ramamoorthi · Answer

Can you give more details

Srinivasan Ramamoorthi · Answer

Are you looking for text search? Then you can implement google search button and call search api. Let me know if you are looking for that. Give more details with example