Hiim trying to create a temporaly datatable and save it as listltstringgt to use as a list to insert into database i already have all the method to insert to the database i just need to save the datatable as listltstringgt sessoin variable so i can use it when ever i wantheres my code public DataTable mTempDT get return DataTableHttpContextCurrentSession34mTempDTDT34 set

Hi MaerskOwI have created sample code which fullfill requirementHTMLltdivgt ltaspButton Text34Insert34 OnClick34Insert34 runat34server34 gt ltdivgtCprivate string Constr ConfigurationManagerConnectionStrings34Constring34ConnectionStringprotected void PageLoadobject sender EventArgs e DataTable dt new DataTable dtColumnsAdd34Name34 typeofstring dtColumnsAdd34Country34 typeofstring dtRowsAdd34Peter34 34USA34 dtRowsAdd34John34 34Franch34 Session34Customers34 dtprotected void Insertobject sender EventArgs e DataTable dtCustomers Session34Customers34 as DataTable SqlConnection con new SqlConnectionConstr conOpen foreach DataRow row in dtCustomersRows SqlCommand cmd new SqlCommand34INSERT INTO Customers ValuesNameCountry34 con cmdParametersAddWithValu

Save and retrive datatable from session variable using C# in ASP.Net

MaerskOw

SOLVED CLOSED ACTIVE ANSWERED
User: MaerskOw
Posted: on Sep 06, 2016 01:46 AM
Forum: Data Controls
Answer: 1
Views: 19018
Sample Code: Download

Hi,

im trying to create a temporaly datatable and save it as list<string> to use as a list to insert into database. i already have all the method to insert to the database i just need to save the datatable as list<string> sessoin variable so i can use it when ever i want.

here's my code

public DataTable m_TempDT
        {
            get
            {
                return (DataTable)HttpContext.Current.Session["m_TempDT_DT"];
            }
            set
            {
                HttpContext.Current.Session["m_TempDT_DT"] = value;
            }
        }

        public List<string[]> m_TempSerial
        {
            get
            {
                return (List<string[]>)HttpContext.Current.Session["m_TempSerial_Serial"];
            }
            set
            {
                HttpContext.Current.Session["m_TempSerial_Serial"] = value;
            }
        }
BusinessObjects.WorkshopInventory.LoadParts.BO_PartePieza_Delta m_PartePiezaAdd = new BusinessObjects.WorkshopInventory.LoadParts.BO_PartePieza_Delta();

m_TempSerial = m_TempDT.Select().Select(c => c.ItemArray.Select(x => x.ToString()).ToArray()).ToList();

                m_PartePiezaAdd.Seriales = m_TempSerial.ToList();

please help me out.

Indresh

0 1

Reply
ANSWER
User: Indresh
Replied: on Sep 06, 2016 02:51 AM
Report

Hi MaerskOw,

I have created sample code which fullfill requirement.

HTML

<div>
        <asp:Button Text="Insert" OnClick="Insert" runat="server" />
    </div>

private string Constr = ConfigurationManager.ConnectionStrings["Constring"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
    DataTable dt = new DataTable();
    dt.Columns.Add("Name", typeof(string));
    dt.Columns.Add("Country", typeof(string));
    dt.Rows.Add("Peter", "USA");
    dt.Rows.Add("John", "Franch");
    Session["Customers"] = dt;
}


protected void Insert(object sender, EventArgs e)
{
    DataTable dtCustomers = Session["Customers"] as DataTable;

    SqlConnection con = new SqlConnection(Constr);
    con.Open();
    foreach (DataRow row in dtCustomers.Rows)
    {
        SqlCommand cmd = new SqlCommand("INSERT INTO Customers Values(@Name,@Country)", con);
        cmd.Parameters.AddWithValue("@Name", row["Name"]);
        cmd.Parameters.AddWithValue("@Country", row["Country"]);
        cmd.ExecuteNonQuery();
    }

    con.Close();
}

I hope works for you.

Save and retrive datatable from session variable using C# in ASP.Net

Company

Explore

Follow us

Contact Us