Hi Destinykid,
Use Contains function.
Check this example. Now please take its reference and correct your code.
HTML
<asp:TextBox runat="server" ID="txtName" />
<asp:Button ID="btnDelete" Text="Delete" runat="server" OnClick="OnDelete" />
<asp:GridView runat="server" ID="gvCustomers"></asp:GridView>
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
CustomerEntities entity = new CustomerEntities();
gvCustomers.DataSource = entity.Customers.ToList();
gvCustomers.DataBind();
}
}
protected void OnDelete(object sender, EventArgs e)
{
CustomerEntities entity = new CustomerEntities();
List<Customer> customers = entity.Customers.Where(c => c.Name.Contains(txtName.Text.Trim())).ToList();
entity.Customers.RemoveRange(customers);
entity.SaveChanges();
gvCustomers.DataSource = entity.Customers.ToList();
gvCustomers.DataBind();
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim entity As CustomerEntities = New CustomerEntities()
gvCustomers.DataSource = entity.Customers.ToList()
gvCustomers.DataBind()
End If
End Sub
Protected Sub OnDelete(ByVal sender As Object, ByVal e As EventArgs)
Dim entity As CustomerEntities = New CustomerEntities()
Dim customers As List(Of Customer) = entity.Customers.Where(Function(c) c.Name.Contains(txtName.Text.Trim())).ToList()
entity.Customers.RemoveRange(customers)
entity.SaveChanges()
gvCustomers.DataSource = entity.Customers.ToList()
gvCustomers.DataBind()
End Sub