how to Tranfer griddata from page 1 to another page and parse those data to textboxes

Question

0.00/5 (No votes)

See more:

Hello guys,

I have data in page1 in gridview,now i want to transfer grid data to another page and also how to parse this grid data so that i can fill those data to lables and textboxes.

Can any one assist me?

Thanks,

Posted 17-May-12 1:34am

Afzal Shaikh

Add a Solution

Comments

preet88 18-May-12 1:29am

hi afzal you can do this in other way also... you can have a class and store the data of the grid accordingly in the data members.
Once you have the data in class object you can pass that object to other page by get methods(if there is direct navigation from 1page to other) or you can also pass this using session variables

7 solutions

Solution 1

put grid inside session in your first page

C#

 protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDb1"].ConnectionString;
            SqlCommand cmd = new SqlCommand("select EVENT_CODE from EVENT_MASTER", con);
            DataTable dt = new DataTable();
            SqlDataAdapter ad = new SqlDataAdapter();
            ad.SelectCommand = cmd;
            ad.Fill(dt);
            this.GridView1.DataSource = dt;
            this.GridView1.DataBind();
            Session["grd"] = GridView1;
            ad.Dispose();
            cmd.Dispose();
            con.Dispose();
}

in second page acess this grid and bind to individual control like

C#

protected void Page_Load(object sender, EventArgs e)
       {

           GridView dr = new GridView();

           if(dr!=null)
               dr = (GridView)Session["grd"];
            Label1.Text = dr.Rows[0].Cells[0].ToString();

       }

Posted 17-May-12 1:49am

Nilesh Rokade

Updated 17-May-12 22:18pm

v2

Comments

Afzal Shaikh 17-May-12 8:13am

I tried this one , it is giving me below error in another page

Unable to cast object of type 'System.Web.UI.WebControls.GridViewRow' to type 'System.Web.UI.WebControls.GridView'.

if u know please ?

Nilesh Rokade 17-May-12 8:28am

can u post code you are trying.since after running i have updated above code.May be there is something typographical error is occuring

Afzal Shaikh 17-May-12 8:41am

Page1 code:

protected void GrdvwSuccessful_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Btn"))
{
GridViewRow gvr = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
int RowIndex = gvr.RowIndex;
//Afzal
object obj = objAgentHandler.GetALLordersSuccssful(Convert.ToInt32(StateHelper.currentLogin);
Session["grd"] = GrdvwSuccessful;

Response.Redirect("InfoPage_Remarks.aspx?ID=" + RowIndex);

}

}

Page2 Code:

public void GetVisaInfo_Remarks()
{
k = Convert.ToInt32(Request.QueryString["ID"]);
List<visaordertinfo> info = (List<visaordertinfo>)new VisaOrder_Handler().GetUserInfo_Neworder(k);

if (info.Count >= 0)
{
//GridViewRow dr = new GridViewRow();
GridView dr = new GridView();
dr = (GridView)Session["grd"];
LbName.Text = dr.Rows[0].Cells[0].ToString();

}

}

Solution 2

VB

Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
       If e.CommandName = "select" Then
 

 
           GridView1.FooterRow.Visible = True
 
           '' for navigate other page or....
            Dim i As Integer
          i = e.CommandArgument()
             Dim row As GridViewRow
           row = GridView1.Rows(i)
 
           Session("name") = row.Cells(1).Text
           Session("mob") = row.Cells(2).Text
           Session("add") = row.Cells(3).Text
           Response.Redirect("Default4.aspx")
 

 

       End If

'' In default4.aspx
use above sessions in default4. page and store this values in datatble and assign datatable to gridview present in default4.aspx

VB

Dim dt As DataTable = New DataTable()
            
dt.Columns.Add("Name")
            dt.Columns.Add("MobileNumber")
            dt.Columns.Add("Address")
            Dim ro As DataRow
            ro = dt.NewRow()
            ro(0) =   Session("name").tostring()
            ro(1) =  Session("mob").tostring()
            ro(2) =  Session("add").tostring()
            dt.Rows.Add(ro)
 GridView1.DataSource = dt
            GridView1.DataBind()

Posted 17-May-12 1:51am

vangapally Naveen Kumar

Updated 17-May-12 22:16pm

v3

Solution 3

are you casting System.Web.UI.WebControls.GridViewRow' to grid ???? copy paste code given in above comments

Posted 17-May-12 2:30am

Nilesh Rokade

Solution 5

there are multiple way,
1)you van use session,
put your griddata into session, and access session data on another page,

2)You can also use HTTPcookies,
you can put you griddata into cookie,

C#

Response.Cookies["myNewCookie"].Values["SubCookie1"] = "value1";

string myResponse = Request.Cookies["myNewCookie"].Values["SubCookie1"];

hope this will help you....

Posted 17-May-12 19:49pm

madhuri@mumbai

Updated 17-May-12 22:17pm

v2

Solution 6

put this code in function where you are retrieving data from databse.

You will have to move your code

C#

Session["grd"] = GrdvwSuccessful;  from 

protected void GrdvwSuccessful_RowCommand(object sender, GridViewCommandEventArgs e)

Posted 17-May-12 21:41pm

Nilesh Rokade

Updated 17-May-12 22:17pm

v2

Solution 7

int pageSize = 0; //每页显示行数
int nMax = 0; //总记录数
int pageCount = 0; //页数＝总记录数/每页显示行数
int pageCurrent = 0; //当前页号
int nCurrent = 0; //当前记录行
DataSet ds = new DataSet();
DataTable dtInfo = new DataTable();

string strConn = "SERVER=127.0.0.1;DATABASE=NORTHWIND;UID=SA;PWD=ULTRATEL"; //数据库连接字符串
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
string strSql = "SELECT * FROM CUSTOMERS";
SqlDataAdapter sda = new SqlDataAdapter(strSql,conn);
sda.Fill(ds,"ds");
conn.Close();
dtInfo = ds.Tables[0];
InitDataSet();

C#

private void InitDataSet()
        {
            pageSize = 20;      //设置页面行数
            nMax = dtInfo.Rows.Count;

            pageCount=(nMax/pageSize);    //计算出总页数

            if ((nMax % pageSize) > 0) pageCount++;

            pageCurrent = 1;    //当前页数从1开始
            nCurrent = 0;       //当前记录数从0开始

            LoadData();
        }

C#

private void LoadData()
        {
            int nStartPos = 0;   //当前页面开始记录行
            int nEndPos = 0;     //当前页面结束记录行

            DataTable dtTemp = dtInfo.Clone();   //克隆DataTable结构框架

            if (pageCurrent == pageCount)
                nEndPos = nMax;
            else
                nEndPos = pageSize * pageCurrent;

            nStartPos = nCurrent;

            lblPageCount.Text = pageCount.ToString();
            txtCurrentPage.Text = Convert.ToString(pageCurrent);

            //从元数据源复制记录行
            for (int i = nStartPos; i < nEndPos; i++)
            {
                dtTemp.ImportRow(dtInfo.Rows[i]);
                nCurrent++;
            }
            bdsInfo.DataSource = dtTemp;
            bdnInfo.BindingSource = bdsInfo;
            dgvInfo.DataSource = bdsInfo;
        }
        4、菜单响应事件：

C#

private void bdnInfo_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            if (e.ClickedItem.Text == "关闭")
            {
                this.Close();
            }
            if (e.ClickedItem.Text == "上一页")
            {
                pageCurrent--;
                if (pageCurrent <= 0)
                {
                    MessageBox.Show("已经是第一页，请点击"下一页"查看！");
                    return;
                }
                else
                {
                    nCurrent = pageSize * (pageCurrent - 1);
                }

                LoadData();
            }
            if (e.ClickedItem.Text == "下一页")
            {
                pageCurrent++;
                if (pageCurrent > pageCount)
                {
                    MessageBox.Show("已经是最后一页，请点击"上一页"查看！");
                    return;
                }
                else
                {
                   nCurrent=pageSize*(pageCurrent-1);
                }
                LoadData();
            }
        }

Posted 17-May-12 23:16pm

miwuawen

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)

Nilesh Rokade · Accepted Answer · 2012-05-17T19:18:00

do not put grid in session at following function .

C#

protected void GrdvwSuccessful_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Btn")) { GridViewRow gvr = (GridViewRow)(((Button)e.CommandSource).NamingContainer); int RowIndex = gvr.RowIndex; //Afzal object obj = objAgentHandler.GetALLordersSuccssful(Convert.ToInt32(StateHelper.currentLogin); Session["grd"] = GrdvwSuccessful; Response.Redirect("InfoPage_Remarks.aspx?ID=" + RowIndex); } }

You will have to put grid in session at place where you are retrieving data.

how to Tranfer griddata from page 1 to another page and parse those data to textboxes

7 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 6

Solution 7

Add your solution here

Preview 0

Existing Members

...or Join us