Pervasive SQL v12 with Visual Basic .NET

[TGrahmann]

Hello, all. I am fairly new to both Visual Basic .NET and Pervasive SQL. I Was wondering if anyone could give me a rundown on how to conduct a SELECT statement and insert the result (it will be a single result) into a VB.net Variable. Thanks!

 

[mirtheil]

Here are the basic steps:
1. Create (or verify) a PSQL database exists for the data you intend to access.
2. Add a reference to the Pervasive.Data.SqlClient.DLL to your VB.NET project.
3. Use the PsqlConnection to open a connection to the PSQL database.
4. Use PsqlCommand to execute the SQL (SELECT) statement.
5. Read the resultset using a PsqlDataReader and save the value to your variable.

Here's a simple C# app from many years ago that I posted. I'm looking for VB.NET.

using System;
using System.Data;
using Pervasive.Data.SqlClient;
using System.IO;

namespace SimpleADONetTest
{
	class Class1
	{
		[STAThread]
		static void Main(string[] args)
		{
			try
			{
				PsqlConnection conn=new PsqlConnection("ServerDSN=demodata;UID=;PWD=;Server=localhost;");
				conn.Open();
				Console.WriteLine("ServerName: " + conn.ServerName.ToString());
				Console.WriteLine("ServerDSN: " + conn.ServerDSN.ToString());
				// Create a SQL command
				string strSQL = "select * from class";
				PsqlCommand DBCmd = new PsqlCommand(strSQL, conn);
				PsqlDataReader myDataReader;
				myDataReader = DBCmd.ExecuteReader();
				Console.WriteLine("FieldCount: " + myDataReader.FieldCount.ToString());
				while (myDataReader.Read())
				{
					for (int i=0;i<myDataReader.FieldCount;i++)
					{
						Console.WriteLine("Field " + i.ToString() + ": " + myDataReader[i].ToString());
					}
				}
				myDataReader.Close();
				conn.Close();
				Console.WriteLine("Press Enter to continue");
				Console.ReadLine();
			}
			catch (Exception ex)
			{
				Console.WriteLine(ex.Message);
				Console.ReadLine();
			}
			
		}
	}
}

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[mirtheil]

Found an old thread that has a VB.NET Console app that connects to a PSQL database:
[URL unfurl="true"]http://www.tek-tips.com/viewthread.cfm?qid=1346380[/url]

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com