public DataTable SearchValue() { try { query = " select [Contract_month_start],[Contract_month_end],[Contract_payment_term],[Contract_Delievery_term],[Contract_loom_size],[Contract_no_of_looms],[Contract_item_name],[Contract_description],[Contract_Rate_per_Mtr],[Contract_Total_cost],[Contract_Remarks] from Contract1"; DataTable dt = new DataTable(); dt = sql.Search(query); return(dt); } catch (Exception ex) { return(null); } }
public DataTable LoadItemName() { try { query = "select IGC_Brand from Item_GreyCloth"; dt = new DataTable(); dt = sql.Search(query); return(dt); } catch (Exception ex) { return(null); } }
public string LoadBuyerID(string buyerName) { try { query = "select Buyer_ID from Buyer where Buyer_Name = '" + buyerName + "'"; dt = new DataTable(); dt = sql.Search(query); if (dt.Rows.Count > 0) { return(dt.Rows[0][0].ToString()); } else { return(null); } } catch (Exception ex) { return(null); } }