View Single Post
  #1 (permalink)  
Old November 2nd, 2006, 10:29 AM
harshwardhan_kulkarni harshwardhan_kulkarni is offline
Registered User
 
Join Date: Jul 2006
Location: indore, m.p., India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to harshwardhan_kulkarni
Default allow paging problem

I have put the code
 Me.DataGrid1.CurrentPageIndex = e.NewPageIndex
        Try
            Dim StrC As New Verify
            'Dim dtr As SqlDataAdapter

            Dim SqlConn As New SqlConnection(StrC.StrConn)
            Dim SqlCmdb As New SqlCommand("SearchFltEqComp", SqlConn)
            'Dim SqlCmdb As New SqlCommand("newabc", SqlConn)
            SqlCmdb.CommandType = CommandType.StoredProcedure
            SqlCmdb.Parameters.Add("@rSt", 1)
            SqlCmdb.Parameters.Add("@rT", 5)
            SqlCmdb.Parameters.Add("@fS", 1)
            SqlCmdb.Parameters.Add("@fT", 5)
            Dim i As Integer
            i = 0
            SqlCmdb.Parameters.Add("@Times", i)
            SqlCmdb.Parameters.Add("@rfld", ".NET")

            SqlCmdb.Parameters.Add("@fld", "software")
            SqlCmdb.Parameters.Add("@bd", "Bsc")
            SqlCmdb.Parameters.Add("@md", "Msc")
            SqlCmdb.Parameters.Add("@Comp", "Abcd Pvt. Ltd")
            SqlCmdb.Parameters.Add("@appFld", "software")
            SqlCmdb.Parameters.Add("@appRole", "Sr.Programmer")
            SqlCmdb.Parameters.Add("@Role", "Programmer")
            SqlCmdb.Parameters.Add("@AppRel", ".NET")
            Dim Fdt As Date
            Fdt = "1/1/1999"
            Dim Tdt As Date
            Tdt = "12/1/2006"
            SqlCmdb.Parameters.Add("@Fdt", Fdt)
            SqlCmdb.Parameters.Add("@Tdt", Tdt)
            SqlConn.Open()
            Dim dtr As New SqlDataAdapter(SqlCmdb)
            dtr.Fill(ds)
            Me.DataGrid1.DataSource = ds.Tables(0)
            Me.DataGrid1.DataBind()
             SqlConn.Close()
            Dim x As Integer
            Dim Str As String
            For x = 0 To Me.DataGrid1.Items.Count - 1
                Str = CType(Me.DataGrid1.Items.Item(x).Cells(0).Controls (1), LinkButton).Text
            Next
        Catch ex As Exception
            Me.Label1.Text = ex.Message
        End Try
yet the mark of next button is not activated
why