I am running the procedure below on my vb.net page when ever the datagrid is clicked. it is picking up the correct screenid number but when the page is viewed if the dataset has no records in it the datagrid remains keeps the same records. Can someone tell me how to get it to switch to no records if none are returned.
SqlDataAdapter6.SelectCommand.Parameters("@paramid").Value = screenid
DataGrid1.DataSource = (DsPAScreen61)
DataGrid1.DataMember = "tblPAPhoneVoucher"