public class DAL
{
public int Id { get; set; }
public string Name { get; set; }
public string City { get; set; }
public string Education { get; set; }

}

public SqlConnection con = new SqlConnection(con);

public List<DAL> Select_data()
{
List<DAL> D = new List<DAL>();
try
{
con.Open();
SqlCommand cmd = new SqlCommand(“select * from tbl_user”, con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DAL da = new DAL();
da.Id = Convert.ToInt32(dr[“id”].ToString());
da.Name = dr[“Name”].ToString();
da.City = dr[“City”].ToString();
da.Education = dr[“Education”].ToString();
D.Add(da);
}
con.Close();
}
catch (Exception)
{
}

return D;
}

[HttpGet]
public ActionResult SearchGrid()
{
return View(Select_data());
}

[HttpPost]
public ActionResult SearchGrid(string SearchKey)
{
List<DAL> D = new List<DAL>();
DAL dd=new DAL();
var data = (from m in Select_data() where m.Name.StartsWith(SearchKey, StringComparison.OrdinalIgnoreCase) select new { m.Name, m.City, m.Education }).ToList();

foreach (var V in data)
{
D.Add(new DAL {
Name = V.Name,
City = V.City,
Education = V.Education
});
}
return View(D);
}

@model  IEnumerable<MVC4_Search_In_Grid.Models.DAL>

@{
ViewBag.Title = “Search”;
}

@using (@Html.BeginForm())
{
<table>
<tr>
<td>
@Html.TextBox(“SearchKey”, “”)

</td>
<td>
<input type=”submit” value=”Search” />
</td>
</tr>
</table>
<table>
<tr>
<th>
Name
</th>
<th>
City
</th>
<th>
Education
</th>
</tr>
<tbody>
@foreach (var item in Model)
{
<tr id=”tr1″>
<td>
@item.Name
</td>
<td>
@item.City
</td>
<td>
@item.Education
</td>
</tr>
}
</tbody>

</table>

}

1. Auto Refresh Partial View in ASP.NET MVC
2. What is ASP.NET Core
3. Difference between TempData keep() And Peek() in Asp.Net MVC
4. Difference between viewbag,viewdata and tempdata in asp.net mvc
5. ASP.NET MVC With AngularJS
6. Retrieving Data Using Form Collection and Inserting Into ASP.Net MVC
7. MVC CRUD Operations Using Entity Framework
8. Search Functionality in ASP.NET MVC
9. How to create a User Registration page using asp.net mvc
10. Store Multiple Checkbox state from cookie using Jquery
11. Cascading Dropdownlist using Ajax in Asp.Net Mvc with city state country
12. Insert, Update, Delete In GridView Using ASP.Net C#
13. Binding Dropdownlist With Database In Asp.Net MVC
14. Search and Filter data in Gridview using Asp.net MVC
15. Select Insert, Update And Delete With ASP.NET MVC
16. Display Data in GridView Using Asp.net MVC
17. Validation in ASP.NET MVC Razor view
18. CRUD Operation Using 3-Tier Architecture In ASP.NET
19. How to get Connection String from Web.Config in Asp.Net C#
20. Login page using 3-Tier Architecture in ASP.Net
21. Asp.Net Image Upload in 3-Tier Architecture and store in sql database