Click here to Skip to main content
15,561,817 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Calling external DLL methods Pin
earlgraham22-Feb-07 13:51
earlgraham22-Feb-07 13:51 
GeneralRe: Calling external DLL methods Pin
pHysiX23-Feb-07 21:44
pHysiX23-Feb-07 21:44 
GeneralCalling external DLL methods Pin
pHysiX23-Feb-07 21:45
pHysiX23-Feb-07 21:45 
QuestionHow to debug Pin
No-e22-Feb-07 9:12
No-e22-Feb-07 9:12 
AnswerRe: How to debug Pin
Vasudevan Deepak Kumar22-Feb-07 18:44
Vasudevan Deepak Kumar22-Feb-07 18:44 
AnswerRe: How to debug Pin
Paddy Boyd23-Feb-07 0:49
Paddy Boyd23-Feb-07 0:49 
GeneralRe: How to debug Pin
No-e23-Feb-07 3:05
No-e23-Feb-07 3:05 
QuestionProblems with query pagination in asp.net Pin
haggenx22-Feb-07 4:35
haggenx22-Feb-07 4:35 
Hi!

I have a problem, i am programming a datagrid in asp.net under webmatrix, only is a connection to access database and show this query in a datagrid, every very good exception for the query pagination.
How i can allow what, if the user press a number of page from query, then the asp change the query result to the number page?, attach the code because not work this section, thanks very mucho for you help.


---------------------------------------------------------------------------------------------------------


Private connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\lo que se va a estar respaldando\mio\my_access_db.mdb"
Private dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)
Private dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
private dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
private dataSet As System.Data.DataSet = New System.Data.DataSet

'/////////////////////////////////////////

Sub cmdQuery_Click(sender As Object, e As EventArgs)


If Len(Trim(txtSQLQUery.Text)) > 0 Then
SQLProcesss(Trim(txtSQLQUery.Text))
Else
MsgBox("No SQL Query string ingresed!", vbCritical, "Error")
End If

End Sub

'/////////////////////////////////////////

Sub SQLProcesss(SQLCommand)

dbCommand.CommandText = SQLCommand
dbCommand.Connection = dbConnection

dataAdapter.SelectCommand = dbCommand
dataAdapter.Fill(dataSet)

dgData.DataSource = dataSet.Tables(0)
dgData.DataBind()

MsgBox(Str(dataSet.Tables(0).Rows.Count) + " rows found!", vbInformation, "Query")

End Sub

'/////////////////////////////////////////

Sub cmdClear_Click(sender As Object, e As EventArgs)
txtSQLQuery.Text = ""
End Sub

Sub dgData_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs)

'This section not change the query results to the number page
dgData.PageIndexChanged = new DataGridPageChangedEventHandler(this.dgrdDepartments_PageIndexChanged)

End Sub

Cuando salga el sol, no estare aqui...

AnswerRe: Problems with query pagination in asp.net Pin
Vasudevan Deepak Kumar22-Feb-07 19:06
Vasudevan Deepak Kumar22-Feb-07 19:06 
QuestionSending of email in VWD 2005 Pin
zareee21-Feb-07 23:10
zareee21-Feb-07 23:10 
AnswerRe: Sending of email in VWD 2005 Pin
Vasudevan Deepak Kumar22-Feb-07 18:45
Vasudevan Deepak Kumar22-Feb-07 18:45 
QuestionHow to get the ceckbox value in to an Excel File Pin
antithx21-Feb-07 22:50
antithx21-Feb-07 22:50 
AnswerRe: How to get the ceckbox value in to an Excel File Pin
Michael Sync21-Feb-07 23:38
Michael Sync21-Feb-07 23:38 
GeneralRe: How to get the ceckbox value in to an Excel File Pin
Michael Sync21-Feb-07 23:54
Michael Sync21-Feb-07 23:54 
QuestionFrom php - passing Array to Javascript [modified] Pin
hiral_shah21-Feb-07 22:32
hiral_shah21-Feb-07 22:32 
AnswerRe: From php - passing Array to Javascript Pin
Bradml22-Feb-07 1:21
Bradml22-Feb-07 1:21 
GeneralRe: From php - passing Array to Javascript Pin
hiral_shah22-Feb-07 19:10
hiral_shah22-Feb-07 19:10 
GeneralRe: From php - passing Array to Javascript Pin
Bradml22-Feb-07 23:19
Bradml22-Feb-07 23:19 
AnswerRe: From php - passing Array to Javascript Pin
haggenx22-Feb-07 4:44
haggenx22-Feb-07 4:44 
GeneralRe: From php - passing Array to Javascript Pin
hiral_shah22-Feb-07 19:06
hiral_shah22-Feb-07 19:06 
QuestionHow to apply css to file Upload control in ASP.NET 2.0 Pin
varshavmane21-Feb-07 20:59
varshavmane21-Feb-07 20:59 
AnswerRe: How to apply css to file Upload control in ASP.NET 2.0 Pin
Michael Sync21-Feb-07 23:34
Michael Sync21-Feb-07 23:34 
AnswerRe: How to apply css to file Upload control in ASP.NET 2.0 Pin
badgrs22-Feb-07 2:35
badgrs22-Feb-07 2:35 
Questioncan we use C# and VB,Net in the same project?? Pin
Rahithi21-Feb-07 19:49
Rahithi21-Feb-07 19:49 
AnswerRe: can we use C# and VB,Net in the same project?? Pin
Michael Sync21-Feb-07 22:52
Michael Sync21-Feb-07 22:52 

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.