Comments by Bala Selvaraj (Top 10 by date)

hi sir

Any idea from this task?

By

Bala

Hi sir

I try this sql stored procedure also

this's syntax

select j.Location from jobdetails j with (nolock)
where j.Location like '%' +@loCat+ '%'


select j.Location from jobdetails j with (nolock)
where j.Location in (@loCat)

But , i didnt got output

hi
replay me sir

By

Bala

hi
I try this code

string sLocation = txtLocation.Value.ToString();
string[] sArrLocation = sLocation.Split(',');
for (int i = 0; i < sArrLocation.Length; i++)
{
sArrLocation[i] = Convert.ToString(sLocation);
bind_KeysrchFunction(lblkey.Text.Trim(), sLocation.ToString().Trim(), lblsrhcat.Text.Trim(), lblsrhexp.Text.Trim(), lblminsal.Text.Trim(), lblmaxsal.Text.Trim(), lblcomp.Text.Trim(), lblrole.Text.Trim(), lblfresh.Text.Trim(), lblsort.Text.Trim(), lblrefsearch.Text.Trim());
}


But I give the input value chennai means i got result the chennai list
totally 12 chennai list

and i give the another input value chennai, mumbai means i got result to match the chennai, mumbai list only. But i want totally chennai list and mumbai list also. please send the coding.for example; naukri, monster jobportal website the same location category.

By

Bala

hi sir

I already use the coding path but i didnt got output. I send my coding please check the coding if error means please alter the coding and send me sir

coding in asp.net

string gh;
gh = lbllocat.Text.Trim();
StringBuilder sb = new StringBuilder();
if (gh != "" && gh != null)
{
string srch = "";

string[] ghsplit = gh.Split(',');
for (int i = 0; i < ghsplit.Length; i++)
{
string ghmultiple = ghsplit[i];
if (srch == "")
{
//srch = ghmultiple.ToString();
srch = ghmultiple[i].ToString().Trim();
//srch = "@loCat like '%" + ghmultiple.Trim() + "%'";
bind_KeysrchFunction(lblkey.Text.Trim(), srch.Trim(), lblsrhcat.Text.Trim(), lblsrhexp.Text.Trim(), lblminsal.Text.Trim(), lblmaxsal.Text.Trim(), lblcomp.Text.Trim(), lblrole.Text.Trim(), lblfresh.Text.Trim(), lblsort.Text.Trim(), lblrefsearch.Text.Trim());
}
else
{
srch = srch + ',' +ghmultiple[i].ToString().Trim();
//srch = gh[i].ToString().Trim();
srch = srch + "or like '% ','" + ghmultiple.Trim() + "%'";
bind_KeysrchFunction(lblkey.Text.Trim(), srch.Trim(), lblsrhcat.Text.Trim(), lblsrhexp.Text.Trim(), lblminsal.Text.Trim(), lblmaxsal.Text.Trim(), lblcomp.Text.Trim(), lblrole.Text.Trim(), lblfresh.Text.Trim(), lblsort.Text.Trim(), lblrefsearch.Text.Trim());
}
}
if (srch != "")
{
sb.Append("and(" + srch + ")");
}
}