ArrayList onto DataControl; Gridview, datalist etc

Hellow Programmers

I have got a datalist from Database which Lists my products with HyperLink that takes a QueryString of ProductName, ProductID and productPrice, as I retrieve the QueryString I transfered into a Session variable. Now I need to Store these values into an ArrayList onto a DataControl so I can see How many Items I have clicked and put it back onto a table in the database?

I have pasted my current code. Thanks

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Request.QueryString("id") Is Nothing Then

Dim productID As Integer = Integer.Parse(Request.QueryString("id")) Session.Add("ID", productID)

Dim Name As String = (Request.QueryString("name")) Session.Add("ProductName", Name) Dim Price As Decimal = (Request.QueryString("Price")) Session.Add("ProductPrice", Price)

lblname.Text = Session("ProductName") lblprice.Text = Session("Productprice") lblid.Text = Session("id")

End If End Sub

Dim a As ShoppingCartItem = New ShoppingCartItem()

a.ProductID = Session("Id")

a.Productname = Session("name")

a.ProductPrice = Session("price")

a.Quantity = txtquantity.Text

Dim a1 As ArrayList

a1 = CType(Session("cartList"), ArrayList)

a1.Add(a)

Session.Add("cartList", a1)

GV.DataSource = a

GV.DataBind()

Please Help

Re: ArrayList onto DataControl; Gridview, datalist etc

Dim a1 As ArrayList

should be chnaged to

Dim a1 As New ArrayList

By the way what is the Error??

Re: ArrayList onto DataControl; Gridview, datalist etc

Thanks Musadarkhan, I changed as you said but still throwing error (Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource.) my objective is to put a Productname, productId, productPrice which are retrieved from a querystring with quantity from a textbox into a data-container and put the rows back into a datatable. do I have to make a dataset and table! someone can tell me how. Many Thanks.

Re: ArrayList onto DataControl; Gridview, datalist etc

this way

Dim dt As New DataTable

dt.Columns.Add("ProductID", System.Type.GetType("System.String"))

dt.Columns.Add("Productname", System.Type.GetType("System.String"))

dt.Columns.Add("ProductPrice", System.Type.GetType("System.String"))

dt.Columns.Add("Quantity", System.Type.GetType("System.String"))

dt.AcceptChanges()

dt.Rows.Add()

dt.Rows(dt.Rows.Count - 1)("ProductID") = Session("Id")

dt.Rows(dt.Rows.Count - 1)("Productname") = Session("name")

dt.Rows(dt.Rows.Count - 1)("ProductPrice") = Session("price")dt.Rows(dt.Rows.Count - 1)("Quantity") = txtquantity.Text

dt.AcceptChanges()

GV.DataSource = dt

GV.DataBind()

Re: ArrayList onto DataControl; Gridview, datalist etc

Thanks ( it highlights Datatable, and as i put the cursor over it it says the system the datatable is not defined.) I have used Imports system.data and the error has disappeared. but as i run I can not see any data on the GV gridview! I have tried using ViewState("dt") = True

but still no data can be seen!

Re: ArrayList onto DataControl; Gridview, datalist etc

Do this check in bold

Dim dt As New DataTable

dt.Columns.Add("ProductID", System.Type.GetType("System.String"))

dt.Columns.Add("Productname", System.Type.GetType("System.String"))

dt.Columns.Add("ProductPrice", System.Type.GetType("System.String"))

dt.Columns.Add("Quantity", System.Type.GetType("System.String"))

dt.AcceptChanges()

dt.Rows.Add()

dt.Rows(dt.Rows.Count - 1)("ProductID") = Session("Id")

dt.Rows(dt.Rows.Count - 1)("Productname") = Session("name")

dt.Rows(dt.Rows.Count - 1)("ProductPrice") = Session("price")dt.Rows(dt.Rows.Count - 1)("Quantity") = txtquantity.Text

dt.AcceptChanges()

Dim str as String = dt.rows.Count //Check the count of Rows

GV.DataSource = dt

GV.DataBind()

Re: ArrayList onto DataControl; Gridview, datalist etc

Thanks for the try. I have added the line as you indicated but no changes, still no data appearing on the GV, My pages are using VB language, could this be why? I have replaced the // with ' I have visited you blog and seen that you can help me with if you got the time. Thanks for the assistance. Ibroawad at gmail

Re: ArrayList onto DataControl; Gridview, datalist etc

What is the value of str I told you to check at runtime??

Also do your Session varaibeles have values??

Re: ArrayList onto DataControl; Gridview, datalist etc

Yes, my session have values and I have made a labels to display the session values, at the moments since I have used your answer there is no error but nothing appears on the GV, I have trieed ViewState("dt") = true but no change.

Re: ArrayList onto DataControl; Gridview, datalist etc

In your aspx

for thr GridView set Autogenerate Columns = true

Re: ArrayList onto DataControl; Gridview, datalist etc

yes it inserted a row into GV.. thanks for that' but as i click another product it olny replaces the new row with the old one. how can I keep the first row and add new one to the GV. Thanks again.

Re: ArrayList onto DataControl; Gridview, datalist etc

Do this

Dim dt As DataTable

if Session("GVData") is Nothing Then

dt = new DataTable

dt.Columns.Add("ProductID", System.Type.GetType("System.String"))

dt.Columns.Add("Productname", System.Type.GetType("System.String"))

dt.Columns.Add("ProductPrice", System.Type.GetType("System.String"))

dt.Columns.Add("Quantity", System.Type.GetType("System.String"))

dt.AcceptChanges()

else

dt = Session("GVData")

End If

dt.Rows.Add()

dt.Rows(dt.Rows.Count - 1)("ProductID") = Session("Id")

dt.Rows(dt.Rows.Count - 1)("Productname") = Session("name")

dt.Rows(dt.Rows.Count - 1)("ProductPrice") = Session("price")dt.Rows(dt.Rows.Count - 1)("Quantity") = txtquantity.Text

dt.AcceptChanges()

Session("GVData") = dt

GV.DataSource = dt

GV.DataBind()

Re: ArrayList onto DataControl; Gridview, datalist etc

Mudassarkhan You are a STAR, it worked and now I can see all the clicked products; name, price, Id and quantity. my quantity is default value of 1 which is from my QueryString cause I can not hardcode the txtquantity in my DataList to take the entered value to the Basket Page,; Also as I enable the Edit and delete command on my GV as I click edit or delete it will not allowing me to do so. one more thing how can I move this content on the GV into batabase table. Sorry for these many questions.

Re: ArrayList onto DataControl; Gridview, datalist etc

loop throght the dataTable

Dim dt as DataTable = Session("GVData")

for i as integer =0 to dt.Rows.Count-1

dim strProductID as String = dt.Rows(i)("ProducID")

dim strProductname as String = dt.Rows(i)("Productname")

dim strProductPrice as String = dt.Rows(i)("ProductPrice")

And now insert the data here

Re: ArrayList onto DataControl; Gridview, datalist etc

Mussadarkhan, I have tried as you indicated and now I can insert from the DT memory table into a database table but, it inserting more records than what my order was, how can I avoid that, also is it possible to edit the DT table from the GV? Thanks for the help

Re: ArrayList onto DataControl; Gridview, datalist etc

Ibro

Mussadarkhan, I have tried as you indicated and now I can insert from the DT memory table into a database table but, it inserting more records than what my order was, how can I avoid that, also is it possible to edit the DT table from the GV? Thanks for the help

All the records are inserted right??

Can you paste the code

Re: ArrayList onto DataControl; Gridview, datalist etc

As I click The Insert Button one more row is generated and inserted into the Database Table, I have tried to use Variables that can be set to " " after each row is inserted into the memory DT table. but still not working, I tried SESSION.ABANDON but this cancels all the session, is there a way of clicking a bottun should not refresh the page and retrive the queryString again and again, aslo please how can I edit the memory table(DT) columns such as Quantity or deliting a row from it before posting to the databse? Many Thanks

Protected Sub Order_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Order.Click

Dim dt As DataTable = Session("GVData")

For i As Integer = 0 To dt.Rows.Count - 1

Dim strProductID As String = dt.Rows(i)("ProductID")

Dim strProductname As String = dt.Rows(i)("Productname")

Dim strProductQuantity As String = dt.Rows(i)("Quantity")

Dim strProductPrice As String = dt.Rows(i)("ProductPrice")

Dim strUserName As String = dt.Rows(i)("Username")

Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\CeeJayStore.mdf;Integrated Security=True;User Instance=True")

Dim insertstatement As String = "INSERT INTO [Orders] ([ProductID], [ProductName], [Quantity],[OrderPrice],[CustomerUserName]) VALUES (@ProductID, @ProductName, @ProductQuantity, @OrderPrice, @UserName)"

Dim cmd As SqlCommand = New SqlCommand(insertstatement, conn)

cmd.Parameters.AddWithValue("@ProductID", strProductID)

cmd.Parameters.AddWithValue("@Productname", strProductname)

cmd.Parameters.AddWithValue("@productQuantity", strProductQuantity)

cmd.Parameters.AddWithValue("Orderprice", strProductPrice)cmd.Parameters.AddWithValue("@username", strUserName)

conn.Open()

cmd.ExecuteNonQuery()

End Sub

Re: ArrayList onto DataControl; Gridview, datalist etc

Can you paste the code??

Re: ArrayList onto DataControl; Gridview, datalist etc

Actually ur Code is fine and it will insert all the rows in ur DataTable.

So what you want now don't you want to insert last row then in the loop

for i as integer=0 to dt.Rows.count-2

Re: ArrayList onto DataControl; Gridview, datalist etc

I used your xample and also I added DT.CLEAR at the of the insert code and it seems oky for the time being, and one still the last row is appearing on the GV gridview!

my Query String which carries the products values takes me to a new page so each taime I want to add another product into my shopping cart I have to go back into the product page, is there a way of having a button in my DataList that can do this for me rather than using the queryString that takes me to another page? Thank very much for the great help.

this is my Link in the DataList:

<asp:HyperLink ID="HyperLink1" runat="server"

NavigateUrl='<%# "test.aspx?id="&Eval("id") &"&Name="&Eval("productname") &"&Price="&Eval("productprice")&"&Quantity=" &1 %>'

Text='<%# "Add Basket" %>'></asp:HyperLink>