State Management :: Build Up The Order Query From The Selections Made And Store It In Db?
Jan 11, 2011
I am building an invoice system for a client and I am having trouble with the web forms related to the INSERT new order query.Basically I want to build up the order query from the selections made and then store it all in db at the end.
I don't want to use temporary db storage because it's a wasted trip to the server, I don't want to use session state because it's not data about the user I'm storing.... Unless I'm wrong, from what I've read I think query string is my best method since the data is not sensitive, it will just be primary keys and the like.
On the first form, the user will select the customer id from a datagrid displaying all customers. The next form allows them to choose the product from a datagrid showing all products and so on.... How do I pass this information across several pages?
My hope is at the end I will be able to take all the values and insert them into the corresponding tables to make up the customer order.
I have a class that being used to connect with the DB. Now I want to count how many times each web request executes the queries, but I've no idea where to store the counted value. I mean, Session wont, ViewState wont work as site also have webservices. What else I can use?
I have a dropdown with names of project managers and a checkboxlist with names of team members. What I want to do is write the IDs of selections made from the dropdown and checkboxlist to the DB. I am using the following code, but only IDs from the checkboxlist are stored in the table. What can I do to store the ID from the dropdown simultaneously? Thanks for your help.
for (int i = 0; i < project_members.Items.Count; i++) { if (project_members.Items[i].Selected)
i am trying to create a Unique order number so i tried to use the code above but every time i enter the quite the page the number get rest.
If (ViewState("counter") Is Nothing) Then ViewState("counter") = 1 Else ViewState("counter") = ViewState("counter") + 1 End If OrderNum.Text = ViewState("counter") If (ViewState("counter") Is Nothing) Then
I want to store List<Class> object to ViewState, when i try to do this than its giving me error to make class serialize,but my class is partial class so didn't get serialize keyword on class how can i store List object to viewstate.
i want to store IQueryable value to ViewState. my code is as below:
Private Property _Query() As IQueryable Get Return CType(ViewState("_Query"), IQueryable) End Get Set(ByVal value As IQueryable) ViewState("_Query") = value End Set
but when i run my page i get following error:
Type 'System.Data.Linq.DataQuery`1[[DynamicQueries.VW_EmployeeProfile_Filter, DynamicQueries, ersion=1.0.0.0, Culture=neutral, PublicKeyToken=null]]' in Assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable
what should i do to get rid of this error. previously i was doing like this:
Private Shared _Query As IQueryable
but problem is that in Multi users environament, Shared variable is making problem, that is why i want to store it in ViewState.
I have this code that loop through table controls how do stick the seleted information into a session variable. Then i have to pass it into another page table control.example code
can i get few data from textboxes (like 12 text boxes) and store it in cookies? so the next time the user will not need to type the data again (so the data will place auto in the text boxes for the next times)
i am building an N-tier application now i want to store Data(like XmlNode) that is common to all users ..
now i thought using Application to hold the data but my data lays in the BLL tier which is an Class Library project and i can't store any datain there for example :
I have a object of Class named "Employee" I need to store the object in the session. what happens if i do not serialize the object and store in the session.
I have some webforms and the main page grabs the users email address when they login and a UserID. It's not uncommon for the user to keep the web page open all day. Is it good practice to store the email address and ID as a session variable and up the timeout to say 10 hours? Or is there a better way? My concern is A) Session variables timing out before the user login timesout B) Doing this incorrectly.
In my website the page viewstate values in hidden are very large.So i wish to store this values into another methods(session,files etc).so please advice me to some methods..
First one is registration page.second one is Gridview page.
When i click on submitt button,the data will store in gridview.
If i want to update the data,click edit button.it will navigate to registration page with concer data.
I wrote code in first page as
[Code]....
In second page gridview as
[Code]....
Now the problem isWhen click on edit,data is stored in concern textboxes.but i open first page it diplays session data.it did not show empty textboxes.I want empty form wen i request first page and wen i click on edit it will store entire data in textboxes with update buttonand client id and client code readonly property false.how to do it?
I have a public property that I use to store a GUID in the viewState:
Property myGUID() As Guid Get Return CType(Me.ViewState("myGUID"), Guid) End Get Set(ByVal value As Guid) Me.ViewState("myGUID") = value End Set End Property
I include this code on many pages in my website...is there any way to migrate this to a common code file, so I don't have to repeat it on each page? If I try to add it to a class file, the "Me" part of course is out of scope.
i am currently storing my shopping cart in a datatable assigned to the session. but i wanted to know is it a good idea to store the GUID for the session shopping cart?
I'm working on a web page that is going to be used to enter data into a database. The page is going to be dynamic in that the user has the ability to add a row to the table with the same fields, ie lname1, fname1, mi1 then lname2, fname2, mi2
I'm wanting to use a variable to keep track of how many lines there are so that when I generate the added line I am creating a new field with the ID of lname+# . Whats the best way to do this, a global variable, session variable? As side note, first time programming in .Net or C#.
I need to store a large amount of data in user's session but I guess using Session Object is not the best way of doing that. Is there any other way around??? Remember I don't have small variables to store, I have large collections.
I have a page that the user can make selection using a checkbox.. at the end of the page, they have the option email those selections to others. So i'd like to loop thru the gridview if they click on the email button, first make sure they made a selection, if no selection then i will prompt them.. if they select 3 records then i need to put those 3 records into the body of the email.. Ive looked around and found some others with the same end result, but none that provided a good example of building that list dynamically for the email body. im using "using System.Net.Mail;" and have the email working fine with hard coded data for the body, i need to connect to the gridview and build the body.. Can anyone offer suggestions, examples or links to a good tutorial?
