how to use gridview values in another page

Question

0.00/5 (No votes)

See more:

Hi,
i used gridview in one page and trying to access that details in another page..because i have order now button in some other page where user is requested for selecting dealer name so when user clicks on order now button that grid data along with dealer name should go to the database..

Posted 19-Apr-12 18:45pm

Aparnashreenivas

Add a Solution

6 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Prasad_Kulkarni · Answer 1 · 2012-04-19T18:49:00

Solution 1

Please refer the links, you will get some help from them:
access data grid view in other page in (c# window application)[^]
how to send gridview row values to other page[^]

Posted 19-Apr-12 18:49pm

Prasad_Kulkarni

P.Salini · Answer 2 · 2012-04-19T18:52:00

Solution 2

see this
http://forums.asp.net/t/1791833.aspx/1?Need+to+pass+single+gridview+value+to+another+page[^]

http://stackoverflow.com/questions/9193063/how-to-send-multiple-gridview-rows-to-another-page-and-populate-those-rows-in-th[^]

Posted 19-Apr-12 18:52pm

P.Salini

v2

Saroj Kumar Sahu · Answer 3 · 2012-04-19T19:13:00

XML

Here is my code... i have taken a page called image.aspx in that the following is the source code (which consists of a griview with hyperlink)

    <%@ Page Language="C#" AutoEventWireup="true" CodeFile="image.aspx.cs" Inherits="image" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" >
    <head runat="server">
    <title>Untitled Page</title>
    </head>
    <body>
    <form id="form1" runat="server">
    <div>
    <asp:FileUpload ID="FileUpload1" runat="server" />
    <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
    BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1"
    DataKeyNames="QuickLook ID" DataSourceID="SqlDataSource1" GridLines="None">
    <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
    <Columns>
    <asp:BoundField DataField="Full Name" HeaderText="Full Name" SortExpression="Full Name" />
    <asp:BoundField DataField="Name Displayed" HeaderText="Name Displayed" SortExpression="Name Displayed" />
    <asp:BoundField DataField="Birth Day" HeaderText="Birth Day" SortExpression="Birth Day" />
    <asp:BoundField DataField="Access Level" HeaderText="Access Level" SortExpression="Access Level" />
    <asp:BoundField DataField="Team Name" HeaderText="Team Name" SortExpression="Team Name" />
    <asp:BoundField DataField="Joining Date" HeaderText="Joining Date" SortExpression="Joining Date" />
    <asp:HyperLinkField DataNavigateUrlFields="Quicklook Id" DataNavigateUrlFormatString="nextpage.aspx?id={0}"
    DataTextField="QuickLook ID" />
    </Columns>
    <RowStyle BackColor="#DEDFDE" ForeColor="Black" />
    <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
    <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CalendarUtilityConnectionString %>"
    SelectCommand="SELECT * FROM [Employee_Record]"></asp:SqlDataSource>
    </div>
    </form>
    </body>
    </html>


After that i have taken another page called newpage.aspx in which i have a another gridview.. which diplays the details from the query string... as follows..
the following is the code behind for newpage.aspx file:

    protected void Page_Load(object sender, EventArgs e)
    {
    SqlConnection con = new SqlConnection(@"Data Source=WINKC185045-MAB\SQLEXPRESS;Initial Catalog=CalendarUtility;Integrated Security=True");
    SqlDataAdapter da = new SqlDataAdapter("select * from Employee_Record where [quicklook id] like '" + Request.QueryString[0] + "'", con);
    DataSet ds = new DataSet();
    da.Fill(ds, "employee_record");
    GridView1.DataSource = ds.Tables[0];
    GridView1.DataBind();
    }

Hope u found the solution !!!!!!!!

sravani.v · Answer 4 · 2012-04-19T19:16:00

Solution 4

See this may give you some idea

http://www.dotnetspider.com/resources/42819-How-show-selected-record-from-grid-view.aspx[^]

Posted 19-Apr-12 19:16pm

sravani.v

v2

Comments

Member 12484939 29-Apr-16 3:22am

how to redirecting to another page using only one particular value which is present in gridview

Deepak_Sharma_ · Answer 5 · 2012-04-19T19:59:00

Here is an example to access GridView from previous page. In first page set DataSource of the GridView to a DataTable using ds.Tables[0]. Then in Button click event add this DataTable in Session. In second page, get this DataTable from the session and bind it to GridView in second page:

In first page add GridView data source in session:

C#

protected void Page_Load(object sender, EventArgs e)
{
    string ConString = ConfigurationManager.ConnectionStrings["ConString2"].ConnectionString;
    SqlConnection con = new SqlConnection(ConString);
    string CmdString = "SELECT * FROM Departments";
    SqlCommand cmd = new SqlCommand(CmdString, con);
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    sda.Fill(ds);
    GridView2.DataSource = ds.Tables[0];
    GridView2.DataBind();
}

protected void Button1_Click(object sender, EventArgs e)
{
    DataTable dt = new DataTable();
    dt = (DataTable)GridView2.DataSource;
    Session.Add("MyDataTable", dt);
    Response.Redirect("WebForm2.aspx");
}

In second page get Data Source from the session:

C#

protected void Page_Load(object sender, EventArgs e)
{
    if(!IsPostBack)
    {
        DataTable dt = new DataTable();
        dt = (DataTable)Session["MyDataTable"];
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

Another solution is here:
http://www.aspsnippets.com/Articles/Pass-ASP.Net-GridView-from-one-page-to-another-page.aspx[^]

Pradhan Gagan · Answer 6 · 2012-04-19T20:24:00

Solution 6

Yes dear
keep it datatable all gridveiw
and take it anoter page by function parameter

Globally you have to make a function in cs.
suppose

C#

public public test(gridview gv)
{
}

acess the function by object

C#

com.test(dt);

and use it

[EDIT] added pre tags

Posted 19-Apr-12 20:24pm

Pradhan Gagan

Updated 19-Apr-12 20:27pm

v2