Getting values from the Gridview and put it in the previous form?

Hello everyone,

I want to get the data from the Gridview and put t in the previous form, how do I do it?

<%@ Page Language="C#" %>

<%@ Reference Page="~/webform1.aspx" %>
<html>
  <head runat="server">
    <title>View Information</title>
  </head>
  <body>
    <form id="form1" runat="server">
      <asp:GridView ID="GridView1" AllowSorting="true" AllowPaging="true" Runat="server"
        DataSourceID="SqlDataSource1" AutoGenerateEditButton="true" DataKeyNames="au_id"
        AutoGenerateColumns="False">
        <Columns>
          <asp:BoundField ReadOnly="true" HeaderText="ID" DataField="au_id" SortExpression="au_id" />
          <asp:BoundField HeaderText="Last Name" DataField="au_lname" SortExpression="au_lname" />
          <asp:BoundField HeaderText="First Name" DataField="au_fname" SortExpression="au_fname" />

 </Columns>
      </asp:GridView>
    </form>
  </body>
</html>
 
In Form1.aspx
ControlID=txtFName.Text
ControlID=txtLName.Text
In GridView 
 protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    { 
	Session.Add(txtFName.Tex), me.GridView1.SelectedRow.Cells(0).Text)   //
	Session.Add((txtLName.Tex), me.GridView1.SelectedRow.Cells(1).Text); 
		OR
	string x;
        string Contact = new newContact();
        newTextbox = GridView1.rows(x).controls.findcontrol("au_fname");		.....................................}

Re: Getting values from the Gridview and put it in the previous form?

any one? thanks

Re: Getting values from the Gridview and put it in the previous form?

Hi:

Have you tried PreviousPage.FindControl() method?

If your problem remains, please tell us the difficulty you meet with.

Thanks

Re: Getting values from the Gridview and put it in the previous form?

No, I haven't use the PreviousPage.FindControl() method.. How do I do that?

I just put the <%@ Reference Page="~/Form1.aspx" %> in the Gridview page to reference Form1 page, then in the Gridview, I try this but gets Error 'System.Web.UI.WebControls.GridView' does not contain a definition for 'rows'

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{string x;

Form1 form = new Form1();

form.Lname = GridView1.rows(x).controls.findcontrol("LastName");

Session.Add("LName", GridView1.SelectedRow.Cells(0).Text);

Server.Transfer("Form1.aspx");

}

Can you show me how to use the PreviousPage.FindControl() method to get the values from Gridview and put it back in the textbox of Form1, thanks

Re: Getting values from the Gridview and put it in the previous form?

Hi:

C# is case sensitive, so it should be GridView1.Rows[x].Controls.FindControl("LastName");

From your code I think what you're doing now is the opposition to your thread. It's better to clarify what do you want to do.

Please elaborate your requirement.

And here's how to use PreviousPage.FindControl():

Control c=PreviousPage.FindControl("ControlID");

Thanks & Regards

Re: Getting values from the Gridview and put it in the previous form?

Thanks Allen for replying,

Okay, let me clarify it, hopefully I won't confuse you hihi....

I have a webform.aspx and 3 control buttons on the form "Save, View All Data (all data from webform Db) and Next" button, The "Save" button is saving all the information on the form to the access database and the "View All Data" is pull out all the information from that webform database and put it in the Gridview. When user view all the data on the Gridview and decided to select the information on Row 5 for either edit or continue on running a search. The row 5 that the user select should be pre-populate all the information on that Row back to the webform, How do I pass variables or values from the Gridview back to the webform?

For Example:

<asp:GridView ID="GridView1" 

        <Columns>

          <asp:BoundField ReadOnly="true" HeaderText="ID" DataField="au_id" SortExpression="au_id" />

          <asp:BoundField HeaderText="Last_Name" DataField=" Last_Name " />

          <asp:BoundField HeaderText="First_Name" DataField=" First_Name "/>

 </Columns>

      </asp:GridView>

In Form1.aspx

ControlID=txtLName.Text

ControlID=txtFName.Text

In Select handler, I include Reference Page and PreviousPageType in the source of Gridview

 <%@ Reference Page="~/RegionBankForm.aspx" %>
<%@ PreviousPageType VirtualPath="RegionBankForm.aspx" %>

 protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

       string x;
       GridView1.Rows[x].Controls.FindControl("Last_Name");   
       Control txtLName = (TextBox)PreviousPage.FindControl("txLName");

       GridView1.Rows[x].Controls.FindControl("First_Name");   
       Control txtFName = (TextBox)PreviousPage.FindControl("txFName");

Response.Direct(txLName.Text+"<br>"+txFName.Text+"<br>");
                                                                                 

//But I got errors: 'System.Web.UI.WebControls.GridViewRowCollection.this[int]' has some invalid  arguments and System.Data.OleDb.OleDbException: Disk or network error.

// Can you show me the right way to do it ? thanks

Re: Getting values from the Gridview and put it in the previous form?

Hi:

Thank you for your updating but I'm afraid I'm still confused. Here's my question:

1. The GridView is in webform.aspx and when user selects one row he'll be redirected to Form1.aspx?

2. You want to show some information of the selected row on page Form1.aspx?

If my understanding is correct. Here's the suggestion:

You can use QueryString to pass values. For example:

protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) //Note the event handler isnot SelectedIndexChanged
{
string s=((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[0]).Text://You can set a breakpoint here to test the index

Response.Redirect("Form1.aspx?A=" + s);
}

in Form1.aspx.cs's Page_Load you can get querystring:

if (Request.QueryString["A"] != null)
{

txtLName.Text= Request.QueryString["A"];

}

Regards

Re: Getting values from the Gridview and put it in the previous form?

Thankyou Allen for all your help, really appreciated!

Allen Chen MSFT

1. The GridView is in webform.aspx and when user selects one row he'll be redirected to Form1.aspx?

Yes, the GridView is in webform.aspx and when user click "View Detail" button on Form1, It pops up with all data in the Gridview

Allen Chen MSFT

2. You want to show some information of the selected row on page Form1.aspx?

Yes, that's correct, How do I pass all the row information into form1? I have about 30 columns in Gridview and about 30 textfields in Form1

Allen Chen MSFT

protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) //Note the event handler isnot SelectedIndexChanged
    {
     string s=((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[0]).Text://You can set a breakpoint here to test the index

    Response.Redirect("Form1.aspx?A=" + s);
    }

in Form1.aspx.cs's Page_Load you can get querystring:

        if (Request.QueryString["A"] != null)
{

txtLName.Text= Request.QueryString["A"];

}

I have an error at Compiler Error Message: CS0117: 'System.EventArgs' does not contain a definition for 'NewSelectedIndex'

Line 29: string s = ((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[0]).Text; //You can set a breakpoint here to test the index

Re: Getting values from the Gridview and put it in the previous form?

Hi:

Thanks for your further elaboration. Then you can just try what I mentioned in my previous post.

boston_ma

I have an error at Compiler Error Message: CS0117: 'System.EventArgs' does not contain a definition for 'NewSelectedIndex'

Line 29: string s = ((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[0]).Text; //You can set a breakpoint here to test the index

About this error, please make sure in your inline code you're specifying the correct event:

OnSelectedIndexChanging="GridView1_SelectedIndexChanging"

Note it's NOT OnSelectedIndexChanged.

If you sill get this error, please inform us.

Regards

Re: Getting values from the Gridview and put it in the previous form?

Allen Chen MSFT

About this error, please make sure in your inline code you're specifying the correct event:

OnSelectedIndexChanging="GridView1_SelectedIndexChanging"

Note it's NOT OnSelectedIndexChanged.

If you sill get this error, please inform us.

Regards

Thanks Allen for still helping me out, really appreciated :-)

On the Gridview, I have set the Automatic Generate Select Button = true, when I double click on the select link on the Gridview, it generated the OnSelectedIndexChanged Not OnSelectedIndexChanging="GridView1_SelectedIndexChanging" , for right now it Redirect to form1 when click "Select" link but values are not showing.. I think it''s because the Select action is triggered the OnSelectedIndexChanged not OnSelectedIndexChanging, so how do I link the Select Command to the Gridview1_OnSelectedIndexChanging?

Re: Getting values from the Gridview and put it in the previous form?

Hi:

Please open your aspx. Shift to Source view. Then manually add this (and remove OnSelectedIndexChanged if it is there):

<asp:GridView OnSelectedIndexChanging="GridView1_SelectedIndexChanging" ID="GridView1" runat="server">
</asp:GridView>

Or in design view, choose your GridView and click the yellow icon in the properties window, in the listed events below you can find SelectedIndexChanging and double click it.

Regards

Re: Getting values from the Gridview and put it in the previous form?

Allen Chen MSFT

Hi:

Please open your aspx. Shift to Source view. Then manually add this (and remove OnSelectedIndexChanged if it is there):

<asp:GridView OnSelectedIndexChanging="GridView1_SelectedIndexChanging" ID="GridView1" runat="server">
</asp:GridView>

Or in design view, choose your GridView and click the yellow icon in the properties window, in the listed events below you can find SelectedIndexChanging and double click it.

I did this already but still no luck, no values show in the form

Re: Getting values from the Gridview and put it in the previous form?

Hi:

Could you please post all your current code (both inline code and code behind of all your two pages)?

Thanks

Re: Getting values from the Gridview and put it in the previous form?

I have about 30+ fields in the form and also the same amount of data on the Gridview pull out from the same database of where form1 save ...Do you want me to post all? let me know, I pull out just the first 3 to show you

Here is part of the Gridview Design form

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="RegionBankDetails.aspx.cs" Inherits="RegionBankDetails" %>
<%@ Reference Page="~/RegionBankForm.aspx" %>

<!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>RegionBankDetails</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource3"
            Style="z-index: 100; left: 0px; position: absolute; top: 24px" AllowPaging="True" AllowSorting="True" CellSpacing="2" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" ForeColor="Black" OnSelectedIndexChanging="GridView1_SelectedIndexChanging" AutoGenerateSelectButton="True">
            <Columns>
                <asp:BoundField DataField="File Num" HeaderText="File Num" InsertVisible="False"
                    SortExpression="File Num" />
                <asp:BoundField DataField="LenderName" HeaderText="LenderName" SortExpression="LenderName" />
                <asp:BoundField DataField="LenderEmail" HeaderText="LenderEmail" SortExpression="LenderEmail" />
                <asp:BoundField DataField="LenderPhone" HeaderText="LenderPhone" SortExpression="LenderPhone" />

.................................

SortExpression="BorrowerInfoQues9Yes" />
                <asp:CheckBoxField DataField="BorrowerInfoQues9No" HeaderText="BorrowerInfoQues9No"
                    SortExpression="BorrowerInfoQues9No" />
            </Columns>
            <FooterStyle BackColor="#CCCCCC" />
            <RowStyle BackColor="White" />
            <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
            <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:bankConnectionString5 %>"
            ProviderName="<%$ ConnectionStrings:bankConnectionString5.ProviderName %>" SelectCommand="SELECT * FROM [bank] ORDER BY [File Num]">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:bankConnectionString4 %>"
            ProviderName="<%$ ConnectionStrings:bankConnectionString4.ProviderName %>" SelectCommand="SELECT * FROM [bank] ORDER BY [File Num]">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:bankConnectionString3 %>"
            ProviderName="<%$ ConnectionStrings:bankConnectionString3.ProviderName %>" SelectCommand="SELECT * FROM [bank] ORDER BY [File Num]">
        </asp:SqlDataSource>
         

    </div>
    </form>
</body>
</html>

And Code Behind

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class RegionBankDetails : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) //Note the event handler isnot SelectedIndexChanged
    {

        string s = ((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[0]).Text; //You can set a breakpoint here to test the index
        string a = ((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[1]).Text;
        string b = ((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[2]).Text;
      Response.Redirect("RegionBankForm.aspx?A=" + s + "B=" + a + "C=" + b );

}

And in Form1.aspx

protected void Page_Load(object sender, EventArgs e)
    {
        this.TextBoxLenderName.Text = Request.QueryString["requestorname"];
        this.TextBoxLenderEmail.Text = Request.QueryString["email"];

        if ((Request.QueryString["A"] != null)&& (Request.QueryString["B"] != null)&& (Request.QueryString["A"] != null))
        {

            TextBoxLName.Text = Request.QueryString["A"];
            TextBoxLEmail.Text = Request.QueryString["B"];
            TextBoxPhone.Text = Request.QueryString["C"];


        }

    }

Re: Getting values from the Gridview and put it in the previous form?

Hi:

Change this at first:

Response.Redirect("RegionBankForm.aspx?A=" + s + "&B=" + a + "&C=" + b );

And I'll keep looking into your code to see whether there're other problems.

Thanks

Re: Getting values from the Gridview and put it in the previous form?

Still Nothing shows in the form,

Re: Getting values from the Gridview and put it in the previous form?

Hi:

What can you see on the address bar? Also:

protected void Page_Load(object sender, EventArgs e)
    {
        this.TextBoxLenderName.Text = Request.QueryString["requestorname"];
        this.TextBoxLenderEmail.Text = Request.QueryString["email"];

        if ((Request.QueryString["A"] != null)&& (Request.QueryString["B"] != null)&& (Request.QueryString["A"] != null))
        {
string s= Request.QueryString["A"];

            TextBoxLName.Text = Request.QueryString["A"];
            TextBoxLEmail.Text = Request.QueryString["B"];
            TextBoxPhone.Text = Request.QueryString["C"];//Set a breakpoint here. What's the value of s?


        }

    }
Regards

Re: Getting values from the Gridview and put it in the previous form?

Sorry for a late reply , Thanks Allen for your patient and your support...

It works perfectly now, It put appropriate values from the row column to the field in the form but I'm afraid that the Querry String for Response Direct have a limit of max string. I have 40 columns in the Gridview and that 40 variable fields have to populate all in the form.

Is there a way to breakdown the Query String?

Re: Getting values from the Gridview and put it in the previous form?

Hi Allen,

Instead of using a long Query String to pass variables back to the form, So, I use the String Session to pass variable back to the form and it works, but when I want to get the checkbox checked from Gridview to the form, it gets error saying CS0117: 'System.Web.UI.WebControls.TableCell' does not contain a definition for 'Checked', so how do I declare the "System.Web.UI.WebControls.TableCell" for the checkbox? I use the boolean but it's not working, ...thanks

protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
        //**Pass variables back to the Form1
        Session["A"] = ((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[2]).Text;
        Session["B"] = ((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[3]).Text;

Session["CKB1"] = ((TableCell)GridView1.Rows[e.NewSelectedIndex].Controls[30]).Checked; //NOT WORKS

Response.Redirect("Form1.aspx");

}

In Form1 Page_Load:

if((Session ["A"] != null) && (Session ["B"] != null)))
       {
            //Get values from Gridview
            TextBoxLenderName.Text = (string)Session["A"];
            TextBoxLenderEmail.Text = (string)Session["B"];

ChckSBAGuarYes.Checked = (bool)Session["CKB1"]; //NOT WORK

}

Re: Getting values from the Gridview and put it in the previous form?

Hi:

Please try this:

Session["CKB1"] = ((CheckBox)GridView1.Rows[e.NewSelectedIndex].Controls[30].Controls[index]).Checked; //Set a breakpoint here, in watch window, change the index to test.

A CheckBox will be added to the TableCell if the field is boolean. So you have to find that control and explicitly convert it to CheckBox.

Regards