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

Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.