Updating the Database from a Webform

[billy_mathis]

Hi, I am trying to update my database from a WebForm. I
am not getting an error but the update routine isn't
working. Do you have any ideas.
In properties, my sqlcommand.commandtext =UPDATE
t_loan_info SET l_tpr = @l_tpr, l_loanAmt = @l_loanAmt
where l_accessnum='12075'
My <Click Event> is pasted below.

Button Click event>

With SqlCommand1

'.Parameters("@l_accessnum").Value =
DropDownList1.SelectedItem.Text
'.Parameters("@num").Value = TextBox2.Text
.Parameters("@l_tpr").Value = TextBox10.Text
.Parameters("@l_loanamt").Value =
TextBox3.Text
End With

SqlConnection1.Open()
SqlCommand1.ExecuteNonQuery()
SqlConnection1.Close()
TextBox3.DataBind()
TextBox10.DataBind()

Page.DataBind()

I'd appreciate any assistance.

Thank you,
Bill

[Cor]

Hi Billy,

I dont know if I or someone here can help you, so take a change in the
newsgroup
microsoft.public.dotned.framework.adonet, it is filled will all of this kind
of questions.

But maybe I can give it a try, but therefore I think I need the code, that
you are using to fill the webpage with the data, because I think you are
mixing things up.

Cor

Hi, I am trying to update my database from a WebForm. I
am not getting an error but the update routine isn't
working. Do you have any ideas.
In properties, my sqlcommand.commandtext =UPDATE
t_loan_info SET l_tpr = @l_tpr, l_loanAmt = @l_loanAmt
where l_accessnum='12075'
My <Click Event> is pasted below.

Button Click event>
With SqlCommand1
'.Parameters("@l_accessnum").Value =
DropDownList1.SelectedItem.Text
'.Parameters("@num").Value = TextBox2.Text
.Parameters("@l_tpr").Value = TextBox10.Text
.Parameters("@l_loanamt").Value =
TextBox3.Text
End With
SqlConnection1.Open()
SqlCommand1.ExecuteNonQuery()
SqlConnection1.Close()
TextBox3.DataBind()
TextBox10.DataBind()
Page.DataBind()