Trying to create a data set that I can reuse

Posted: Dec/14/2010 By: nikhil Points:15 Category: .NET - ASP.Net Views:101 Vote Up (0) Vote Down (0)

Hard to describe be here goes.

Currently I have this in the aspx page

<% = new BuildFormField() { FieldName = "FirstName" }%>

And the simplified object

Class BuildFormField(){

return GetFieldAttributes("FirstName") //calls a linq query based on the field name to get all the attributes of the field ie size/class and builds the html string.

}

The problem is, I will have many of these and it queries the database every time. What I would like to do is build a general dataset once and query that result set for each field.

I can't figure out where I should setup the initial query. Obviously don't want to put it in the aspx page or the controller and I can't figure out how to create a class that would only get called once that I could use again inside the BuildFormField Class.

Hope that makes sense. Yea, a bit unusual of a way to create form fields, but there is good reasons.

Thanks ahead of time.

View Complete Post

Comments:

Be the first to comment this post.

Post Comment

Please login to post your comment

More Related Resources

Grouping Data in the ListView Control

In ASP.NET 1.X and ASP.NET 2.0 DataList was the primary control used to display data in groups. In ASP.NET 3.5 we have a new control that takes care of grouping data. In this article we are going to demonstrate how to group data using the ListView control.

Selecting and Highlighting Multiple Columns in a Data Grid

Many times you want to select multiple columns in a DataGrid and highlight the columns selected.

In the DataGrid MouseDown Event you will find out if you have selected a column header through the hit test. You then find the co-ordinate of the column and construct a rectangle out of that. If you are selecting multiple columns you can store the index of the columns and the rectangle in ArrayList.

Make sure you clear the ArrayList when you HitType is None.

Create Navigation in asp.net web application

Create Navigation in asp.net web application. Create Navigation in asp.net

How to keep rigth data in cache

Hi,

I would want to know what is better: to keep a lot of data in cache at once or to keep a little data by paging?

For example:

I have 1000 articles and 200 pages.

send alert message to user if close internet browser before save web form data

Hi, I have window form to let user fill data, I want to alert user if close web browser before saved web form data, could anyone provide any clue?

Thanks,

Martin

How to display dynamic XML data inside a Panel control?

Hi all,

I have a SQL routine which builds me an entire XML file and returns it as a string.
If I save the content of this file as sample.xml for instance, I am able to open it in IE or any other browser and the user can expand the nodes and see all the content he wishes.

I am trying to build a ASP.Net page which will display the content of a XML file in the same way (or similar) that the browsers do.

So far, I've been reading some posts and noticed I can use XmlDataSource control and its Data property to load the entire XML doc as a string. Now I am stuck how to display the contents. I found TreeView very confusing and not sure if DataGrid would be a alternative as well. I need to user to be able to open and expand the nodes.

Please someone point me to the right direction. What controls to use, etc... sample codes are the best ;-)

Thank you

create a method similar to this

In one of our pages we are using this bit of code to check if something is null and passing in a 0 instead. This works great for this page, but this was done by another person and thye are no longer here.. so i'd like to take that idea and create something similar but return a empty string or blank space, the reason is that i have a page where you make a selection from a gridview and onselect that rows data is passed into some textboxes.. well at the moment, if you select a row and one of the columns is blank, the textbox is being populated anyway with this   so i would like to make sure that if there is nothing, that the textboxes are left blank.. since there is potential for having alot of textboxes, i would rather create a method that can do the checking instead of doing if condition for each parameter. does that make sense? If so any suggestions would be great. and thanks you

        //CONVERTS NULL VALUES TO ZERO
        protected string valid(OleDbDataReader myreader, int stval)
        {
            object val = myreader[stval];
            if (val != DBNull.Value)
                return val.ToString();
            else
                return Convert.ToString(0);
        }
        //END

grid view without any data source date sorting problem

i grid view contain the following coloum

id name DateofBirth DateofJoining

1 a 22-Aug-1980 10-jan-2000

1 a 22-may-1980 20-feb-2000

1 a 12-Feb-1980 15-mar-2000

1 a 3-Aug-1980 7-jan-2000

how to sort if we click DateofBirth or Dateofjoining and not sort any where if we click(Id,Name)

Create more than 1 set of controls in runtime.

I've figured out how to create the controls in the format I want, but now I am confused as to how create more than one set of them. I set everything to new and increment the names of each control, but it's only updating the one set. Here is my code:

  intPnlCounter += CInt(ViewState("intPgCount"))
        
        'Table
        'PlaceHolder1.Controls.Add(New LiteralControl(" <table style=""height: 27px""><tr><td colspan=""2""> </td><td colspan=""2"">"))
        PlaceHolder1.Controls.Add(New LiteralControl("<table style=""height: 27px"">"))

        'Component Header
        Dim lblHeader As Label = New Label
        lblHeader.Text = "Additional Component Item: " & intPnlCounter
        lblHeader.ID = "lblHeader" & intPnlCounter
        lblHeader.Font.Bold = True
        lblHeader.Font.Underline = True
        lblHeader.Font.Name = "Trebuchet MS"
        PlaceHolder1.Controls.Add(lblHeader)
        PlaceHolder1.Controls.Add(New LiteralControl("<tr><td colspan=""2""> </td><td colspan=""2"">"))

        'Item Label
        Dim lblItem As Label = New Label
        lblItem.Text = "Item:"
        lblItem.ID = "lblItem" & intPnlCounter
        lblItem.Font.Bold = True
        lblItem.Font.Underline = True
        lblItem.Font.Name = "Trebuchet MS"
        'lblItem.Font.Size = Unit.Percentage(10)
        PlaceHolder1.Controls.Add(lblItem)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'Item Textbox
        Dim txtItem As TextBox = New TextBox
        txtItem.ID = "txtItem" & intPnlCounter
        txtItem.Width = Unit.Pixel(306)
        PlaceHolder1.Controls.Add(txtItem)
        PlaceHolder1.Controls.Add(New LiteralControl("</td><td> </td></tr><tr><td class=""style11"">"))

        'NSN Label
        Dim lblNSN As Label = New Label
        lblNSN.Text = "NSN:"
        lblNSN.ID = "lblNSN" & intPnlCounter
        lblNSN.Font.Bold = True
        lblNSN.Font.Underline = True
        lblNSN.Font.Name = "Trebuchet MS"
        lblNSN.Font.Size = 10
        PlaceHolder1.Controls.Add(lblNSN)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'NSN Textbox
        Dim txtNSN As TextBox = New TextBox
        txtNSN.ID = "txtNSN" & intPnlCounter
        PlaceHolder1.Controls.Add(txtNSN)
        PlaceHolder1.Controls.Add(New LiteralControl("</td><td class=""style12"">"))

        'PartNum Label
        Dim lblPartNum As Label = New Label
        lblPartNum.Text = "Part Number:"
        lblPartNum.ID = "lblPartNum" & intPnlCounter
        lblPartNum.Font.Bold = True
        lblPartNum.Font.Underline = True
        lblPartNum.Font.Name = "Trebuchet MS"
        lblPartNum.Font.Size = 10
        PlaceHolder1.Controls.Add(lblPartNum)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'PartNum Textbox
        Dim txtPartNum As TextBox = New TextBox
        txtPartNum.ID = "txtPartNum" & intPnlCounter
        PlaceHolder1.Controls.Add(txtPartNum)
        PlaceHolder1.Controls.Add(New LiteralControl("</td><td colspan=""2"">"))

        'SerialNum Label
        Dim lblSerialNum As Label = New Label
        lblSerialNum.Text = "Serial Number:"
        lblSerialNum.ID = "lblSerialNum" & intPnlCounter
        lblSerialNum.Font.Bold = True
        lblSerialNum.Font.Underline = True
        lblSerialNum.Font.Name = "Trebuchet MS"
        lblSerialNum.Font.Size = 10
        PlaceHolder1.Controls.Add(lblSerialNum)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'SerialNum Textbox
        Dim txtSerialNum As TextBox = New TextBox
        txtSerialNum.ID = "txtSerialNum" & intPnlCounter
        PlaceHolder1.Controls.Add(txtSerialNum)
        PlaceHolder1.Controls.Add(New LiteralControl("</td><td>"))

        'Hours Label
        Dim lblHours As Label = New Label
        lblHours.Text = "Hours:"
        lblHours.ID = "lblHours" & intPnlCounter
        lblHours.Font.Bold = True
        lblHours.Font.Underline = True
        lblHours.Font.Name = "Trebuchet MS"
        lblHours.Font.Size = 10
        PlaceHolder1.Controls.Add(lblHours)
        PlaceHolder1.Controls.Add(New LiteralControl(" "))
        'Hours Textbox
        Dim txtHours

How can i create Barcode for coupon???

Hi all,

I am creating a web site that provide coupon for it's registered member. I want to set up barcoad for each coupon that the member printed. How can i create barcode and Print them in a html page that is used as my coupon page.

Is anybody can give me solution for that???? Please help me, its argent.

Bye

With regards

Sadequzzaman Monoj

Bangladesh