Show Grid View in VB.Net
Partial Class _Default
Inherits System.Web.UI.Page Dim con As SqlConnection Dim cmd As SqlCommand Dim str As String Dim ad As SqlDataAdapter Dim dr As SqlDataReader Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
con = New SqlConnection("Data Source =MCNDESKTOP06; Initial catalog = empinfo ; User ID = sa;Password = wintellect") con.Open() Response.Write("connect")
str = (("select * from emp_info where name ='" + TextBox1.Text & "' ,address = '") + TextBox2.Text & "',email_id ='") + TextBox3.Text & "'" ad = New SqlDataAdapter(str, con) ad.Fill(ds, "emp_info") GridView1.DataSource = ds.tables(emp_info).defaultview GridView1.DataMember = "emp_info" GridView1.DataBind()
End Sub