ASP.NET and Data base

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
        con.Open()
        txtvacancies.Text = Val(txtcarder.Text - txtpresent.Text)
        str = "INSERT INTO Carder_of_Ministry(Designation,Service_of_Description,Grade,Salary_Code,Carder,Present,Vacancies) VALUES('" + ddldesignation.Text + "','" + ddlinvolveservice.Text + "','" + ddlgrade.Text + "','" + ddlsalarycode.Text + "','" + txtcarder.Text + "','" + txtpresent.Text + "','" + txtvacancies.Text + "' )"
        com = New SqlCommand(str, con)
        com.ExecuteNonQuery()
        con.Close()
    End Sub

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak13y ago
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
        con.Open()
        txtvacancies.Text = Val(txtcarder.Text - txtpresent.Text)
        str = "INSERT INTO Carder_of_Ministry(Designation,Service_of_Description,Grade,Salary_Code,Carder,Present,Vacancies) VALUES('" + ddldesignation.Text + "','" + ddlinvolveservice.Text + "','" + ddlgrade.Text + "','" + ddlsalarycode.Text + "','" + txtcarder.Text + "','" + txtpresent.Text + "','" + txtvacancies.Text + "' )"
        com = New SqlCommand(str, con)
        com.ExecuteNonQuery()
        con.Close()
    End Sub