Forms Data Controls :: List Of Anonymous Types At Page Scope?

Nov 21, 2010

I have a listview in which I have a dropdownlist that will be repeated about 8 times. In the itemdatabound event of this listview, I fill the dropdownlist of that particular row with data. I obtain this data by using a linq query. It gets me an anonymous type in return:

[Code]....

The problem with this code is that I fire a query to the database everytime the itemdataboundevent is called. What I want to do is to fire the query only once, and have it available at page scope so I can reference it in the itemdatabound event. How can I get it like that?

View 1 Replies


Similar Messages:

C# And Anonymous Types - Iterate Through A DataTable While Manually Building An Anonymous Type

Jan 18, 2010

I am currently implementing a client-side paging solution using ASP.NET, jQuery and JSON.

I have been following the excellent article from encosia: http://encosia.com/2008/08/20/easily-build-powerful-client-side-ajax-paging-using-jquery/

In my Web Method I retrieve my data from the database as a DataTable:

DataTable categoryProducts = ProductViewerAccess.GetCategoryProducts
("AA", 4, 0, Page.ToString(), out howManyPages, "FALSE", 0, "CostPrice", "asc", destinationList);

I then retrieve the data from the DataTable into an anonymous type:

var feeds =
from feed in categoryProducts.AsEnumerable()[code]....

This all works great.

However, I would like to extend the code to perform some evaluation checks (e.g., check that various columns in the DataTable are not NULL) and other pre-processing (e.g., call various functions to build the image URL based on the image ID - which is another column in the DataTable not shown in the code fragment) before I return the resulting rows of the DataTable as an anonymous type to the client-side.Basically, I want to iterate through the DataTable, perform the evaluation checks and pre-processing, while building my anonymous type manually as I go. Or maybe there is a better way to achieve this?

View 2 Replies

Forms Data Controls :: How To Retrieve Items In An Anonymous List

Apr 13, 2010

i did not know how to phrase the question above but this is what I want to achieve;

using a linq to sql datacontext db, I want to retrieve a sequence of items with the code below [Code]....

View 3 Replies

Is Context.Items User Scope Or Application Scope

Apr 6, 2010

I want to use Context.Items to store some info of a User Control like:

Context.Items["Data"] = 5;

I want to know, Is Context.Items is for each request or it is global for the application?

View 1 Replies

Page Scope Variables In .NET?

Dec 7, 2010

I need to access some variables in a page in web application. The scope of variables is just in that specific page.
which one is the solution ? Session or ViewState ? or any better solution ?

Private Property UserId() As Integer
Get
If Not ViewState("UserId") Is Nothing Then[code]....

And also Is ViewState custom per user?

View 1 Replies

Forms Data Controls :: Nested Repeater - How To Get Particular Field Of The Anonymous Type?

Jan 26, 2011

nested repeater like this:

<asp:Repeater ID="repeaterReportListByJob" runat="server" DataSource='<%# GetReportsByJobNID(Eval(Container.DataItem, "JobNID")) %>'>

It seems my Eval(Container.DataItem, "JobNID") is not working and I assume this is because the datasource of the outer (parent) repeater is an anonymous type. So how am I supposed to access a particular field of my anonymous type?

View 7 Replies

Web Forms :: Hiding Menu Page To Anonymous Users

Mar 9, 2011

I would like to ask if somebody knows how to deny view of page in the telerik rad menu to anonymous users. So if the user wont be leged in then he wont be alble to see a page in the rad menu, but when he log in the the page show up in the menu.

View 2 Replies

Forms Data Controls :: Validating TextBox Data Against Multiple Types Of Data

Dec 22, 2010

I m Using a GridView: Columns: "Ser_type" tells what type of data is it i.e. VC for Varchar, NU for Numeric, DT for DateTime etc, for the time being i m using datavalidation controlls at design time. this is not a good approach. I just wan to do is that, DataValidationControlls should be created at RunTime and TextBox should validate data at runtime only. i.e. if Data required in the TextBox is of Type VC then it should validate only at runtime, if DT then validate DateTime only at Runtime similarly for all dataType:

<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server" >
</asp:ScriptManager>
<div>
<div>
<asp:Panel ID="Panel1" runat="server" Height="150px" Style="left: 0px; position: relative;
top: 0px" Width="970px">
<asp:Image ID="Image1" runat="server" ImageUrl="~/Images/Home.jpg" Style="position: relative" /></asp:Panel>
</div>
<div>
<asp:Panel ID="Panel2" runat="server" BackColor="PaleTurquoise" Height="350px" Style="left: 0px;
position: relative; top: 0px" Width="970px">
<asp:Label ID="lbl_Home" runat="server" Font-Bold="True" Font-Size="XX-Large" ForeColor="#404040"
Style="position: relative" Text="Welcome to AutoSoft Dynamics" Width="700px"></asp:Label> <br />
<table style="left: 0px; position: relative; top: 0px">
<tr>
<td colspan="2" style="height: 21px">
<asp:Label ID="lbl_messege" runat="server" Style="position: relative" Font-Bold="True" Font-Size="16pt" ForeColor="#0000C0" Width="100%"></asp:Label></td>
</tr>
<tr>
<td colspan="2">
<asp:Label ID="lblExpMessage" runat="server" Style="position: relative" Width="100%" Font-Bold="False" Font-Size="12pt" ForeColor="Red"></asp:Label></td>
</tr>
<tr>
<td style="width: 464px">
<asp:Button ID="Button1" runat="server" Style="position: relative" Text="Button" />
<asp:Button ID="Button2" runat="server" PostBackUrl="~/EmpDetails.aspx" Style="position: relative"
Text="Go to Details Page" /></td>
<td style="width: 162px">
</td>
</tr>
</table>
<br />
</asp:Panel>
<asp:Panel ID="Panel3" runat="server" BackImageUrl="~/Images/Footer.bmp" Height="50px"
Style="left: 0px; position: relative; top: 0px" Width="970px">
</asp:Panel>
<br />
<cc1:ModalPopupExtender ID="ModalPopupExtender1" runat="server"
BackgroundCssClass="modalBackground"
PopupControlID="Panel_Popup"
CancelControlID="btnRemindLater"
TargetControlID="Button1" >
</cc1:ModalPopupExtender>
<asp:Panel ID="Panel_Popup" runat="server" Width="540px" HorizontalAlign="Center" >
<br />
<table width="100%" style="left: 0px; position: relative; top: 0px; background-color: inactivecaptiontext">
<tr>
<td colspan="4">
<asp:Label ID="lbl_Title" runat="server" BackColor="Desktop" Font-Bold="True" ForeColor="White"
Height="28px" Style="font-weight: bold; font-size: 15pt; vertical-align: middle;
position: relative; text-align: center" Width="100%"></asp:Label></td>
</tr>
<tr>
<td style="width: 11px">
</td>
<td style="width: 583px">
<asp:GridView ID="GridView_Popup" runat="Server" AutoGenerateColumns="False" BorderColor="Navy"
BorderStyle="Solid" BorderWidth="2px" CellPadding="3" DataKeyNames="ser_no" EmptyDataText="No recored found"
Font-Bold="False" ForeColor="Black" GridLines="Horizontal" HorizontalAlign="Left"
OnRowDataBound="GridView_Popup_RowDataBound" Style="position: relative">
<EmptyDataRowStyle BorderColor="Navy" BorderWidth="2px" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="lbl_ser_no" runat="server" Font-Size="1pt"
Text='<%# Bind("ser_no") %>' ForeColor="ActiveCaptionText" >
</asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="GradientInactiveCaption" />
<ItemStyle HorizontalAlign="Left" Width="5px" ForeColor="ActiveCaptionText" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Description">
<ItemTemplate>
<asp:Label ID="lbl_description" runat="server" Font-Size="Small" Text='<%# Bind("description") %>'
Width="110px">
</asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="GradientInactiveCaption" Font-Bold="True" Font-Size="Small"
ForeColor="White" HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" Width="110px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Declared Value">
<ItemTemplate>
<asp:TextBox ID="txt_DeclaredValue" runat="server" CausesValidation="True" Font-Size="Small"
Text='<%# Eval("declared_value") %>' ToolTip='<%# Eval("ser_help") %>' Width="205px" MaxLength="50"></asp:TextBox>
</ItemTemplate>
<HeaderStyle BackColor="GradientInactiveCaption" Font-Bold="True" Font-Size="Small"
ForeColor="White" HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" Width="205px" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="lbl_Mandatory" runat="server" Font-Size=".5pt" ForeColor="inactivecaptiontext"
Text='<%# Bind("mandatory") %>' Width="15px"></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="GradientInactiveCaption" Font-Size="Small" />
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" Width="15px" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="lbl_ser_type" runat="server" Font-Size=".5pt" ForeColor="inactivecaptiontext"
Text='<%# Bind("ser_type") %>' Width="15px"></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="GradientInactiveCaption" />
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" Width="15px" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:RequiredFieldValidator ID="rfv_declaredVal" runat="server" ControlToValidate="txt_DeclaredValue"
ErrorMessage="*" >
</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="rfv_num" runat="server"
ControlToValidate="txt_DeclaredValue" Display="Dynamic" Enabled="false" ErrorMessage="Only (0-9)"
ValidationExpression="^[0-9]*$" Font-Size="10pt" >
</asp:RegularExpressionValidator>
<asp:RegularExpressionValidator ID="rfv_NonNumeric" runat="server" ControlToValidate="txt_DeclaredValue"
Enabled="false" ErrorMessage="Only (a-z/A-Z)" ValidationExpression="^[a-zA-Z'.s]{1,40}$" Font-Size="10pt" >
</asp:RegularExpressionValidator >
<asp:CompareValidator ID="cv_txtDate" runat="server"
ControlToValidate="txt_DeclaredValue" ErrorMessage="dd/MM/yyyy only"
Operator="DataTypeCheck" Type="Date" Font-Size="10pt" >
</asp:CompareValidator>
<asp:RegularExpressionValidator ID="rev_Decimal" runat="server" ErrorMessage="Only Decimal"
ControlToValidate="txt_DeclaredValue" Style="position: relative" Font-Size="10pt"
ValidationExpression="(?!^0*$)(?!^0*.0*$)^d{1,18}(.d{1,2})?$" />
</ItemTemplate>
<HeaderStyle BackColor="GradientInactiveCaption" />
<ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
</asp:TemplateField>
</Columns>
<HeaderStyle BorderColor="Navy" BorderStyle="Solid" BorderWidth="1px" ForeColor="#0000C0"
Height="25px" HorizontalAlign="Left" VerticalAlign="Middle" />
</asp:GridView>
</td>
<td style="width: 10px">
</td>
</tr>
<tr>
<td style="width: 11px; height: 26px">
</td>
<td style="width: 583px; height: 26px">
<table style="left: 0px; width: 100%; position: relative; top: 0px">
<tr>
<td style="width: 63px; height: 26px">
<asp:Button ID="btnSubmit" runat="server" Style="left: 0px;
position: relative; top: 0px" Text="Submit" OnClick="btnSubmit_Click1" />
</td>
<td style="width: 100px; height: 26px">
<asp:Button ID="btnRemindLater" runat="server" OnClientClick="winclose()"
Style="left: 0px; position: relative" Text="Remind Me Later" UseSubmitBehavior="False"
Width="120px" />
</td>
<td style="vertical-align: middle; width: 304px; height: 26px; text-align: right">
<asp:Label ID="lbl_LastDatePopup" runat="server" Font-Bold="False" Font-Size="Small"
ForeColor="Red" Style="position: relative" Width="100%"></asp:Label></td>
</tr>
</table>
<asp:Label ID="Label1" runat="server" BackColor="InactiveCaptionText" Style="position: relative">
</asp:Label><asp:ValidationSummary ID="ValidationSummary1" runat="server" HeaderText="Please correct the mandatory fields labeled with * "
Height="1px" ShowMessageBox="True" ShowSummary="False" Style="position: relative" />
</td>
<td style="width: 10px; height: 26px">
</td>
</tr>
</table>
<br />
</asp:Panel>
</div>
</div>
</form>

View 4 Replies

Forms Data Controls :: Object Cannot Be Cast From DBNull To Other Types

Sep 9, 2010

Object cannot be cast from DBNull to other types. 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.InvalidCastException: Object cannot be cast from DBNull to other types. Source Error:

[Code]....

Line 292:
Line 293: If DataBinder.Eval(e.Row.DataItem, "Casette") IsNot Nothing Then
Line 294: stcassette += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Casette"))
Line 295: End If
Line 296:

View 6 Replies

Forms Data Controls :: Object Cannot Be Cast From DBNull To Other Types?

Mar 10, 2010

There are two dropdowns for date (Fromdate and Todate) in my webpage and by default when the page loads for the first time the dropdowns loads with the last date (currentdate), if I select some previous date in Fromdate dropdown and reload the page then it displays runtime i.e.

Object cannot be cast from DBNull to other types.

Following code is written under GridView RowDataBound Event.

[Code]....

The error found at following line:

less7daysTotal += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "less7days"))

If I comment this line then the error moves to next line till following line.

grt28daysTotal += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "grt28days"))

I fruther want to inform that some columns in the grid are showing 0 if there is no record but I replaced 0 to - then some 0s replaced and some not. What is the reason?

View 30 Replies

Forms Data Controls :: List Data In Page From 2 Tabels?

Jan 26, 2010

I have 2 tabels,names 'Product' for saving the names of goods and 'Properties' for saving good's properties.I want to show them in one of my webpage like this:product1:1-properties1-properties23-properties3product2:1-properties12-properties23-properties3

View 3 Replies

Forms Data Controls :: Data List With Page Transfer?

Sep 2, 2010

I built a data list list in the follow. It seems that href is not asp language. How can I transfer it to asp language?

<ItemTemplate>
<a
href="~/Team.aspx?Id=<%#Eval("TeamId")%>">
<%#Eval("TeamName") %>
</a>
</ItemTemplate>

View 2 Replies

Forms Data Controls :: Hiding Page Dropdown List?

Dec 30, 2010

I would like to ask a question about hiding a drop down in my gridview. I have a gridview and I have a drop down list to control the page size of that gridview. when there is data in that gridview, it is fine for user to see the drop down list. But when there are records in the gridview, I do not want the user to see this drop down list. How can I hide it when there is no data?

View 2 Replies

Forms Data Controls :: Two List View Changing The Page (.Net 3.5)?

Jan 15, 2011

I am having two list view and the pager control inside the layout in page, two listview is having same data but two different layout what i want is if i changed the page of one listview and it must effect the other one

View 4 Replies

Forms Data Controls :: Datagrid Item List Getting To Long For One Page?

Feb 14, 2011

I didn't had any problem using datagrid to display Sql table on ASP.NET page,

but as the table grows so as the datagrid, and now the item list is too long for one page.

So I would like to break the datagrid into several pages with page numbers. ( <1,2,3,4> click the number to go to next page)

My simple datagrid code:

[Code]....

View 3 Replies

Forms Data Controls :: How To Return Back To A Specific Page In A Gridview List

Aug 22, 2010

I have a gridview with paging. So for instance, I'm on say the page number 10, and I open the form details on a specific record_id (link). After I update/submit the form, it returns to page number 10. But, if I go to another page, for instance page 5, and submit the form, it returns to page 10.

I've tried some things, for instance history.back(), but it returns to the first page I went to, in this case page number 10 (or whatever the first page I go to).

[code].....

View 4 Replies

Get An Error When Try To Load A Report Current Data Set Scope?

Sep 30, 2010

I always got the error below when i load my report.i cannot get it since i have already added the field on my data set.{"The Value expression for the textbox ‘textbox22’ refers to the field ‘isTransfer’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."}

View 7 Replies

Forms Data Controls :: How To Show Online Users Name List On Master Page Using Gridview

May 6, 2010

Im using Visual Web Developer 2010 , ASP.NET and VB

Im using the "ASPNETDB.MDF" database for membership and others ,

1-- i created a gridview in my masterpage
2-- Connected to to " ASPNETDB.MDF" and "asp_Users Table"
3 -- Selected all
4-- My Select the Field "UserName"

Now im trying to get the On-line Users .

Im having a problem , becouse i can't see it when i debug the page, i changed the font , background color , i havent got any erros , what i need to do ?

View 4 Replies

Forms Data Controls :: GridView Page Reset Based On DropDown List Selection?

Jan 3, 2011

i want to see the sales in the grid view based on the month selected from drop down list. Ex: when I select June 2010 from the ddl box, the sales for that month are correctly displayed in the grid view. I go to page 4 to look at some sales there and then switch the month to August 2010 to see sales for that month instead. Here is the problem. When I switch the month, it show August 2010 sales, but stays in page 4 instead of going back/resetting back to page 1 of August 2010 sales.

How do I reset the grid view page back to the first page of August 2010 sales?

I am fairly new to ASP. If I have missed an imp. detail in this post, let me know and I will get that info. out there.

View 4 Replies

Forms Data Controls :: Access Link Button Inside List On Page Load

Jan 4, 2010

I am using two data list one at the bottom & another at the Top to display paging. On Page load, I need to access link button placed inside Data List. Actually I had got two Datalists. I can access one Datalist Link button like this:

LinkButton lnkPg=(LinkButton)dlPg.Items[0].FindControl("lnkbtnpaging");
lnkPg.Visible= false;

This is giving no error. But if I write same code for another datalist say dlPg1, it is giving error: Index was out of range. must be non-negative.

View 1 Replies

Architecture :: Class Design - Application Allows Admins To Add Types Such As Document Types?

Oct 12, 2010

I have an application that allows admins to add types such as document types and training types that are in seperate tables with a foreign key in a transaction table.

When structuring my class I decided to go with an abstract-like pattern (without the factory methods though). So I have a Type abstract class that defines my Save, Delete, and GetList methods. I have a training type class that inherits this class. The thing is all types have 3 main properties - defined in the abstract base - but have different source tables and thus different store procedures in my DbCommand object. So basically I repeat setting up the same parameters on all the derived classes. I would like to implement the common stuff in the base but I am getting thrown off by the difference in data sources.

View 2 Replies

Web Forms :: One Page Returning Different Content Types - Not Working In IE?

Jan 21, 2010

I have one page that checks the content type then either returns an XML or a Plain Text page.

On IE6 (Unfortunately still the corporate standard) viewing XML content works but when I try and view the Plain Text content it reports: The XML page cannot be displayed. Invalid at the top level of the document. Error processing resource.

On Firefox it works perfectly, displaying an XML document for XML content and a plain text document otherwise.

Is this a bug with IE6 caching the content type? The URL is the same but the query string is different for different entries.

Here is the code that generates the output. I have single stepped it and it goes down the Plain Text leg when I expect it to, but IE still reports the XML error:

[Code]....

View 2 Replies

DataSource Controls :: Use Scope Identity To Get Newly Inserted Table

Feb 14, 2010

I have an SQL Server table named "Fields" with an autoincrement identity column "FieldID" as the primary key, an nchar column "Phrase" that textbox entries are to be stored in from a web page, and another column that is defaulted to null. The following is the recommended example on how to use Scope_Identity() to get a newly inserted table row identity value:

//C#
string query = "Insert Into Categories (CategoryName) Values (@CategoryName);" +
"Select Scope_Identity()";
int ID;
string connect = @"Server=.SQLExpress;AttachDbFilename=|DataDirectory|Northwind.mdf;" +
"Database=Northwind;Trusted_Connection=Yes;";
using (SqlConnection conn = new SqlConnection(connect))
{
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@CategoryName", Category.Text);
conn.Open();
ID = (int)cmd.ExecuteScalar();
}
}

Obviously, this example uses a Categories Table in a Northwind database, which I do not have. So I am confused by how to adapt this example for my application. The following is my data context:

DataClassesDataContext db = new DataClassesDataContext();

Could you explain how I can adapt the example for my "Fields" table in my "EFMDB" database?

View 13 Replies

Cache Page For Anonymous Users Only?

Jan 17, 2010

Is there an easy way to cache ASP.NET whole page for anonymous users only (forms authentication used)?

Context: I'm making a website where pages displayed to anonymous users are mostly completely static, but the same pages displayed for logged-in users are not.

Of course I can do this by hand through code behind, but I thought there might be a better/easier/faster way.

View 1 Replies

Forms Data Controls :: Can Show Multiple Columns In Drop Down List Or List Box

Jun 24, 2010

I have drop down list box that I would like to show two columns, is this possible? Or can it be done with a list box?The query correctly retrieves all of the table data to be displayed, one colum is an abbreviation, the other a bit longer description.

View 2 Replies







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