View Code Snippet

Author: Gehan Fernando
Date Submitted: 7/2/2007
Category: Database
Compatibility: .NET
This code has been accessed 5225 times.

Task: VB.Net - Use Dataview { Data Type Component } To Filter Data In Very Easy Way. No Need To Write SQL Queries, One SQL Query Enough To Do All The Things.

Declarations

Code

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load DataGridView1.DataSource = ReturnDataTable() End Sub Public Function ReturnDataTable() As DataTable Dim SQLCon As New SqlClient.SqlConnection("Data Source=UDEESHA;Initial Catalog=Gehan;Integrated Security=True;Pooling=False") SQLCon.Open() Dim SQLCom As New SqlClient.SqlCommand("SELECT * FROM Students", SQLCon) Dim DSet As New DataSet() Dim DAdap As New SqlClient.SqlDataAdapter(SQLCom) DAdap.Fill(DSet) Return DSet.Tables(0) End Function Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim DView As New DataView(ReturnDataTable()) With DView .AllowDelete = False .AllowEdit = False .AllowNew = False .RowFilter = "StudName LIKE '" & TextBox1.Text.ToString().Trim() & "%'" .RowStateFilter = DataViewRowState.OriginalRows .Sort = "ID" End With DataGridView1.DataSource = DView End Sub