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); }