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
|