private static void GetDataSetSpsSchema(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_schema");
DataColumn workCol = table.Columns.Add("schemaid", typeof(Int32));
workCol.AllowDBNull = false;
workCol.Unique = true;
table.Columns.Add("wmi", typeof(String));
table.Columns.Add("salesmakecode", typeof(Int32));
table.Columns.Add("protocol", typeof(Int32));
table.Columns.Add("systemtype", typeof(Int32));
table.Columns.Add("modelyearcode", typeof(Int32));
table.Columns.Add("vinpattern", typeof(String));
table.Columns.Add("snfrom", typeof(String));
table.Columns.Add("snto", typeof(String));
table.Columns.Add("hwid", typeof(Int32));
table.Columns.Add("identtype", typeof(Int32));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
}
private static void GetDataSetSpsHwdescription(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_hwdescription");
DataColumn workCol = table.Columns.Add("hwid", typeof(Int32));
workCol.AllowDBNull = false;
workCol.Unique = true;
table.Columns.Add("hwlocid", typeof(Int32));
table.Columns.Add("hwname", typeof(String));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
/*
TbDataAdapter adapter = new TbDataAdapter();
DataTable sampleTable = new DataTable("sps_hwdescription");
TbCommand com = (TbCommand)con.CreateCommand();
com.CommandText = command;
adapter.SelectCommand = com;
adapter.Fill(sampleTable);
//adapter.Fill(sampleTable,"sps_schema");
adapter.Dispose();
com.Dispose();
*/
}
private static void GetDataSetSpsHwdescription(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_hwdescription");
DataColumn workCol = table.Columns.Add("hwid", typeof(Int32));
workCol.AllowDBNull = false;
workCol.Unique = true;
table.Columns.Add("hwlocid", typeof(Int32));
table.Columns.Add("hwname", typeof(String));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
/*
* TbDataAdapter adapter = new TbDataAdapter();
*
* DataTable sampleTable = new DataTable("sps_hwdescription");
* TbCommand com = (TbCommand)con.CreateCommand();
* com.CommandText = command;
* adapter.SelectCommand = com;
* adapter.Fill(sampleTable);
* //adapter.Fill(sampleTable,"sps_schema");
*
* adapter.Dispose();
* com.Dispose();
*/
}
private static void GetDataSetSpsConfiguration(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_configuration");
DataColumn workCol = table.Columns.Add("vehicleid", typeof(Int32));
//workCol.AllowDBNull = false;
//workCol.Unique = true;
table.Columns.Add("ecuid", typeof(Int32));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
}
private static void GetDataSetSpsConfiguration(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_configuration");
DataColumn workCol = table.Columns.Add("vehicleid", typeof(Int32));
//workCol.AllowDBNull = false;
//workCol.Unique = true;
table.Columns.Add("ecuid", typeof(Int32));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
}
protected internal static void Main(string[] args)
{
try
{
// t2w_spsgadb, 383MB, moduleid_count=6472
// t2w_spssbdb, 146MB, moduleid_count=1098
// sas_saabdb
// spssaabdb old saab only tis?
TbConnection con = new TbConnection("t2w_spssbdb:5024", "tbadmin", "dgs");
con.Open();
//----- tioneb
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "Select TBADMIN.SPS_VEHICLE.VEHICLEID, TBADMIN.SPS_VEHICLE.SALESMAKECODE,TBADMIN.SPS_MODELDESCRIPTION.MODELCODE,";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS.DESCRIPTION As MOTEUR,TBADMIN.SPS_OPTION.CATEGORYCODE,SPS_FREEOPTIONS1.DESCRIPTION As FUEL,";
// com.CommandText += " SPS_FREEOPTIONS2.DESCRIPTION,SPS_OPTION2.CATEGORYCODE As CATEGORYCODE1";
// com.CommandText += " From";
// com.CommandText += " TBADMIN.SPS_VEHICLE Inner Join";
// com.CommandText += " TBADMIN.SPS_SALESMAKE On TBADMIN.SPS_SALESMAKE.SALESMAKECODE = TBADMIN.SPS_VEHICLE.SALESMAKECODE Inner Join";
// com.CommandText += " TBADMIN.SPS_MODELYEAR On TBADMIN.SPS_MODELYEAR.MODELYEARCODE = TBADMIN.SPS_VEHICLE.MODELYEARCODE Inner Join";
// com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION On TBADMIN.SPS_MODELDESCRIPTION.MODELCODE = TBADMIN.SPS_VEHICLE.MODELCODE Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTION On TBADMIN.SPS_OPTION.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTIONGROUP On TBADMIN.SPS_OPTIONGROUP.OPTIONGROUP = TBADMIN.SPS_OPTION.OPTIONGROUP Inner Join";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS On TBADMIN.SPS_FREEOPTIONS.OPTIONCODE = TBADMIN.SPS_OPTIONGROUP.OPTIONCODE Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTION SPS_OPTION1 On SPS_OPTION1.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTIONGROUP SPS_OPTIONGROUP1 On SPS_OPTIONGROUP1.OPTIONGROUP = SPS_OPTION1.OPTIONGROUP Inner Join";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS SPS_FREEOPTIONS1 On SPS_FREEOPTIONS1.OPTIONCODE = SPS_OPTIONGROUP1.OPTIONCODE Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTION SPS_OPTION2 On SPS_OPTION2.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTIONGROUP SPS_OPTIONGROUP2 On SPS_OPTIONGROUP2.OPTIONGROUP = SPS_OPTION2.OPTIONGROUP Inner Join";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS SPS_FREEOPTIONS2 On SPS_FREEOPTIONS2.OPTIONCODE = SPS_OPTIONGROUP2.OPTIONCODE";
// com.CommandText += " Where";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS.DESCRIPTION = 'B207R' And";
// com.CommandText += " TBADMIN.SPS_OPTION.CATEGORYCODE = 'ENG' And";
// com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.MODELCODE = 25 And";
// com.CommandText += " TBADMIN.SPS_SALESMAKE.SALESMAKE = 'SAAB' And";
// com.CommandText += " TBADMIN.SPS_MODELYEAR.MODELYEAR = '2011' And";
// com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.LANGUAGEID = 'fr_FR' And";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS.LANGUAGEID = 'fr_FR' And";
// com.CommandText += " SPS_OPTION1.CATEGORYCODE = 'S34' And";
// com.CommandText += " SPS_FREEOPTIONS1.LANGUAGEID = 'fr_FR' And";
// com.CommandText += " SPS_FREEOPTIONS2.LANGUAGEID = 'fr_FR'";
// com.CommandText += " Group By";
// com.CommandText += " TBADMIN.SPS_VEHICLE.VEHICLEID, TBADMIN.SPS_VEHICLE.SALESMAKECODE,";
// com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.MODELCODE, TBADMIN.SPS_FREEOPTIONS.DESCRIPTION,";
// com.CommandText += " TBADMIN.SPS_OPTION.CATEGORYCODE, SPS_FREEOPTIONS1.DESCRIPTION,";
// com.CommandText += " SPS_FREEOPTIONS2.DESCRIPTION, SPS_OPTION1.CATEGORYCODE,";
// com.CommandText += " SPS_OPTIONGROUP1.OPTIONGROUP, SPS_FREEOPTIONS1.LANGUAGEID,";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS.LANGUAGEID, TBADMIN.SPS_MODELDESCRIPTION.DESCRIPTION,";
// com.CommandText += " SPS_FREEOPTIONS2.OPTIONCODE, SPS_OPTION2.CATEGORYCODE,";
// com.CommandText += " SPS_FREEOPTIONS2.LANGUAGEID, SPS_OPTION2.CATEGORYCODE";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = " " + dr.GetString(0) + " " + dr.GetString(1) + " " + dr.GetString(2) + " " + dr.GetString(3) + " " + dr.GetString(4) + " " + dr.GetString(5) + " " + dr.GetString(6) + " " + dr.GetString(7);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- tioneb
{
DbCommand com = con.CreateCommand();
com.CommandText = "Select TBADMIN.SPS_VEHICLE.VEHICLEID, TBADMIN.SPS_VEHICLE.SALESMAKECODE,TBADMIN.SPS_MODELDESCRIPTION.MODELCODE,";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS.DESCRIPTION As ENGINE,TBADMIN.SPS_OPTION.CATEGORYCODE,SPS_FREEOPTIONS1.DESCRIPTION As FUEL,";
com.CommandText += " SPS_FREEOPTIONS2.DESCRIPTION,SPS_OPTION2.CATEGORYCODE As CATEGORYCODE1";
com.CommandText += " From";
com.CommandText += " TBADMIN.SPS_VEHICLE Inner Join";
com.CommandText += " TBADMIN.SPS_SALESMAKE On TBADMIN.SPS_SALESMAKE.SALESMAKECODE = TBADMIN.SPS_VEHICLE.SALESMAKECODE Inner Join";
com.CommandText += " TBADMIN.SPS_MODELYEAR On TBADMIN.SPS_MODELYEAR.MODELYEARCODE = TBADMIN.SPS_VEHICLE.MODELYEARCODE Inner Join";
com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION On TBADMIN.SPS_MODELDESCRIPTION.MODELCODE = TBADMIN.SPS_VEHICLE.MODELCODE Inner Join";
com.CommandText += " TBADMIN.SPS_OPTION On TBADMIN.SPS_OPTION.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
com.CommandText += " TBADMIN.SPS_OPTIONGROUP On TBADMIN.SPS_OPTIONGROUP.OPTIONGROUP = TBADMIN.SPS_OPTION.OPTIONGROUP Inner Join";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS On TBADMIN.SPS_FREEOPTIONS.OPTIONCODE = TBADMIN.SPS_OPTIONGROUP.OPTIONCODE Inner Join";
com.CommandText += " TBADMIN.SPS_OPTION SPS_OPTION1 On SPS_OPTION1.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
com.CommandText += " TBADMIN.SPS_OPTIONGROUP SPS_OPTIONGROUP1 On SPS_OPTIONGROUP1.OPTIONGROUP = SPS_OPTION1.OPTIONGROUP Inner Join";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS SPS_FREEOPTIONS1 On SPS_FREEOPTIONS1.OPTIONCODE = SPS_OPTIONGROUP1.OPTIONCODE Inner Join";
com.CommandText += " TBADMIN.SPS_OPTION SPS_OPTION2 On SPS_OPTION2.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
com.CommandText += " TBADMIN.SPS_OPTIONGROUP SPS_OPTIONGROUP2 On SPS_OPTIONGROUP2.OPTIONGROUP = SPS_OPTION2.OPTIONGROUP Inner Join";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS SPS_FREEOPTIONS2 On SPS_FREEOPTIONS2.OPTIONCODE = SPS_OPTIONGROUP2.OPTIONCODE";
com.CommandText += " Where";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS.DESCRIPTION = 'B207R' And";
com.CommandText += " TBADMIN.SPS_OPTION.CATEGORYCODE = 'ENG' And";
com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.MODELCODE = 25 And";
com.CommandText += " TBADMIN.SPS_SALESMAKE.SALESMAKE = 'SAAB' And";
com.CommandText += " TBADMIN.SPS_MODELYEAR.MODELYEAR = '2011' And";
com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.LANGUAGEID = 'en_GB' And";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS.LANGUAGEID = 'en_GB' And";
com.CommandText += " SPS_OPTION1.CATEGORYCODE = 'S34' And";
com.CommandText += " SPS_FREEOPTIONS1.LANGUAGEID = 'en_GB' And";
com.CommandText += " SPS_FREEOPTIONS2.LANGUAGEID = 'en_GB'";
com.CommandText += " Group By";
com.CommandText += " TBADMIN.SPS_VEHICLE.VEHICLEID, TBADMIN.SPS_VEHICLE.SALESMAKECODE,";
com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.MODELCODE, TBADMIN.SPS_FREEOPTIONS.DESCRIPTION,";
com.CommandText += " TBADMIN.SPS_OPTION.CATEGORYCODE, SPS_FREEOPTIONS1.DESCRIPTION,";
com.CommandText += " SPS_FREEOPTIONS2.DESCRIPTION, SPS_OPTION1.CATEGORYCODE,";
com.CommandText += " SPS_OPTIONGROUP1.OPTIONGROUP, SPS_FREEOPTIONS1.LANGUAGEID,";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS.LANGUAGEID, TBADMIN.SPS_MODELDESCRIPTION.DESCRIPTION,";
com.CommandText += " SPS_FREEOPTIONS2.OPTIONCODE, SPS_OPTION2.CATEGORYCODE,";
com.CommandText += " SPS_FREEOPTIONS2.LANGUAGEID, SPS_OPTION2.CATEGORYCODE";
DbDataReader dr = com.ExecuteReader();
string header = "SPS_VEHICLE.VEHICLEID" + "\t" + "SPS_VEHICLE.SALESMAKECODE" + "\t" + "SPS_MODELDESCRIPTION.MODELCODE" + "\t" + "SPS_FREEOPTIONS.DESCRIPTION(engine)" + "\t" + "SPS_OPTION.CATEGORYCODE" + "\t" + "SPS_FREEOPTIONS1.DESCRIPTION(fuel)" + "\t" + "SPS_FREEOPTIONS2.DESCRIPTION" + "\t" + "SPS_OPTION2.CATEGORYCODE";
Console.Out.WriteLine(header);
while (dr.Read())
{
string tab = dr.GetString(0) + "\t" + dr.GetString(1) + "\t" + dr.GetString(2) + "\t" + dr.GetString(3) + "\t" + dr.GetString(4) + "\t" + dr.GetString(5) + "\t" + dr.GetString(6) + "\t" + dr.GetString(7);
Console.Out.WriteLine(tab);
}
dr.Close();
dr.Dispose();
com.Dispose();
}
//--------------------------
//----- SPS_VERSION
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select item,version from sps_version";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- TBADMIN.SPS_FREEOPTIONS.LANGUAGEID
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select * from TBADMIN.SPS_FREEOPTIONS";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1) + " " + dr.GetString(2);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- SPS_BLOBS
{
DbCommand com = con.CreateCommand();
com.CommandText = "select moduleid,moduleblob,blobsize from sps_blobs";
DbDataReader dr = com.ExecuteReader();
Console.Out.WriteLine(com.CommandText);
int count = 0;
while (dr.Read())
{
string tab = "moduleid: " + dr.GetString(0) + " moduleblob: " + dr.GetString(1) + " blobsize: " + dr.GetString(2);
Console.Out.WriteLine(tab);
//int size = dr.GetInt32(2);
//byte[] binary = new byte[size];
//dr.GetBytes(1, 0, binary,0,size);
//string s = System.BitConverter.ToString(binary);
//Console.Out.WriteLine(s);
//Console.In.ReadLine();
count++;
}
dr.Close();
dr.Dispose();
com.Dispose();
Console.Out.WriteLine("count:" + count);
}
//--------------------------
Console.Out.WriteLine("Press Enter to contine!");
Console.In.ReadLine();
//----- SPS_SCHEMA
{
DbCommand com = con.CreateCommand();
com.CommandText = "select schemaid,wmi,salesmakecode,protocol,systemtype,modelyearcode,vinpattern,snfrom,snto,hwid,identtype from sps_schema";
DbDataReader dr = com.ExecuteReader();
Console.Out.WriteLine(com.CommandText);
while (dr.Read())
{
string tab = "schemaid: " + dr.GetString(0) + " wmi: " + dr.GetString(1) + " salesmakecode: " + dr.GetString(2) + " protocol: " + dr.GetString(3) + " systemtype: " + dr.GetString(4) + " modelyearcode: " + dr.GetString(5) + " vinpattern: " + dr.GetString(6) + " snfrom: " + dr.GetString(7) + " snto: " + dr.GetString(8) + " hwid: " + dr.GetString(9) + " identtype: " + dr.GetString(10);
Console.Out.WriteLine(tab);
}
dr.Close();
dr.Dispose();
com.Dispose();
}
//--------------------------
Console.Out.WriteLine("Press Enter to contine!");
Console.In.ReadLine();
// Now with DataSet instead
string command = "select hwid,hwlocid,hwname from sps_hwdescription";
GetDataSetSpsHwdescription(con, command);
command = "select ecuid,hwid from sps_hardware";
GetDataSetSpsHardware(con, command);
command = "select ecuid,moduleid,modulename from sps_modules";
GetDataSetSpsModules(con, command);
command = "select vehicleid,ecuid from sps_configuration";
GetDataSetSpsConfiguration(con, command);
foreach (DataRow myDataRowC in set.Tables["sps_configuration"].Rows)
{
Console.WriteLine("vehicleid: " + myDataRowC["vehicleid"]);
foreach (DataRow myDataRow1 in set.Tables["sps_hardware"].Rows)
{
if (myDataRow1["ecuid"].Equals(myDataRowC["ecuid"]))
{
Console.Write("\t\tecuid: " + myDataRow1["ecuid"]);
if (myDataRow1["hwid"] != null)
{
// Iterate to find name data.
foreach (DataRow myDataRow2 in set.Tables["sps_hwdescription"].Rows)
{
if (myDataRow1["hwid"].Equals(myDataRow2["hwid"]))
{
Console.Write(" hwname: " + myDataRow2["hwname"]);
}
}
}
else
{
Console.Write(" hwid: " + myDataRow1["hwid"]);
}
// Iterate to find name data.
foreach (DataRow myDataRow3 in set.Tables["sps_modules"].Rows)
{
if (myDataRow1["ecuid"].Equals(myDataRow3["ecuid"]))
{
Console.WriteLine();
Console.Write("\t\t\tmoduleid: " + myDataRow3["moduleid"]); // ------> GET binary from "select moduleid,moduleblob,blobsize from sps_blobs"
Console.Write("\t\t\tmodulename: " + myDataRow3["modulename"]);
}
}
Console.WriteLine();
Console.WriteLine();
}
}
}
//
set.Dispose();
con.Close();
con.Dispose();
}
catch (TbException tbx)
{
Console.Out.WriteLine("ErrorCode: " + tbx.Code);
Console.Out.WriteLine(tbx.Message);
}
Console.Out.WriteLine("Application about to terminate. Press Enter to finish!");
Console.In.ReadLine();
}
private static void GetDataSetSpsSchema(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_schema");
DataColumn workCol = table.Columns.Add("schemaid", typeof(Int32));
workCol.AllowDBNull = false;
workCol.Unique = true;
table.Columns.Add("wmi", typeof(String));
table.Columns.Add("salesmakecode", typeof(Int32));
table.Columns.Add("protocol", typeof(Int32));
table.Columns.Add("systemtype", typeof(Int32));
table.Columns.Add("modelyearcode", typeof(Int32));
table.Columns.Add("vinpattern", typeof(String));
table.Columns.Add("snfrom", typeof(String));
table.Columns.Add("snto", typeof(String));
table.Columns.Add("hwid", typeof(Int32));
table.Columns.Add("identtype", typeof(Int32));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
}
protected internal static void Main(string[] args)
{
try
{
// t2w_spsgadb, 383MB, moduleid_count=6472
// t2w_spssbdb, 146MB, moduleid_count=1098
// sas_saabdb
// spssaabdb old saab only tis?
TbConnection con = new TbConnection("t2w_spssbdb:5024", "tbadmin", "dgs");
con.Open();
//----- tioneb
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "Select TBADMIN.SPS_VEHICLE.VEHICLEID, TBADMIN.SPS_VEHICLE.SALESMAKECODE,TBADMIN.SPS_MODELDESCRIPTION.MODELCODE,";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS.DESCRIPTION As MOTEUR,TBADMIN.SPS_OPTION.CATEGORYCODE,SPS_FREEOPTIONS1.DESCRIPTION As FUEL,";
// com.CommandText += " SPS_FREEOPTIONS2.DESCRIPTION,SPS_OPTION2.CATEGORYCODE As CATEGORYCODE1";
// com.CommandText += " From";
// com.CommandText += " TBADMIN.SPS_VEHICLE Inner Join";
// com.CommandText += " TBADMIN.SPS_SALESMAKE On TBADMIN.SPS_SALESMAKE.SALESMAKECODE = TBADMIN.SPS_VEHICLE.SALESMAKECODE Inner Join";
// com.CommandText += " TBADMIN.SPS_MODELYEAR On TBADMIN.SPS_MODELYEAR.MODELYEARCODE = TBADMIN.SPS_VEHICLE.MODELYEARCODE Inner Join";
// com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION On TBADMIN.SPS_MODELDESCRIPTION.MODELCODE = TBADMIN.SPS_VEHICLE.MODELCODE Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTION On TBADMIN.SPS_OPTION.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTIONGROUP On TBADMIN.SPS_OPTIONGROUP.OPTIONGROUP = TBADMIN.SPS_OPTION.OPTIONGROUP Inner Join";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS On TBADMIN.SPS_FREEOPTIONS.OPTIONCODE = TBADMIN.SPS_OPTIONGROUP.OPTIONCODE Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTION SPS_OPTION1 On SPS_OPTION1.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTIONGROUP SPS_OPTIONGROUP1 On SPS_OPTIONGROUP1.OPTIONGROUP = SPS_OPTION1.OPTIONGROUP Inner Join";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS SPS_FREEOPTIONS1 On SPS_FREEOPTIONS1.OPTIONCODE = SPS_OPTIONGROUP1.OPTIONCODE Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTION SPS_OPTION2 On SPS_OPTION2.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
// com.CommandText += " TBADMIN.SPS_OPTIONGROUP SPS_OPTIONGROUP2 On SPS_OPTIONGROUP2.OPTIONGROUP = SPS_OPTION2.OPTIONGROUP Inner Join";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS SPS_FREEOPTIONS2 On SPS_FREEOPTIONS2.OPTIONCODE = SPS_OPTIONGROUP2.OPTIONCODE";
// com.CommandText += " Where";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS.DESCRIPTION = 'B207R' And";
// com.CommandText += " TBADMIN.SPS_OPTION.CATEGORYCODE = 'ENG' And";
// com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.MODELCODE = 25 And";
// com.CommandText += " TBADMIN.SPS_SALESMAKE.SALESMAKE = 'SAAB' And";
// com.CommandText += " TBADMIN.SPS_MODELYEAR.MODELYEAR = '2011' And";
// com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.LANGUAGEID = 'fr_FR' And";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS.LANGUAGEID = 'fr_FR' And";
// com.CommandText += " SPS_OPTION1.CATEGORYCODE = 'S34' And";
// com.CommandText += " SPS_FREEOPTIONS1.LANGUAGEID = 'fr_FR' And";
// com.CommandText += " SPS_FREEOPTIONS2.LANGUAGEID = 'fr_FR'";
// com.CommandText += " Group By";
// com.CommandText += " TBADMIN.SPS_VEHICLE.VEHICLEID, TBADMIN.SPS_VEHICLE.SALESMAKECODE,";
// com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.MODELCODE, TBADMIN.SPS_FREEOPTIONS.DESCRIPTION,";
// com.CommandText += " TBADMIN.SPS_OPTION.CATEGORYCODE, SPS_FREEOPTIONS1.DESCRIPTION,";
// com.CommandText += " SPS_FREEOPTIONS2.DESCRIPTION, SPS_OPTION1.CATEGORYCODE,";
// com.CommandText += " SPS_OPTIONGROUP1.OPTIONGROUP, SPS_FREEOPTIONS1.LANGUAGEID,";
// com.CommandText += " TBADMIN.SPS_FREEOPTIONS.LANGUAGEID, TBADMIN.SPS_MODELDESCRIPTION.DESCRIPTION,";
// com.CommandText += " SPS_FREEOPTIONS2.OPTIONCODE, SPS_OPTION2.CATEGORYCODE,";
// com.CommandText += " SPS_FREEOPTIONS2.LANGUAGEID, SPS_OPTION2.CATEGORYCODE";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = " " + dr.GetString(0) + " " + dr.GetString(1) + " " + dr.GetString(2) + " " + dr.GetString(3) + " " + dr.GetString(4) + " " + dr.GetString(5) + " " + dr.GetString(6) + " " + dr.GetString(7);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- tioneb
{
DbCommand com = con.CreateCommand();
com.CommandText = "Select TBADMIN.SPS_VEHICLE.VEHICLEID, TBADMIN.SPS_VEHICLE.SALESMAKECODE,TBADMIN.SPS_MODELDESCRIPTION.MODELCODE,";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS.DESCRIPTION As ENGINE,TBADMIN.SPS_OPTION.CATEGORYCODE,SPS_FREEOPTIONS1.DESCRIPTION As FUEL,";
com.CommandText += " SPS_FREEOPTIONS2.DESCRIPTION,SPS_OPTION2.CATEGORYCODE As CATEGORYCODE1";
com.CommandText += " From";
com.CommandText += " TBADMIN.SPS_VEHICLE Inner Join";
com.CommandText += " TBADMIN.SPS_SALESMAKE On TBADMIN.SPS_SALESMAKE.SALESMAKECODE = TBADMIN.SPS_VEHICLE.SALESMAKECODE Inner Join";
com.CommandText += " TBADMIN.SPS_MODELYEAR On TBADMIN.SPS_MODELYEAR.MODELYEARCODE = TBADMIN.SPS_VEHICLE.MODELYEARCODE Inner Join";
com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION On TBADMIN.SPS_MODELDESCRIPTION.MODELCODE = TBADMIN.SPS_VEHICLE.MODELCODE Inner Join";
com.CommandText += " TBADMIN.SPS_OPTION On TBADMIN.SPS_OPTION.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
com.CommandText += " TBADMIN.SPS_OPTIONGROUP On TBADMIN.SPS_OPTIONGROUP.OPTIONGROUP = TBADMIN.SPS_OPTION.OPTIONGROUP Inner Join";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS On TBADMIN.SPS_FREEOPTIONS.OPTIONCODE = TBADMIN.SPS_OPTIONGROUP.OPTIONCODE Inner Join";
com.CommandText += " TBADMIN.SPS_OPTION SPS_OPTION1 On SPS_OPTION1.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
com.CommandText += " TBADMIN.SPS_OPTIONGROUP SPS_OPTIONGROUP1 On SPS_OPTIONGROUP1.OPTIONGROUP = SPS_OPTION1.OPTIONGROUP Inner Join";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS SPS_FREEOPTIONS1 On SPS_FREEOPTIONS1.OPTIONCODE = SPS_OPTIONGROUP1.OPTIONCODE Inner Join";
com.CommandText += " TBADMIN.SPS_OPTION SPS_OPTION2 On SPS_OPTION2.VEHICLEID = TBADMIN.SPS_VEHICLE.VEHICLEID Inner Join";
com.CommandText += " TBADMIN.SPS_OPTIONGROUP SPS_OPTIONGROUP2 On SPS_OPTIONGROUP2.OPTIONGROUP = SPS_OPTION2.OPTIONGROUP Inner Join";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS SPS_FREEOPTIONS2 On SPS_FREEOPTIONS2.OPTIONCODE = SPS_OPTIONGROUP2.OPTIONCODE";
com.CommandText += " Where";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS.DESCRIPTION = 'B207R' And";
com.CommandText += " TBADMIN.SPS_OPTION.CATEGORYCODE = 'ENG' And";
com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.MODELCODE = 25 And";
com.CommandText += " TBADMIN.SPS_SALESMAKE.SALESMAKE = 'SAAB' And";
com.CommandText += " TBADMIN.SPS_MODELYEAR.MODELYEAR = '2011' And";
com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.LANGUAGEID = 'en_GB' And";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS.LANGUAGEID = 'en_GB' And";
com.CommandText += " SPS_OPTION1.CATEGORYCODE = 'S34' And";
com.CommandText += " SPS_FREEOPTIONS1.LANGUAGEID = 'en_GB' And";
com.CommandText += " SPS_FREEOPTIONS2.LANGUAGEID = 'en_GB'";
com.CommandText += " Group By";
com.CommandText += " TBADMIN.SPS_VEHICLE.VEHICLEID, TBADMIN.SPS_VEHICLE.SALESMAKECODE,";
com.CommandText += " TBADMIN.SPS_MODELDESCRIPTION.MODELCODE, TBADMIN.SPS_FREEOPTIONS.DESCRIPTION,";
com.CommandText += " TBADMIN.SPS_OPTION.CATEGORYCODE, SPS_FREEOPTIONS1.DESCRIPTION,";
com.CommandText += " SPS_FREEOPTIONS2.DESCRIPTION, SPS_OPTION1.CATEGORYCODE,";
com.CommandText += " SPS_OPTIONGROUP1.OPTIONGROUP, SPS_FREEOPTIONS1.LANGUAGEID,";
com.CommandText += " TBADMIN.SPS_FREEOPTIONS.LANGUAGEID, TBADMIN.SPS_MODELDESCRIPTION.DESCRIPTION,";
com.CommandText += " SPS_FREEOPTIONS2.OPTIONCODE, SPS_OPTION2.CATEGORYCODE,";
com.CommandText += " SPS_FREEOPTIONS2.LANGUAGEID, SPS_OPTION2.CATEGORYCODE";
DbDataReader dr = com.ExecuteReader();
string header = "SPS_VEHICLE.VEHICLEID" + "\t" + "SPS_VEHICLE.SALESMAKECODE" + "\t" + "SPS_MODELDESCRIPTION.MODELCODE" + "\t" + "SPS_FREEOPTIONS.DESCRIPTION(engine)" + "\t" + "SPS_OPTION.CATEGORYCODE" + "\t" + "SPS_FREEOPTIONS1.DESCRIPTION(fuel)" + "\t" + "SPS_FREEOPTIONS2.DESCRIPTION" + "\t" + "SPS_OPTION2.CATEGORYCODE";
Console.Out.WriteLine(header);
while (dr.Read())
{
string tab = dr.GetString(0) + "\t" + dr.GetString(1) + "\t" + dr.GetString(2) + "\t" + dr.GetString(3) + "\t" + dr.GetString(4) + "\t" + dr.GetString(5) + "\t" + dr.GetString(6) + "\t" + dr.GetString(7);
Console.Out.WriteLine(tab);
}
dr.Close();
dr.Dispose();
com.Dispose();
}
//--------------------------
//----- SPS_VERSION
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select item,version from sps_version";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- TBADMIN.SPS_FREEOPTIONS.LANGUAGEID
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select * from TBADMIN.SPS_FREEOPTIONS";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1) + " " + dr.GetString(2);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- SPS_BLOBS
{
DbCommand com = con.CreateCommand();
com.CommandText = "select moduleid,moduleblob,blobsize from sps_blobs";
DbDataReader dr = com.ExecuteReader();
Console.Out.WriteLine(com.CommandText);
int count=0;
while (dr.Read())
{
string tab = "moduleid: " + dr.GetString(0) + " moduleblob: " + dr.GetString(1) + " blobsize: " + dr.GetString(2);
Console.Out.WriteLine(tab);
//int size = dr.GetInt32(2);
//byte[] binary = new byte[size];
//dr.GetBytes(1, 0, binary,0,size);
//string s = System.BitConverter.ToString(binary);
//Console.Out.WriteLine(s);
//Console.In.ReadLine();
count++;
}
dr.Close();
dr.Dispose();
com.Dispose();
Console.Out.WriteLine("count:" + count);
}
//--------------------------
Console.Out.WriteLine("Press Enter to contine!");
Console.In.ReadLine();
//----- SPS_SCHEMA
{
DbCommand com = con.CreateCommand();
com.CommandText = "select schemaid,wmi,salesmakecode,protocol,systemtype,modelyearcode,vinpattern,snfrom,snto,hwid,identtype from sps_schema";
DbDataReader dr = com.ExecuteReader();
Console.Out.WriteLine(com.CommandText);
while (dr.Read())
{
string tab = "schemaid: " + dr.GetString(0) + " wmi: " + dr.GetString(1) + " salesmakecode: " + dr.GetString(2) + " protocol: " + dr.GetString(3) + " systemtype: " + dr.GetString(4) + " modelyearcode: " + dr.GetString(5) + " vinpattern: " + dr.GetString(6) + " snfrom: " + dr.GetString(7) + " snto: " + dr.GetString(8) + " hwid: " + dr.GetString(9) + " identtype: " + dr.GetString(10);
Console.Out.WriteLine(tab);
}
dr.Close();
dr.Dispose();
com.Dispose();
}
//--------------------------
Console.Out.WriteLine("Press Enter to contine!");
Console.In.ReadLine();
// Now with DataSet instead
string command = "select hwid,hwlocid,hwname from sps_hwdescription";
GetDataSetSpsHwdescription(con, command);
command = "select ecuid,hwid from sps_hardware";
GetDataSetSpsHardware(con,command);
command = "select ecuid,moduleid,modulename from sps_modules";
GetDataSetSpsModules(con, command);
command = "select vehicleid,ecuid from sps_configuration";
GetDataSetSpsConfiguration(con, command);
foreach (DataRow myDataRowC in set.Tables["sps_configuration"].Rows)
{
Console.WriteLine("vehicleid: " + myDataRowC["vehicleid"]);
foreach (DataRow myDataRow1 in set.Tables["sps_hardware"].Rows)
{
if (myDataRow1["ecuid"].Equals(myDataRowC["ecuid"]))
{
Console.Write("\t\tecuid: " + myDataRow1["ecuid"]);
if (myDataRow1["hwid"] != null)
{
// Iterate to find name data.
foreach (DataRow myDataRow2 in set.Tables["sps_hwdescription"].Rows)
{
if (myDataRow1["hwid"].Equals(myDataRow2["hwid"]))
{
Console.Write(" hwname: " + myDataRow2["hwname"]);
}
}
}
else
{
Console.Write(" hwid: " + myDataRow1["hwid"]);
}
// Iterate to find name data.
foreach (DataRow myDataRow3 in set.Tables["sps_modules"].Rows)
{
if (myDataRow1["ecuid"].Equals(myDataRow3["ecuid"]))
{
Console.WriteLine();
Console.Write("\t\t\tmoduleid: " + myDataRow3["moduleid"]); // ------> GET binary from "select moduleid,moduleblob,blobsize from sps_blobs"
Console.Write("\t\t\tmodulename: " + myDataRow3["modulename"]);
}
}
Console.WriteLine();
Console.WriteLine();
}
}
}
//
set.Dispose();
con.Close();
con.Dispose();
}
catch (TbException tbx)
{
Console.Out.WriteLine("ErrorCode: " + tbx.Code);
Console.Out.WriteLine(tbx.Message);
}
Console.Out.WriteLine("Application about to terminate. Press Enter to finish!");
Console.In.ReadLine();
}
static void Main(string[] args)
{
try
{
TbConnection con = new TbConnection("t2w_spssbdb:5024", "tbadmin", "dgs");
con.Open();
//----- SPS_VERSION
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select item,version from sps_version";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- SPS_BLOBS
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select moduleid,moduleblob,blobsize from sps_blobs";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1) + " " + dr.GetString(2);
// Console.Out.WriteLine(tab);
// int size = dr.GetInt32(2);
// byte[] binary = new byte[size];
// dr.GetBytes(1, 0, binary,0,size);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- SPS_SCHEMA
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select schemaid,wmi,salesmakecode,protocol,systemtype,modelyearcode,vinpattern,snfrom,snto,hwid,identtype from sps_schema";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1) + " " + dr.GetString(2) + " " + dr.GetString(3) + " " + dr.GetString(4) + " " + dr.GetString(5) + " " + dr.GetString(6) + " " + dr.GetString(7) + " " + dr.GetString(8) + " " + dr.GetString(9) + " " + dr.GetString(10) + " " + dr.GetString(10);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
// Now with DataSet instead
string command = "select hwid,hwlocid,hwname from sps_hwdescription";
GetDataSetSpsHwdescription(con, command);
command = "select ecuid,hwid from sps_hardware";
GetDataSetSpsHardware(con, command);
command = "select ecuid,moduleid,modulename from sps_modules";
GetDataSetSpsModules(con, command);
command = "select vehicleid,ecuid from sps_configuration";
GetDataSetSpsConfiguration(con, command);
foreach (DataRow myDataRowC in set.Tables["sps_configuration"].Rows)
{
Console.WriteLine("vehicleid: " + myDataRowC["vehicleid"]);
foreach (DataRow myDataRow1 in set.Tables["sps_hardware"].Rows)
{
if (myDataRow1["ecuid"].Equals(myDataRowC["ecuid"]))
{
Console.Write("\t\tecuid: " + myDataRow1["ecuid"]);
if (myDataRow1["hwid"] != null)
{
// Iterate to find name data.
foreach (DataRow myDataRow2 in set.Tables["sps_hwdescription"].Rows)
{
if (myDataRow1["hwid"].Equals(myDataRow2["hwid"]))
{
Console.Write(" hwname: " + myDataRow2["hwname"]);
}
}
}
else
{
Console.Write(" hwid: " + myDataRow1["hwid"]);
}
// Iterate to find name data.
foreach (DataRow myDataRow3 in set.Tables["sps_modules"].Rows)
{
if (myDataRow1["ecuid"].Equals(myDataRow3["ecuid"]))
{
Console.WriteLine();
Console.Write("\t\t\tmoduleid: " + myDataRow3["moduleid"]); // ------> GET binary from "select moduleid,moduleblob,blobsize from sps_blobs"
Console.Write("\t\t\tmodulename: " + myDataRow3["modulename"]);
}
}
Console.WriteLine();
Console.WriteLine();
}
}
}
//
set.Dispose();
con.Close();
con.Dispose();
}
catch (TbException tbx)
{
Console.Out.WriteLine("ErrorCode: " + tbx.Code);
Console.Out.WriteLine(tbx.Message);
}
Console.Out.WriteLine("Application about to terminate. Press Enter to finish!");
Console.In.ReadLine();
}
static void Main(string[] args)
{
try
{
TbConnection con = new TbConnection("t2w_spssbdb:5024", "tbadmin", "dgs");
con.Open();
//----- SPS_VERSION
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select item,version from sps_version";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- SPS_BLOBS
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select moduleid,moduleblob,blobsize from sps_blobs";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1) + " " + dr.GetString(2);
// Console.Out.WriteLine(tab);
// int size = dr.GetInt32(2);
// byte[] binary = new byte[size];
// dr.GetBytes(1, 0, binary,0,size);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
//----- SPS_SCHEMA
//{
// DbCommand com = con.CreateCommand();
// com.CommandText = "select schemaid,wmi,salesmakecode,protocol,systemtype,modelyearcode,vinpattern,snfrom,snto,hwid,identtype from sps_schema";
// DbDataReader dr = com.ExecuteReader();
// Console.Out.WriteLine(com.CommandText);
// while (dr.Read())
// {
// string tab = dr.GetString(0) + " " + dr.GetString(1) + " " + dr.GetString(2) + " " + dr.GetString(3) + " " + dr.GetString(4) + " " + dr.GetString(5) + " " + dr.GetString(6) + " " + dr.GetString(7) + " " + dr.GetString(8) + " " + dr.GetString(9) + " " + dr.GetString(10) + " " + dr.GetString(10);
// Console.Out.WriteLine(tab);
// }
// dr.Close();
// dr.Dispose();
// com.Dispose();
//}
//--------------------------
// Now with DataSet instead
string command = "select hwid,hwlocid,hwname from sps_hwdescription";
GetDataSetSpsHwdescription(con, command);
command = "select ecuid,hwid from sps_hardware";
GetDataSetSpsHardware(con,command);
command = "select ecuid,moduleid,modulename from sps_modules";
GetDataSetSpsModules(con, command);
command = "select vehicleid,ecuid from sps_configuration";
GetDataSetSpsConfiguration(con, command);
foreach (DataRow myDataRowC in set.Tables["sps_configuration"].Rows)
{
Console.WriteLine("vehicleid: " + myDataRowC["vehicleid"]);
foreach (DataRow myDataRow1 in set.Tables["sps_hardware"].Rows)
{
if (myDataRow1["ecuid"].Equals(myDataRowC["ecuid"]))
{
Console.Write("\t\tecuid: " + myDataRow1["ecuid"]);
if (myDataRow1["hwid"] != null)
{
// Iterate to find name data.
foreach (DataRow myDataRow2 in set.Tables["sps_hwdescription"].Rows)
{
if (myDataRow1["hwid"].Equals(myDataRow2["hwid"]))
{
Console.Write(" hwname: " + myDataRow2["hwname"]);
}
}
}
else
{
Console.Write(" hwid: " + myDataRow1["hwid"]);
}
// Iterate to find name data.
foreach (DataRow myDataRow3 in set.Tables["sps_modules"].Rows)
{
if (myDataRow1["ecuid"].Equals(myDataRow3["ecuid"]))
{
Console.WriteLine();
Console.Write("\t\t\tmoduleid: " + myDataRow3["moduleid"]); // ------> GET binary from "select moduleid,moduleblob,blobsize from sps_blobs"
Console.Write("\t\t\tmodulename: " + myDataRow3["modulename"]);
}
}
Console.WriteLine();
Console.WriteLine();
}
}
}
//
set.Dispose();
con.Close();
con.Dispose();
}
catch (TbException tbx)
{
Console.Out.WriteLine("ErrorCode: " + tbx.Code);
Console.Out.WriteLine(tbx.Message);
}
Console.Out.WriteLine("Application about to terminate. Press Enter to finish!");
Console.In.ReadLine();
}
