Linq To Xml Datasource For Grid View Is Not Working - The Grid Show No Rows

Jun 30, 2010

I'm getting some Xml back from a service. I would like it to be the datasource of a grid view on my aspx page. Here is a sample of the Xml

<?xml version="1.0" encoding="utf-16" ?>
<ArrayOfTripTollCompleteDC xmlns:xsi=[URL]"
xmlns:xsd=[URL]>
<TripTollCompleteDC>
<TripTollId>5</TripTollId>
<DMSLaneModeID xsi:nil="true" />
<HOVOnly>false</HOVOnly>
<CreateDateTime>2010-06-07T15:54:01.023</CreateDateTime>
<ConfigVTMSDelaySeconds>5</ConfigVTMSDelaySeconds>
</TripTollCompleteDC>

and here is my code that parses the xml and tries to bind the grid. What am I missing here?

var retVal = service.GetTripDetailsByTripID(tripId);
var xmlTrips = XDocument.Parse(retVal);
var tripTolls =
from t in xmlTrips.Elements("TripTollCompleteDC")
select new {
TripTollId = (int)t.Element("TripTollId")
, DMSLaneModeID = (int?)t.Element("DMSLaneModeID")
, HOVOnly = (bool)t.Element("HOVOnly")
, CreateDateTime = (DateTime)t.Element("CreateDateTime")
, ConfigVTMSDelaySeconds = (int)t.Element("ConfigVTMSDelaySeconds")
};
grdTripDetails.DataSource = tripTolls;
grdTripDetails.DataBind();

I realize these are anonymous types. Is that a problem? I have verified the service is returning the Xml as stated above. Can anyone out there point me in the right direction? Just for completeness, here is the grid markup <asp:GridView runat="server" ID="grdTripDetails" />

View 1 Replies


Similar Messages:

Forms Data Controls :: Want To Show Datalist In Grid View View Column On Click Of Linkbutton Show?

Apr 20, 2010

I have gridview and want to show datalist in grid view view column on click of linkbutton show.

[Code]....

View 2 Replies

Forms Data Controls :: Have A Grid View With Some Coulmns Like Name,Phone No Etc With Edit,Delete Column In Grid View?

May 27, 2010

i have a grid view with some coulmns like Name,Phone no etc with Edit,Delete column in grid view. I click a row in grid view to Edit,it goes another page where i can edit all fields .Once i update i redirect the page to gridview. I want the grid view to remain in that particular page say 4 of the grid view

View 5 Replies

Forms Data Controls :: Custom Grid View Header - Grid View Row Created Event Versus Gridview Row Databound Events

Aug 24, 2010

It happened to add an extra Gridveiw Header in row_databound event , It did worked fine on !Postback but disappered on Page.Postback . Quick google search guided me to move the event to Row_Created event and every thing is okay .

Can any expert post some pointers , differnces between grid row_created vs row_databount with some sample table data created dynamically behaviour of both the events in !Postback and page.Postback .

View 2 Replies

Forms Data Controls :: Click Button Outside Grid View And Display The Grid View Upon Load?

Feb 9, 2011

I am doing a online web application whereby user is able to enter in new template as well as search for template. The Add template is located outside the grid view and if user clicks on the button, it will load the grid view that is populated with data as there is a row of empty fields at the bottom. However when I click on the Add Template button, the grid view does not appear.

This is my business logic that I used it to search for records as well to click on the Add Template button to add in new records:

[Code]....

[Code]....

[Code]....

View 6 Replies

Forms Data Controls :: Extract Value In Grid View And Display It In A Textbox In Grid View ?

Jun 8, 2010

i have a grid view which displays only one value and i need to extract that value and display it in a textbox?

View 4 Replies

C# - How To Calculate Row-wise Sum Of Values In Grid-view And Display It In Grid View

Mar 14, 2011

I have a grid view which displays some values. now i have to calculate row wise sum of those values for each row and then display against them.i tried this code but i am getting error as Input String Was not in Correct Format.

public void gv_RowCreated(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int total = Convert.ToInt32(e.Row.Cells[1].Text) + Convert.ToInt32(e.Row.Cells[2].Text) + Convert.ToInt32(e.Row.Cells[3].Text) + Convert.ToInt32(e.Row.Cells[4].Text) + Convert.ToInt32(e.Row.Cells[5].Text) + Convert.ToInt32(e.Row.Cells[6].Text) + Convert.ToInt32(e.Row.Cells[7].Text);
((Label)gv.FindControl("Label8")).Text = Convert.ToString(total);
}
}

View 2 Replies

Use ValidatorCalloutExtender To Validate Zero Rows Of Grid View

Nov 6, 2010

can i use ajaxtoolkit:ValidatorCalloutExtender to validate zero rows of a grid view

View 1 Replies

Forms Data Controls :: Show View In Grid View?

Jun 8, 2010

i have created a simple view, and display it into gridview.. i have successfully created view but it is not shown in grid view , it return nothing...

protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=E:
arenHDI-AJAX-TK-Calendar-CSApp_DataDatabase.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from nview", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}

View 3 Replies

Forms Data Controls :: Can't Get The Blank Grid With 5 Rows To Show Up

Jun 25, 2010

I found code [URL] that allows multiple-row inserts, and tried to convert it to vb.net. I can't get the blank grid with 5 rows to show up -- for some reason the datasource won't bind.

[Code]....

Code gridview:

[Code]....

View 4 Replies

Forms Data Controls :: Show Grid With All Orders And In Grid One Column With Last State Of Order?

Feb 2, 2011

I have an entity "Order", which contains a set of states. Every state has date and name.

I want show grid with all orders and in grid one column with last state of order. But I dont understand how to do it.

View 1 Replies

Forms Data Controls :: Count The No Of Rows In Grid View?

Nov 9, 2010

I am having a grid view

[Code]....

now depending on the text of lblstatus i want to count the no of rows in the gridview....

i m binding the lblstatus with two values 1 and 0...

now i want to count the no of rows in gridview whose lblstatus is 1...

View 34 Replies

Forms Data Controls :: Selecting Rows From A Grid View?

Oct 17, 2010

How do you select value from a gridview? I would like to pass values of rows selected to a query with the code below, but the grid seems to be frozen and I can't find a property for the grid that allows me to select rows.

Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles GridView1.SelectedIndexChanged
Dim DB As New AOP29DBDataContext
If GridView1.SelectedValue = "Receiver" Then
Dim Query = From p In DB.Receivers
Select p
GridView2.DataSource = Query
GridView2.DataBind()
End If
If GridView1.SelectedValue = "Donor" Then
Dim Query = From p In DB.Donors
Select p
GridView2.DataSource = Query
GridView2.DataBind()
End If
End Sub

View 4 Replies

Forms Data Controls :: How To Retain Old Rows In Grid View

Mar 22, 2011

am using a stored proc: that uses text of a textbox as input parmeter and returns single result each time ,am binding grid view to this stored proc:,now wat happens is the data gets displyed in grid view and whn i give new input in text box ,the old data in grid view is lost and new data comes...now wat are the options i have to keep the old data in grid view?/.

View 8 Replies

Forms Data Controls :: Force Grid View To Select Next Row On A Button_click Which Is Outside The Grid?

Jun 23, 2010

Have a GridView with a templated select button hidden and using

e.Row.Attributes.Add("onclick",Page.ClientScript.GetPostBackEventReference(this.grdMaster, "Select$" + e.Row.RowIndex.ToString())); to select a row .

When user like to update the datasource he will select one row from gridview then in selected indexchanged event i would display the selected row values beneath the form under the grid , Then user will update the contents displayed from grid and click an update button which is outside the grid . After updating the displayed row , i got to get the values of the next row in the grid and display them for next updation , i'e if users maually selects row 3 from grid then he can update the values using the update button and then on update click itself i'll have to display next row contents of row 4 and this process could go on .

View 3 Replies

How To Remove Grid Lines From Grid View Suing Style Sheet

Mar 31, 2010

how to remove grid lines from Grid View suing style sheet...

View 1 Replies

Forms Data Controls :: How To Edit Grid View (draged The Grid To The Aspx Page)

Sep 29, 2010

I have a grid view that does add, edit update and delete. ( I draged the grid to the aspx page ) it is working. I would like to have the following : once I lick on edit, I open a form inside the grid view to edit the fields. How can I do that.

View 4 Replies

Forms Data Controls :: Deleting The Rows In Grid View At Runtime?

Mar 17, 2011

I have created a gridview which adds a remove button through item template. I wish to know how do u remove the row from grid view dynamically depending upon the button he clicks ?

protected void RemoveBtn_OnClick(object sender, EventArgs e)
{
Button clickedButton = sender as Button;
GridViewRow row = (GridViewRow)clickedButton.Parent.Parent;
int rowID = Convert.ToInt16(row.RowIndex);
GridView1.DeleteRow(rowID);
}
<asp:GridView ID= "GridView1" runat="server" AutoGenerateColumns="true" OnRowDeleting="RowDeletingEvent">
<Columns>
<asp:TemplateField HeaderText="Remove Items">
<ItemTemplate>
<asp:Button id="RemoveBtn" runat="server" Text="Remove" OnClick="RemoveBtn_OnClick"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

View 5 Replies

JQuery :: Save Multile Rows In Grid View Using Jqery Json?

Mar 10, 2011

how to save multile rows in grid view using jqery json

View 4 Replies

LINQ Option Missing In Data Source For Grid View?

May 12, 2010

I don't see a LINQ option when picking a data source for a grid view - I see the other options like SQL etc.

If I go into a page in another folder, I'm able to see this option.

I just upgraded to Visual Web Developer 2010.

View 1 Replies

AJAX :: Grid View Doesn't Show

Feb 22, 2010

I am unable to view my grid view already linked to my data source. when i run it locally it does not show... Is there any thing else should i include when calling Grid view in Ajax ?

View 2 Replies

Show Two Properties In One Column Of Grid View C#?

Feb 7, 2011

I have class Person, having two properties First Name and Last Name, if I set array of person as Data Source to GridView how can I show both First Name and Last Name in one column?/

View 2 Replies

Forms Data Controls :: Fetching Multiple Rows And Binding In Grid View?

Jun 8, 2010

I am developing an application in C# and Sql Server.

View 3 Replies

Forms Data Controls :: Dynamically Created Rows And Columns Of Grid View?

Jun 2, 2010

Need row editing on page_load for all the cells and need to validate each cell entry. Means cell1 one entery isvalid it fills thrid cell and insert or update to a table in the database. How do i handle on tab clicking to update in databse.

View 1 Replies

Finding Working Code For Pdf And Excel For Grid With In A Grid

Feb 18, 2011

i have a gridview in which there is another gridview now i want the data in the primary as well as the nested gridview in pdf and excel format. i have tried all sort of things how ever none is working can anyone send me the working code for pdf and excel for grid with in a grid.

View 3 Replies







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