Last post Mar 31, 2009 09:49 AM by vemulapalli26
Mar 30, 2009 10:21 AM|Abitha|LINK
i have search. in this search the category names are listeed. the user will select category name so according that category name the company names will display.
the prob is in the clienttable(nearly 25000 clients are there) all categorycodes is complressed in one cell.
the category table is like this
i can split the categorycodes by using this code
skipChar += 3
but how to do for search. i have to search all the clientnames whose category codes are matches to the category which i selected in searcg form.
please give me any idea.
Mar 30, 2009 01:28 PM|Abitha|LINK
please give me some idea regarding this thread.
i want any idea to proceed.
Mar 30, 2009 02:29 PM|vemulapalli26|LINK
I'm slightly confused by what data we have at what place. I have explained my understanding. Correct me if i got wrong.
What is Classification Table and how is it related to Client Details Table.(My Guess is through Classcode right)
So in the ClientDetails Table under the Company Name Section you have all company names which are concatenated.
These names you want to separate based on Category Code. But where is category Code in the Client Details Table?
Mar 30, 2009 02:41 PM|Abitha|LINK
2 tables classification and clientdetails.
categorycode means classcode only. sorry i written wrong. not categorycode. it means classcode only.both are same.
clientdetails table refer classification table through classcode. but all classcodes are concatenetated in clientdetails in one cell iteself.
i can split classcodes into 3 equal parts. but when the user select one category i have to search company name falls under that particular category.
this is the prob. how to do this?
i believe u got my point clearly.
Mar 30, 2009 02:53 PM|vemulapalli26|LINK
So Based on User Selection of Classification you have ClassCode. Pass that as parameter to SP and search the ClientDetails Column contaning ClassCodes for the combination and return all the company names which match the criteria.
Declare @SearchClassCode varchar(200)
Set @SearchClassCode = '%' + @ClassCode + '%'
Select CompanyName from ClientDetails Where ClassCode like @SearchClassCode
Mar 30, 2009 03:06 PM|Abitha|LINK
but the porb is classcode not doirect values. they are concatenated into onle cell. i have splitted the classcodes like this. fetched from database.
this code will return classcode seperately. my ques is how to search passed classcode(thourgh search) in this output. how to search full clietns who matched to that passed classcode.
i hope u understand. if any doubt feel free to ask. thanks you.
Mar 30, 2009 03:25 PM|vemulapalli26|LINK
So the ClientDetails Table has 25000 rows.The classcode column for all these rows is concatenated and returned to the vb.Net code logic. Am I right?
Do you have any idea how they are concatenating this classcode data?
Mar 31, 2009 01:13 AM|Abitha|LINK
no idea how they have concatenated.we just got the database. please give some solutions.
Mar 31, 2009 03:18 AM|Abitha|LINK
Mar 31, 2009 09:49 AM|vemulapalli26|LINK
Will the values for the classcode column be different for each row (in 25000 rows) ? I'm asking this as my doubt is that does each company have different combination of Category Codes.