ASP.NET

Nishant Singh9-Nov-09 1:16

9-Nov-09 1:16

Hi ......
I believe that somewhere in your code you are overwriting the DataTable without preserving the older records .
Most possible place is where you are adding a new row,
just debug your code or post relevent pieces here ,

mylogics9-Nov-09 1:26

mylogics

9-Nov-09 1:26

this is the page wr my cart is shown name cart.aspx....

public partial class mycart : System.Web.UI.Page
{
    DataTable dt =new DataTable(); 
       
    DataView cartview; 
    protected void Page_Load(object sender, EventArgs e)
    {
        Getsource();      
        if(!IsPostBack)
        {
            Bindlist();
        }
        //DataList1.DataSource = dt;
        //DataList1.DataBind();
        //Session["cart"] = dt;
        //cartview.Sort = "ProductName";
    }
    void Bindlist()
    {
        DataList1.DataSource = cartview;
        DataList1.DataBind();
        Session["cart"] = dt;
    }
    void Getsource()
    {
        
        dt = (DataTable)Session["cart"];
        cartview = new DataView(dt);
        return;
        //cartview.Sort = "ProductName";
        //Session["cart"] = dt;
    }
    
    protected void Update(object source, DataListCommandEventArgs e)
    {
        int ProductID = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);
        TextBox txtqty;
        txtqty = ((TextBox)e.Item.FindControl("txtqty"));
        string connectionstring = ConfigurationManager.ConnectionStrings["SilverOnline"].ConnectionString;
        SqlConnection conn = new SqlConnection(connectionstring);
        SqlCommand cmd = new SqlCommand("Update Home Set ProductQty=@productqty Where ProductID=@productid", conn);
        cmd.Parameters.Add("@productqty", SqlDbType.VarChar).Value = txtqty.Text;
        cmd.Parameters.Add("@productid", SqlDbType.Int).Value = ProductID;
        if (conn.State == ConnectionState.Closed)
            conn.Open();
        cmd.ExecuteNonQuery();
        if (conn.State == ConnectionState.Open)
            conn.Close();
        DataList1.EditItemIndex = -1;
        Bindlist();
        
    }
    protected void Delete(object source, DataListCommandEventArgs e)
    {
        string name = ((Label)e.Item.FindControl("Label1")).Text;
        cartview.RowFilter = "ProductName='" + name + "'";
        if (cartview.Count > 0)
        {
            cartview.Delete(0);
        }
        cartview.RowFilter = "";
        DataList1.EditItemIndex = -1;
        Bindlist();
    }
}

on my addcart.aspx page m adding that particular product to cart....the code is...

protected void Button1_Click(object sender, EventArgs e)
    {
        DataList1.Visible = false;
        Button1.Visible = false;
        GridView1.Visible = true;

       
        string str = Request.QueryString["ProductID"];
        int i = Convert.ToInt16(str);
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SilverOnline"].ConnectionString);
        string str1 = "Select * From Home Where(ProductID='" + str + "')";
        SqlCommand cmd = new SqlCommand(str1, conn);
        SqlDataReader dr = null;
        conn.Open();
        dr = cmd.ExecuteReader();
        DataTable dt = new DataTable();
        while (dr.Read())
        {

            dt.Columns.Add("ProductID", typeof(int));
            dt.Columns["ProductID"].AutoIncrement = true;
            dt.Columns["ProductID"].AutoIncrementSeed = 100;
            dt.Columns.Add("ProductName", typeof(string));
            dt.Columns.Add("ProductImg", typeof(string));
            dt.Columns.Add("ProductPrice", typeof(string));
            dt.Columns.Add("ProductQty", typeof(string));

            DataRow row = dt.NewRow();
            row["ProductName"] = dr["ProductName"].ToString();
            row["ProductImg"] = dr["ProductImg"].ToString();
            row["ProductPrice"] = dr["ProductPrice"].ToString();
            row["ProductQty"] = 1;
            dt.Rows.Add(row);
            Session["cart"] = dt;
            //GridView1.DataSource = Session["cart"];
            //GridView1.DataBind();

        }
        conn.Close();
        Response.Redirect("mycart.aspx");
        
    }

Nishant Singh9-Nov-09 1:40

9-Nov-09 1:40

Where are you adding a new row to the DataTable???

Nishant Singh9-Nov-09 1:43

9-Nov-09 1:43

Sir ,
On Button1_Click you are creating a new DataTable .....no where you are retrieving DaTatable from Session,
So How is it suppose to Take the older rows ???

Run a video clip in asp.net stored in database

Greg Chelstowski9-Nov-09 1:49

Greg Chelstowski

9-Nov-09 1:49

"Technically", the bug is here (your assigning a whole new datatable as your Session["cart"] object).

mylogics wrote:
dt.Rows.Add(row);
Session["cart"] = dt;

If your Session["cart"] schema is the same as dt just do:

((DataTable)Session["cart"]).Rows.Add(row);

But the whole thing is veerrry messsssyy....
Come on man, ever heard of Sql injection?
I see you use parameters in your Update method, good - use them all round your code, better yet, turn those sql strings into stored procedures.

var question = (_2b || !(_2b));

gautamamit88-Nov-09 23:24

gautamamit8

8-Nov-09 23:24

Hi Coders,

How can I store a 1 or 2 minutes long Video in Database and run in flash player in a Asp.net website.I Google a lot but all in vain.
any help would be appreciated.

Thanks in Advance

Amit Gautam

Re: Run a video clip in asp.net stored in database

Christian Graus8-Nov-09 23:30

Christian Graus

8-Nov-09 23:30

Sure - just make a page that returns the bytes of the video and takes an ID on the URL to choose the file. Then point your flash player to that url

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Run a video clip in asp.net stored in database

gautamamit88-Nov-09 23:41

gautamamit8

8-Nov-09 23:41

Hi Graus
I can find the ID to run the specific clip but unable to connect with player.
Could u provide me code.

Amit Gautam

Web Application

Swati_g19858-Nov-09 23:24

Swati_g1985

8-Nov-09 23:24

Hiii....

I have created on desktop application using c# and sql server 2005. Now I want the same application to be Web Enabled. So how should I start with it? What are different ways to do it?

Please help..

Thanks in advace...

Re: Web Application

Christian Graus8-Nov-09 23:29

Christian Graus

8-Nov-09 23:29

YOu need to rewrite it. Hopefully you built it in tiers so all you need to redo is the presentation layer.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Web Application

Swati_g19858-Nov-09 23:43

Swati_g1985

8-Nov-09 23:43

how can i user WebServices in it??

Re: Web Application

sashidhar9-Nov-09 0:13

sashidhar

9-Nov-09 0:13

Swati_g1985 wrote:
how can i user WebServices in it??

Just As Same..!
Website-->
Add Web Reference
--Url
Add--
If You Did'nt Got my solution
Search Calling WebServices From Asp.net
You Will get Lots of Support..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Redirect from one page of a one project to another page of another project in same solution

getaccessyr8-Nov-09 23:24

getaccessyr

8-Nov-09 23:24

Hi friends,

I want to know

How to Redirect from one page eg: 1.aspx of a one project to another page like 2.aspx of another project in same solution,when we click on a link of 1.aspx?

Can any one tell me?
In how many ways we can get that and which will be the better one?

Thankyou In Advance

Re: Redirect from one page of a one project to another page of another project in same solution

Nishant Singh8-Nov-09 23:26

Re: Redirect from one page of a one project to another page of another project in same solution

8-Nov-09 23:26

This depends on How these projects are conifigred in Virtual Directory on IIS in Server

padmanabhan N8-Nov-09 23:30

padmanabhan N

8-Nov-09 23:30

You can use Response.Redirect("your navigate page here");

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Re: Redirect from one page of a one project to another page of another project in same solution

getaccessyr8-Nov-09 23:36

getaccessyr

8-Nov-09 23:36

Ya i know that

Still i need few ways to get that like thru code not giving directly like response.redirect("http://www.microsoft.com");

Thats y i mentioned in the Question that in how many ways we can get that?n which will be better?

total and subtotal in gridview footer

RajpootRohan8-Nov-09 23:08

RajpootRohan

8-Nov-09 23:08

Hello friends,

I have to display subtotal, vat,total in gridview footer. I am doing like this but nothing is displayed.

<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" <br />
                    CellPadding="4" Font-Names="Verdana" Font-Size="Small" ForeColor="#333333" <br />
                    PageSize="900" Width="600px" EmptyDataText="No items in your cart!!" <br />
                    DataKeyNames="REF" GridLines="None" ShowFooter="True" <br />
                    onrowdatabound="GridView1_RowDataBound"><br />
                    <FooterStyle BackColor="#1C5E55" ForeColor="#FFFFFF" Font-Bold="True" /><br />
                    <RowStyle BackColor="#E3EAEB" /><br />
            <Columns><br />
                <asp:BoundField DataField="REF" HeaderText="REF" SortExpression="REF" <br />
                    ItemStyle-Width="60px" ><br />
<ItemStyle Width="60px"></ItemStyle><br />
                </asp:BoundField><br />
                <asp:TemplateField HeaderText="product_id" Visible="False"><br />
                <ItemTemplate><br />
                <asp:Label ID="lblProduct_Id" runat="server" Text='<%# Eval("REF") %>'></asp:Label><br />
                </ItemTemplate><br />
                </asp:TemplateField><br />
                <br />
                <asp:BoundField DataField="Description" HeaderText="Description" <br />
                    SortExpression="Description" ItemStyle-Width="300px" ><br />
<ItemStyle Width="300px"></ItemStyle><br />
                </asp:BoundField><br />
                <asp:TemplateField HeaderText="Description" Visible="False"><br />
                <ItemTemplate><br />
                <asp:Label ID="lblDescription" runat="server" Text='<%# Eval("Description")%>' ></asp:Label><br />
                </ItemTemplate><br />
                </asp:TemplateField><br />
                <br />
                <asp:TemplateField HeaderText="QTY"><br />
                <ItemTemplate><br />
                <asp:TextBox ID="TxtQTY" runat="server" Width="30px" Text='<%# Eval("QTY") %>' /><br />
                </ItemTemplate><br />
                </asp:TemplateField><br />
                <br />
                <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" <br />
                    ItemStyle-Width="80px" ><br />
<ItemStyle Width="80px"></ItemStyle><br />
                </asp:BoundField><br />
                <asp:TemplateField HeaderText="Price" Visible="False"><br />
                <ItemTemplate><br />
                <asp:Label ID="lblPrice" runat="server" Text='<%# Eval("Price")%>' ></asp:Label><br />
                </ItemTemplate><br />
                </asp:TemplateField><br />
                <br />
                <asp:BoundField DataField="Cost" HeaderText="Cost" SortExpression="Cost" <br />
                    ItemStyle-Width="80px" ><br />
<ItemStyle Width="80px"></ItemStyle><br />
                </asp:BoundField><br />
                <asp:TemplateField HeaderText="Cost" Visible="False"><br />
                <ItemTemplate><br />
                <asp:Label ID="lblCost" runat="server" Text='<%# Eval("Cost")%>' ></asp:Label><br />
                </ItemTemplate><br />
                     <FooterTemplate><br />
                        <asp:Label ID="lblSubTotal" runat="server" ForeColor="#ffffff" /><br />
                    </FooterTemplate><br />
                </asp:TemplateField><br />
                <br />
                <asp:TemplateField HeaderText="Select"><br />
                <ItemTemplate><br />
                <asp:CheckBox ID="chkSelection" runat="server" /><br />
                </ItemTemplate><br />
                </asp:TemplateField><br />
            </Columns><br />
                    <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" /><br />
                    <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" /><br />
                    <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" /><br />
                    <EditRowStyle BackColor="#7C6F57" /><br />
                    <AlternatingRowStyle BackColor="White" /><br />
        </asp:GridView><br />

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        Label lblCost = (Label)e.Row.FindControl("lblCost");
        float price = float.Parse(lblCost.Text);
        tprice += price;
    }

    if (e.Row.RowType == DataControlRowType.Footer)
    {
        Label lblSubTotal = (Label)e.Row.FindControl("lblSubTotal");
        lblSubTotal.Text = tprice.ToString();
    }
}

Please assist where I am doing wrong...

cheers,
sneha

Nishant Singh8-Nov-09 23:38

8-Nov-09 23:38

Hi Sneha
you need to basically debug the GridView1_RowDataBound function.
In my opinion

Label lblSubTotal = (Label)e.Row.Cells[4].FindControl("lblSubTotal");

RajpootRohan9-Nov-09 0:21

RajpootRohan

9-Nov-09 0:21

thanks for the reply Nishant. I did what you said but didn't get the results. On debugging the label control is showing the value but not in the browser. Unable to sort out the problem.

cheers,
sneha

Member 42191699-Nov-09 0:24

Member 4219169

9-Nov-09 0:24

test