User-388731848 posted
I have a Access database. I wantto connect it and fill dataset with dataadapter. However i throws an exception that says "System.InvalidOperationException was caught" And in detail it says that "When connection assigned to the command is
in a local operation, ExecuteReader, requires that command must have a operation. Command's transaction is not started."
Here is my code:
string CmdText = "SELECT Kimlik, UNVANKODU, UNVANSIRA, IKINCIGOREV, IGONAYTARSAY, AKUNVAN, ADI, SOYADI, KIZSOYADI, SICIL, KADROKURUM, KADKURKOD, GECICIGOREV, GECICIGOREVKODU,
ONAYMAKTARSAY, AYRILTAR, MEMURBASLAYIS, KURUMBASTAR, TCNO, ESNO, MEDENIHALI, CINSIYETI, DOGUMYERI, DOGUMTARIHI, BABAADI, ANNEADI, KANGURUBU, KROSOSHASTA, OGDURUMU, EVTEL, CEPTEL, EVADRESI, GELDIGIKURUM, GECGORYER, PARTTIMELISTESI, PARTTIMEYERI, KURSEGITIM,
EMAIL, SENDIKA, Alan39 FROM CALISANLAR " +
"WHERE (ADI LIKE '*" + fADI +
"*') AND (SOYADI LIKE '*" + fSOYADI +
"*')";
Baglanti =
new
Baglan();
try
{
Baglanti.Ac();
DataTable dt=
new DataTable();
OleDbDataAdapter da =
new OleDbDataAdapter(CmdText, Baglanti.Connection);
da.Fill(dt);
return "başarılı";
fSONUC = dt;
}
catch
{
return "başarısız";
}
finally
{
Baglanti.Kapat();
}
And here is what i have there in Baglanti class;
public
class
Baglan
{
private bool fActive;
private OleDbConnection fConnection;
private OleDbTransaction fTransaction;public Baglan()
{
//
// TODO: Add constructor logic here
//
}
public void Ac()
{
if (fActive)
throw new
Exception("Connection is already open");
fConnection = new
OleDbConnection();
fConnection.ConnectionString =
@"Provider=Microsoft.Jet.OLEDB.4.0; Data source= ... \Veri_1.mdb";
try
{
fConnection.Open();
fTransaction = fConnection.BeginTransaction();
fActive = true;
}
catch
{
fActive = false;
}
finally
{
}
}
public void Kapat()
{
if (!fActive)
throw new
Exception("Connection is already closed");
fActive = false;
fTransaction.Dispose();
fConnection.Close();
fConnection.Dispose();
fConnection = null;GC.Collect();
}
public OleDbConnection Connection
{
get
{
return fConnection;
}
}
public OleDbTransaction Transaction
{
get
{
return fTransaction;
}
}
public bool Active
{
get
{
return fActive;
}
set
{
if (value != fActive)if (value)
Ac();
else
Kapat();
}
}
}
