Hi,
I want my gridview to be disabled during page-load.During the button ckick only it should be enabled . I am also using paging concept in my Grid.If i make my function call at page-load it's working exactly.But i dont want my grid to be enabled at page-load .It should be enabled on button click.Someone nos help me out
here is my code.Candidatedetails is ny gridview name and quick is my table name.
Imports System.Data.Sqlclient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load()
If flg = 1 Then
Call g()
Else
CandidatesDetails.Visible = False
MsgBox("hai")
End If
End Sub
Protected Sub DisplayCandidateCount_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles DisplayCandidateCount.Click
Dim db As Database = Nothing
db = DatabaseFactory.CreateDatabase("DEVTEST")
Dim count As Integer = CType(db.ExecuteScalar(CommandType.Text, "SELECT COUNT(*) FROM QUICK"), Integer)
Dim message As String = String.Format("There are {0} customers in the database", count.ToString())
MsgBox(message)
End Sub
Dim flg As Integer = 0
Public Sub DisplayCandidateList_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles DisplayCandidateList.Click
flg = 1
End Sub
Sub g()
Dim db As Database = Nothing
db = DatabaseFactory.CreateDatabase("DEVTEST")
Dim ds As DataSet = db.ExecuteDataSet(CommandType.Text, "SELECT CANDIDATENAME,CANDIDATEID,AGE From Quick")
Me.CandidatesDetails.DataSource = ds.Tables(0)
CandidatesDetails.AllowPaging = True
CandidatesDetails.AllowSorting = True
CandidatesDetails.EnableSortingAndPagingCallbacks = True
CandidatesDetails.PageSize = 5
CandidatesDetails.Visible = True
CandidatesDetails.DataBind()
End Sub
End Class