Forum guidelines
AuthorQuestion
ASP.NET and Data base
Posted By jayani chathurika on 10 Apr 2013
source code.rar Why vacancy field is not filling?
AuthorReply
Re: ASP.NET and Data base
Posted By Satyapriya Nayak on 10 Apr 2013  
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

If this post helps you mark it as answer
Thanks

Infragistics jQuery Controls

SPONSORED BY

JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.