public DataView Transaction_Get_Single(Iinterface Entity)
{
ObjCmd = Entity.Get_Single();
//ObjCmd.Connection = Conn;
ObjCmd.Connection = DbTrans.Connection;
ObjCmd.Transaction = DbTrans;
// Dataadapter
MySqlDataAdapter da = new MySqlDataAdapter(ObjCmd);
// fill dataset
DataSet DS = new DataSet();
da.Fill(DS);
// Create the DataView Object
DataView DV = new DataView(DS.Tables[0]);
return(DV);
}
// public DataView Transaction_Get_All(Iinterface Entity)
// {
// ObjCmd = Entity.Get_All();
// ObjCmd.Transaction = DbTrans;
// ObjCmd.Connection = Conn;
//
// // Dataadapter
// OdbcDataAdapter da = new OdbcDataAdapter(ObjCmd);
// // fill dataset
// DataSet DS = new DataSet();
// da.Fill(DS);
//
// // Create the DataView Object
// DataView DV = new DataView(DS.Tables[0]);
//
// return DV;
// }
public DataView DataTrigger_Get_Single(Iinterface Entity)
{
// Get Database connection
Conn = Objconn.Odbc_SQL_Connection;
ObjCmd = Entity.Get_Single();
ObjCmd.Connection = Conn;
// Dataadapter
MySqlDataAdapter da = new MySqlDataAdapter(ObjCmd);
// fill dataset
DataSet DS = new DataSet();
da.Fill(DS);
ObjCmd.Connection.Close();
ObjCmd.Connection.Dispose();
ObjCmd.Connection = null;
// Create the DataView Object
DataView DV = new DataView(DS.Tables[0]);
return(DV);
}
