i managed to fill the datagrid with all the data i want but now i need to add one more column to it whereby the fields inside will be a hyperlink to send data to either a variable or to a function. i only managed to do until the adding of column. Thanks for your help.
Dim data AsNew clsPDData
Dim ds As DataSet = data.GetData("Select ID, Name from Pt Where ID = '" + txtSearch.Text + "'")
Dim dc As DataColumn = New DataColumn("Status")
ds.Tables(0).Columns.Add(dc)
DataGrid1.DataSource() = ds
DataGrid1.DataBind()
Dim data AsNew clsPDData
Dim ds As DataSet = data.GetData("Select ID, Name from Pt Where ID = '" + txtSearch.Text + "'")
Dim dc As DataColumn = New DataColumn("Status")
ds.Tables(0).Columns.Add(dc)
DataGrid1.DataSource() = ds
DataGrid1.DataBind()