public DataSet TransferRecord() { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection("local"); dbconn.DatabaseConn("FileNotesIntegrateData"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@AccountID", bll.AccountID); dbconn.sqlComm.Parameters.AddWithValue("@AccountName", bll.AccountName); dbconn.sqlComm.Parameters.AddWithValue("@Action", bll.Action); dbconn.sqlComm.Parameters.AddWithValue("@ExternalClubID", bll.ClubID); dbconn.sqlComm.Parameters.AddWithValue("@FileNotesID", bll.FileNotesID); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dtResult); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } }
public DataSet GetRecord() { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection("local"); dbconn.DatabaseConn("FileNotesGetAll"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dtResult); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } }