/* * * /// <summary> * /// Function For Build Autogenerate strQuery from Datatable to String(SQL strQuery) * /// </summary> * /// <param name="table">Datatable Target</param> * /// <param name="table_name">Table Name</param> * /// <param name="DBConfig">Database Configuration</param> * /// <returns></returns> * public static string DBBulkInsertBuilder(ref DataTable table, string table_name, Connection.Database DBConfig) * { * return DBConfig.BulkInsert(ref table, table_name); * } */ /// <summary> /// Function For Build Dictonary from table/datatable /// </summary> /// <param name="strQuery"></param> /// <param name="strKeyColumnName"></param> /// <param name="strValueColumnName"></param> /// <param name="DBConfig"></param> /// <returns></returns> public static Dictionary <string, string> DBTableToDict(string strQuery, string strKeyColumnName, string strValueColumnName, Connection.Database DBConfig) { Dictionary <string, string> result = new Dictionary <string, string>(); DataTable dtQueryTable = DBConfig.MySqlToDataTable(strQuery); foreach (DataRow dr in dtQueryTable.Rows) { result.Add(GetDataFromRow(dr, strKeyColumnName), GetDataFromRow(dr, strValueColumnName)); } return(result); }
/// <summary> /// Function For Queries Result to Datatable /// </summary> public static System.Data.DataTable DBRowsDatatable(string strQuery, Connection.Database DBConfig) { return(DBConfig.MySqlToDataTable(strQuery)); }