Universal Search Form(windows desktop application)

Bhautik Joshi

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..

9 Replies

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

Sachin Singh4y ago
Accepted 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);
Bhautik Joshi4y ago
thanx sir
Sachin Singh4y ago
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 Joshi4y ago

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 Joshi4y ago
thanx sir
Sachin Singh4y ago
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 Joshi4y ago
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 Ramamoorthi4y ago
Can you give more details
Srinivasan Ramamoorthi4y ago
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