Protected Sub btStart_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btStart.Click Session("NoOfRecords") = 0 Try sqlConn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("Constr") With sqlComm .Connection = sqlConn .CommandText = "OLE_InsertExamDetails" .CommandType = CommandType.StoredProcedure .Parameters.Add("@RollNumber", SqlDbType.Char, 100).Value = Trim(txtrollnumber.Text) .Parameters.Add("@ExamDate", SqlDbType.DateTime).Value = "02-02-2009" .Parameters.Add("@SemesterName", SqlDbType.Char, 20).Value = "One" .Parameters.Add("@Papertype", SqlDbType.Char, 20).Value = RadioButtonList1.SelectedItem.Text End With sqlDataAdap.SelectCommand = sqlComm sqlConn.Open() sqlDataset = New DataSet sqlDataAdap.Fill(sqlDataset) Catch ex As Exception lblmessage.text ="Error in inserting" End Try sqlConn.Close() MsgBox(sqlDataset.Tables.Count) MsgBox(sqlDataset.Tables(0).Rows.Count) End Sub it displays number of tables and corresponding records but when i click on another command button ] for number of tables it displays 0 and for number of rows it generates error cannot find table 0

Hi When you select the rows from table sorted by some order let's say sorting by name you can ranking for selected rows and then get the rows where between 1 and 14 This sample query may help you: DECLARE @PageIndex int = 1, DECLARE @PageSize int = 14 SELECT * FROM ( -- selecting the rows sorted by name SELECT Row_NUMBER() OVER (ORDER BY Name DESC) AS Row, Q.* FROM Questions_Table Q ) AS questions WHERE Row BETWEEN CONVERT(nvarchar(10), ((@PageIndex - 1) * @PageSize + 1)) AND CONVERT(nvarchar(10),@PageIndex*@PageSize) Hope that helps -- http://ashakthi.blogspot.com http://kids-articles.blogspot.com

its a simple one... Take two grid in the first grid if u click a row get the identity value and pass it as a values for the select query whcih will ne like"select * from table where id = //your value" and assign the datasouce for the next grid..... Padmanabhan

Dear govindi, There are two way to put grid on the page. First is that you can put it into the another grid (Nested grid). and the another one is that you put seperate grid on the page. In nested grid you hv to bind the second grid in rowdatabound event. Let me know if u want another clearficitation. _Anil jhgdgf