ASP.NET and Data base

Question

Why vacancy field is not filling?

Satyapriya Nayak · Answer

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(DesignationService_of_DescriptionGradeSalary_CodeCarderPresentVacancies) 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