How will get session from gridview

[visalakshi]

how will get session variable from gridview ....pls tell me the codings

[radcaesar]

Session variable from gridview ? What you try to achieve ?

Can u explain your requirement in detail ?

:)

[visalakshi]

Session variable from gridview ? What you try to achieve ?

Can u explain your requirement in detail ?

:)

yes

I have two forms ...one form-gridview ...another oneform have some textbox

in gridview i have three columns....one column is company Name with hyperlink .....if i click one company name it will show that related company details in another form to textbox.....this concept.....

i am doing....selected row put into session ......that session variable compare to another form textbox.....but it not working ....wat can i do...


this is my coding

ingridview
--------------

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

Session["CompanyName"] =GridView1.SelectedRow.Cells[1].Text;
Response.Redirect("Default6.aspx");

}

In nextform
------------------

string str =ConfigurationSettings.AppSettings.Get("connection ");
protected void Page_Load(object sender, EventArgs e)
{
if (TextBox2.Text == "")
{
con = new SqlConnection(str);
cmd = new SqlCommand("SELECT [Company Id], [CompanyName], [Address1], [ContactPerson], [EmailId], [Website] FROM [seller] ", con);
con.Open();
dr = cmd.ExecuteReader();
Response.Write(Session["CompanyName"]);
while (dr.Read())
{
if (Convert.ToString(Session["CompanyName"]) == dr["CompanyName"].ToString())
{
TextBox1.Text = dr["Company Id"].ToString();
TextBox2.Text = dr["CompanyName"].ToString();
TextBox3.Text = dr["Address1"].ToString();
TextBox4.Text = dr["EmailId"].ToString();
TextBox5.Text = dr["Website"].ToString();
TextBox6.Text = dr["ContactPerson"].ToString();
;
}
}

}

}
}

[dip_developer]

yes

I have two forms ...one form-gridview ...another oneform have some textbox

in gridview i have three columns....one column is company Name with hyperlink .....if i click one company name it will show that related company details in another form to textbox.....this concept.....

i am doing....selected row put into session ......that session variable compare to another form textbox.....but it not working ....wat can i do...


this is my coding

ingridview
--------------

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

Session["CompanyName"] =GridView1.SelectedRow.Cells[1].Text;
Response.Redirect("Default6.aspx");

}

In nextform
------------------

string str =ConfigurationSettings.AppSettings.Get("connection ");
protected void Page_Load(object sender, EventArgs e)
{
if (TextBox2.Text == "")
{
con = new SqlConnection(str);
cmd = new SqlCommand("SELECT [Company Id], [CompanyName], [Address1], [ContactPerson], [EmailId], [Website] FROM [seller] ", con);
con.Open();
dr = cmd.ExecuteReader();
Response.Write(Session["CompanyName"]);
while (dr.Read())
{
if (Convert.ToString(Session["CompanyName"]) == dr["CompanyName"].ToString())
{
TextBox1.Text = dr["Company Id"].ToString();
TextBox2.Text = dr["CompanyName"].ToString();
TextBox3.Text = dr["Address1"].ToString();
TextBox4.Text = dr["EmailId"].ToString();
TextBox5.Text = dr["Website"].ToString();
TextBox6.Text = dr["ContactPerson"].ToString();
;
}
}

}

}
}

i dont understand your logic......
In my opinion do the following...
1.when clicking on company name link hold the ID of that company(if you are using an company_id.If not then you should use.Querying with company name is not a good idea) in a variable.

2.Pass that variable as a Query string when you are redirecting your page to another one.

3.In the Page_Load event of that second page retrive the company_id from the query string variable in a local variable(say comp_id )

4.Now execute a SQL query like

SELECT Company Id, CompanyName, Address1, ContactPerson, EmailId, Website FROM seller WHERE Company Id='" & comp_id & "'

[radcaesar]

Declare the field like this,

<asp:HyperLinkField DataTextField="CategoryName" DataNavigateUrlFields="CategoryID" DataNavigateUrlFormatString="NewPage.aspx?id={0}"
HeaderText="CategoryName" />

In the destination page query it like this,

if (Request.QueryString["id"] != null)
{
int yourValue = Convert.ToInt32(Request.QueryString["id"]);
}

[qqqqqqqqqq]

hi... how to declare the querystring if i am using an image button in the gridview.. thanks