Dim szQuery As String = "select * from emp where empid=10"

Dim objAdp As OleDbDataAdapter = New OleDbDataAdapter(szQuery, "Connectionstring")

Dim objDS As new DataSet
objAdp.Fill(objDS , "emp") //give table name here

Dim con As SqlConnection = New SqlConnection(ConnStr)
Dim strQuery As String = "select  Name from emp where Id>100"
Dim ada As SqlDataAdapter = New SqlDataAdapter(strQuery, con)
Dim lds As DataSet = New DataSet
ada.Fill(lds)
gvSales.DataSource = lds
gvSales.DataBind

imports System
imports System.Data
imports System.Data.SqlClient

Public Class Form1
Dim sqlConn as new SqlConnection("Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password")
Dim da as  SqlDataAdapter
Dim ds as new DataSet
Dim Sql as String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)     
      if Not Page.IsPostBack then
        Try
            sqlConn.Open()
            Sql = "select * from emptable"
            da = New SqlDataAdapter(Sql,sqlConn )
            da.Fill(ds)
            sqlConn.Close()
            DataGridView1.Data Source= ds.Tables(0)
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
   end if
End Sub 
End Class

Dim SQLCon As New SqlClient.SqlSQLConection
SQLCon.SQLConectionString = "Data Source=<Database Server>;Initial Catalog=Data base name;Integrated Security=SSPI;"
SQLCon.Open()

Dim SQLCmd As New SqlClient.SqlCommand
SQLCmd.CommandText = "SELECT name,address,city FROM employee"
SQLCmd.CommandType = CommandType.Text
SQLCmd.SQLConection = SQLCon

Dim dt As New DataTable
dt.Load(SQLCmd.ExecuteReader)

DataGridView1.AutoGenerateColumns = True
DataGridView1.DataSource = dt

SQLCmd.Dispose()
SQLCon.Dispose()

using System.Data;
using System.Data.SqlClient;
public partial class GridViewOperation : System.Web.UI.Page
{
    SqlConnection sqlcon = new SqlConnection(@"Server= RAVI-PC\SQLEXPRESS;database=test1;uid=ravindran;pwd=srirangam;");
    SqlCommand sqlcmd;
    SqlDataAdapter da;   
    DataSet ds = new DataSet();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {           
            GridData();
        }
    }
    void GridData()
    {
        sqlcmd = new SqlCommand("select * from emp", sqlcon);
        sqlcon.Open();
        da = new SqlDataAdapter(sqlcmd);        
        da.Fill(ds);
        if (ds.Tables[0].Rows.Count > 0)
        {  
            GridView1.DataSource = ds.Tables[0];
            GridView1.DataBind();
        }        
    }
}