i have a web in asp.net+vb code and sql database
Protected Sub movebtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles movebtn.Click
Dim con As New SqlConnection
con.ConnectionString = ConfigurationManager.ConnectionStrings("26ConnectionString").ConnectionString
con.Open()
If persno.Text = "" Then
Page.ClientScript.RegisterStartupScript(Me.GetType, "Forms", "<script> alert('Enter Pers No of Offr ..........') </script>")
persno.Focus()
Exit Sub
End If
Dim sql_ins, sql_del As String
sql_ins = "insert into NE_offrs select * from col_data where pnumb='" + notxt.Text + "'"
sql_del = "delete col_data where pnumb='" + notxt.Text + "'"
Dim sqlcom As New SqlCommand(sql_ins, con)
Dim sqlcom1 As New SqlCommand(sql_del, con)
sqlcom.ExecuteNonQuery()
sqlcom1.ExecuteNonQuery()
Page.ClientScript.RegisterStartupScript(Me.GetType, "Forms", "<script> alert('Record Moved to Promoted/Retired Table Successfully........')</script>")
End Sub