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.
I have a Dictionary and I bind it to my Grid view...
[Code]....
But its not paging at all... is it even possibe to page if you are bound to a Dictionary?
DLRepository is a class with method getDLandRules. I am binding the gridview with the list that is returned by method. Now I would like to iterate through the list and add 1 more column to each row that is returned. currently, I am getting an error
GridView1.Rows[row].Cells[7].Text 'GridView1.Rows[row].Cells[7]' threw an exception of type 'System.ArgumentOutOfRangeException' strin
I have a generic list of a custom type. The custom type has a string and double.I'm binding the list to a gridview and it outputs everything fine.I'm trying to format the double column into a currency format. It is in a template field as I'm calculating a running total. I pass the value to a function that returns a double and adds the current value to a running total which I will show in the footer.
The format is not changing to currency as expected when using String.Format("{0:c}", GetTotal(Convert.ToDouble(Eval("Amount"))))
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?
i use objectdatasource control for bind record and also in gridview paging.in my gridview there is a linkbutton(edit) when i click it then it redirect to next page with some key value.but problem is when i try to paging in gridview an error is occure that is Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
protected void grdClassList_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow row = grdClassList.Rows[Convert.ToInt32(e.CommandArgument)];//error
[code]...
I have a rather large gridview that I need to page. the follwoing is my code but when I try to page it gives me a internet lost connection error??? I have not gotten to work in dot.net 4.0 this code is from one of my projects in 1.1 where it works fine but for some reason it is changes for 4.0.
[Code]....
Is there a way to use the GridView paging and having the links not use JavaScript. So that when you click on the page number 5 (for example) that link is a hyperlink.
View 3 RepliesI have a databound FormView with a dropdown list of categories. All works as expected, but I want to provide the facility for the user to add a new category to the list and I can't find an elegant way to do it. My current approach is to have a simple modal popup (Ajax toolkit) with a FormView (bound to the Categories table). That successfully inserts the new row, but it doesn't show in the dropdown so it can't be selected. I can force a refresh by calling formview.DataBind() in a suitable event handler, but that of course moves the formview off the selected record and loses any changes the user may have made.
Is there a convenient way (perhaps using AJAX, avoiding a postback entirely) to update the Categories table and refresh the dropdown without moving off of the current FormView's record? I feel sure this
must be a frequent and basic requirement, but I've not found any mention of how to implement it.
[ASP.Net 4.0, by the way]
How can I bind a datalist control with a list of objects. I have a list of objects that contain a name, desc, and url for menu commands that I am trying to show in a DataList. I am getting the list from a WCF service so I have a list called something like menuList which consists of a List<MenuCommands>. I then do a menuDataList.DataSource = menuList and then a menuList.DataBind but nothing is happening. What am I missing here? I need to use a DataList because I need the commands to be selectable.
View 11 RepliesMy griedview code :-
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" RowStyle-BackColor="Black" Font-Names = "Arial" Font-Size = "10pt"
HeaderStyle-BackColor="Black" HeaderStyle-ForeColor="Black" ForeColor="Black" AllowPaging ="true"
OnPageIndexChanging = "OnPaging" PageSize = "5">
[Code] ....
Error is:- The data source does not support server-side data paging.
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.NotSupportedException: The data source does not support server-side data paging.
Source Error:
Line 34: con.Open();
Line 35: GridView1.DataSource = cmd.ExecuteReader();
Line 36: GridView1.DataBind(); Line 37: con.Close();
Line 38: }
I am using Visual Studio 2010 and SQLServer 2008. I have a GridView and code is
[Code]....
And populating grid on Page load Event like this.
[Code]....
[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 RepliesI 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
I have some data which contains angle brackets in some of the fields.Even if properly escaped as <: or > (or even the hex codes), or contained in CDATA, in Visual Studio 2005 ASP.Net, the field data is being truncated at the first angle bracket. If I replace the data with curly braces, it displays fine.Is this a parser defect in the TreeView control? I can use Response.Write and see that the data provided by the XmlDataSource is fine. Example:
<ITReview>
<row TopNode="REQ 123456 TT Description <Date sent to app dev> <Priority> <SubTask Status>"/><row TopNode="REQ 456789 TT Description <Date sent to app dev> <Priority> <SubTask Status>"/>
</ITReview>
<ITReview>
<row TopNode="REQ 123456 TT Description <Date sent to app dev> <Priority> <SubTask Status>"/><row TopNode="REQ 456789 TT Description <Date sent to app dev> <Priority> <SubTask Status>"/>
</ITReview>
This truncates right after TT Description. If I change to curly braces or parentheses, it displays fine.
I'm trying to follow this article on cascading dropdown list in a GridView control in edit mode (except I'm using C#) [URL] I keep getting this error message "ProjectID is neither a DataColumn nor a DataRelation for table DefaultView."
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)
{
DataRowView dv = (DataRowView)e.Row.DataItem;
//// Preselect correct value in Projects list
DropDownList listProjects = (DropDownList)e.Row.FindControl("DropDownList1");
listProjects.SelectedValue = dv["ProjectID"].ToString(); // *****************this is where I get the error *********
// Databind list of categories in dependent drop-down list
DropDownList listCategories = (DropDownList)e.Row.FindControl("DropDownList2");
SqlDataSource dsc = (SqlDataSource)e.Row.FindControl("sdsDDL2");
dsc.SelectParameters["ProjectName"].DefaultValue = dv["ProjectName"].ToString();
listCategories.DataBind();
listCategories.SelectedValue =(dv["CategoryID"].ToString());
}
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>" SelectCommand="SELECT
TE.TimeEntryID,
P.ProjectName,
CAT.CategoryName,
TE.TimeEntryDescription,
TE.TimeEntryDuration,
TE.TimeEntryDate
FROM dbo.aspnet_starterkits_TimeEntry TE inner join
dbo.aspnet_starterkits_ProjectCategories CAT on
TE.CategoryID=CAT.CategoryID inner join
dbo.aspnet_starterkits_Projects P on
CAT.ProjectID=P.ProjectID
Where TimeEntryUserID=(SELECT UserId FROM dbo.aspnet_Users WHERE
UserName=@UserName) AND
TE.TimeEntryDate=@WeekEnding
" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE dbo.aspnet_starterkits_TimeEntry
SET
TimeEntryDescription=@TimeEntryDescription,
TimeEntryDuration=@TimeEntryDuration,
TimeEntryDate=@TimeEntryDate
WHERE
TimeEntryID=@original_TimeEntryID">
<SelectParameters>
<asp:ControlParameter ControlID="UserList" Name="UserName"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="WeekEnding2" Name="WeekEnding"
PropertyName="Text" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="TimeEntryDescription" />
<asp:Parameter Name="TimeEntryDuration" />
<asp:Parameter Name="TimeEntryDate" />
<asp:Parameter Name="original_TimeEntryID" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" BorderWidth="0px"
BorderStyle="None" Width="100%" CellPadding="2" PageSize="25"
DataKeyNames="TimeEntryID" onrowdatabound="GridView1_RowDataBound"
onrowupdating="GridView1_RowUpdating" >
<Columns>
<%--<asp:CommandField ShowEditButton="True" />--%>
<asp:BoundField DataField="TimeEntryID" HeaderText="ID"
SortExpression="TimeEntryID" InsertVisible="False" ReadOnly="True"
ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="Project" SortExpression="ProjectName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="sdsDdlProjectsEdit"
DataTextField="ProjectName"
DataValueField="ProjectID"
AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDdlProjectsEdit"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT ProjectID,ProjectName FROM dbo.aspnet_starterkits_Projects">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("ProjectName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList2"
runat="server"
DataSourceID="sdsDDL2"
DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDDL2"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT CategoryID,CategoryName FROM dbo.aspnet_starterkits_ProjectCategories WHERE ProjectID=@ProjectID">
<SelectParameters>
<asp:Parameter Name="ProjectID" />
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:BoundField DataField="TimeEntryDescription" HeaderText="Description"
SortExpression="TimeEntryDescription" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="TimeEntryDuration" HeaderText="Hours"
SortExpression="TimeEntryDuration" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField ApplyFormatInEditMode="True" DataField="TimeEntryDate"
DataFormatString="{0:d}" HeaderText="Week Ending"
SortExpression="TimeEntryDate" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:CommandField ShowEditButton="True" HeaderText="Edit" ButtonType="Image" EditImageUrl="images/icon-edit.gif"
UpdateImageUrl="images/icon-save.gif" CancelImageUrl="images/icon-cancel.gif" />
</Columns>
</asp:GridView>
If the gridview binds to empty dataset, I need to still show a gridview so that users can ADD more using the textfields in the bottom of the footer template. Since the gridview is empty it won't bind not allowing rendering of the <footer template> I guess I should create a empty dataset if the gridview is empty. How do I check for this and can this be done in GridviewRowEventArgs
View 5 RepliesI got his code for RowDataBound
[Code]....
I have a foreign key (TeamID) in a GridView. I use a TemplateField to display it as the lookup value (TeamName) in a label, and a dropdown for editing. When row is selected and SelectedIndexChanged is fired, I want to access the TeamID. I can get the TeamName from the label. I tried putting the TeamID in DataKeyNames, but that fouled up my dropdown when saving (it reverts to the original value). So, how can I get the TeamID?
View 1 RepliesI am having a hard time updating from my gridview based the value that I am setting in the datakeynames it is the Ucc field I keep getting and index out of range exception on the e.keys[0]. I have done this before so I am confused what I am missing here.
View 8 Replieswhat it is i have a datagrid bound to a datatable.This datatable fills from a sql table. This datatable will have 2 columns which is 'part' and 'description'.What it is I want to have a couple of chk boxes next to the datagrid which will filter it by column 'part'.The issue is the datagrid will have about 1000 records so i dont want to do a for next loop searching for field part for a certain filter
View 1 RepliesI have a gridview being data bound by an objectdatasource which points to a BLL/DAL. I have paging and sorting enabled within the gridview. I have the fields configured in the look/fell I want from a templatefield. This templatefield has the sort expression (date) I want things to be sorted by. All this works as it should and I have no issues with it.But, the issue is that when I click on the header to sort asc/desc by date, I have to click on it twice for it switch to descending order. E.g. I hit the webpage and it lists all the information in the gridview, sorted by date, ascending order. If I want to sort by descending order, I have to click the date header twice in order for the gridview to sort the information in descending order; the clicks cause a post-back and the whole screen is refreshed.
View 2 RepliesI have a Gridview that has a template field containing a bound textbox (fieldname is 'Status'). I have an extra column containing an update button, which is designed to update the db with whatever is in the textbox.
What's happening is that when I load the form, the textbox is blank, even though there is existing data in the fields. If however I click the update button, all the textboxes in the Status column update and populate with the correct data from the database. I guess my question is why would bound textboxes not populate until an update command is run?
VS2010 Ultimate ASP.NET 4.0 Web Appliction project
I have a simple aspx page with a GridView Bound to an ObjectDataSource utilizing a class object that returns a DataView.
There are no errors generated, but the GridView does not display any rows. If I check the return value of the ObjectDataSource in the Selected event in the Immediate window (?CType(e.ReturnValue,DataView).Count), there are 51 rows. However, (?Me.GridView1.Rows.Count) shows 0 rows. The exact same page in VS2008, ASP.NET 3.5 works fine. how to get the GridView to display the rows? What has been done to the GridView in 4.0?
Page and code below -
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm2.aspx.vb" Inherits=".WebForm2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
[Code]....
so instead of a datasource control, I have a Data Access class that I'm using to populate the ListviewI added a datapager and everything pretty much works until I hit the first or last button. Then, I get the following error: Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/>Also, Something was mentioned about ClientScriptManager.RegisterForEventValidation - - couldnt' really find an implementationI tried setting:EnableEventValidation="false", but then, all I got was squirelly interaction with all the numbered links (sometimes having to double click them, etc) - no matter what I tried from there on out, even when I removed the enableEventValidation property altogether.
View 7 Replies
