public DataTable GetBorrowedBookISBNPerBorrower(eVariable.FIND_TYPE oFilter, string sBookID, string sBorrowerID) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; string sQuery = string.Empty; switch (oFilter) { case eVariable.FIND_TYPE.BOOK_ID: sQuery = "SELECT BOOK_ID, BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE BOOK_ID = '" + sBookID + "' AND [STATUS] = 'BORROWED'"; break; case eVariable.FIND_TYPE.BORROWER_ID: sQuery = "SELECT BOOK_ID,BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE BOOK_ID = '" + sBookID + "' AND BORROWER_ID = '" + sBorrowerID + "' AND [STATUS] = 'BORROWED' "; break; default: sQuery = "SELECT BOOK_ID, BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE [STATUS] = 'BORROWED' "; break; } ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables.Count > 0 ? ds.Tables[0] : null); } catch (Exception ex) { throw ex; } }
public void UpdateBorrower(Model.Borrower oData) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "SP_UPDATE_BORROWER"; ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oData.PERSON_ID); ddq.AddParamer("@FIRST_NAME", SqlDbType.VarChar, oData.FIRST_NAME); ddq.AddParamer("@MIDDLE_NAME", SqlDbType.VarChar, oData.MIDDLE_NAME); ddq.AddParamer("@LAST_NAME", SqlDbType.VarChar, oData.LAST_NAME); ddq.AddParamer("@DOB", SqlDbType.VarChar, oData.DOB); ddq.AddParamer("@AGE", SqlDbType.VarChar, oData.AGE); ddq.AddParamer("@CONTACT_NO", SqlDbType.VarChar, oData.CONTACT_NO); ddq.AddParamer("@ADDRESS", SqlDbType.VarChar, oData.ADDRESS); ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oData.MODIFIED_DATE); ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oData.MODIFIED_BY); ddq.AddParamer("@STATUS", SqlDbType.VarChar, oData.STATUS); ddq.AddParamer("@PROFILE_PIC", SqlDbType.VarChar, oData.PROFILE_PIC); ddq.ExecuteNonQuery(CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } }
public DataTable GetBookISBN(eVariable.FIND_TYPE o_FindType, string sFindText) { try { string sQuery = string.Empty; osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; switch (o_FindType) { case eVariable.FIND_TYPE.BOOK_ID: sQuery = "SELECT ID, BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS WHERE ID = '" + sFindText + "'"; break; case eVariable.FIND_TYPE.BOOK_NO: sQuery = "SELECT ID, BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS WHERE BOOK_NO = '" + sFindText + "'"; break; default: sQuery = "SELECT ID,BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS"; break; } ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables.Count > 0 ? ds.Tables[0] : null); } catch (Exception ex) { throw ex; } }
public DataTable getCandidatePosition(string sType, string sValue) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; string sQuery = String.Empty; switch (sType) { case "ID": sQuery = "Select * from tbl_Position where ID LIKE '%" + sValue + "%' and status = 'ACTIVE'"; break; case "POSITION": sQuery = "Select * from tbl_Position where Position LIKE '%" + sValue + "5' and status = 'ACTIVE'"; break; default: sQuery = "Select * from tbl_Position where Position Like '%" + sValue + "%' and status = 'ACTIVE'"; break; } ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables.Count > 0 ? ds.Tables[0] : null); } catch (Exception ex) { throw ex; } }
public void ReturnBook(Model.Transaction oMTransaction) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "SP_RETURN_BOOK"; ddq.AddParamer("@BOOK_ID", SqlDbType.VarChar, oMTransaction.BOOK_ID); ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oMTransaction.PERSON_ID); ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO); ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oMTransaction.MODIFIED_DATE); ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oMTransaction.MODIFIED_BY); ddq.AddParamer("@TOTAL_AMOUNT", SqlDbType.Decimal, oMTransaction.TOTAL_AMOUNT); ddq.AddParamer("@REMARKS", SqlDbType.VarChar, oMTransaction.REMARKS); ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS); ddq.ExecuteNonQuery(CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } }
public DataTable GetCategory(string sType, string sValue) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; string sQuery = String.Empty; switch (sType) { case "INACTIVE": sQuery = "SELECT * FROM TBL_CATEGORY WHERE [STATUS] = 'INACTIVE'"; break; case "CATEGORY": sQuery = "SELECT * FROM TBL_CATEGORY WHERE [STATUS] = 'ACTIVE' AND CATEGORY LIKE '%" + sValue + "%'"; break; default: sQuery = "SELECT * FROM TBL_CATEGORY"; break; } ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables.Count > 0 ? ds.Tables[0] : null); } catch (Exception ex) { return(null); } }
public DataTable GetRole(String sType, string sFindText) { try { scb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = scb.ConnectionString; string sQuery = ""; switch (sType) { case "ROLE": sQuery = "SELECT * FROM TBL_ROLE WHERE ROLE LIKE '%" + sFindText + "%'"; break; default: sQuery = "SELECT * FROM TBL_ROLE WHERE ROLE LIKE '%" + sFindText + "%'"; break; } ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables.Count > 0 ? ds.Tables[0] : null); } catch (Exception ex) { throw ex; } }
public void UpdateBookDetails(Model.Transaction oMTransaction) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "SP_UPDATE_BOOK_DETAILS"; ddq.AddParamer("@ID", SqlDbType.VarChar, oMTransaction.BOOK_ID); ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO); ddq.AddParamer("@TITLE", SqlDbType.VarChar, oMTransaction.TITLE); ddq.AddParamer("@SUBJECT", SqlDbType.VarChar, oMTransaction.SUBJECT); ddq.AddParamer("@CATEGORY", SqlDbType.VarChar, oMTransaction.CATEGORY); ddq.AddParamer("@AUTHOR", SqlDbType.VarChar, oMTransaction.AUTHOR); ddq.AddParamer("@PUBLISH_DATE", SqlDbType.VarChar, oMTransaction.PUBLISH_DATE); ddq.AddParamer("@LOCATION", SqlDbType.VarChar, oMTransaction.LOCATION); ddq.AddParamer("@BOOK_PRICE", SqlDbType.VarChar, oMTransaction.BOOK_PRICE); ddq.AddParamer("@RENT_PRICE", SqlDbType.VarChar, oMTransaction.RENT_PRICE); ddq.AddParamer("@ISBN_NUMBER", SqlDbType.VarChar, oMTransaction.ISBN_NUMBER); ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oMTransaction.MODIFIED_DATE); ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oMTransaction.MODIFIED_BY); ddq.AddParamer("@REMARKS", SqlDbType.VarChar, oMTransaction.REMARKS); ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS); ddq.ExecuteNonQuery(CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } }
public void RequestBook(Model.Transaction oMTransaction) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "SP_REQUEST_BOOK"; ddq.AddParamer("@ID", SqlDbType.VarChar, oMTransaction.BOOK_ID); ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oMTransaction.PERSON_ID); ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO); ddq.AddParamer("@TITLE", SqlDbType.VarChar, oMTransaction.TITLE); ddq.AddParamer("@SUBJECT", SqlDbType.VarChar, oMTransaction.SUBJECT); ddq.AddParamer("@CATEGORY", SqlDbType.VarChar, oMTransaction.CATEGORY); ddq.AddParamer("@AUTHOR", SqlDbType.VarChar, oMTransaction.AUTHOR); ddq.AddParamer("@PUBLISH_DATE", SqlDbType.VarChar, oMTransaction.PUBLISH_DATE); ddq.AddParamer("@ISBN_NUMBER", SqlDbType.VarChar, oMTransaction.ISBN_NUMBER); ddq.AddParamer("@LOCATION", SqlDbType.VarChar, oMTransaction.LOCATION); ddq.AddParamer("@BOOK_PRICE", SqlDbType.VarChar, oMTransaction.BOOK_PRICE); ddq.AddParamer("@RENT_PRICE", SqlDbType.VarChar, oMTransaction.RENT_PRICE); ddq.AddParamer("@DAYS_BORROWED", SqlDbType.VarChar, oMTransaction.TOTAL_DAYS); ddq.AddParamer("@ADDED_DATE", SqlDbType.VarChar, oMTransaction.ADDED_DATE); ddq.AddParamer("@ADDED_BY", SqlDbType.VarChar, oMTransaction.ADDED_BY); ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS); ddq.ExecuteNonQuery(CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } }
public Boolean IsBookRecordDataExists(eVariable.FIND_TYPE oFilter, string sFindText) { try { string sQuery = string.Empty; osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; switch (oFilter) { case eVariable.FIND_TYPE.ISBN_NUMBER: sQuery = "SELECT * FROM TBL_BOOKS WHERE ISBN_NUMBER = '" + sFindText + "'"; break; case eVariable.FIND_TYPE.BOOK_NO: sQuery = "SELECT * FROM TBL_BOOKS WHERE BOOK_NO = '" + sFindText + "'"; break; default: sQuery = "SELECT * FROM TBL_BOOKS WHERE ISBN_NUMBER = '" + sFindText + "'"; break; } ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables[0].Rows.Count > 0 ? true : false); } catch (Exception ex) { throw ex; } }
public int GetBookID() { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "SELECT TOP 1 ID FROM TBL_BOOKS ORDER BY ID DESC"; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables[0].Rows.Count > 0 ? Convert.ToInt32(ds.Tables[0].Rows[0][0]) : 0); }
private int GetStudentNo() { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "SELECT TOP 1 STUDENT_ID FROM TBL_STUDENTS ORDER BY STUDENT_ID DESC"; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables[0].Rows.Count > 0 ? Convert.ToInt32(Regex.Replace(ds.Tables[0].Rows[0][0].ToString(), "[^0-9]", "")) : 0); }
public int GetBorrowerNo() { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "SELECT TOP 1 BORROWER_ID FROM TBL_BORROWER ORDER BY BORROWER_ID DESC"; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables[0].Rows.Count > 0 ? Convert.ToInt32(Regex.Replace(ds.Tables[0].Rows[0][0].ToString(), "[^0-9]", "")) : 0); }
public int GetTransactionNo() { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "SELECT TOP 1 TRANSACTION_NO FROM TBL_BORROWEDBOOKS ORDER BY TRANSACTION_NO DESC"; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables[0].Rows.Count > 0 ? Convert.ToInt32(Regex.Replace(ds.Tables[0].Rows[0][0].ToString(), "[^0-9]", "")) : 0); }
public Boolean IsBookCheckout(Model.Transaction oData) { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = " SELECT ID FROM TBL_BOOKS WHERE BOOK_NO = '" + oData.BOOK_NO + "' AND [STATUS] = 'ACTIVE' " + " AND (BOOK_NO IN (SELECT BOOK_NO FROM TBL_BORROWEDBOOKS WHERE [STATUS] = 'BORROWED') " + " OR BOOK_NO IN (SELECT BOOK_NO FROM TBL_BORROWERREQUEST WHERE [STATUS] = 'REQUEST')) "; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables[0].Rows.Count > 0 ? true : false); }
public DataTable getCandidates(String sType, string sValue) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; string sQuery; switch (sType) { case "ID": sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.STUDENT_ID = '" + sValue + "'"; break; case "STUDENT ID": sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.STUDENT_ID LIKE '%" + sValue + "%'"; break; case "CANDIDATE ID": sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.STUDENT_ID LIKE '%" + sValue + "%'"; break; case "FIRST NAME": sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.FIRST_NAME LIKE '%" + sValue + "%'"; break; case "LAST NAME": sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.LAST_NAME LIKE '%" + sValue + "%'"; break; case "INACTIVE": sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'INACTIVE' AND A.STUDENT_ID LIKE '%" + sValue + "%'"; break; default: sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.FIRST_NAME LIKE '%" + sValue + "%'"; break; } ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables.Count > 0 ? ds.Tables[0] : null); } catch (Exception ex) { throw ex; } }
public DataTable getCandidate(String sType, string sValue) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; string sQuery; switch (sType) { case "STUDENT ID": sQuery = "SELECT * FROM TBL_STUDENTS WHERE STUDENT_ID Like '%" + sValue + "%' and status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')"; break; case "FIRST NAME": sQuery = "SELECT * FROM TBL_STUDENTS WHERE FIRST_NAME Like '%" + sValue + "%' and status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')"; break; case "MIDDLE NAME": sQuery = "SELECT * FROM TBL_STUDENTS WHERE MIDDLE_NAME Like '%" + sValue + "%' and status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')"; break; case "LAST NAME": sQuery = "SELECT * FROM TBL_STUDENTS WHERE LAST_NAME Like '%" + sValue + "%' and status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')"; break; case "INACTIVE": sQuery = "Select * from tbl_Students where status = 'INACTIVE'"; break; default: sQuery = "Select * from tbl_Students where status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')"; break; } ddq.CommandText = sQuery; ds = ddq.GetDataset(CommandType.Text); return(ds.Tables.Count > 0 ? ds.Tables[0] : null); } catch (Exception ex) { throw ex; } }
public void ArchiveUser(string sUsername) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "Update tbl_User set Status = 'INACTIVE' where Username = '******'"; ddq.ExecuteNonQuery(CommandType.Text); } catch (Exception ex) { throw ex; } }
public void UpdateStudent(Model.Student oData) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "Update tbl_Students set First_Name = '" + oData.FIRST_NAME + "',Middle_Name = '" + oData.MIDDLE_NAME + "',Last_Name = '" + oData.LAST_NAME + "',DOB = '" + oData.DOB + "',AGE = '" + oData.AGE + "',COURSE = '" + oData.COURSE + "',SECTION = '" + oData.SECTION + "',ADDRESS = '" + oData.ADDRESS + "',Contact_No = '" + oData.CONTACT_NO + "',Modified_Date = '" + DateTime.Now.ToShortDateString() + "' where STUDENT_ID = '" + oData.UNIQUE_ID + "'"; ddq.ExecuteNonQuery(CommandType.Text); } catch (Exception ex) { throw ex; } }