Connectivity in VB.NET & ASP.NET

Imports System.Data.OleDb
Imports System.Data
Public Class Form1
Dim CON As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\db5.mdb")//Database Path
Dim DA As New OleDbDataAdapter
Dim DS As New DataSet, I As Integer = 0, J As Integer = 0
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
CON.Open()
DA.InsertCommand = New OleDbCommand
DA.InsertCommand.CommandText = "INSERT INTO Table1 VALUES('" & Val(TextBox1.Text) & "','" & TextBox2.Text & "')"
DA.InsertCommand.CommandType = CommandType.Text
DA.InsertCommand.Connection = CON
DA.InsertCommand.ExecuteNonQuery().ToString()
End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
DA.SelectCommand = New OleDbCommand
DA.SelectCommand.CommandText = "SELECT * FROM Table1 WHERE ID=3"
DA.SelectCommand.CommandType = CommandType.Text
DA.SelectCommand.Connection = CON
DA.Fill(DS)
TextBox1.Text = ""
TextBox2.Text = ""

TextBox1.Text = DS.Tables(0).Rows(0).Item(0).ToString
TextBox2.Text = DS.Tables(0).Rows(0).Item(1).ToString
End Sub


Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
I = CInt(TextBox3.Text)
DA.SelectCommand = New OleDbCommand
DA.SelectCommand.CommandText = "SELECT Table1.NAME FROM Table1 WHERE Table1.ID='" & TextBox3.Text & "'"
DA.SelectCommand.CommandType = CommandType.Text
DA.SelectCommand.Connection = CON
DA.Fill(DS)
TextBox1.Text = ""
TextBox2.Text = ""
DATAGRIVIEW1()
'TextBox1.Text = DS.Tables(0).Rows(J).Item(0).Equals(I)
TextBox2.Text = DS.Tables(0).Rows(0).Item(1).ToString

End Sub

End Class

Comments

Post a Comment

Popular posts from this blog

Edit/Modify existing PDF using Java(iText)

import java.io.FileOutputStream; import java.io.IOException; import com.itextpdf.text.DocumentException; import com.itextpdf.text.pdf.BaseFont; import com.itextpdf.text.pdf.PdfContentByte; import com.itextpdf.text.pdf.PdfReader; import com.itextpdf.text.pdf.PdfStamper; public class EditExistingPDF { public static void main(String[] args) throws IOException, DocumentException { PdfReader reader = new PdfReader("C:\\signed.pdf"); // input PDF PdfStamper stamper = new PdfStamper(reader,new FileOutputStream( "C:\\test.pdf")); // output PDF BaseFont bf = BaseFont.createFont(BaseFont.HELVETICA, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); // set font // loop on pages (1-based) for (int i = 1; i // get object for writing over the existing content; // you can also use getUnderContent for writing in the bottom // layer PdfContentByte over = stamper.getOverContent(i); // write text over.beginText(); over.setFontAndSize(bf, 10); // set font and size over....
Read more

Verify Digital Signature in PDF using Java(iText) and cacerts

Jars Files: itext-2.1.7.jar itextpdf-5.4.2.jar bcprov-ext-jdk14-1.47.jar bcprov-1.39.jar ---------------------------------------------------------------- import java.io.FileNotFoundException; import java.io.IOException; import java.security.KeyStore; import java.security.KeyStoreException; import java.security.NoSuchAlgorithmException; import java.security.SignatureException; import java.security.cert.CertificateException; import java.util.ArrayList; import java.util.Calendar; import java.util.Enumeration; import com.lowagie.text.pdf.AcroFields; import com.lowagie.text.pdf.PdfPKCS7; import com.lowagie.text.pdf.PdfReader; public class VerifySignature { public static void main(String[] args) throws KeyStoreException, NoSuchAlgorithmException, CertificateException, FileNotFoundException, IOException, SignatureException { //loads all the keystore imported in cacerts. To load your certificate from cacerts, first it needs to be imported using k...
Read more

Steps to create SOAP Web service using Eclipse

Image
Step 1 : Go to File -> New -> Dynamic Web Project Step 2 : Enter Project name as “SOAPWebSErvice” as created in below screenshot. Step 3 : Create below packages under src folder: a. com.test.controller b. com.test.model Step 4 : Add Employee.java under package - com.test.model Add EmployeeController.java under package - com.test.controller. Employee.java package com.test.model; public class Employee { private String id; private String name; public String getId() { return id; } public String getName() { return name; } public void setId(String id) { this.id = id; } public void setName(String name) { this.name = name; } } ------------------------------------------------------------------------------------------------------------------ EmployeeController.java package com.test.controller; import com.test.model.Employee; public class EmployeeController { public Employee employee; public Employee setEmployee(...
Read more