/// <summary>
/// Function that retrieves single Datatable from database using select criteria
/// </summary>
/// <param name="selectQuery">Select query to retrieve Datatable</param>
/// <returns>Return a single DataTable</returns>
public DataTable selectDataTable(string selectQuery)
{
DataTable dtSelectedTable = new DataTable();
try
{
SqlCommand insproCom = insproCommand.CreateTextCommand(selectQuery, insproConnection);
SqlDataAdapter insproDataAdapter = new SqlDataAdapter(insproCom);
insproDataAdapter.Fill(dtSelectedTable);
}
catch { }
finally { insproConnection.CloseConnection(); }
return(dtSelectedTable);
}
/// <summary>
/// Function that retrieves single Datatable from database using select criteria
/// </summary>
/// <param name="selectQuery">Select query to retrieve Datatable</param>
/// <returns>Return a single DataTable</returns>
public DataTable selectDataTable(string selectQuery, Dictionary <string, string> dicParameter)
{
DataTable dtSelectedTable = new DataTable();
try
{
SqlCommand insproCom = insproCommand.CreateStoredCommand(selectQuery, insproConnection, dicParameter);
SqlDataAdapter insproDataAdapter = new SqlDataAdapter(insproCom);
insproDataAdapter.Fill(dtSelectedTable);
}
catch { }
finally { insproConnection.CloseConnection(); }
return(dtSelectedTable);
}
