how can i access string variable value of .aspx.cs file in .aspx file

Question

i m getting a string value regression as regression = (Session["Regression"]).ToString(); in .aspx.cs file then i want to use this value in .aspx file in SelectCommand of SqlDataSource property as below

SelectCommand="SELECT [issue_oid], [issue_num], [regression], 
            [status], [tested_by], [tested_on], [patch_name], [arrived_on], [previous_info], [comment], [is_duplicate] FROM [itt_monthly_patch_issue_list] where status='Not Tested' and `regression='<%#regression%>'"`

.aspx.cs file page_load method is as below

 protected void Page_Load(object sender, EventArgs e)
    {
            if ((Session["UserName"].ToString()) == string.Empty)
            {
                Server.Transfer("regressionType.aspx");
            }
            regression = (Session["Regression"]).ToString();
            usrname = (Session["UserName"]).ToString();
            DataBind();
     }

please suggest me how can i do this? thanks in advance...

it can de done by using System.CodeDom,expressionBuilders, similar task i did it once satindersinght.blogspot.in/2012/01/… — Satinder singh
– Satinder singh, Commented Jul 12, 2012 at 5:47

Mayank Pathak · Accepted Answer · 2012-07-12 05:50:35Z

2

You can you Session Variable's value in your SQLDatasource. Like this Example.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:testDatabaseConnectionString %>"
    SelectCommand="SELECT * FROM [UserTable] WHERE ([userID] = @UserID)">
    <SelectParameters>
        <asp:SessionParameter Name="UserID" SessionField="UserID" Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>

let us know any other concerns on this..

answered Jul 12, 2012 at 5:50

Mayank Pathak

3,6815 gold badges41 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Waqar Janjua · Accepted Answer · 2012-07-12 05:49:43Z

0

add Session paramter to your sql Datasource like this

<asp:SqlDataSource SelectCommand="SELECT [issue_oid], [issue_num], [regression], 
        [status], [tested_by], [tested_on], [patch_name], [arrived_on], [previous_info], [comment], [is_duplicate] FROM [itt_monthly_patch_issue_list] where status='Not Tested' and `regression='<%#regression%>'"`>

<SelectParameters>
        <asp:SessionParameter SessionField="Regression" Name="ParameterName" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

answered Jul 12, 2012 at 5:49

Waqar Janjua

6,1432 gold badges28 silver badges36 bronze badges

6 Comments

Waqar Janjua Over a year ago

what error you are getting now ? This is the only way, you have to add the session feild to the sqldatasource declaratively ( in the aspx code ) or programatically ( in the code behind).

Piyush Over a year ago

SelectCommand="SELECT [issue_oid], [issue_num], [regression], [status], [tested_by], [tested_on], [patch_name], [arrived_on], [previous_info], [comment], [is_duplicate] FROM [itt_monthly_patch_issue_list] where status='Not Tested' and [regression]='<% =regression%>'" actually the above command is not fetching the data from db because the query having incorrect value for column regression just for confirmation i m printing that value in one label at last on wep page but there it is printing as it is like <%#regression%>

Waqar Janjua Over a year ago

no need to write regression in this format "<%=regression%>" bcz you have defined it in the select parameters. IF you specify the name Regresion in the session parameter inside the select parameters of sqldatasource then in your select command write the name of parameter which would be Regression. You query should look like SelectCommand="SELECT [issue_oid], [issue_num], [regression], [status], [tested_by], [tested_on], [patch_name], [arrived_on], [previous_info], [comment], [is_duplicate] FROM [itt_monthly_patch_issue_list] where status='Not Tested' and [regression]='Regression'"

Waqar Janjua Over a year ago

or go to design view of your webpage, select sqldatasource set it's database property and also set the session feild from there.

Piyush Over a year ago

<asp:Label ID="regre" runat="server" Text=" name is regression" /> how can i print it on level for testing means it's coming in web page or not

|

Ashwin Singh · Accepted Answer · 2012-07-12 06:31:31Z

0

Try this:

  SelectCommand="SELECT [issue_oid], [issue_num], [regression], 
                [status], [tested_by], [tested_on], [patch_name], [arrived_on], [previous_info], [comment], [is_duplicate] FROM [itt_monthly_patch_issue_list] where status='Not Tested' and `regression='<%=ReturnRegression()%>'"`

In codebehind:

    string regression=null;//Before Page_Load

    protected string ReturnRegression()
    {
    //Write logic here to prevent null being returned
        return regression;
    }

edited Jul 12, 2012 at 6:31

answered Jul 12, 2012 at 6:18

Ashwin Singh

7,3855 gold badges38 silver badges55 bronze badges

1 Comment

Piyush Over a year ago

not working.is there anything i have to do for <form id="form1" runat="server"> like get or set method????

user1509 · Accepted Answer · 2012-07-12 06:55:29Z

0

try this:

public StringBuilder regression = new StringBuilder();
regression.Append((Session["Regression"]).ToString());

Then in the .aspx page (in the selct command), you can use "regression" as:

 <% =regression %>

answered Jul 12, 2012 at 6:55

user1509

1,1515 gold badges17 silver badges45 bronze badges

3 Comments

Piyush Over a year ago

still not fetching the data from DB bcoz regression value is not coming from aspx.cs page to aspx page

user1509 Over a year ago

check the 3rd post at this link: [link] (forums.asp.net/t/1115044.aspx/1) .. Hope it helps you

user1509 Over a year ago

try the following search in google: "get string variable from code behind to sqldatasource" .. you'll get good results.

Collectives™ on Stack Overflow

how can i access string variable value of .aspx.cs file in .aspx file

4 Answers 4

Comments

6 Comments

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

6 Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related