public SqlConnection con = new SqlConnection("server=anwar; 
uid=sa; pwd=s;database=Employee;");
 public SqlCommand cmd;
 public SqlDataAdapter da;
  public   DataSet ds;
     
cmd = new SqlCommand("select * from empdetails", con);
       
        da = new SqlDataAdapter(cmd);
        ds = new DataSet();
        da.Fill(ds, "empdetails");
        foreach(DataRow dr in ds.Tables["empdetails"].Rows)
        {
            txtempname.Text = dr["name"].ToString();
            txtdob.Text = dr["dob"].ToString();
            txtstreetname.Text = dr["street"].ToString();
        } // foreach

We r talking about vb.net not c# codding
system.data
system.data.sqlclient

dim con,s as string
con="Server=servername;database=name;uid=sa;pwd=;"
s="Select * from tablename"
dim ad as new sqldataadapter(s,con)
dim ds as dataset
ad.fill(ds)
dim dv as dataview= new dataview(ds.tables("tablename"))
dv.sort="Name desc"
listbox.datasource=ds
listbox.displayMember="Name"&"Age"&"sex"...
 
it will work fine thanx!

The sequence is
Step 1: Create a Connection Object with Connection String
         Eg: <Provider**>Connection ActiveConnection = new 
<Provider**>Connection(<ConnectionString>)

Step 2: Create a Command Object with Command Text and the 
created Connection Object

       Eg: <Provider**>Command Qry = new <Provider**>Command
(<Command Text>,        ActiveConnection)

Step 3: Set the command Type for the created Command
           Eg: Qry.CommandType = CommandType.Text

Step 4: Create Data Adapter with the created Command
          Eg: <Provider**>DataAdapter da = new 
<Provider**>DataAdapter(Qry*);

Step 5: Create a DataSet Object.
          Eg: DataSet ds = new DataSet();

Step 6: populate the dataset by calling the fill method of 
Data adaper against the Data set object
           Eg: da.Fill(ds); 

__________________________________________________________
*Qry contains a select query (or) Stored Procedure Name 
containing a Select Query

** If the provider is SQL server then the Connection type 
is SQLConnection, Command type is SQLCommand and Data 
adapter type is SQLDataAdapter.