how are you updating ?using sqldatasource or sqlcommand
sqlcomm.commandtext ="update Approve_Overtime Set ninka_nen_from = @ninka_nen_from ,ninka_gatsu_from = @ninka_gatsu_from Where syainNo = @syainNo"
will that help you?
regards,
satish.
Marked as answer by yyy8347 on Nov 16, 2006 02:31 AM
Dim MyConn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString3").ConnectionString)
Dim sqlcom As SqlClient.SqlCommand = MyConn.CreateCommand()
MyConn.Open()
sqlcom.CommandType = CommandType.Text
sqlcom.CommandText = "insert into Approve_Overtime(syainNo,ninka_nen_from,ninka_gatsu_from,ninka_hi_from,ninka_nen_to,ninka_gatsu_to,ninka_hi_to,ninka_ji_from,ninka_ji_to,ninka_bun_from,ninka_bun_to)values(@syainNo,@ninka_nen_from,@ninka_gatsu_from,@ninka_hi_from,@ninka_nen_to,@ninka_gatsu_to,@ninka_hi_to,@ninka_ji_from,@ninka_ji_to,@ninka_bun_from,@ninka_bun_to)"
hi satish this is my previous codes but instead of inserting values my officemate said it should not be insert into but "update"
what changes should i chnage for this?
shouyld it be something like this?
Dim MyConn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString3").ConnectionString)
Dim sqlcom As SqlClient.SqlCommand = MyConn.CreateCommand()
MyConn.Open()
sqlcom.CommandType = CommandType.Text
sqlcom.CommandText = "update Approve_Overtime Set ninka_nen_from = @ninka_nen_from ,ninka_gatsu_from = @ninka_gatsu_from Where syainNo = @syainNo"
hello [:)] natasha yea it has been a while...hows work going on,
well natasha yes the code should be like this
sqlcom.CommandText = "update Approve_Overtime Set ninka_nen_from = @ninka_nen_from ,ninka_gatsu_from = @ninka_gatsu_from Where syainNo = @syainNo"
, the thing i assume here is that syainNo is Primary key or in other words just for putting a proper where clause.
"Character-string data or the binary data is rounded down.
The statement was ended. "
why do you think i always encounter this kind of error?
when i press "save button" here is my code...
Button_save.Visible = True
Dim MyConn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ms_project").ConnectionString)
Dim sqlcom As SqlClient.SqlCommand = MyConn.CreateCommand()
i think you are passing improper data like say column permits 10 chars & you might be passing 11 or might be the case that column's datatype is integer & you are passing long or double value.
like for int 1-65000+ something and you are passing 66000 something value.
could you do one thing debug your code take values of each parameter, in query analyzer or whatever your db is try to execute the above update statement with values which you are passing via your code.
one more thing i think, messagebox should appear if your executenonquery was successful.
also check table definition i mean datatype of columns etc.
natasha_arri...
Member
698 Points
343 Posts
update values...
Nov 15, 2006 11:22 PM|LINK
instead of insert into command
sqlcom.CommandText = "insert into Approve_Overtime(syainNo,ninka_nen_from,ninka_gatsu_from)values(@syainNo,@ninka_nen_from,@ninka_gatsu_from)
how can i change it using update command?
thnx
satish_nagde...
Contributor
6572 Points
1432 Posts
Re: update values...
Nov 16, 2006 12:56 AM|LINK
hi,
how are you updating ?using sqldatasource or sqlcommand
sqlcomm.commandtext ="update Approve_Overtime Set ninka_nen_from = @ninka_nen_from ,ninka_gatsu_from = @ninka_gatsu_from Where syainNo = @syainNo"
will that help you?
regards,
satish.
natasha_arri...
Member
698 Points
343 Posts
Re: update values...
Nov 16, 2006 01:05 AM|LINK
Dim MyConn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString3").ConnectionString)
Dim sqlcom As SqlClient.SqlCommand = MyConn.CreateCommand()
MyConn.Open()
sqlcom.CommandType = CommandType.Text
sqlcom.CommandText = "insert into Approve_Overtime(syainNo,ninka_nen_from,ninka_gatsu_from,ninka_hi_from,ninka_nen_to,ninka_gatsu_to,ninka_hi_to,ninka_ji_from,ninka_ji_to,ninka_bun_from,ninka_bun_to)values(@syainNo,@ninka_nen_from,@ninka_gatsu_from,@ninka_hi_from,@ninka_nen_to,@ninka_gatsu_to,@ninka_hi_to,@ninka_ji_from,@ninka_ji_to,@ninka_bun_from,@ninka_bun_to)"
sqlcom.Parameters.AddWithValue("@syainNo", label_id_number.Text)
sqlcom.Parameters.AddWithValue("@ninka_nen_from", dropdwn_aprv_yr_from.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_gatsu_from", dropdwn_aprv_month_from.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_hi_from", dropdwn_aprv_day_from.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_nen_to", dropdwn_aprv_yr_to.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_gatsu_to", dropdwn_aprv_month_to.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_hi_to", dropdwn_aprv_day_to.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_ji_from", textbox_apprv_from_hr.Text)
sqlcom.Parameters.AddWithValue("@ninka_ji_to", textbox_apprv_to_hr.Text)
sqlcom.Parameters.AddWithValue("@ninka_bun_from", textbox_apprv_from_min.Text)
sqlcom.Parameters.AddWithValue("@ninka_bun_to", textbox_apprv_to_min.Text)
sqlcom.ExecuteNonQuery()
MyConn.Close()
sqlcom.Dispose()
MyConn.Dispose()
hi satish this is my previous codes but instead of inserting values my officemate said it should not be insert into but "update"
what changes should i chnage for this?
shouyld it be something like this?
Dim MyConn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString3").ConnectionString)
Dim sqlcom As SqlClient.SqlCommand = MyConn.CreateCommand()
MyConn.Open()
sqlcom.CommandType = CommandType.Text
sqlcom.CommandText = "update Approve_Overtime Set ninka_nen_from = @ninka_nen_from ,ninka_gatsu_from = @ninka_gatsu_from Where syainNo = @syainNo"
what u think?
thanks.. and its been awhile! hello again :-)
satish_nagde...
Contributor
6572 Points
1432 Posts
Re: update values...
Nov 16, 2006 01:10 AM|LINK
hi,
hello [:)] natasha yea it has been a while...hows work going on,
well natasha yes the code should be like this
sqlcom.CommandText = "update Approve_Overtime Set ninka_nen_from = @ninka_nen_from ,ninka_gatsu_from = @ninka_gatsu_from Where syainNo = @syainNo"
, the thing i assume here is that syainNo is Primary key or in other words just for putting a proper where clause.
regards,
satish.
natasha_arri...
Member
698 Points
343 Posts
Re: update values...
Nov 16, 2006 01:21 AM|LINK
yeah im trying it now!hope it works....
my work?yeah doing ok....but im recoding my modules because we changed the database design! i mean everythinG!hahahaha
if i encounter errors again ill message you ok?:-)
____
natasha
satish_nagde...
Contributor
6572 Points
1432 Posts
Re: update values...
Nov 16, 2006 01:32 AM|LINK
ok no problems will help you to my level best.
regards,
satish.
natasha_arri...
Member
698 Points
343 Posts
Re: update values...
Nov 16, 2006 02:18 AM|LINK
yehey i got it working already!thank you thank you thank you!!!!hehehehe!
later ill message u again ok? mybe ill still be needing ur help!hahahaha!
thanks alot!:-)
satish_nagde...
Contributor
6572 Points
1432 Posts
Re: update values...
Nov 16, 2006 02:35 AM|LINK
okie no worries [:)].
regards,
satish.
natasha_arri...
Member
698 Points
343 Posts
Re: update values...
Nov 16, 2006 02:58 AM|LINK
"Character-string data or the binary data is rounded down.
The statement was ended. "
why do you think i always encounter this kind of error?
when i press "save button" here is my code...
Button_save.Visible = True
Dim MyConn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ms_project").ConnectionString)
Dim sqlcom As SqlClient.SqlCommand = MyConn.CreateCommand()
MyConn.Open()
sqlcom.CommandType = CommandType.Text
sqlcom.CommandText = "update 残業申請テーブル Set ninka_nen_from = @ninka_nen_from ,ninka_gatsu_from = @ninka_gatsu_from, ninka_hi_from = @ninka_hi_from ,ninka_nen_to = @ninka_nen_to, ninka_gatsu_to = @ninka_gatsu_to, ninka_hi_to = @ninka_hi_to, ninka_ji_from = @ninka_ji_from,ninka_ji_to = @ninka_ji_to,ninka_bun_from = @ninka_bun_from,ninka_bun_to = @ninka_bun_to,ninka_day_name_from = @ninka_day_name_from,ninka_day_name_to= @ninka_day_name_to where syain_no = " + Request.QueryString("syain_no")
sqlcom.Parameters.AddWithValue("@ninka_nen_from", dropdwn_aprv_yr_from.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_gatsu_from", dropdwn_aprv_month_from.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_hi_from", dropdwn_aprv_day_from.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_nen_to", dropdwn_aprv_yr_to.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_gatsu_to", dropdwn_aprv_month_to.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_hi_to", dropdwn_aprv_day_to.SelectedValue)
sqlcom.Parameters.AddWithValue("@ninka_ji_from", textbox_apprv_from_hr.Text)
sqlcom.Parameters.AddWithValue("@ninka_ji_to", textbox_apprv_to_hr.Text)
sqlcom.Parameters.AddWithValue("@ninka_bun_from", textbox_apprv_from_min.Text)
sqlcom.Parameters.AddWithValue("@ninka_bun_to", textbox_apprv_to_min.Text)
sqlcom.Parameters.AddWithValue("@ninka_day_name_from", dropdwn_aprv_daywk_from.Text)
sqlcom.Parameters.AddWithValue("@ninka_day_name_to", dropdwn_aprv_daywk_to.Text)
Label28.Visible = True
textbox_approval_date.Visible = True
textbox_approval_date.Text = Date.Today
statusbox_approve_mesg.Visible = True
MsgBox(" Application Dates was Successfully Edited and Approved")
sqlcom.ExecuteNonQuery()
MyConn.Close()
sqlcom.Dispose()
MyConn.Dispose()
but error!
what do you think?
satish_nagde...
Contributor
6572 Points
1432 Posts
Re: update values...
Nov 16, 2006 03:31 AM|LINK
i think you are passing improper data like say column permits 10 chars & you might be passing 11 or might be the case that column's datatype is integer & you are passing long or double value.
like for int 1-65000+ something and you are passing 66000 something value.
could you do one thing debug your code take values of each parameter, in query analyzer or whatever your db is try to execute the above update statement with values which you are passing via your code.
one more thing i think, messagebox should appear if your executenonquery was successful.
also check table definition i mean datatype of columns etc.
regards,
satish.