ASP.NET

Dim connstr As String = String.Empty<br />
    Dim notes As String = String.Empty<br />
    Dim oldbconn As New OdbcConnection(ConfigurationManager.ConnectionStrings("DBConnectionString").ToString())<br />
    Protected Sub SubmitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubmitButton.Click<br />
        If Job_Notes.Text = "" Then<br />
            notes = "No notes"<br />
        Else<br />
            notes = Job_Notes.Text<br />
        End If<br />
        Dim oldbcmd As New OdbcCommand()<br />
        connstr = "insert into JOB_HR_Details(Job_Type,Job_Title,Job_Description,Location_ID,Qualification,Years_of_Experience,Competencies_Desired,"<br />
        connstr += "Competencies_Technical,Email_ID,Notes,Status) values('" & Job_Type_DDL.SelectedValue & "','" & Job_Title_TXT.Text & "','"<br />
        connstr += JOB_Description.Text & "'," & Location_DDL.SelectedValue & ",'" & Qualification.Text & "'," & Experience_DDL.SelectedValue & ",'" & Des_Comp.Text & "','"<br />
        connstr += Tech_Comp.Text & "','" & Emp_Email_ID.Text & "','" & notes & "','0');"<br />
        oldbcmd.CommandText = connstr<br />
        oldbcmd.Connection = oldbconn<br />
        oldbconn.Open()<br />
        oldbcmd.ExecuteNonQuery()<br />
        oldbconn.Close()