protected void TextBox4_TextChanged(object sender, EventArgs e)
{
var scity = from item in db.tbl_cities where item.City.Contains(TextBox4.Text) select item;
GrvCities.DataSource = scity;
GrvCities.DataBind();
}
//protected void Button4_Click(object sender, EventArgs e)
//{
// tbl_city t = new tbl_city()
// {
// City = TextBoxcity.Text,
// };
// db.tbl_cities.InsertOnSubmit(t);
// db.SubmitChanges();
// LoadGrvCities();
//}
public void LoadGrvCities()
{
try
{
var query = from item in db.tbl_cities
select item;
if (query.Count() > 0)
{
GrvCities.DataSource = query;
GrvCities.DataBind();
}
}
catch (Exception ex)
{
}
}
