Im trying to build a database application

i don't know how to do it in vb but in c# you can use an sqldataadapter to query the results you want.



string studid = "Your student id"

SqConnection myconnection = new SqlConnection(@"YourConnectionstring here");
SqlDataAdapter myadapter = new SqlDataAdapter();
myadapter.SelectCommand = myconnection.CreateCommand();

myadapter.SelectCommand.Commandtype = Commandtype.Text;
myadapter.SelectCommand.CommandText = "Your Query String here";
myadapter.SelectCommand.Parameters.AddWithValue("@param",studid);

DataTable da = new DataTable();

//fill the datatable

myadapter.Fill(da);

//bind the your a datagridview on the datatable

DatagridView1.DataSource = da;





I'm just a newbie trying to help.. :)