Binding Tuple Output To The Gridview?

Mar 4, 2011

I am developing a web application where in i have a WCF service which interacts with the database using entity framework. I want to get rid of creating Classes for each & every LINQ query
e.g

public class Emp
{
public int CD{get;set;}
public string Name{get;set;}
}
public List<Emp> GetServTypeForPromotionDue()
{
return (from a in Context.TableName
select new Emp{ a.CD, a.NAME });
}

for other table & LINQ i have to create a separate class every time. Alternative to this is to use Anonymous method which is not preferable solution. To avoid both the methods I am using Tuple Class where I return List> or List> depending on the return type. This works fine but the problem is I am binding the result of LINQ query directly to a Gridview By default Tuple has properties item1,item2,..& so on. So my griview shows these names are column names so, Is there any way I can change the property name to CD, Name instead of Tuple's Item1, Item2 before binding to grid?

View 2 Replies


Similar Messages:

Check If Output Parameter Is Null Before Binding?

Jan 26, 2011

How can i check if an output parameter is null before i bind it to a asp literal, and if it is null i want to just make the literal

hname1.Text = cmd.Parameters("@hotel1").Value
hname1.DataBind()
hname2.Text = cmd.Parameters("@hotel2").Value

[code]...

View 1 Replies

C# - Bug With Tuple And Typed Views.

Sep 2, 2010

Got a werid problem with a view, if i define it with Inherits="System.Web.Mvc.ViewPage<List<Tuple<string, DateTime?, double?, double?, double?>>>"
i get the werid error:
CS1003: Syntax error, '>' expected
Line 118: public class views_report_intrestcalc_aspx : System.Web.Mvc.ViewPage<List<Tuple<string, System.Web.SessionState.IRequiresSessionState, System.Web.IHttpHandler {


But it workes perfectly if i remove the last", double?".A bug in the asp.net comiller?

View 3 Replies

Javascript - Tuple<string, Int> JSON To Pass To Wcf?

Mar 29, 2011

how to pass this via Json.Tried doing something like

var data = { Item1: "test", Item2: 5 };
var JSONdata = $.toJSON(data);

However that did not work. Although simply changing wcf to expect an object with two properties such as Item1 and Item2 will work. Here is example I'm using... I'll trim it a bit to make it easier to read:

function Post(data, url)
{
$.ajax({
type: 'POST',[code].....

View 1 Replies

Web Forms :: Browser Output Doesn't Look Like Web Developer Output Using Nested Master Pages And Css Stylesheets

Apr 18, 2010

First off, suggest better ways if you want rather than patch up this code. I am just starting this project and it is first time I have tried to code a web site so anything you suggest is very much welcomed. I have spent the last 2 and 1/2 days trying to find workable answers to this but none I have found and tried seem to fit. If needed I can email screens shots or code. I am trying to construct a website that will have the same main theme throughout as far as the header, navbars sitemap, and footer go. Naturally the content will vary from page to page. I want to use a single master page and css stylesheet for this main theme and I will change the content format as needed per page because each page may vary somewhat.

However, about 15 of the pages will all use the same format for their content and this format will differ from the rest of the site but the format of the main theme will stay the same. So I am trying to create a nested master page to use to format the just the content area for all these pages while retaining the main theme for the header, etc.. I believe I should use a separate css file with the nested master page to handle the formatting of the content areas for these 15 pages. I have code that looks like it works when viewed in web developer but design view but does not work when viewd through a browser (IE, Chrome, Firefox). So far I have the following done in web developer.

If it helps the code and screen shots follow. Master Page called "Parent.master". For all theme throughout site Nested Master Page called "Lab.master". For the 15 like pages Primary stylesheet file for main theme called "StylesheetNew.css" For site theme Secondary stylesheet file to syle the 15 like formatted pages. It is called Labmaster.css Labs.apsx file to use as first of the 15 like pages.
Finally screens shots from web developer and browser. Sorry try as I might I could not capture screenshots and put them into this post. The problem is that web developer shows all the area (many lines high) with gray background and with the XXX text that I want to allocate for content in the 15 pages. Yet all the browser show is one line of text o a white background followed by the footer. It looks like the LabStyleSheet works in Web Developer but not in a browser.

Parent.master
<%@ Master Language="VB" CodeFile="Parent.master.vb" Inherits="MasterPage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL]">
<html xmlns="[URL]">
<head id="ParentHeader" runat="server">
<title>HX5</title>
<asp:ContentPlaceHolder runat="server" id="headerPlaceHolder" />
<link href="~/StyleSheetNew.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div id="wrapper" >
<div id="Header" >
<table class="hdrtbl1" >
<tr>
<td id="hdrtd1" style="width:175px; height:100px;" >
<img id="logo" alt="Logo" src="../Images/logo.png" style="width: 136px; height: 87px" />
</td>
</tr>
</table >
<table class="hdrtbl2" >
<tr><td id="hdrtbl2td1"><b> Providing Professional Technical, Manangement and Business Solution</b></td></tr>
<tr><td id="hdrtbl2td2"> <b> Services since 2004 </b></td></tr>
<tr> <td id="hdrtbl2td3" align="center" ><img id="rdln" alt="RedLine" style=" height:3px;" src="../Images/RedLine.png" /></td></tr>
<tr><td id="hdrtbl2td4" > <b>Committed to Excellence In All We Do</b></td></tr>
</table>
</div>
<div id="navbardiv">
<ul id="topnav">
<li><a href="../pages/about.aspx" >About Us <img style=" border: none; " src="../Images/arrow-down.gif" /></a>
<!--Subnav Starts Here-->
<span>
<a style="font-weight:lighter; " href="#" >Who We Are </a> |
<a href="#">Locations</a> |
<a href="#">Business Classifications</a> |
<a href="#">Contact Us</a> |
</span>
</li>
<!--Subnav Ends Here-->
<li><a href="../pages/services.aspx">Services <img alt="arrow" style="border: none; " src="../Images/arrow-down.gif" /></a>
<!--Subnav Starts Here-->
<span>
<a style="font-weight:lighter; " href="#" >Capabilities</a> |
</span>
<!--Subnav Ends Here-->
</li>
<li><a href="#">Customers <img style=" border: none; " src="../Images/arrow-down.gif" /></a>
<span>
<a style="font-weight:lighter; " href="#" >Subnav Link</a> |
<a href="#">Customer Locations</a> |
<a href="../pages/labs.aspx">Labs</a> |
</span>
</li>
<li><a href="#">Careers <img style=" border: none; " src="../Images/arrow-down.gif" /></a>
<!--Subnav Starts Here-->
<span>
<a style="font-weight:lighter; " href="#" >Joining the HX5 Team</a> |
<a href="#">Current Opportunities</a> |
</span>
</li>
</ul>
</div>
<div id="subnavbar" >
<!-- <asp:SiteMapPath ID="SiteMapPath" runat="server">
</asp:SiteMapPath> -->
</div>
<div id="topContent" style="border-bottom:solid 1px #191970;">
<table>
<tr><td style="height:30px; width:900px;" >
<asp:ContentPlaceHolder id="TopPlaceHolder" runat="server">
</asp:ContentPlaceHolder>
</td>
</tr>
</table>
</div>
<!-- <div id="mainContent"> -->
<asp:ContentPlaceHolder id="MainPlaceHolder" runat="server" />
<!-- </div> -->
<!-- <div id="lowerContent"> -->
<asp:ContentPlaceHolder id="LowerPlaceHolder" runat="server">
</asp:ContentPlaceHolder>
<!-- </div> -->
<div id="footerContent" style=" height:50px; width:900px; text-align: right; background-color: #ccc; ">
<span style=" font-family: Arial, Helvetica, sans-serif; font-size: xx-small; font-weight: bold; color: #000080; margin: 30px 20px 0px 0px;"> Copyright 2010 HX5, LLC All rights reserved</span></div>
</div>
</form>
</body>
</html>

View 4 Replies

C# - Output A GridView To Excel Outside Of Page?

Feb 24, 2011

I want to have a helper class that can serve requests from multiple pages to output contents of any gridview to excel. But if I pass in the GridView it throws an error that it must be inside "form runat='server'" tags, which makes sense. However is there anyway to do this in a seperate class that is not directly connected to any particular page?

[Code]....

View 1 Replies

Modifying The Html Output Of A Gridview?

Jul 28, 2010

I'm trying to modify the output of my GridView in the RowDataBound event handler, but it's not working - nothing happens.

My code:

Private Sub MyGridView_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs) Handles MyGridView.RowDataBound
e.Row.Attributes.Add("data-xkoordinat", 0)
End Sub

[Code]....

Is there anything here that would cause the rows not to be databound? I'm reloading via F5 or by selecting the address field in my browser and hitting Enter, so I don't think postbacks should be an issue.

View 3 Replies

C# - Binding DataTable To GridView, But No Rows In GridViewRowCollection Despite GridView Population?

Jun 2, 2010

I've coded a GridView in the markup in a page. I have coded a DataTable in the code-behind that takes data from a collection of custom objects. I then bind that DataTable to the GridView. (Specific problem mentioned a couple code-snippets below.)

GridView Markup:

<asp:GridView ID="gvCart" runat="server" CssClass="pList" AutoGenerateColumns="false" DataKeyNames="ProductID">
<Columns>
[code]....

Goal: I'm basically trying to find a way to update the data in my GridView (and more importantly my cart Session object) without having to do everything else I've seen online such as utilizing OnRowUpdate, etc. Could someone please tell me why gvCart.Rows is empty and/or how I could accomplish my goal without utilizing OnRowUpdate, etc.? When I execute this code, the GridView gets populated but for some reason I can't access any of its rows in the code-behind.

View 5 Replies

SQL Server :: Stored Procedure Output In Gridview Incorrect?

Feb 10, 2011

We had a simple Gridview that displayed a column list as Linkbuttons but we now need to display three columns as one, so I wrote a simple stored procedure to do it. However, the output in the Gridview shows duplicates and is not in order even though I specifySELECT DISTINCT in the result select as shown below.

ALTER PROCEDURE [dbo].[GetGeneralAction]
Add the parameters for the stored procedure here
AS
BEGIN
SET NOCOUNT ON;
CREATE TABLE #TempTbl (GeneralAction varchar(300) )
INSERT INTO #TempTbl (GeneralAction)
SELECT [General Action]
FROM [dbo].[Formulary2011]
INSERT INTO #TempTbl (GeneralAction)
SELECT [General Action2]
FROM [dbo].[Formulary2011]
[code]...

View 7 Replies

Forms Data Controls :: Binding DataSet And GridView, Apply Bulk Rows Edit And Update On GridView

Dec 10, 2010

I have a set of dataset with different column retrieved from DB. I need to present the datasets in one GridView (or other ListView etc...) without specifying the column_header. It should present automaticly since the GridView is bind to the DataSet.

In additional, I want this GridView to handle multiple rows edit and update the dataset, idealy, show data in textboxs in initially.How could I set the GridView to edit_model without hardcode column_header and textboxs in 'itemtemplate' or filed.

How could I achieve the bulk edit and update, so that I can assign 'mydataview1.table' to the dataset.

View 1 Replies

Forms Data Controls :: GridView Not Displaying Sorted Output?

Mar 1, 2010

I am building a SortedList object for use as the DataSource of a GridView control. The key-value pairs are being built manually with the "key" fields being inserted in already sorted order. The "key" column is invisible with the "value" column the single displayed data item. I set the DataSource property of the gridview to the sortedlist and call the Bind method. The gridview then displays the data in random fashion!

View 4 Replies

VS 2008 Checkbox Column In Gridview/unable To Get Correct Output, Because Database Null?

Oct 20, 2010

SOURCE CODE -

Code:
<asp:GridView runat="server" ID="Grd" AutoGenerateColumns ="false" >
<Columns >[code]....

You can see in Pic Attached, Records of table TBL_STUDENT, and also find the output what I am getting . For the records - 2 and 3 whose Name is B and C, I m getting the correct status,But for the Record whose Name is A, I am not getting correct Output, Because in Database null is dere, I want if in database null is dere then checkbox is Unchecked. How to to dat???

View 3 Replies

Binding Xml Data Into Gridview Using C#?

Mar 24, 2010

I have a XML file which contains a list of items/elements:

[Code]...

I can bind the data into a gridview. However, only the attributes are displayed(which is: category and ID). I need the elements to display out too (which is: Name,Description,Latitude and Longtitude).

Would anyone be kind enough to solve this problem for me?

And is it possible to populate a drop down list in using the same XML file? As in populating the category in the drop down list.

View 2 Replies

ArrayList Binding To Gridview?

Jan 26, 2011

I have an arraylist of string items that I want to bind to a gridview.I want to bind the value from each item to a asp:HyperLinkField but I dont know what the DataTextField should be? The arraylist obviously doesn't have a column heading as it's just 1 dimensional.What value do I need to use in the DataTextField?

View 3 Replies

C# - Gridview Binding To XML - Something Missing?

Jan 1, 2010

I am trying to make a simple grid view that is binded to a simple xml document but I must be missing something since I am keep getting error message:

The data source for GridView with i 'GridView1' did not have any properties or attributes from which to generate columns. Ensure that your data source has content.

Code

<asp:GridView ID="GridView1" runat="server" DataSourceID="XmlDataSource1">
<Columns>
<asp:BoundField DataField="id" HeaderText="ID" SortExpression="id" />[code]...

Is it perhaps my xpath that is wrong or am I making something fundamentally wrong here?

View 3 Replies

C# - Binding A Button To A GridView?

Jan 7, 2011

This a pretty simple question, I'm just not sure how to do it exactly. I would like to bind a Button or perhaps ImageButton to a GridView in ASP.NET/C#. Currently, the GridView has two columns and is bound to a DataTable with two columns. I want to add a third column to the GridView, which will include the Button.I know GridView has ButtonField, but I'm not too sure how to go about using it to do what I want. I want to dynamically generate these Buttons and add them to the GridView.Here is how my GridView looks right now:

<asp:GridView
ID="GridView1"
Runat="server">

[code]...

View 2 Replies

VS 2010 / C# GridView Binding Twice

Jan 12, 2012

I want to be able to click on a cell in the GridView and determine the data in the cell. So using the example from here [URL] .... I created a new class inheriting the GridView class. But the problem I am running into now is that the data is now being added twice to the GridView so that I have twice as many columns than I had before. Base on what I was able to gleem from the Internet is that the DataBind method is running twice. Once for my class and once for the inherited class.

Is there a way to keep this from happening?

View 4 Replies

Exception When Binding GridView

Sep 28, 2013

I am trying to bind GridView when I'm getting next exception: 'System.Data.DataRowView does not contain a property with the name "AvailabilityDate".

Below are my asp GridView and Vb codes with both purple lines where the exception happens.

<asp:GridView ID="gvAvailability" runat="server"
PageSize="50" ShowFooter="True"
BackColor="White" BorderColor="#CC9966" BorderStyle="None"
BorderWidth="1px" CellPadding="4" AutoGenerateEditButton="True"
AutoGenerateDeleteButton="True" EmptyDataText="No records found!"
GridLines="None" AllowPaging="True" AutoGenerateColumns="False">

[Code] .....

View 3 Replies

Binding Gridview From Two Different Tables

Sep 23, 2011

I have two tables:

Table 1: QuestionsBank
Columns:
ID
TheQuestion

Table 2: Answers
Columns:
QuestionID
Answer
Result

Example first table:

ID The Question
1 what is mean cat?
2 what is mean forum?
3 How you can register in vbforum?

Example second table:

QuestionID Answer Result
1 it's mean tomcat 10
1 mean cat 10
2 Nothing 0

I want gridview display as in below:

ID The Question Answer Result
1 what is mean cat? it's mean tomcat 10
1 what is mean cat? mean cat 10
2 what is mean forum? Nothing 0

etc ...

Note:No any relation between tables only ID column is primary Key and i have also primary key in second table.

View 6 Replies

C# - What's The Difference Between Binding Data To The Repeater In The Mark-up Or Binding It Programatically

Mar 4, 2011

What's the difference between binding for example a column called ("Name") in both cases ? and is there's any performance difference ?1- Assigning the data in the mark-up

<asp:Label ID="Name_Lbl" runat="server" Text='<%# Eval("Name") %>' ></asp:Label>

2- defining a control object for every control inside the repeater ItemTemplate and find it and then assign the data in the column "Name" to ite.Item.FindControl("Name_Lbl")

View 2 Replies

AJAX :: Tab Container And Binding Gridview

May 8, 2010

I am using the ajax control toolkit - Tabcontainer. I wonder how to refresh the latest data inside the tab. For example, I have two tab. The first tab is a add form. After I add the form, I prompt out a successful message. Then I click on the second tab which is my gridview listing of the inserted record. But when I click on the second tab, it seem not binding the gridview to show the most latest record I have inserted.

View 2 Replies

Binding LinqDataSource From Code - Behind To Gridview?

Sep 8, 2010

i have a grdidview control on the .aspx page and i am trying to connect dynamically from code behind and bind the gridview but somehow it throwing me an error... what is wrong with this code?

LinqDataSource LDS_POReport = new LinqDataSource();
LDS_POReport.ContextTypeName = "DataContextDataContext";
LDS_POReport.Selecting += new EventHandler<LinqDataSourceSelectEventArgs>(LinqDataSourcePO_Selecting);
this.gvReport.DataSource = "LDS_POReport";
//this.gvReport.DataBind();

Update:

after i update the code to this.gvReport.DataSource = LDS_POReport;

it works fine but when i try to sort i get this error:

The GridView 'gvReport' fired event Sorting which wasn't handled.

i added this but no effect.

LDS_POReport.AutoPage = true;
LDS_POReport.AutoSort = true;

View 2 Replies

Gridview Binding With Combobox's In Header?

Jul 27, 2010

how one might go about binding to a gridview in ASP.Net 4 in a scenario where the first row of my gridview should be the headers, the second should be a combobox for each column and the third is the beginning of my actual datasource.

If you can imagine what I am trying to achieve is an ability to create a binding between each column in the datagrid and another datasource. This binding is created by the user selecting a value in the comboboxes. However no matter what I try I cant seem to achieve this.

HeaderText1 | HeaderText2 | HeaderText3
ComboBox1 | ComboBox2 | ComboBox3
DataRow1 | DataRow1 | DataRow1
DataRow2 | DataRow2 | DataRow2
DataRow3 | DataRow3 | DataRow3

View 2 Replies

MVC :: Binding Each Gridview Column With A Property?

Mar 16, 2011

Is their any way I can bind each column of the grid seperatly with each property? It is possible to do that in web form, but i am not sure about MVC grids.

View 2 Replies

AJAX :: Data To Gridview Is Not Binding?

Feb 17, 2011

I want to bind gridview at runtime on button click.

I have use AJAX toolkit control, it's reference on that page(also script manager and update panel controls required for AJAX controls). When i remove all these from my page gridview data binds successfully. But when i use these controls and AJAX library reference, data is not binding to grdiview control. But at debug time it shows row count to 2 which is exact count which i wants.

here is my binding sample.

AMCGrid.DataSourceID = "AMCFILLAll"
AMCGrid.DataBind()
here AMCFILLAll is my sqlDatasource.

View 8 Replies







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