Forms Data Controls :: Creating Paging Functionality With A Data List Control With Asp.net (VB, Not C#)

Nov 7, 2010

I am in need of getting the correct sysntax for being able to use paging with a datalist whose data is being generated by a SQL Datasource and a stored procedure inside the aspx(asp.net VB...Not C#) page. A Gridview or any other rigid control that does not allow full control and layout will not work so I have to use the datalist. I have the datalist working perfectly but I need to add paging. I did some searching and found a good solution. It was a C# solution, in particular the code behind syntax so I used a code converter to convert it to VB. However, as I am not an experienced coder I need help converting the portion for handling the datalist. I am fairly confident I have the buttons on the aspx page worked out. I will ask that if you se something I need to do besides the section(5) I have listed please offer suggestions. So that you can help me better I have boken the code out into sections where I'm listing the code I copied, my code and the section I need help with. I think at a minimum I will have to change the references of Repeater to Datalist.

The section I need help with is section 5 where the original autor is referencing items generated in the Repeater where he used XML. As I said I'm using a SQL Datasource with a Datalist so I truly don't understand what I need to change to get the code behind to work with my Datalist. As always I appreciate all of you guys and ladies help. And also as always I will ask to please provide the actual code to type in because telling me how to do it just won't help very much. Sorry about that.

Here is what I have:
SECTION 1 - The buttons to handle the paging
*******************************************
<td> <asp:label id="lblCurrentPage" runat="server"></asp:label></td>
</tr>
<tr>
<td> <asp:button id="cmdPrev" runat="server" text=" << " onclick="cmdPrev_Click"></asp:button>
<asp:button id="cmdNext" runat="server" text=" >> " onclick="cmdNext_Click"></asp:button></td>
</tr>
********************************************

SECTION 2 - 4Guys repeater reading an XML file
*********************************************
<table border="1">
<asp:repeater id="repeaterItems" runat="server">
<itemtemplate>
<tr>
<td> <b><%# DataBinder.Eval(Container.DataItem, "ItemName") %></b></td>
<td> <b><%# DataBinder.Eval(Container.DataItem, "ItemDescription") %></b></td>
<td> <b><%# DataBinder.Eval(Container.DataItem, "ItemPrice") %></b></td>
<td> <b><%# DataBinder.Eval(Container.DataItem, "ItemInStock") %></b></td>
</tr>
</itemtemplate>
</asp:repeater>
</table>

*********************************************

SECTION 3 - My datalist control.
********************************************
<asp:DataList ID="DataList1" runat="server" DataKeyField="eid"
DataSourceID="SqlDataSource1">
<ItemTemplate>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" width="600px">
<tr>
<td valign="top">
<table cellpadding="0" cellspacing="0">
<tr>
<td>
<b>Name</b></td>
</tr>
<tr>
<td>
<asp:Label ID="nameLabel" runat="server" style="font-size: 7pt"
Text='<%# Eval("name") %>' />
</td>
</tr>
<tr>
<td>
<b>Description</b></td>
</tr>
<tr>
<td>
<asp:Label ID="exDescriptionLabel" runat="server" style="font-size: 7pt"
Text='<%# Eval("exDescription") %>' />
</td>
</tr>
<tr>
<td>
<b>Workout Notes</b></td>
</tr>
<tr>
<td>
<asp:Label ID="notestipLabel" runat="server" style="font-size: 7pt"
Text='<%# Eval("notestip") %>' />
</td>
</tr>
<tr>
<td>
<b>Base Workout</b></td>
</tr>
<tr>
<td style="font-size: 7pt">
<asp:Label ID="broutineLabel" runat="server" Text='<%# Eval("broutine") %>' />
</td>
</tr>
<tr>
<td>
<b>Major Bodypart</b></td>
</tr>
<tr>
<td style="font-size: 7pt">
<asp:Label ID="bodypartmgLabel" runat="server"
Text='<%# Eval("bodypartmg") %>' />
</td>
</tr>
<tr>
<td>
<b>Target Bodypart</b></td>
</tr>
<tr>
<td style="font-size: 7pt">
<asp:Label ID="bodypartspecificLabel" runat="server"
Text='<%# Eval("bodypartspecific") %>' />
</td>
</tr>
<tr>
<td>
<b>Supporting Muscles</b></td>
</tr>
<tr>
<td>
<asp:Label ID="secondary_areasLabel" runat="server"
Text='<%# Eval("secondary_areas") %>' />
</td>
</tr>
</table>
<b>
<br />
</b>
</td>
<td valign="top">
<asp:HyperLink ID="HyperLink31" runat="server"
ForeColor="White"
ImageUrl='<%# Eval("videoplay") %>'
OnClick='<%# String.Format("return popIt({0})", Eval("eid")) %>'
NavigateUrl='<%# String.Format("~/player2010.aspx?eid={0} ", Eval("eid")) %>'
Text='<%# Eval("ddupdateworkout") %>'>
</asp:HyperLink>
</td>
<td valign="top">
<table>
<tr>
<td>
<table align="left" cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
<td style="text-align: center">
<asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("modelImage") %>' />
</td>
</tr>
<tr>
<td>
</td>
<td style="text-align: center">
<asp:Label ID="modelNameLabel" runat="server" Text='<%# Eval("modelName") %>' />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<asp:HyperLink ID="HyperLink1" runat="server" ForeColor="White"
NavigateUrl='<%# String.Format("~/favorites_addexercise.aspx?eid={0}&name={1}&exercateg={2}&bodypartmg={3}&bodypartspecific={4}&demolink={5} ", Eval("eid"),
Eval("name"), Eval("exercateg"), Eval("bodypartmg"), Eval("bodypartspecific"), Eval("demolink")) %>'
Text='<%# Eval("addtofavorite") %>'></asp:HyperLink>
</td>
</tr>
<tr>
<td>
<asp:HyperLink ID="HyperLink30" runat="server" ForeColor="White"
NavigateUrl='<%# String.Format("~/workouts_create.aspx?eid={0} ", Eval("eid")) %>'
Text='<%# Eval("ddnewworkout") %>'></asp:HyperLink>
</td>
</tr>
<tr>
<td>
<asp:HyperLink ID="HyperLink2" runat="server" ForeColor="White"
NavigateUrl='<%# String.Format("~/workouts_saved_addexer.aspx?eid={0} ", Eval("eid")) %>'
Text='<%# Eval("ddupdateworkout") %>'></asp:HyperLink>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
</td>
<td>
</td>
<td>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br />
<br />
</ItemTemplate>
</asp:DataList>

********************************************

SECTION 4 - Public Property CurrentPage() As Integer
Get
' look for current page in ViewState
Dim o As Object = Me.ViewState("_CurrentPage")
If o Is Nothing Then
Return 0
Else
' default to showing the first page
Return CInt(o)
End If
End Get
Set
Me.ViewState("_CurrentPage") = value
End Set
End Property
Private Sub Page_Load(sender As Object, e As System.EventArgs)
' Call the ItemsGet method to populate control,
' passing in the sample data.
ItemsGet()
End Sub

SECTION 5 - NEED HELPING IN CHANGING TO WORK WITH DATA LIST
***************************************************
Private Sub ItemsGet()
' Read sample item info from XML document into a DataSet
Dim Items As New DataSet()
Items.ReadXml(MapPath("Items.xml"))
' Populate the repeater control with the Items DataSet
Dim objPds As New PagedDataSource()
objPds.DataSource = Items.Tables(0).DefaultView
objPds.AllowPaging = True
objPds.PageSize = 3
objPds.CurrentPageIndex = CurrentPage
lblCurrentPage.Text = "Page: " & (CurrentPage + 1).ToString() & " of " & objPds.PageCount.ToString()
' Disable Prev or Next buttons if necessary
cmdPrev.Enabled = Not objPds.IsFirstPage
cmdNext.Enabled = Not objPds.IsLastPage
repeaterItems.DataSource = objPds
repeaterItems.DataBind()
End Sub

Private Sub cmdPrev_Click(sender As Object, e As System.EventArgs)
' Set viewstate variable to the previous page
CurrentPage -= 1
' Reload control
ItemsGet()
End Sub

Private Sub cmdNext_Click(sender As Object, e As System.EventArgs)
' Set viewstate variable to the next page
CurrentPage += 1
' Reload control
ItemsGet()
End Sub

View 1 Replies


Similar Messages:

Forms Data Controls :: What's The Best Grid Control For Paging Without Creating A Stored Procedure

Jan 6, 2011

I have been using the GridView control, to display data, but now my two datasources (Informix, and VisualM/Mumps) makes it very difficult to create a store procedure to with paging. Is there a better data grid, that will allow my users to scroll/search the current data set?

View 1 Replies

Forms Data Controls :: Create List View To Provide Functionality

Apr 26, 2010

I am trying to create a list view to provide functionality similiar to the pages in this article(will end up being much simpler in my case)

[URL]

Basically I need three columns. Column 1 will be populated on page load with a list of user names and some data. Clicking on a user from column 1 will query for data regarding that user and bring back multiple rows to be displayed in Column 2. Clicking on data from a row in column 2 will return rows to be displayed in column 3. I am just curious as to how some of you guys would approach this. Ive looked at grouping templates and some articles regarding listviews with multiple rows but. Would it be easier to use 3 seperate listviews? Any ideas or articles to point me in the right direction?

View 2 Replies

Forms Data Controls :: Checkbox In List View With Paging?

Mar 17, 2011

[URL] i am trying to display one check box that would perform 'selectall/deselect all' . As I have data paging, I assume I do not have the id's of page 2 yet. how would one go about implementing this.

View 1 Replies

Forms Data Controls :: GridView Paging Error When Bound To A List?

Jan 21, 2010

I have this grid view

[Code]....

The first page show up just fine, when i try to go to the second page of the GV i get this errorThe GridView 'GVCreditMemos' fired event PageIndexChanging which wasn't handled.

View 14 Replies

Forms Data Controls :: How To Enable Paging-List Binded Gridview

Feb 6, 2011

I am binding the gridview with the list like this

<ev_event> objev_event = new List<ev_event>();
GridView1.DataSource = objev_event.ToList();
GridView1.DataBind();

I want to enable paging for the Gridview. when I enable True for Enable paging property, The error throws.how to enable the paging for list binded GridView?

View 3 Replies

Forms Data Controls :: Any Data Presentation Control With Custom Paging?

May 1, 2010

My question is if my page size is 10 records per page and my query returning 100,000 rows then remaining all records are not in use for that page.

Is there any way so I can only fetch records from table as page size (10) with all page numbers at bottom and fetch next 10 records only when user clicks on next page number?

View 1 Replies

Forms Data Controls :: Drag And Drop Functionality In Treeview Control

Nov 23, 2010

Could you point me to a reference article on how to implement drag and drop within a treeview control using ASP.NET in C#? Is this best implemented with AJAX? I will be using an XMLDatasource. Also, I did not want to use any third party control at this point

View 2 Replies

Forms Data Controls :: Creating Dynamic Rows In A Table From List?

Sep 7, 2010

am creating dynamic rows in a table from List<Productos> but this list have repeats same objects depending of quantity for one product.

[Code]....

I like that the products are not repeated but instead that show the quantity in a label.

View 2 Replies

Forms Data Controls :: Creating Data Table In Memory And Binding To Gridview Control?

Jun 24, 2010

I'm a bit of an ASP.NET newbie and I am creating a data table in memory and binding this to a gridview control. The code is as follows:

Dim DstBasket As New DataSet, TblBasket As New DataTable
With TblBasket
.Columns.Add("BskPrdCd", System.Type.GetType("System.String"))
.Columns.Add("BskPrdDesc", System.Type.GetType("System.String"))
.Columns.Add("BskQty", System.Type.GetType("System.Int16"))
.LoadDataRow(Split("12345,Test product 1,1", ","), True)
.LoadDataRow(Split("122,Test product 2,2", ","), True)
.LoadDataRow(Split("123A,Test product 3,5", ","), True)
.LoadDataRow(Split("44,Test product 4,1", ","), True)
End With
DstBasket.Tables.Add(TblBasket)
With LfnGridView("GdvBasket")
.DataSource = DstBasket
.DataBind()
End With

The data displays in the gridview control fine with both edit & delete options but when I attempt to delete, it has no effect. How do I force removal of the relevant row from both gridview and table? Most of the documentation I have unearthed shows how to achieve this when connected to a SQL table which is clearly not the case here.

View 2 Replies

Forms Data Controls :: Creating A Single Item From Two Data Fields In A HYPERLINK Control Within A Repeater...

Jun 22, 2010

I am trying to use a repeater control that will display a hyperlink control. For the text of that Hyperlink control I would like to concatenate to fields from my data source (lets say First Name and Last Name). How would I do this appropriately for the Hyperlink control within an ItemTemplate?

View 3 Replies

Forms Data Controls :: Paging In Repeater Control

Jul 1, 2010

I am trying to experiment with things as a beginner and want to use paging in Repeater Control. Since Repeater control is light weight, I want to use that. I have heard of two methods: PagedDataSource class and the other that I dont remember. I wanted to attempt both of them. How do I proceed?

View 2 Replies

Forms Data Controls :: Set Paging In Datalist Control?

Jan 11, 2011

How to set paging in datalist control using asp.net+C#.net?

View 6 Replies

Forms Data Controls :: How To Do Paging In Datalist Control

Nov 3, 2010

How to do paging in datalist control

View 1 Replies

Data Controls :: Display Empty Message When Data List Is Empty When Working With Alphabet Paging

Jun 27, 2012

When I click on the Alphabets it will show the details of a player...however, when that particular letters has no details of the player..I want to show."No results can be found"..Is there anyway to do it?

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["CurrentAlphabet"] = "ALL";
this.GenerateAlphabets();

[code]...

View 1 Replies

Forms Data Controls :: Datalist Paging Using Pager Control

Apr 10, 2010

i am using asp:pager to do paging for datalist... i have successfully implemented it but the problem is that he is showing all the page nos at one time instead of that i want to show 10 pages at a time then user goes on the last page then next 10 pages should show...

View 3 Replies

Forms Data Controls :: Paging In Gridview Control Asp.net 2.0, MySQL

Feb 20, 2010

I am a new user of ASP.NET 2.0 (VB.NET)
I am facing a problem related to GridView Control

I have a table <UsersDetail> with following structure in MySQL

FIELDNAME | DATATYPE
---------------------------------------
userid | Numeric
Userlogin | Varchar(25)
Userpassword | Varchar(25)
Firstname | Varchar(50)
Lastname | Varchar(50)
---------------------------------------

I wrote a code to fetch data from this table :

Dim Con As New MySqlConnection
Dim Cmd As New MySqlCommand
Dim Adp As New MySqlDataAdapter
Dim DTable As DataTable
Con.ConnectionString = ConfigurationManager.ConnectionStrings("dbConString").ConnectionString
Cmd.CommandType = CommandType.StoredProcedure
Cmd.CommandText = "sp_FetchAllUsers"
Cmd.Connection = Con
Adp = New MySqlDataAdapter
Adp.SelectCommand = Cmd
DTable = New DataTable
Adp.Fill(DTable)
GridView1.DataSource = DTable
GridView1.DataBind()

Basically Gridview controls is used to display data in tabular format.
but due to requirement I changed its layout to columner in following manner

<asp:GridView ID="myGridView" runat="server" AutoGenerateColumns="false" AllowPaging="True" PageSize="3" Width="520px">
<Columns>
<asp:TemplateField HeaderText="User ID">
<ItemTemplate>
<asp:Label ID="Label3" Text='<%#Eval("userid") %>' runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="User Login">
<ItemTemplate>
<asp:Label ID="Label4" Text='<%#Eval("Userlogin") %>' runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Pack Amount">
<ItemTemplate>
<asp:Label ID="Password" Text='<%#Eval("Userpassword") %>' runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="For">
<ItemTemplate>
<asp:Label ID="First name" Text='<%#Eval("Firstname") %>' runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Validity">
<ItemTemplate>
<asp:Label ID="Last name" Text='<%#Eval("Lastname") %> Months' runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

Now come to the problem, i set the AllowPaging="True" and page size to 3 records/page but when click on paging links it displays the following error :

The GridView 'myGridView' fired event PageIndexChanging which wasn't handled.

Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The GridView 'myGridView' fired event PageIndexChanging which wasn't handled.

Source Error:

[Code]....

View 4 Replies

Forms Data Controls :: How To Implement Paging Without Objectdatasource Control

Apr 14, 2010

I have read many online articles showing how to implement custom paging with stored procedure and objectdatasource control. So I know the benefits of custom paging on large result sets and I know how to implement it.

In my application, I have a stored procedure which is using ROW_NUMBER and taking parameters such as startIndex, pageSize etc. I also have method in my DAL who call this stored procedure and on my page I have GridView and ObjectDataSource control and they are calling DAL methods and everything is working perfectly fine.

Now I want to implement GridView paging without ObjectDataSource control by calling the DAL methods manually. I dont want to use ObjectDataSource control because I need manual access to the DataTable my DAL methods return which I think I dont have if I use ObjectDataSource control.

how to implement paging without ObjectDataSource control

View 4 Replies

Forms Data Controls :: Sorting And Paging Using DataList Control

Oct 19, 2010

Am trying to use sorting and paging using a Asp.net DataList Control.....I found a Tutorial at asp.net website, but not able to understand that. I found other two links ,which exactly is of my need...but the only thing is that , it is in VB...[URL]

But Am working with C# I wanna Use Sorting & Paging For this

[Code]...

[Code]...

View 3 Replies

Forms Data Controls :: Paging Repeater Control In Databinding?

May 3, 2010

I have a strange problem. I have made a PagedRepeater control, which inherits from the Repeater, from a tutorial I saw here: http://www.4guysfromrolla.com/articles/020905-1.aspx. It's in VB and I'm in C#, and it didn't quite have all the features I was lookingfor, so, I've modified it quite a bit. I added support for a SqlDataSource control, as well. The only problem is, that it always returns the first item from the SqlDataSource, even when the CurrentPageIndex on the PagedDataSource is set to a different value.

View 1 Replies

Forms Data Controls :: To Enable Paging In .net Datalist Control

Sep 26, 2010

How to enable paging in Asp.net Datalist control

View 1 Replies

Forms Data Controls :: Creating Control Preferrably Using The DropDownList Control?

Sep 14, 2010

assuming there is no ComboBox control in ASP.NET (or is there?????) : I want to create such a control preferrably using the DropDownList control.

View 3 Replies

Forms Data Controls :: Get Result Search With Paging In DataList Control

Sep 16, 2010

I have Database called mygroup , and I have three tables:

* Cataloges table .. columns (CatalogeId
int, CatalogeName
nvarchar)
* Brand table .. columns (BrandId
int, BrandName
nvarchar)

* Products table, it is consists of these columns :

ProductId int

ProductNO nvarchar

CatalogeId int

BrandId int

MainSpecification nvarchar

DetailsSpecification ntext

Image imageand I want to desgin form for products, and this form contain these ToolBox

* DropDownList for CatalogeId

* DropDownList for BrandId

* DataList Control for displaying the Result Search

* Button

When the user visit Product Page for Example (productpage.aspx), then he see the two DropDownList , then choose one of Cataloge Name (Laptop , Printer, ....) , and choose one of the Brand Name (Sony, Toshiba, ....) , then Click the Button, and get the Result Search in Paging DataList

View 7 Replies

Forms Data Controls :: Add Paging To Datalist Control Linked To An SQL Server For Asp.net 2.0 Using C#

Jan 25, 2010

Does anyone have a simple / working example of how to add paging to a Datalist control when the data for the Datalist control comes from an SQL database?

View 4 Replies

Forms Data Controls :: Grid View Control Paging With Dropdown

Dec 20, 2010

I am using grid view control with paging Like-:

protected
void grdUpdateColumn_RowCreated(object
sender, GridViewRowEventArgs
e)
{

if (e.Row.RowType ==
DataControlRowType.Pager)
{
DropDownList ddl
= new
DropDownList();
//adds variants of pager size
ddl.Items.Add(
"5"
);
ddl.Items.Add(
"10"
);
ddl.Items.Add(
"20"
);
ddl.Items.Add(
"50");
ddl.AutoPostBack = true;
//selects item due to the GridView current page size

ListItem
li = ddl.Items.FindByText(grdUpdateColumn.PageSize.ToString());
if (li !=
null
)
ddl.SelectedIndex = ddl.Items.IndexOf(li);
ddl.SelectedIndexChanged +=
new
EventHandler(ddl_SelectedIndexChanged);
//adds dropdownlist in the additional cell to the pager table
Table pagerTable = e.Row.FindControl("pagerTable")as
Table;
//e.Row.Cells[0].Controls[0] as Table;
TableCell cell =
new
TableCell
();
cell.Style[
"padding-left"] =
"15px"
;
cell.Controls.Add(
new
LiteralControl("Page
Size:"
));
}
protected
void ddl_SelectedIndexChanged(object
sender, EventArgs
e)
{
//changes page size
grdUpdateColumn.PageSize = int.Parse(((DropDownList)sender).SelectedValue);
ViewState["Index"]
= 1;
//binds data source
this.GetChangesRecord();
}
Grid view Like -:
<PagerTemplate>
<asp:Table
ID="pagerTable"
runat="server"><asp:TableRow>
</asp:TableRow>

It's working fine but problem is that if i select 10 and record from dropdown and record also has 10 then paging is not showing.

That's mean i select 10 from dropdown and record is 10 then dropdown also disable with numbers, suppose i need to select again 5 then i can't do this.

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved