How to edit Sql query in aspx.file using asp.net

Question

Below is my query which i want to edit in aspx file

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
     ConnectionString="<%$ ConnectionStrings:ConnectionString %>
     "InsertCommand="INSERT INTO [Sales] ([ReceiptID], [EmployeeID], [Discount], [Date])
      VALUES (@ReceiptID, @EmployeeID, @Discount, @Date)">

I want to replace the @EmployeeID with a global variable value.
How can i do that. This global variable is saved in a class which I can access by global_var_session.GID.

Are you saying that the name of your field is not actually [EmployeeID] but is actually the value stored in global_var_session.GID? — Aaron Palmer
– Aaron Palmer, Commented Dec 10, 2013 at 12:55
sorry see the edited question i want to replace that @employeeid with a global value. — user1056466
– user1056466, Commented Dec 10, 2013 at 13:00

Aaron Palmer · Accepted Answer · 2013-12-10 13:07:16Z

1

You can use InsertParameters:

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
 ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
 InsertCommand="INSERT INTO [Sales] ([ReceiptID], [EmployeeID], [Discount], [Date])
 VALUES (@ReceiptID, @Gid, @Discount, @Date)">

    <InsertParameters>
        <asp:Parameter Name="Gid" Type="String" />
        ...define other parameters...
    </InsertParameters>
</asp:SqlDataSource>

And in code-behind use

SqlDataSource2.InsertParameters["Gid"].DefaultValue = global_var_session.GID;
...set other parameter values...

edited Dec 10, 2013 at 13:07

answered Dec 10, 2013 at 13:01

Aaron Palmer

9,0309 gold badges52 silver badges78 bronze badges

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

Comments

FeliceM · Accepted Answer · 2013-12-10 13:06:34Z

0

I would remove the InsertCommand from the aspx and move it to the cs. Then in the .cs under the appropriate event handler:

SqlDatasource2.InsertCommand= "your query string with the reference to your Global Variable"

edited Dec 10, 2013 at 13:06

answered Dec 10, 2013 at 12:56

FeliceM

4,21911 gold badges53 silver badges77 bronze badges

Collectives™ on Stack Overflow

How to edit Sql query in aspx.file using asp.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related