public List <Object> getValues(string queryString)
{
List <Object> results = new List <Object>();
configureConnection();
using (conn)
{
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(queryString, conn);
try
{
conn.Open();
System.Data.OleDb.OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Object[] nextRow = new Object[reader.FieldCount];
reader.GetValues(nextRow);
results.Add(nextRow);
}
return(results);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
return(null);
}
}
}
public void Open(String filename, string sheetName)
{
var conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filename + ";Extended Properties=\"" + "Excel 12.0 Xml;HDR=YES;IMEX=1;" + "\"");
conn.Open();
var comm = new OleDbCommand("Select * from [" + sheetName + "]", conn);
reader = comm.ExecuteReader(CommandBehavior.SingleResult);
records.Clear();
while (reader.Read())
{
fields = new object[reader.FieldCount];
var fieldcount = reader.GetValues(fields);
records.Add(fields);
}
//reader.
}
private ExcelReader(string fileName, ExcelSchema schema, ExcelOptions options, bool hasSchema)
{
if (!File.Exists(fileName))
{
throw new FileNotFoundException(Resources.FileNotFound, fileName);
}
if (hasSchema && schema == null)
{
throw new ArgumentNullException("schema");
}
if (options == null)
{
throw new ArgumentNullException("options");
}
this.options = options;
string connectionString = ExcelHelpers.GetConnectionString(fileName);
connection = new OleDbConnection(connectionString);
connection.Open();
command = connection.CreateCommand();
command.CommandText = ExcelHelpers.GetSelectCommandText(schema, options);
dataReader = command.ExecuteReader();
if (hasSchema)
{
if (options.IsFirstRecordSchema)
{
dataReader.Read(); // skip header record
}
this.schema = schema;
}
else if (options.IsFirstRecordSchema && dataReader.Read())
{
object[] values = new object[dataReader.FieldCount];
dataReader.GetValues(values);
int startingIndex = ExcelHelpers.GetExcelColumnIndex(options.StartingColumn ?? "A");
this.schema = new ExcelSchema();
for (int valueIndex = 0; valueIndex != values.Length; ++valueIndex)
{
object value = values[valueIndex];
string columnName = getColumnName(startingIndex + valueIndex, value);
StringColumn column = new StringColumn(columnName);
this.schema.AddColumn(column);
}
}
}
private void loadDataForSteel()
{
//MessageBox.Show("loadDataForSteel()");
// Data from DATA1-STEEL - Variable
string sql2 = "Select * from Steel where id_steel like '1'";
dat_reader = dat_conn.getDBReader(sql2);
dat_reader.Read();
dat_reader.GetValues(collection4);
// Data from DATA1-STEEL - Variable Table name
sql2 = "Select * from Steel where id_steel like '2'";
dat_reader = dat_conn.getDBReader(sql2);
dat_reader.Read();
dat_reader.GetValues(collection5);
// Data from DATA1-STEEL - Units
sql2 = "Select * from Steel where id_steel like '3'";
dat_reader = dat_conn.getDBReader(sql2);
dat_reader.Read();
dat_reader.GetValues(collection6);
// STEEL VARIABLES CHECKED LIST BOX 4
//ide sa od indexu 3 lebo prve tri stlpce z databazy vynechavame
for (int i = 3; i < collection4.Count(); i++)
{
//loading data from database to lists ZoznamPremennych,ZoznamZobrazPremennych,ZoznamJednotiek
infoSteel.ZoznamPremennych.Add(collection4[i].ToString());
infoSteel.ZoznamZobrazPremennych.Add(collection5[i].ToString());
infoSteel.ZoznamJednotiek.Add(collection6[i].ToString());
infoSteel.ZoznamZasktPrem.Add(false);
}
zozChLInfos[0, 0] = infoSteel;
this.SaveData();
}
private void loadDataForSection(byte typ_prierezu)
{
//MessageBox.Show("loadDataForSection()"+typ_prierezu);
// Data from DATA1-SECTIONS_VAR2 - Variable
string sql = "Select * from sections_var2 where csprofshape_var like '" + typ_prierezu + "'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
dat_reader.GetValues(collection1);
// Data from DATA1-SECTIONS_VAR2 - Variable Table Name
sql = "Select * from sections_var2 where id_sections_var2 like '1'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
dat_reader.GetValues(collection2);
// Data from DATA1-SECTIONS_VAR2 - Units
sql = "Select * from sections_var2 where id_sections_var2 like '3'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
dat_reader.GetValues(collection3);
// SECTION VARIABLES CHECKED LIST BOX 1
//prvych 5 stlpcov v databaze vynechavame
info1 = new CheckedListInfo();
for (int i = 5; i < collection1.Count(); i++)
{
if (!collection1[i].ToString().Equals(""))
{
info1.ZoznamPremennych.Add(collection1[i].ToString());
info1.ZoznamZobrazPremennych.Add(collection2[i].ToString());
info1.ZoznamJednotiek.Add(collection3[i].ToString());
info1.ZoznamZasktPrem.Add(false);
}
}
zozChLInfos[typ_prierezu, 0] = info1;
this.SaveData();
}
