ASP.NET

UpdateParameters

Please support our ASP.NET advertiser: $6.99 Domain Names at 1&1. Includes Free Privacy. Save Now!

•

Join Date: Jul 2008

Posts: 46

Reputation: robertmacedonia is an unknown quantity at this point

Solved Threads: 0

robertmacedonia robertmacedonia is offline

Offline

Light Poster

UpdateParameters

May 9th, 2009

Hi, I have this little application in ASP.NET, written in C#, it's about keeping simple information about clients, so I have the user enter info, and then, another page when he or she can update the information, particularly the address. So I have a textbox where the new information is entered, and the this button, and this is the code in the button - click event.

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
    protected void PromeniButton_Click(object sender, EventArgs e)
    {
        SqlDataSource1.UpdateParameters["Adresa"].DefaultValue = NovaAdresaTextBox.Text;
        SqlDataSource1.Update();
 
        Response.Redirect("~/Meni.aspx");
    }
    protected void PromeniButton_Click(object sender, EventArgs e)
    {
        SqlDataSource1.UpdateParameters["Adresa"].DefaultValue = NovaAdresaTextBox.Text;
        SqlDataSource1.Update();

        Response.Redirect("~/Meni.aspx");
    }

And yet, when this is done, nothing is changed in the database, the address is still the same. I do not know what the problem might be, so would you please help me. Regards.

•

Join Date: Feb 2009

Posts: 3,793

Reputation: sknake has much to be proud of

Solved Threads: 698

sknake

Offline

.NET Enthusiast

Re: UpdateParameters

May 11th, 2009

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
SqlDataSource1.UpdateParameters["Adresa"].DefaultValue = NovaAdresaTextBox.Text;
SqlDataSource1.UpdateParameters["Adresa"].DefaultValue = NovaAdresaTextBox.Text;

That code is setting the default value used in the update queries' parameters. SqlDataSource should expose a View for the table in question. I don't use SqlDataSource but look around, you should be able to:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
SqlDataSource["TableName"][rowIndex].Field = value;
SqlDataSource["TableName"].Save();
SqlDataSource["TableName"][rowIndex].Field = value;
SqlDataSource["TableName"].Save();