Here microsoft visual studio Options may be changed.
Follow the steps to make it work fine.
1) Go to "Tools" option on the top of the visual studio as shown below figure1.
2) Select "Options" in the Tools menu.
3) Options Popup Box you see Tree View Items, Expand Projects and Solutions.
4) Select Build and Run Option.
5) After selecting you see couple of dropDowns on the right side section.
6) Where you see "On Run, when build or deployment errors occur:" select "Prompt to Launch" in the below DropDown.
7) Click "OK"... Thats it you are ready to Go.
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...
ReplyDeleteImports System.Data.SqlClient
Partial Class Minnesota
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
End Sub
Dim con As SqlConnection
Dim cmd As SqlCommand
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
con = New SqlConnection("Data Source=STG-PC;Initial Catalog=Card distribution locations;Integrated Security=True")
con.Open()
cmd = New SqlCommand("UPDATE Minnesota(Hospitals) Set Delivery Report=" + TextBox3.Text + " where Type=" + TextBox2.Text + "", con)
cmd.ExecuteNonQuery()
Button3.Text = " Successfully Updated"
TextBox2.Text =""
TextBox3.Text =""
con.Close()
End Sub
End Class