ASP.NET

lrsalunkhe wrote:

Can we Attached multiple files.

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();
    }
}

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");
        
    }

mylogics wrote:

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

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