help with rowcommand...please....

Hello. I have this code that updates my database. My problem is that it updates every row in the database. What I want to do is update only the selected rows.

What should be done so that only selected rows will be updated. Thanks in advance!

**************************************************************************************************************************************************************************************

If e.CommandName = "Select" Then

Dim index As Integer = Convert.ToInt32(e.CommandArgument)

Dim cnn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("StrConn").ConnectionString)


Dim strSQL2 As New SqlCommand("UPDATE TE_zangyou SET ninka_nen_from=apply_nen_from, ninka_gatsu_from=apply_gatsu_from, ninka_hi_from=apply_hi_from, ninka_day_name_from=apply_day_name_from, ninka_ji_from=apply_ji_from,ninka_bun_from=apply_bun_from,ninka_nen_to=apply_nen_to, ninka_gatsu_to=apply_gatsu_to, ninka_hi_to=apply_hi_to, ninka_day_name_to=apply_day_name_to, ninka_ji_to=apply_ji_to,ninka_bun_to=apply_bun_to", cnn)

cnn.Open()




strSQL2.ExecuteNonQuery()

cnn.Close()
End If

**************************************************************************************************************************************************************************************

hi audrey,

you've not specified where clause in update query.

thanks,

satish.

|||

I tried this, it does not update.

Dim strSQL2 As New SqlCommand("UPDATE TE_zangyou SET ninka_nen_from=apply_nen_from, ninka_gatsu_from=apply_gatsu_from, ninka_hi_from=apply_hi_from, ninka_day_name_from=apply_day_name_from, ninka_ji_from=apply_ji_from,ninka_bun_from=apply_bun_from,ninka_nen_to=apply_nen_to, ninka_gatsu_to=apply_gatsu_to, ninka_hi_to=apply_hi_to, ninka_day_name_to=apply_day_name_to, ninka_ji_to=apply_ji_to,ninka_bun_to=apply_bun_toWHERE id=' '", cnn)

id is the primary key.

|||

I also tried this...

But there is an error,Must declare the scalar variable "@.syain_No".

Dim strSQL2 As New SqlCommand("UPDATE TE_zangyou SET ninka_nen_from=apply_nen_from, ninka_gatsu_from=apply_gatsu_from, ninka_hi_from=apply_hi_from, ninka_day_name_from=apply_day_name_from, ninka_ji_from=apply_ji_from,ninka_bun_from=apply_bun_from,ninka_nen_to=apply_nen_to, ninka_gatsu_to=apply_gatsu_to, ninka_hi_to=apply_hi_to, ninka_day_name_to=apply_day_name_to, ninka_ji_to=apply_ji_to,ninka_bun_to=apply_bun_toWHERE [syain_No] = @.syain_No", cnn)

|||

are you passing value parameter to update command like following

strSQL2.parameter.addwithvalue("@.syain_no", value); //value is value you need to pass like in grid_selectindexchanged event it should be value of current row's syain_no.

thanks,

satish.

|||

I'm not using -> strSQL2.parameter.addwithvalue("@.syain_no", value).

Im just updating a column from another column.

In my gridview, if button_1 is clicked, values should be updated. Im using rowcommand.

|||

you are updating record using following as per your earlier post

Dim strSQL2 As New SqlCommand("UPDATE TE_zangyou SET ninka_nen_from=apply_nen_from, ninka_gatsu_from=apply_gatsu_from, ninka_hi_from=apply_hi_from, ninka_day_name_from=apply_day_name_from, ninka_ji_from=apply_ji_from,ninka_bun_from=apply_bun_from,ninka_nen_to=apply_nen_to, ninka_gatsu_to=apply_gatsu_to, ninka_hi_to=apply_hi_to, ninka_day_name_to=apply_day_name_to, ninka_ji_to=apply_ji_to,ninka_bun_to=apply_bun_toWHERE [syain_No] =@.syain_No", cnn)

so you need to pass @.syain_no & its value as a parameter which is what i referring in my earlier post

strsql2.parameter.addwithvalue("@.syain_no", value) //value is value of gridview's cell in current row

hope you getting

thanks,

satish.

|||

Ok. I get it now. I'll let you know if I'll let it run...

Thanks so much.

|||

no problems. do let me know.

thanks,

satish.

|||

Here's the code. There is no error, but it does not update. What seems to be wrong?

If e.CommandName = "Select" Then



Dim cnn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("StrConn").ConnectionString)

cnn.Open()
Dim strSQL2 As New SqlCommand("UPDATE TE_zangyou SET ninka_nen_from=apply_nen_from WHERE syain_No = @.syain_No", cnn)

strSQL2.Parameters.AddWithValue("@.syain_No", "syain_No")
strSQL2.Parameters.AddWithValue("@.apply_nen_from", "ninka_nen_from")

strSQL2.ExecuteNonQuery()
strSQL2.Parameters.Clear()

cnn.Close()
End If

|||

wait!!! it worked...

Thanks so much...

I added some codes...

Thanks...

|||

hi audrey

is syain_no character field, if yes use

Dim strSQL2 As New SqlCommand("UPDATE TE_zangyou SET ninka_nen_from=@.apply_nen_from WHERE syain_No = @.syain_No", cnn) //a little mistake
strSQL2.Parameters.AddWithValue("@.syain_No", "'" + syain_no + "'" ) //i assume syain_no is variable that contains value, which is mistake i think in your code & i've included in single quotes check properly please.

strSQL2.Parameters.AddWithValue("@.apply_nen_from", "'" + ninka_nen_from + "'") //same is case here.

hope it helps.

regards,

satish

|||ok. Thanks so much.|||

no worries.

cheers,

satish.