tag:blogger.com,1999:blog-6159625330036671738.post3241345038931786343..comments2023-08-18T03:30:33.547-07:00Comments on CoolTuts: Cooltuts - General Help - Prompt Build Errors in Microsoft Visual StudioEmmaneale Menduhttp://www.blogger.com/profile/01829923430978159667noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6159625330036671738.post-45544222811874273892012-08-15T13:24:41.565-07:002012-08-15T13:24:41.565-07:00I having a problem about updating the Sql Database...I having a problem about updating the Sql Database through asp.net website. When I build it, it doesn't show any error. But, When I try to update from the website, it shows error on this line... "Cmd.ExecuteNonQuery() " And the error messege is "Incorrect syntex near '('. 'Delivery' is not recognized SAT option. Please help. The code is following...<br /><br />Imports System.Data.SqlClient<br /><br />Partial Class Minnesota<br /><br />Inherits System.Web.UI.Page<br /><br />Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click<br /><br />End Sub<br /><br />Dim con As SqlConnection<br /><br />Dim cmd As SqlCommand<br /><br />Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click<br /><br />con = New SqlConnection("Data Source=STG-PC;Initial Catalog=Card distribution locations;Integrated Security=True")<br /><br />con.Open()<br /><br />cmd = New SqlCommand("UPDATE Minnesota(Hospitals) Set Delivery Report=" + TextBox3.Text + " where Type=" + TextBox2.Text + "", con)<br /><br />cmd.ExecuteNonQuery()<br /><br />Button3.Text = " Successfully Updated"<br /><br />TextBox2.Text =""<br /><br />TextBox3.Text =""<br /><br />con.Close()<br /><br />End Sub<br /><br />End Classamipavelohttps://www.blogger.com/profile/15420916985604328397noreply@blogger.com