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