my code here gives me an error "invalid sql statement expected insert, delete or update" and if i start the query with select it gives me an "ierrorinfo.getdescription failed with E_Fail(0x80004005)" error. please sir's and ma's i need an urgent help to this problem. thanks for your help
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.ComponentModel;
using System.Threading;
namespace DiaryApps
{
static class Program
{
///
/// The main entry point for the application.
///
[STAThread]
static void Main()
{
bool InstanceCountOne = false;
using (Mutex mtex = new Mutex(true, "DiaryApps", out InstanceCountOne))
{
if (InstanceCountOne)
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new RegistrationForm());
// what am trying to do here is load the registration page once and to load the Login page for other subsequent logins
OleDbConnection newConnection;
OleDbCommand cmd = new OleDbCommand();
string Connection = @" provider=Microsoft.Jet.OLEDB.4.0; data source='Diarydatabase.mdb'; Jet OLEDB:Database Password= segunsco";
newConnection = new OleDbConnection(Connection);
cmd.Connection = newConnection;
newConnection.Open();
try
{
cmd.CommandText = "if exist(select [Flag] from [createdDetails]) begin select '1' end else begin select '0' end";
OleDbDataReader MotReader = cmd.ExecuteReader();
if (MotReader.HasRows == true)
{
while (MotReader.Read())
{
string ty = MotReader.GetString(0);
if (ty == "0")
{
Application.Run(new RegistrationForm());
}
else if (ty == "1")
{
Application.Run(new Login());
}
}
}
newConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("An instance of the application is already running");
}
}
}
}
}
Sunny SharmaPosted Jun 23, 2013, 9:01 AM
try replacing the try...catch block with below one:
-----------------------------------------------------------
newConnection.Open();
try
{
cmd.CommandText = "select [Flag] from [createdDetails]";
OleDbDataReader MotReader = cmd.ExecuteReader();
if (MotReader.HasRows == true)
{
while (MotReader.Read())
{
string ty = MotReader.GetString(0);
if (ty == "0")
{
Application.Run(new RegistrationForm());
}
else if (ty == "1")
{
Application.Run(new Login());
}
}
}
newConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
-------------------------------------------------------------------
Mark it as answer if it helps.
Cheers!