Click here to Skip to main content
16,005,169 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Random Draw Pin
Sam Heller9-May-07 3:33
Sam Heller9-May-07 3:33 
GeneralRe: Random Draw Pin
Tarakeshwar Reddy9-May-07 3:45
professionalTarakeshwar Reddy9-May-07 3:45 
QuestionHow to get a PopUp Pin
Spunky Coder9-May-07 2:05
Spunky Coder9-May-07 2:05 
AnswerRe: How to get a PopUp Pin
varshavmane9-May-07 2:26
varshavmane9-May-07 2:26 
AnswerRe: How to get a PopUp Pin
varshavmane9-May-07 2:28
varshavmane9-May-07 2:28 
QuestionASP Grid Pin
speedy_gonzalas9-May-07 2:04
speedy_gonzalas9-May-07 2:04 
AnswerRe: ASP Grid Pin
varshavmane9-May-07 2:20
varshavmane9-May-07 2:20 
GeneralRe: ASP Grid Pin
speedy_gonzalas9-May-07 18:32
speedy_gonzalas9-May-07 18:32 
i guess problem is due to parameters i am passing in Qry strin that every time parameters are passed again and results comes same instead of next page


on Page load i have this code
If Not Page.IsPostBack Then
bind SQL
end if

BindSQL()
'DSgrid is a data.dataset
'DB is a object of a class where i make connection

dsgrid = db.getRecords("SELECT attendence.EmpNo, Strength.Name,convert(varchar,Strength.DOJ,101)as DOJ,Strength.EmpStatusid,convert(varchar,attendence.Date,101)as DDate,convert(varchar,attendence.InTime,108) As InTime,convert(varchar,attendence.OutTime,108)As OutTime,attendence.Present AS Status,convert(varchar,(OutTime-InTime),108)As WorkedHrs FROM attendence INNER JOIN Strength ON attendence.EmpNo = Strength.EmpNo Where attendence.EmpNo ='" & cempid & "'AND attendence.Date >= '" & mfromdate & "' And attendence.Date <= '" & mtodate & "' Order by Date")

Dim mtcheck As Integer = dsgrid.Tables(0).Rows.Count()
If mtcheck = 0 Then
lblerror.Visible = True
Label3.Visible = False
Label5.Visible = False
lblerror.Text = "No Record Found"
Else


DG_CheckBox.DataSource = dsgrid
DG_CheckBox.DataBind()
End If


End Sub

Sub myDataGrid_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub



K Dastgir

GeneralRe: ASP Grid Pin
varshavmane9-May-07 20:06
varshavmane9-May-07 20:06 
GeneralRe: ASP Grid Pin
speedy_gonzalas9-May-07 20:13
speedy_gonzalas9-May-07 20:13 
GeneralRe: ASP Grid Pin
varshavmane9-May-07 20:34
varshavmane9-May-07 20:34 
QuestionRental System Pin
Brendan Vogt9-May-07 1:35
Brendan Vogt9-May-07 1:35 
Questionhow to edit DropDownList [modified] Pin
savindra.bandi9-May-07 1:34
savindra.bandi9-May-07 1:34 
AnswerRe: how to edit DropDownList Pin
Sandeep Akhare9-May-07 3:56
Sandeep Akhare9-May-07 3:56 
GeneralRe: how to edit DropDownList Pin
savindra.bandi9-May-07 19:23
savindra.bandi9-May-07 19:23 
QuestionRadioButton List Disabled Problem Pin
sonia_basangar9-May-07 1:34
sonia_basangar9-May-07 1:34 
AnswerRe: RadioButton List Disabled Problem Pin
varshavmane9-May-07 2:30
varshavmane9-May-07 2:30 
AnswerRe: RadioButton List Disabled Problem Pin
Sandeep Akhare9-May-07 2:32
Sandeep Akhare9-May-07 2:32 
QuestionRadioButtonList Problem Pin
sonia_basangar9-May-07 1:31
sonia_basangar9-May-07 1:31 
Questionusage of COM Component in .net Pin
vijay_839-May-07 1:27
vijay_839-May-07 1:27 
AnswerRe: usage of COM Component in .net Pin
Sandeep Akhare9-May-07 2:04
Sandeep Akhare9-May-07 2:04 
GeneralRe: usage of COM Component in .net Pin
vijay_839-May-07 18:43
vijay_839-May-07 18:43 
QuestionDifference between Asp.Net Ajax 1.0 and Atlas Pin
Bijay Bhaskar Deo9-May-07 1:14
Bijay Bhaskar Deo9-May-07 1:14 
AnswerRe: Difference between Asp.Net Ajax 1.0 and Atlas Pin
Sylvester george9-May-07 1:24
Sylvester george9-May-07 1:24 
GeneralRe: Difference between Asp.Net Ajax 1.0 and Atlas Pin
Bijay Bhaskar Deo9-May-07 1:32
Bijay Bhaskar Deo9-May-07 1:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.