Comments by Member 10226004 (Top 39 by date)

your correct but can't we do using a key-value pair using resource files while writing a stored procedure

foreach (var result in locationresult)
{
var getcountryid = context.Jobs.FirstOrDefault(n => n.Id == result.Id);
int countryid = getcountryid.CountryId;
var countryname = context.MasterCountries.FirstOrDefault(n => n.Id == countryid);

var template = context.EmailTemplates.FirstOrDefault(n => n.Name == "SendDailyAlerts");
var templateid = template.Id;
//string Subject=template.Subject;
var valuesList = new Hashtable
{
{"TotalCount",count},
{"Title", result.Title},
{"CompanyName",result.CompanyName},
{"LocationName",result.LocationName},
{"CountryName",countryname.Description},
{"Keyword",keyword},
{"Location",location},
{"Server Url",keyword+"-jobs-in-"+location+".aspx"},
{"Base Url","Home.aspx"},

//{"Salary",}
//{"Currency",salary.MasterCurrencyType.Symbol}

};
string baseUrl = "www.hostname.com/";
Program url = new Program();
string applyjob = Path.Combine(baseUrl, url.JobsUrlGenerator(result.Id));
valuesList.Add("Generate Url", applyjob);
var msg = new MailMessage();
string fromUserName = System.Configuration.ConfigurationManager.AppSettings["FromUserName"];
string userName = System.Configuration.ConfigurationManager.AppSettings["FromEmailjobs"];
string password = System.Configuration.ConfigurationManager.AppSettings["FromEmailPassword"];
string smtpAddress = System.Configuration.ConfigurationManager.AppSettings["SMTPAddress"];
int smtpPort = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["SMTPPort"]);
bool enableSsl = Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["EnableSsl"]);
string body = url.LoadTemplate(template.TemplateText, valuesList);
//SnovaUtil.SendEmail(template.Subject, body, user.EmailAddress);
url.SendEmail(template.Subject, body, mailid);
}

i want to display top results companyname=dell and countryid=108 and then after remaining results should display so now please guide me how can i approach

not as autocomplete if search doesn't match i want to display the list which is very closest to the search text