ASP.NET

string query = SELECT * FROM SomeTable WHERE SomeId = @id;
......
yourCommand.Parameters.AddWithValue("@id",someid);

PreparedStatement updateSales = con.prepareStatement(
       "UPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ? ");
updateSales.setInt(1, 75); 
updateSales.setString(2, "Colombian"); 
updateSales.executeUpdate():

SqlCommand cmd = new SqlCommand("UPDATE COFFEES SET SALES = @psales WHERE COF_NAME LIKE @pconfname",connection);
cmd.Parameters.add("@psales",SqlDbType.Int);
cmd.Parameters("@psales").Value = 75;
cmd.parameters.add("@pconfname",SqlDbType.Varchar);
cmd.Parameters.add("@pconfname").Value = "Colombian";
cmd.ExecuteNonQuery();

MarkMokris wrote:

1. Any variables I create global to the page class will be re-initialized with each post-back. Is that correct?

MarkMokris wrote:

2. Does that mean that nothing really persists from post-back to post-back?

MarkMokris wrote:

What about if I set up a SQLDataSource at design time and bind it to a GridView. Is the SQLDataSource reconnecting and rerunning the SQL with every post-back? Even post-backs that do not involve the GrdiView?

Abhijit Jana wrote:

MarkMokris wrote:
What about if I set up a SQLDataSource at design time and bind it to a GridView. Is the SQLDataSource reconnecting and rerunning the SQL with every post-back? Even post-backs that do not involve the GrdiView?
Yes. You have to very much clear about asp.net page lifecycle and PostBack Property.

AlexeiXX3 wrote:

The sql statement wont be executed on every postback, just the first time. On postbacks caused by other controls, the gridview will be regenerated from its view state

<asp:GridView ID="grd" runat="server" DataSourceID="sql_ds_id">
   .....
</asp:GridView>

N a v a n e e t h wrote:

GridView will be regenerated on each postback.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
    DataKeyNames="ID" DataSourceID="SqlDataSource1"
    EmptyDataText="There are no data records to display.">
    <Columns>
        <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True"
            SortExpression="ID" />
        <asp:BoundField DataField="Name" HeaderText="Name"
            SortExpression="Name" />
    </Columns>
</asp:GridView>

MarkMokris wrote:

Any variables I create global to the page class will be re-initialized with each post-back. Is that correct?

MarkMokris wrote:

Does that mean that nothing really persists from post-back to post-back?

MarkMokris wrote:

What about if I set up a SQLDataSource at design time and bind it to a GridView. Is the SQLDataSource reconnecting and rerunning the SQL with every post-back? Even post-backs that do not involve the GrdiView?

katarukoti wrote:

i have 2 textbox controls
assume
TextBox1 is 150
then in
TextBox2 one hundred and fifty
i need to display

suppose
TextBox1 is 19999
then in
TextBox2 Nineteen thousand nine hundred ninety nine
i need to display