|
I have a database in which I store the items that a customer added to the shoppingcart. Now I try to get the data and put it into the shoppingcart when the user loggs back in and there were items he didn't purchased yet but left in cart last time he was logged.
It will display the right quantity of each product, but it shows the Name and price of last recieved product in my ShoppingCart display on all products.
Here is code I have so far for getting items from DB and adding to ShoppingCart:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Membership.GetUser() Is Nothing Then
StoreManager.ShoppingCart.UserID = Membership.GetUser().UserName
If Not Session("Logged") Then
StoreDB.GetShoppingCart(Membership.GetUser().UserName)
Session("Logged") = True
End If
Else
HttpContext.Current.Session("ShoppingCart") = New ShoppingCart()
StoreManager.ShoppingCart.UserID = ""
Session("Logged") = False
End If
End Sub
Public Shared Sub GetShoppingCart(ByVal userID As String)
Try
Using myCon As New SqlConnection(AppConnection.ConnectionString)
Dim myCom As SqlCommand = New SqlCommand("sprocGetShoppingCartItems", myCon)
myCom.CommandType = CommandType.StoredProcedure
myCom.Parameters.AddWithValue("@cartID", userID)
Dim prod As Product = New Product
Dim qty As Integer = 0
myCon.Open()
Using myRd As SqlDataReader = myCom.ExecuteReader(CommandBehavior.CloseConnection)
While myRd.Read()
prod.CategorieID = myRd.GetInt32(myRd.GetOrdinal("CategorieID"))
prod.ProductID = myRd.GetInt32(myRd.GetOrdinal("ProductID"))
prod.ProductName = myRd.GetString(myRd.GetOrdinal("ProductName"))
prod.ProductPrice = myRd.GetDecimal(myRd.GetOrdinal("ProductPrice"))
prod.ProductMini = myRd.GetString(myRd.GetOrdinal("ProductImage"))
prod.Qty = myRd.GetInt32(myRd.GetOrdinal("Quantity"))
MsgBox("Adding: " & prod.ProductName)
StoreManager.ShoppingCart.AddDB(prod, prod.Qty)
End While
myRd.Close()
End Using
End Using
Catch ex As Exception
' error handling set in Global.asax and web.config
Throw
End Try
End Sub
'Part of my ShoppingCart Class:
Public Class ShoppingCart
Private _items As List(Of OrderedProducts) = New List(Of OrderedProducts)
Public Sub New()
End Sub
Public Sub AddDB(ByVal product As Product, ByVal qty As Integer)
Dim orderedProd As OrderedProducts = New OrderedProducts(product, qty)
_items.Add(orderedProd)
End Sub
End Class
Public Shared ReadOnly Property ShoppingCart() As ShoppingCart
Get
If HttpContext.Current.Session("ShoppingCart") Is Nothing Then
HttpContext.Current.Session("ShoppingCart") = New ShoppingCart()
End If
Return CType(HttpContext.Current.Session("ShoppingCart"), ShoppingCart)
End Get
End Property
|
|
|
|
|
How can I truely get a date in the UK/GB format of dd/mm/yyy?
It's a dedicated server and everything is in GMT format as far as I can see, but nothing will change it to UK/GB format.
Any suggestions? I'd prefer to change a setting on the server than having an ASP .NET function, as it saves messing around.
Thanks,
Aaron
|
|
|
|
|
String.Format(yourDate, "dd/MM/yyyy")
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
-Dr_X- wrote: String.Format(yourDate, "dd/MM/yyyy")
A slight correction:
String.Format("{0:dd/MM/yyyy}", yourDate)
---
single minded; short sighted; long gone;
|
|
|
|
|
Your locale settings determine the default date format. Region and Language settings in the control panel is what you need.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi All,
I am working on GridView.
I used sorting on two columns ASC/DESC alternatively, as usually it is done.
Everything works fine but After changing the Sorting order GridView Displays the desired order but on GVMaterialMaster_SelectedIndexChanging Event,
Code:
protected void GVMaterialMaster_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
GridViewRow row = GVMaterialMaster.Rows[e.NewSelectedIndex];
string materialCode = row.Cells[0].Text;
}
the row.Cells[0].Text always have value of row.Cells[0] of GridView before Sorting. Means row.Cells[0] always have the same value whether sorting is changed or not.
Any help is appreciated,
Thanks
Bajrang Singh
Using .net 2.0 (VS2005)
|
|
|
|
|
Have you checked whether SelectedIndexChanging Event is firing??
|
|
|
|
|
Thanks Venkatesh for Reply
Yes GVMaterialMaster_SelectedIndexChanging Event is firing on Selection.
Sorting on a cloumn change the order of rows of grids Rows but in SelectedIndexChanging Event of Gridview Value
of row.Cells[0].Text remains as it is before sorting.
Example: GridView's first Row's first cell has value 'A' and Last Row's first cell has value 'X'
Now after sorting GridView is showing first Row's first Cell's value 'X' and Last Row's first cell has value 'A'. Its fine.
Now I Select First Row so It Shold show value of row.Cells[0] as 'X' but It is showing value of row.Cells[0] as 'A'.
So Any Idea why It is not have row.Cells[0] in desird order ?
Thanks Again for kind help.
Bajrang Singh
Using .net 2.0 (VS2005)
|
|
|
|
|
Keep track of the RowIndex when you select the row. When sorting is done, just get the value in the copied RowIndex.
|
|
|
|
|
I am creating DataView(Runtime) and bind the GridView for Sorting.
Is it the cause of Problem?
Bajrang Singh
Using .net 2.0 (VS2005)
|
|
|
|
|
The following variations (and more) fail to display correctly. Want to have the HeaderText property in the aspx page obtain a value from the code behind page.
Any ideas?
asp:BoundField DataField="Cargo" HeaderText='<% BL.Translate("Cargos") %>' SortExpression="Cargo"
asp:BoundField DataField="Cargo" HeaderText='<% =BL.Translate("Cargos") %>' SortExpression="Cargo"
asp:BoundField DataField="Cargo" HeaderText=<% BL.Translate("Cargos") %> SortExpression="Cargo"
Thanks,
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
You cannot use Inline Coding in Server Controls.
Use RowDataBound or DataBound Event of the GridView Control to set its HeaderText.
|
|
|
|
|
Are there any standards out there on the best practices for how to pass object properties from the page to a user control?
For example, lets say I have a Person class with FirstName and LastName properties. Now say I wanted to display those attributes on a PersonDisplay user control. Should I be passing the control the Person object itself, or just the Person.FirstName and Person.LastName values? I've always done the latter, but wanted to see if there are any best practices or guidelines out there I should be following.
Thanks in advance 
john miller
web developer
|
|
|
|
|
I made a httphandler for .asp pages to redirect to .aspx page of the same name. It works in cassini from VS2005, it works in IIS on XP on my dev box, but does not work in IIS in server 2003 in staging (or production). I had to change the mapping of .asp to aspnet_isapi.dll in the IIS config for the virtual directory to make it work on XP, and I did the exact same thing in server 2003, but I get a page not found error anyway. Is there some other step I need to take with server 2003 to have .asp requests handled by the .net framework so my handler can catch .asp pages?
|
|
|
|
|
I want to play video file using real player in my asp.net application.
Any ideas or links.
Thanks
|
|
|
|
|
|
We are using forms authentication in our applicaion to restrict unauthorised users from downloading the content.
In our application once a user enters the page, the forms authentication checks with cookie and then authenticates the user and allowing him to download.
The problem is once the cookie is being created, we are unable to delete the cookie or expire the cookie.
We've tried setting the time out attribute in forms tag in web.config file and also in code behind file. But still the cookie exist and the user is able to download the content even after the timeout period.
When we open a new browser window then also the earlier cookie remains and the user is automatically authenticated and able to download the content.
Its not creating new Session but using the earlier session.
Please help us...
VENKATESH
|
|
|
|
|
Are you using .net 2.0? I have a working web site that using the .net 2.0 login controls and the default cookie it creates. It all seems to expire without any issues. If you are doing your own cookies you will probably need to post some code for anyone to be helpful to you.
Ben
|
|
|
|
|
we are using asp.net 1.1
VENKATESH
|
|
|
|
|
GDay everyone,
I have a problem with Gridview that I really need someone's help.
I'd like to get data of the record at which user clicks on the select hyperlink of that record in GridView. I need to save it and use it to populate data of that record into another form.
Please give me a solution.
Thanks in advance.
eric
|
|
|
|
|
Here is an example:
<<asp:HyperLinkField DataTextField="FullName" HeaderText="Employee"
SortExpression="FullName" DataNavigateUrlFields="EncryptedUID" ItemStyle-Font-Size="10px"
DataNavigateUrlFormatString="~/Employee/EmployeeCoursesScheduled.aspx?id={0}" >
<</asp:HyperLinkField>
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Can anyone help me to start making a favourite lonks page just to get me started
|
|
|
|
|
You need two pages, right ? One full of radio buttons and one full of links for the button you pressed. What's not clear is, how are the links stored ? In a database ? XML ? hard coded ? A radio button list page is pretty trivial, and then each button needs, on click, to divert to the second page. The two ways to handle this are a cross page postback, or putting a variable on the URL, so that the second page knows which URLs to show. Again, it's not clear from the question where they come from.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
thanks. yeah we need two two pages and yeah it neeeds to be hard coded
|
|
|
|
|
come on... start (hard) coding...
------------------------------
If u think u can, u can.
If u think u can't, u r right.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
