using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace DataReader
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
string strConn="Provider=SQLOLEDB;User ID=sa;Password=gatsol;Initial Catalog=vins;Data Source=211.236.186.207;";
OleDbConnection Cn = new OleDbConnection(strConn);
Cn.Open();
string StrSQL1 = " Select Count(*) From FormType ";
string StrSQL2 = " Select FormTypeName From FormType Where FormTypeID=9 ";
OleDbCommand Cmd = Cn.CreateCommand();
Cmd.CommandText = StrSQL1;
int intCustomers1 = Convert.ToInt32(Cmd.ExecuteScalar());
Console.WriteLine("IntCustomers1 = " + intCustomers1);
Cmd.CommandText = StrSQL2;
string intCustomers2 = Convert.ToString(Cmd.ExecuteScalar());
Console.WriteLine("IntCustomers2 = " + intCustomers2);
}
}
}
