TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
sagar Bhosale
NA
179
176k
Can i used Session value two time in single page?
Jul 22 2011 6:59 AM
hi friends ,
can i use session value two times becouse at sexond time when i used session i get null value
plz help me
my code is
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//imgExport.Visible = false;
string ID = Request.QueryString["0"];
txtqueryexec.Text = "";
string LoginId = Convert.ToString(Session["LoginID"]);
if (LoginId !="")
{
FillGrid();
}
}
Session["DrdQury"] = drpdwn_query.SelectedItem.Text.ToString();
Session["TxtQuery"] = txtqueryexec.Text.Trim();
}
protected void btnexec_Click(object sender, EventArgs e)
{
}
private void FillGrid()
{
DataSet ds;
string drd = Convert.ToString(Session["DrdQury"]); //my first session
string txt = Convert.ToString(Session["TxtQuery"]);
if (!String.IsNullOrEmpty(Convert.ToString(Session["DrdQury"])) && !String.IsNullOrEmpty(Convert.ToString(Session["TxtQuery"])))
{
ds = objclient.get_queryexec(drd, txt);
//Session["DrdQury"] = "null"; Session["TxtQuery"] = "null";
}
else
{
ds = objclient.get_queryexec(drpdwn_query.SelectedItem.Text, txtqueryexec.Text);
}
if (ds.Tables[0].Rows.Count > 0)
{
gv_command.Visible = true;
gv_command.DataSource = ds;
gv_command.DataBind();
}
}
protected void drpdwn_query_SelectedIndexChanged(object sender, EventArgs e)
{
string query = drpdwn_query.SelectedItem.Text;
switch(query)
{
case "SELECT":
txtqueryexec.Text = "SELECT * FROM [TABLENAME]";
break;
case "INSERT":
txtqueryexec.Text = "INSERT INTO [TABLENAME] [(col1, col2, col3,...colN)] VALUES (value1, value2, value3,...valueN)";
break;
case "UPDATE":
txtqueryexec.Text = "UPDATE [TABLENAME] SET column_1 = [value1], column_2 = [value2]";
break;
}
}
protected void imgExport_Click(object sender, ImageClickEventArgs e)
{
string strPath = Server.MapPath(Request.ApplicationPath);
strPath = strPath + "\\ExportedFiles\\SchemeRating.xls";
string drd = Convert.ToString(Session["DrdQury"]); //my second session but here i got null value
string txt = Convert.ToString(Session["TxtQuery"]);
DataSet ds = objclient.get_queryexec(drd, txt);
exportToExcelSlow(ds.Tables[0], strPath);
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ClearContent();
Response.ContentType = "application/ms-excel";
Response.AddHeader("content-disposition", "attachment; filename=SchemeRating.xls");
Response.WriteFile(strPath);
Response.End();
Response.Flush();
}
Reply
Answers (
11
)
Error Only Content controls are allowed directly in a content page that contains Content controls
What is use of ~/, ./ ../ when making website?