How to store data from multiple gridview datatable from multiple web pages

Question

5.00/5 (1 vote)

See more:

Hi guys,
So just wondering. I got a few pages where by each pages have a gridview(lets called this sourcegridview). So in these sourcegridview, I have put a column of checkboxes for each row. Every time I checked a checkbox, that particular row will be added to another gridview(lets called this gridview CompiledGridview). I did this by transferring the checked row into a datatable and bind it with the CompiledGridview. So my question is, how to maintain the data added to the CompiledGridview? Because I have to navigate to each of my webpages and select the record that I want to be added to the CompiledGridview and everytime I navigate to a different web page, the data in the CompiledGridview is gone. One of the way is Session but how to bind it? because I have multiple sourcegridview.

Any help is greatly appreciated! :)

Posted 30-Dec-13 15:03pm

nizam15

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

adriancs · Answer 1 · 2013-12-30T17:04:00

Solution 1

As you said, if you want to store it at session, you can create a class like this:

C#

public class Class1
{
    public static DataTable TableSession
    {
        get
        {
            if (HttpContext.Current.Session["dt"] == null)
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("checked");
                dt.Columns.Add("name");
                HttpContext.Current.Session["dt"] = dt;
            }
            return (DataTable)HttpContext.Current.Session["dt"];
        }
        set
        {
            HttpContext.Current.Session["dt"] = value;
        }
    }
}

and access it anywhere like this:

C#

protected void Page_Load(object sender, EventArgs e)
{
    sourcegridview.DataSource = Class1.TableSession;
    sourcegridview.DataBind();

    Class1.TableSession.Rows.Add("1", "new data");

    CompiledGridview.DataSource = Class1.TableSession;
    CompiledGridview.DataBind();
}

Posted 30-Dec-13 17:04pm

adriancs

Comments

nizam15 1-Jan-14 22:08pm

Hi adriancs.
Sorry for the late reply. Got a problem with my laptop. Thanks for the suggestion! Will try it out. By they way is it possible for me to insert all the data I have stored in a datatable into a SQL table?

adriancs 1-Jan-14 22:21pm

database = SQL database = SQL table
are you referring to System.Data.DataTable?

nizam15 2-Jan-14 2:37am

yup~i am referring to System.Data.Datatable. Now I stored my data in a Data.Datatable. So I was wondering if there is anyway for me to transfer that data into a SQL database table.

adriancs 2-Jan-14 2:43am

by executing INSERT, UPDATE and DELETE of SQL statements.

nizam15 2-Jan-14 2:56am

Is it the same as inserting normal data? because the data is already in the datatable right so just want to copy those data into a SQL table.

adriancs 2-Jan-14 3:02am

If the data is already existed in database and you wish to update it, you use the UPDATE statement. If you want to insert new data, then you will use INSERT statement. These are the very basics of MsSQL, try google it for tutorials. You need to learn the basic first before doing anything further.

nizam15 2-Jan-14 3:09am

emm...I think there's a little misunderstanding here. Yeah I know about the basic SQL command. Its just I don't know how to insert data into a SQL table from System.Data.Datatable. I already store the data inside a Data.Datatable and now I want to insert all of this data into my SQL database table. I know I need to use INSERT command but I'm quite lost on how to do it because its not like your normal data INSERT. :)

adriancs 2-Jan-14 17:55pm

For this situation, you'll use UPDATE.

How to store data from multiple gridview datatable from multiple web pages

1 solution

Solution 1

Add your solution here

Preview 0

How to store data from multiple gridview datatable from multiple web pages

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us