Go4Expert

Go4Expert (http://www.go4expert.com/)
-   ASP (http://www.go4expert.com/forums/asp/)
-   -   Paging Problem in Datagrid...! (http://www.go4expert.com/forums/paging-datagrid-t14005/)

asad_black 18Sep2008 09:46

Paging Problem in Datagrid...!
 
hi, i have a very small problem in datagrid which is basically contain on the paging problem.

i create a registration page for new user. my page contain datagrid and a form which contain registration textfields.

my record insert successfully, but problem is that when i click on the number for view next pages then its shows only registration textfields not a datagrid.

i dont know what is the problem ....! kindly solve my problem as soon as possible. my code is...!



<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>DataGrid - Insert</title>
</head>
<body leftmargin="0" topmargin="0">
<form id="Form1" method="post" runat="server">
<table id="Table1"
style="Z-INDEX: 110; LEFT: 5px; POSITION: absolute; TOP: 5px"
cellspacing="0" cellpadding="0" width="300" border="0" >
<tr>
<td colspan="3">
<asp:DataGrid id="dgNorthwind" runat="server"
Width="728" Height="150px" BorderColor="#CC9966"
BorderStyle="None" BorderWidth="1"
BackColor="White" CellPadding="2" EnableViewState="False" AllowPaging="True" PageSize="3" OnPageIndexChanged="pager" >
<PagerStyle Mode="NumericPages" />

</asp:DataGrid>
</td>
</tr>
<tr>
<td colSpan="3" style="height: 19px"></td>
</tr>
<tr>
<td colSpan="3" style="height: 148px">
<p>
<asp:Label id="Label1" runat="server"
Width="317" BackColor="Firebrick" ForeColor="White">
Insert a new record...
</asp:Label>
</p>
<table id="Table2">
</td>
</tr>
<tr>
<td colSpan="4" style="width: 441px"></td>
</tr>
<tr>
<td style="width: 115px; height: 24px">
<asp:Label ID="Labelfirstname" runat="server" Text="First Name"></asp:Label></td>
<td style="height: 24px; width: 277px;"><asp:TextBox id="txtfirstname" runat="server" width="193" /></td>
<td style="width: 277px; height: 24px">


<asp:RequiredFieldValidator id="rfvfirstname" runat="server"
ErrorMessage="Please Enter the First Name"
ControlToValidate="txtfirstname" /></td>
</tr>
<tr>
<td style="width: 115px; height: 24px">
<asp:Label ID="Labellastname" runat="server" Text="Last Name"></asp:Label></td>
<td style="height: 24px; width: 277px;"><asp:TextBox id="txtlastname" runat="server" width="193" /></td>
<td style="width: 277px; height: 24px">

<asp:RequiredFieldValidator id="rfvlastname" runat="server"
ErrorMessage="Please Enter the Last Name"
ControlToValidate="txtlastname" /></td>
</tr>
<tr>
<td style="WIDTH: 115px; height: 24px;">
<asp:Label id="Label2" runat="server">Username</asp:Label>
</td>
<td style="height: 24px; width: 277px;">
<asp:TextBox id="txtUserName" runat="server" width="193" />
</td>
<td style="width: 277px; height: 24px">


<asp:RequiredFieldValidator id="rfvUserName" runat="server"
ErrorMessage="Please Fill the Username"
ControlToValidate="txtUserName" /></td>
</tr>
<tr>
<td style="WIDTH: 115px">
<asp:Label id="Label3" runat="server">Password</asp:Label>
</td>
<td style="width: 277px">


<asp:TextBox id="txtPassword" runat="server" width="193" TextMode="Password" /></td>
<td style="width: 277px">


<asp:RequiredFieldValidator id="rfvPassword" runat="server"
ErrorMessage="Please Fill the your desire Password"
ControlToValidate="txtPassword" /></td>
</tr>

<tr>
<td style="WIDTH: 115px">
<asp:Label id="Label4" runat="server" Width="118px">Confrim Password</asp:Label>
</td>
<td style="width: 277px">


<asp:TextBox id="txtconfirmpass" runat="server" width="193" TextMode="Password" /></td>
<td style="width: 277px">

<asp:CompareValidator
id="compval"
Display="dynamic"
ControlToValidate="txtPassword"
ControlToCompare="txtconfirmpass"
ForeColor="red"
BackColor="yellow"
Type="String"
EnableClientScript="false"
Text="Your Password Does Not Match"
runat="server" Width="271px" /></td>
</tr>


<tr>
<td style="WIDTH: 115px" colSpan="2"><br />
<asp:Button id="btnInsert" runat="server"
OnClick="btnInsert_Click" width="298" text="INSERT!" />
</td>
<td colspan="1" style="width: 115px">
<asp:Label ID="msgofaddusername" runat="server" Width="238px"></asp:Label></td>
</tr>
</table>




</form>


</body>
</html>

<script runat="server">
Dim objConnection As OleDbConnection
Dim daNorthwind As OleDbDataAdapter
Dim dsNorthwind As DataSet

Sub Page_Load(ByVal Source As Object, ByVal E As EventArgs)
objConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _
& "DATA SOURCE=" _
& Server.MapPath("nwind.mdb;"))

Dim strSQL As String = "SELECT firstname, lastname, username, pw " & _
"FROM login"
daNorthwind = New OleDbDataAdapter(strSQL, objConnection)

' Create a command builder object in order to create
' INSERT, UPDATE, and DELETE SQL statements automatically
Dim cb As New OleDbCommandBuilder(daNorthwind)

' Is the page being loaded for the first time?
If Not Page.IsPostBack Then
FillDataGrid()
End If
End Sub
Sub FillDataGrid()

' Create a new dataset to contain categories' records
dsNorthwind = New DataSet()

' Fill the dataset retrieving data from the database
daNorthwind.Fill(dsNorthwind)

' Set the DataSource property of the DataGrid
dgNorthwind.DataSource = dsNorthwind.Tables(0).DefaultView

' Bind the dataset data to the DataGrid
dgNorthwind.DataBind()
End Sub



Sub pager(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEvent Args)
dgNorthwind.CurrentPageIndex = e.NewPageIndex

FillDataGrid()
End Sub

Sub btnInsert_Click(ByVal Sender As Object, ByVal E As EventArgs)


' If user has filled every text box correctly...
If Page.IsValid Then

' Create a temporary dataset to contain the new record
Dim dsTemp As New DataSet()

' Fill the temporary dataset
daNorthwind.Fill(dsTemp)
' Create a new row
Dim r As DataRow = dsTemp.Tables(0).NewRow()

' Add the category name, reading its value from the text box
r("firstname") = txtfirstname.Text

' Add the category description, reading its value from the text box
r("lastname") = txtlastname.Text

' Add the category name, reading its value from the text box
r("username") = txtUserName.Text

' Add the category description, reading its value from the text box
r("pw") = txtPassword.Text

' Add the new row into the dataset's rows collection
dsTemp.Tables(0).Rows.Add(r)

' Update the database using the temporary dataset
daNorthwind.Update(dsTemp)

' Usually, you have to call the AcceptChanges() method in order to align the
' dataset with records in the database. Because this is a temporary dataset,
' we can omit this instruction.
dsTemp.AcceptChanges()

' Refresh the data grid to display the new record
FillDataGrid()

msgofaddusername.Text = "New account of " + txtfirstname.Text + " " + txtlastname.Text + " has been created successfully"


End If
End Sub





</script>


All times are GMT +5.5. The time now is 06:03.