private void bbatonishe_Click(object sender, EventArgs e) { dabse.OleDbCommand newCom = new dabse.OleDbCommand(); var comand = new dabse.OleDbCommand("SELECT Код, Название FROM Дисциплины WHERE Шифр_специальности=?", Date_baseone); comand.Parameters.Add("Шфр_спц", dabse.OleDbType.Integer, 255).Value = int.Parse(shifrSpecialnosti.Text); comand.Connection = Date_baseone; dabse.OleDbDataReader Result = comand.ExecuteReader(); int x = Result.FieldCount; String Name_disc, index_disk; while (Result.Read() == true) { index_disk = Result.GetValue(0).ToString(); Name_disc = Result.GetValue(1).ToString(); dabse.OleDbCommand spisok = new dabse.OleDbCommand("insert into Дисциплины_обучение (Шифр_студента, Код_дисциплины) values (?, ?)", Date_baseone); spisok.Parameters.Add("Шифр_студента", dabse.OleDbType.Integer, 255).Value = int.Parse(shifrStudenta.Text); spisok.Parameters.Add("Код_дисциплины", dabse.OleDbType.Integer, 255).Value = int.Parse(index_disk); spisok.Connection = Date_baseone; //MessageBox.Show(spisok.CommandText); spisok.ExecuteReader(); //spisok.Close(); } MessageBox.Show("Всё хорошо!!!"); }
public Form1() { InitializeComponent(); var connection = new oleDB.OleDbConnection("Data Source=\"e:\\vic.mdb\";User ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";"); connection.Open(); oleDB.OleDbCommand command = new oleDB.OleDbCommand("Select * From [Phones]", connection); oleDB.OleDbDataReader reader = command.ExecuteReader(); DataTable table = new DataTable(); table.Columns.Add(reader.GetName(0)); table.Columns.Add(reader.GetName(1)); table.Columns.Add(reader.GetName(2)); while (reader.Read() == true) { table.Rows.Add(new object[] { reader.GetValue(0), reader.GetValue(1), reader.GetValue(2) }); } reader.Close(); connection.Close(); dataGridView1.DataSource = table; }
// Constructor for searched login public Login(uint gloid) { // Declarations uint gvoid = 0, modifiedby = 0; string username = null, password = null, note = null, status = null; bool active = false; DateTime datemodified = new DateTime(1901, 1, 1); // Command string query = string.Format("SELECT glo_username, glo_password, glo_note, glo_active, glo_status, gvo_id, date_modified, modified_by FROM gfrc_login" + " WHERE glo_id = {0}", gloid); try { using (conn) { conn.Open(); cmd = new OleDbCommand(query, conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { username = rdr.GetString(0); password = rdr.GetString(1); note = rdr.GetString(2); active = rdr.GetBoolean(3); status = rdr.GetString(4); if (!UInt32.TryParse(rdr.GetValue(5).ToString(), out gvoid)) gvoid = 0; if (!DateTime.TryParse(rdr.GetValue(6).ToString(), out datemodified)) datemodified = new DateTime(1901, 1, 1); if (!UInt32.TryParse(rdr.GetValue(7).ToString(), out modifiedby)) modifiedby = 0; } } } finally { if (rdr != null) rdr.Close(); } if (conn != null) { conn.Close(); } _gloID = gloid; _Username = username; _Password = password; _Note = note; _Active = active; _Status = status; _gvoID = gvoid; _DateModified = datemodified; _ModifiedBy = modifiedby; }
// Constructor for searched volunteer holiday public Holiday(uint gvhid) { // Declarations uint gvoid = 0, modifiedby = 0; DateTime datemodified = new DateTime(1901, 1, 1), start = new DateTime(1901, 1, 1), end = new DateTime(1901, 1, 1); // Command string query = string.Format("SELECT gvo_id, gvh_start, gvh_end, date_modified, modified_by " + "FROM gfrc_volunteer_holiday WHERE gvh_id = {0}", gvhid); try { using (conn) { conn.Open(); cmd = new OleDbCommand(query, conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { gvoid = Convert.ToUInt32(rdr.GetInt32(0)); start = rdr.GetDateTime(1); if (!DateTime.TryParse(rdr.GetValue(2).ToString(), out end)) end = new DateTime(1901, 1, 1); if (!DateTime.TryParse(rdr.GetValue(14).ToString(), out datemodified)) datemodified = new DateTime(1901, 1, 1); if (!UInt32.TryParse(rdr.GetValue(15).ToString(), out modifiedby)) modifiedby = 0; } } } finally { if (rdr != null) rdr.Close(); } if (conn != null) { conn.Close(); } _gvhID = gvhid; _gvoID = gvoid; _Start = start; _End = end; _DateModified = datemodified; _ModifiedBy = modifiedby; }
public static DataTable FunctionOfAdding(String stringsione) { var Database = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb"); Database.Open(); dabse.OleDbCommand loadingOfTable = new dabse.OleDbCommand("Select * From " + stringsione, Database); dabse.OleDbDataReader result = loadingOfTable.ExecuteReader(); DataTable table = new DataTable(); for (int i = 0; i < result.FieldCount; i++) { table.Columns.Add(result.GetName(i)); } while (result.Read() == true) { object[] yacheiki = new object[result.FieldCount]; for (int i = 0; i < result.FieldCount; i++) { yacheiki[i] = result.GetValue(i); } table.Rows.Add(yacheiki); } result.Close(); Database.Close(); return(table); }
private void button1_Click(object sender, EventArgs e) { var Database = new OleDiBi.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb"); Database.Open(); OleDiBi.OleDbCommand loadingOfTable = new OleDiBi.OleDbCommand(richTextBox1.Text, Database); OleDiBi.OleDbDataReader result = loadingOfTable.ExecuteReader(); DataTable table = new DataTable(); for (int i = 0; i < result.FieldCount; i++) { table.Columns.Add(result.GetName(i)); } while (result.Read() == true) { object[] yacheiki = new object[result.FieldCount]; for (int i = 0; i < result.FieldCount; i++) { yacheiki[i] = result.GetValue(i); } table.Rows.Add(yacheiki); } result.Close(); Database.Close(); dataGridView1.DataSource = table; }
//Get all pictures from Database and save in a list public List<byte[]> photos() { byte[] aBytes = null; List<byte[]> pictures = new List<byte[]> {}; for (int i = 1; i <= 5000; i++) { try { int cont = 0; string query = "SELECT image FROM Data WHERE counter = " + i + " AND image <> NULL;"; command = new OleDbCommand(query, connection); reader = command.ExecuteReader(); while (reader.Read()) { aBytes = (byte[])reader.GetValue(cont); pictures.Add(aBytes); cont++; } reader.Close(); } catch (Exception e) { ////The error message is not displayed to continue with the process. //MessageBox.Show("I'm so sorry, we cannot get the images.\n" + e); } } return pictures; }
private void btnSave_Click(object sender, EventArgs e) { saveFileDialog1.ShowDialog(); //Se muestra el cuadro de diálogo para guardar string nombreArchivo = saveFileDialog1.FileName; //Contiene la ruta completa del archivo a guardar FileStream Holi = new FileStream(nombreArchivo,FileMode.Create); StreamWriter writer = new StreamWriter(Holi); consulta = "SELECT * FROM Paquetes WHERE Numero = " + cmbPaquetes.SelectedItem; cmd = new OleDbCommand(consulta, Con); Con.Open(); DR = cmd.ExecuteReader(); while (DR.Read()) { writer.Write("Nº: " + DR.GetValue(0) + "\t"); //Escribe el número de paquete writer.Write("Costo: $" + DR.GetValue(2) + "\t"); //Escribe el costo writer.Write("Origen: " + DR.GetValue(3) + "\t"); //Escribe el origen writer.WriteLine("Destino: " + DR.GetValue(4)); //Escribe el destino } Con.Close(); consulta = "SELECT * FROM Movimientos WHERE Paquete = " + cmbPaquetes.SelectedItem; cmd = new OleDbCommand(consulta, Con); Con.Open(); DR = cmd.ExecuteReader(); int mov; while (DR.Read()) { writer.Write("Fecha: " + DR.GetValue(2) + "\t"); //Añade la fecha mov = (int)DR.GetValue(3); writer.WriteLine(QueMov[mov-1]); //Añade el movimiento } Con.Close(); //Cierra conexión writer.Close(); //Cierra Streamwriter Holi.Close(); //Ciera filestream //PINCHE IMBÉCIL!!!! .l. (-_-) .l. }
//vykresli obrazok private void loadPictureOfCrossSection(byte num) { string command = "Select h,b,tw,tf,r,d from SECTIONS where csprof_name like '" + combo_text + "'"; string h = "h", b = "b", tw = "tw", tf = "tf", r = "r", d = "d"; dat_reader = dat_conn.getDBReader(command); dat_reader.Read(); try { h = dat_reader.GetValue(0).ToString(); b = dat_reader.GetValue(1).ToString(); tw = dat_reader.GetValue(2).ToString(); tf = dat_reader.GetValue(3).ToString(); r = dat_reader.GetValue(4).ToString(); d = dat_reader.GetValue(5).ToString(); } catch (FormatException) { MessageBox.Show("Probably wrong selected cross-section."); } catch (InvalidOperationException) { MessageBox.Show("Probably wrong selected cross-section."); } switch (num) { case 1: Image image = Image.FromFile(@"prierezy\prier1.jpg"); Bitmap myBitmap = new Bitmap(image, pictureBox1.Width, pictureBox1.Height); Graphics g = Graphics.FromImage(myBitmap); Font f_text = new Font("Arial", 14, FontStyle.Bold); g.DrawString(h, f_text, Brushes.Black, new PointF(2, pictureBox1.Height / 2 + 30)); g.DrawString(d, f_text, Brushes.Black, new PointF(pictureBox1.Width / 8, pictureBox1.Height / 2 + 30)); f_text = new Font("Arial", 16, FontStyle.Bold); g.DrawString(tw, f_text, Brushes.Black, new PointF(pictureBox1.Width / 2 +50, pictureBox1.Height / 2-30)); g.DrawString(tf, f_text, Brushes.Black, new PointF(pictureBox1.Width/1.15f, pictureBox1.Height/1.25f)); g.DrawString(r, f_text, Brushes.Black, new PointF(pictureBox1.Width / 2 + 80, pictureBox1.Height / 2 + 47)); f_text = new Font("Arial", 19, FontStyle.Bold); g.DrawString(b, f_text, Brushes.Black, new PointF(pictureBox1.Width / 2 + 12, 10)); //g.DrawImage(myBitmap, AutoScrollPosition.X, AutoScrollPosition.Y); pictureBox1.Image = myBitmap; break; case 2: image = Image.FromFile(@"prierezy\prier2.jpg"); myBitmap = new Bitmap(image, pictureBox1.Width, pictureBox1.Height); g = Graphics.FromImage(myBitmap); f_text = new Font("Arial", 14, FontStyle.Bold); g.DrawString(h, f_text, Brushes.Black, new PointF(2, pictureBox1.Height / 2 + 30)); f_text = new Font("Arial", 16, FontStyle.Bold); g.DrawString(b, f_text, Brushes.Black, new PointF(pictureBox1.Width / 2 + 10, 12)); //g.DrawString(tw, f_text, Brushes.Black, new PointF(10, 0)); //g.DrawString(tf, f_text, Brushes.Black, new PointF(10, 0)); //g.DrawString(r, f_text, Brushes.Black, new PointF(10, 0)); //g.DrawString(d, f_text, Brushes.Black, new PointF(10, 0)); //g.DrawImage(myBitmap, AutoScrollPosition.X, AutoScrollPosition.Y); pictureBox1.Image = myBitmap; break; case 3: break; default: MessageBox.Show("Neimplementovane..."); break; } }
public static string GetDataFieldValues(OleDbDataReader reader) { string dt = ""; for (int i = 0; i < reader.FieldCount; i++) { dt = dt + "'" + ReplaceMarks(reader.GetValue(i).ToString()) + "'"; if (i < reader.FieldCount - 1) { dt = dt + ", "; } } return dt; }
static void Main(string[] args) { var connection = new oleDB.OleDbConnection("Data Source=\"e:\\vic.mdb\";User ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";"); connection.Open(); var command = new oleDB.OleDbCommand("SELECT * From [Phones]", connection); oleDB.OleDbDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection); Console.WriteLine("Таблица БД:\n"); while (reader.Read() == true) { Console.WriteLine("{0,-3} {1, -15} {2, -15}", reader.GetValue(0), reader.GetValue(1), reader.GetValue(2)); } reader.Close(); connection.Close(); Console.ReadKey(); }
public void LoadRow(OleDbDataReader reader) { var schema = reader.GetSchemaTable(); foreach (var pi in this.GetType().GetProperties()) { if (schema.Select("ColumnName='" + pi.Name + "'").Length > 0) { var value = reader.GetValue(reader.GetOrdinal(pi.Name)); if (value != null) pi.SetValue(this, value, null); } } }
public static void Load(this DataObject dataObj, OleDbDataReader reader) { try { foreach (ColumnDefinition columnDef in dataObj.ColumnDefs()) { if (reader.GetValue(columnDef.ColumnIndex) != DBNull.Value) { switch (columnDef.ColumnFieldType) { case ColumnDefinition.FieldType.String: dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetString(columnDef.ColumnIndex); break; case ColumnDefinition.FieldType.Int32: dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetInt32(columnDef.ColumnIndex); break; case ColumnDefinition.FieldType.Boolean: dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetBoolean(columnDef.ColumnIndex); break; } } else //default values for nulls { switch (columnDef.ColumnFieldType) { case ColumnDefinition.FieldType.String: dataObj.GetColumnValues()[columnDef.ColumnIndex] = string.Empty; break; case ColumnDefinition.FieldType.Int32: dataObj.GetColumnValues()[columnDef.ColumnIndex] = 0; break; case ColumnDefinition.FieldType.Boolean: dataObj.GetColumnValues()[columnDef.ColumnIndex] = false; break; } } } } catch (Exception e) { //TODO: what to do here? } }
//Get the last request in the data base public int LastRequest() { int last = 1; string query = "SELECT MAX(counter) FROM Data"; try { command = new OleDbCommand(query, connection); reader = command.ExecuteReader(); if(reader.Read()) { last = int.Parse(reader.GetValue(0).ToString()); } reader.Close(); } catch(Exception e) { MessageBox.Show("We're so sorry, couldn't get the last record." + e); } return last; }
//loading of data //data from mat_name from table CONCRETE in database //loading all elements from column mat_num except 0,1,List_name,Unit private void loadList() { string item; listView1.Items.Clear(); dat_reader = dat_conn.getDBReader("Select mat_name from concrete where id_concrete not in (1,2,3) order by id_concrete"); // if cell type is text - string '2' while (dat_reader.Read()) { item = dat_reader.GetValue(0).ToString(); listView1.Items.Add(item); } /* ListViewItem(); listView1.Items.Add(); ListViewItem.ListViewSubItem ListViewGroupCollection ListViewItem.ListViewSubItemCollection (); */ }
// Constructor for searched volunteer qualification public vQualification(uint gvqid) { // Declarations uint gvoid = 0; string qualification = null; // Command string query = string.Format("SELECT gvo_id, gvq_qual " + "FROM gfrc_volunteer_qualification WHERE gvq_id = {0}", gvqid); try { using (conn) { conn.Open(); cmd = new OleDbCommand(query, conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { UInt32.TryParse(rdr.GetValue(0).ToString(), out gvoid); qualification = rdr.GetString(1); } } } finally { if (rdr != null) rdr.Close(); } if (conn != null) { conn.Close(); } _gvqID = gvqid; _gvoID = gvoid; _Qualification = qualification; }
public bool createQualification(vQualification create) { bool result = false; // Command string query = String.Format(@"INSERT INTO gfrc_volunteer_qualification (gvo_id, gvq_qual) " + "VALUES({0}, '{1}')", create.gvoID, create.Qualification); int affected = 0; try { using (conn) { conn.Open(); cmd = new OleDbCommand(query, conn); affected = cmd.ExecuteNonQuery(); // checks if rows were affected by the insert query if (affected > 0) { result = true; query = String.Format(@"SELECT gvq_id FROM gfrc_volunteer_qualification WHERE gvq_id = (SELECT MAX(gvq_id) FROM gfrc_volunteer_qualification)"); cmd = new OleDbCommand(query, conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { // Set gloID UInt32.TryParse(rdr.GetValue(0).ToString(), out _gvqID); } } } } catch (Exception e) { result = false; } finally { if (rdr != null) rdr.Close(); } if (conn != null) { conn.Close(); } return result; }
private PivotItem ReadItem(OleDbDataReader dataReader, int rowId) { PivotItem item = new PivotItem(rowId.ToString(), this); for (int column = 0; column < dataReader.FieldCount; column++) { if (dataReader.IsDBNull(column)) continue; String columnName = dataReader.GetName(column).ToLowerInvariant(); String value = dataReader.GetValue(column).ToString(); if (String.IsNullOrEmpty(value)) continue; if (columnName == OleDbSchemaConstants.Item.Name) { item.Name = value; } else if (columnName == OleDbSchemaConstants.Item.Image) { String imagePath = UriUtility.ExpandRelativeUri(this.BasePath, value); item.Image = new PivotImage(imagePath); } else if (columnName == OleDbSchemaConstants.Item.Description) { item.Description = value; } else if (columnName == OleDbSchemaConstants.Item.Href) { item.Href = value; } else if (columnName == OleDbSchemaConstants.Item.RelatedLinks) { StringReader valueReader = new StringReader(value); String singleValue = null; while ((singleValue = valueReader.ReadLine()) != null) { String[] parts = singleValue.Split( new String[] { OleDbSchemaConstants.LinkPartDelimiter }, StringSplitOptions.None); if (parts.Length > 0) { String name = null, url = null; if (parts.Length == 1) { url = parts[0]; } else if (parts.Length >= 2) { name = parts[0]; url = parts[1]; } item.AddRelatedLink(new PivotLink(name, url)); } } } else { PivotFacetCategory facetCategory = null; foreach (PivotFacetCategory currentFacetCategory in m_facetCategoryMap.Values) { if (columnName == currentFacetCategory.Name.Replace('.', '#').ToLowerInvariant()) { facetCategory = currentFacetCategory; break; } } if (facetCategory != null) { item.AddFacetValues(facetCategory.Name, this.SplitJoinedStrings(value).ToArray()); } } } return item; }
private PivotFacetCategory CreateFacetCategory(OleDbDataReader dataReader) { String name = null; PivotFacetType type = null; for (int column = 0; column < dataReader.FieldCount; column++) { if (dataReader.IsDBNull(column)) continue; String columnName = dataReader.GetName(column).ToLowerInvariant(); String value = dataReader.GetValue(column).ToString(); if (columnName == OleDbSchemaConstants.FacetCategory.Name) { name = value; } else if (columnName == OleDbSchemaConstants.FacetCategory.Type) { type = PivotFacetType.Parse(value); } } if (name == null) throw new InvalidDataException("Facet Categories data set is missing a Name column"); if (type == null) throw new InvalidDataException("Facet Categories data set is missing a Type column"); return new PivotFacetCategory(name, type); }
/// <summary> /// Поиск Записи в таблице /// </summary> /// <param name="parDataReader">Ридер - для пробега по таблице</param> /// <param name="parFromLesson">Параметр который ищем</param> /// <param name="parColNumberCompare">Номер столбца для сравнения</param> /// <param name="parColNumberReturn">Номер столбца откуда возращаем результат</param> /// <returns></returns> public Object SearchRecordInTable(OleDbDataReader parDataReader, Object parFromLesson, int parColNumberCompare, int parColNumberReturn) { Object param = null; while (parDataReader.Read()) { if (parFromLesson.Equals(parDataReader.GetValue(parColNumberCompare))) { //задаем значение параметра param = parDataReader.GetValue(parColNumberReturn); break; } } parDataReader.Dispose(); return param; }
private void naplnZoznamy() { string combo1 = comboBox1.Text; //actual text in combobox1 string combo2 = comboBox2.Text; //actual text in combobox2 string unit = "nedef"; CheckedListInfo chLInfo; this.deleteLists(); #region choosing typ_prierezu from database // checking type of cross-section from database for further processing string sql = "Select csprofshape from sections where csprof_name like '" + combo2 + "'"; dat_reader = dat_conn.getDBReader(sql); dat_reader.Read(); try { typ_prierezu = Convert.ToByte(dat_reader.GetValue(0).ToString()); } catch (InvalidOperationException) { /*MessageBox.Show("Set up cross-section in ComboBox Cross-section, please!");*/ //This type of exception appears mainly because text in combo2 is empty } catch (FormatException) { } #endregion dtform = new DataTableForm(typ_prierezu); try { #region filling lists with actual variables,their names in table and units chLInfo = dtform.ZozChLInfos[0, 0]; //for checkListbox 4. (STEEL) for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++) { //if the variable is checked in checkedlistbox4 then add this variable to list of variables if (chLInfo.ZoznamZasktPrem[i]) { zoznamNazvyPremeSTEEL.Add(chLInfo.ZoznamPremennych[i]); //variables for database zoznamMenuNazvySTEEL.Add(chLInfo.ZoznamZobrazPremennych[i]); //variables names for table zoznamMenuJednotkySTEEL.Add(chLInfo.ZoznamJednotiek[i]); //units of these variables } } chLInfo = dtform.ZozChLInfos[typ_prierezu, 0]; //pre checkListbox 1. for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++) { if (chLInfo.ZoznamZasktPrem[i]) { zoznamNazvyPremennych.Add(chLInfo.ZoznamPremennych[i]); //premenne do databazy zoznamMenuNazvy.Add(chLInfo.ZoznamZobrazPremennych[i]); //premenne zobrazene v tabulke zoznamMenuJednotky.Add(chLInfo.ZoznamJednotiek[i]); //MessageBox.Show(chLInfo.ZoznamPremennych[i] + "\n" + chLInfo.ZoznamZobrazPremennych[i] + "\n" // + chLInfo.ZoznamJednotiek[i]); } } chLInfo = dtform.ZozChLInfos[typ_prierezu, 1]; //pre checkListbox 2. for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++) { if (chLInfo.ZoznamZasktPrem[i]) { zoznamMenuNazvy.Add(chLInfo.ZoznamPremennych[i]); //premenne zadavane pouzivatelom zoznamNazvyPremennych.Add(chLInfo.ZoznamPremennych[i]); //MessageBox.Show(chLInfo.ZoznamPremennych[i]); } } #endregion #region loading values for variables from database //getting values of actual choosen variables of STEEL for (int i = 0; i < zoznamNazvyPremeSTEEL.Count; i++) { if (combo1 != "" && comboBox1.SelectedIndex != 0 && combo2 != "") { sql = "Select " + zoznamNazvyPremeSTEEL[i] + " from Steel where mat_name like '"+combo1+"'"; dat_reader = dat_conn.getDBReader(sql); dat_reader.Read(); try { zoznamMenuHodnotySTEEL.Add(dat_reader.GetValue(0).ToString()); } catch (InvalidOperationException) { } } } //getting values of actual choosen variables of cross sections //if variable is from user input - getting character from database that determines //that it is user input,adding unit for this variable ,other visual style for this //variable in datagrid is defined in method updateDataGridView() for (int i = 0; i < zoznamNazvyPremennych.Count; i++) { if (combo2 != "" && combo1 != "") { sql = "Select "; switch (zoznamNazvyPremennych[i]) { #region Table - user-data cells basic loading - database "user" column // Internal forces in section case "N": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break; case "Vy": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break; case "Vz": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break; case "Mx": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "My": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "Mz": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; // End bending moments case "My.a": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "My.b": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "Mz.a": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "Mz.b": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; // Midspan bending moments case "My.s": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "Mz.s": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; // Annex A - Table A.2 input data case "My.Ed.x": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break; case "Mz.Ed.x": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break; case "Deflection.y.x": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break; case "Deflection.z.x": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break; // Lateral buckling Mcr variables case "C1y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; case "C2y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; case "C3y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; case "kz_LT": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; case "kw_LT": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; // Beam properties - lenght case "L_teor": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_y_buck": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_z_buck": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_y_LT": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_z_LT": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_T": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; // Cross-section data case "Anet": sql += "user"; unit = "mm2"; zoznamMenuJednotky.Add(unit); break; // Variables - Torsion NAD CZE case "MEd.T": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break; case "VEd.T": sql += "user"; unit = "[kN]"; zoznamMenuJednotky.Add(unit); break; case "e.T": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break; #endregion default: sql += zoznamNazvyPremennych[i]; break; } sql += " from SECTIONS where csprof_name like '" + combo2 + "'"; dat_reader = dat_conn.getDBReader(sql); dat_reader.Read(); try { zoznamMenuHodnoty.Add(dat_reader.GetValue(0).ToString());//zapise sa hodnota do zoznamu } catch (InvalidOperationException) { } } } #endregion } catch (NullReferenceException) { MessageBox.Show("There is nothing to display! Please choose some variables in Options -> Data table list."); } }
//Image mainBackGroundImage; public frmMainForm() { byte i = 0; PrivateDataEncode pde = new PrivateDataEncode(); myConn = new OleDbConnection(); myCom = new OleDbCommand(); myCom.CommandText = "Select M_ID, M_Name, M_Type, M_Description From tblMasterInfor ORDER BY M_Type"; myCom.Connection = myConn; myConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;Jet OLEDB:Database Password=whatthehellisgoingon"; try{ myConn.Open(); }catch (Exception e) { MessageBox.Show(ERROR_WHILE_LOADING_DATABASE + e.Message.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Dispose(); Application.Exit(); } myReader = myCom.ExecuteReader(); System.ComponentModel.ComponentResourceManager resources1 = new System.ComponentModel.ComponentResourceManager(typeof(frmMainForm)); InitializeComponent(); if (myReader.HasRows) { while (myReader.Read()) { this.tbTmp4LoadDynamic = new System.Windows.Forms.ToolStripButton(); this.tbTmp4LoadDynamic.Overflow = ToolStripItemOverflow.Never; if (myReader.GetByte(2) == frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_DIAGNOSIS) { try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\diagnosis.bmp"); }catch (System.IO.FileNotFoundException) {} } else if (myReader.GetByte(2) == frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_TREATMENT) { //treatment try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\treatment.bmp"); //career.bmp }catch (System.IO.FileNotFoundException) {} } else { try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\career.bmp"); }catch (System.IO.FileNotFoundException) {} } //this.tbTmp4LoadDynamic.Image = ((System.Drawing.Image)(resources.GetObject("mnuBtnPatientRecord.Image"))); this.tbTmp4LoadDynamic.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft; this.tbTmp4LoadDynamic.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta; this.tbTmp4LoadDynamic.Name = "tb" + myReader.GetValue(0).ToString(); this.tbTmp4LoadDynamic.Size = new System.Drawing.Size(90, 40); this.tbTmp4LoadDynamic.TextAlign = System.Drawing.ContentAlignment.MiddleRight; this.tbTmp4LoadDynamic.Click += new System.EventHandler(this.DynamicToolBarClick); this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta; this.tbTmp4LoadDynamic.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.ImageAndText; this.tbTmp4LoadDynamic.Text = myReader.GetString(1); this.tbTmp4LoadDynamic.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageBeforeText; this.tbTmp4LoadDynamic.DoubleClick += new EventHandler(DynamicToolBarClick); sepTmp = new ToolStripSeparator(); sepTmp.Name = "auto" + i++.ToString(); sepTmp.Size = new System.Drawing.Size(6, 1); this.tbMainToolBar.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { sepTmp, tbTmp4LoadDynamic }); } // myReader.Read() } //myReader.HasRows myReader.Close(); this.frmMainForm_SizeChanged(null, null); }
public EN1993_1_1(string combo1, string combo2,bool item3,bool item4, bool item5, bool item6) { string sql1; string sql2; sql1 = "Select mat_num, mat_name, mat_prod_code_num, mat_prod_code_name1, mat_prod_code_name2, steel_grade_num, fy1, fu1, fy2, fu2, gamaM0, gamaM1, gamaM2, betaw, eta_shear, E, G, nu_pois, alpha_temp from Steel where mat_name like '" + combo1 + "'"; #region Database DATA-STEEL variables reader dat_conn = DatabaseConnection.getInstance(); dat_reader = dat_conn.getDBReader(sql1); try { while (dat_reader.Read()) { // STEEL DATABASE DATA #region Data list try { mat_num = Convert.ToInt16(dat_reader.GetValue(0).ToString()); } catch (FormatException) { } try { mat_name = dat_reader.GetValue(1).ToString(); } catch (FormatException) { } try { mat_prod_code_num = Convert.ToInt16(dat_reader.GetValue(2).ToString()); } catch (FormatException) { } try { mat_prod_code_name1 = dat_reader.GetValue(3).ToString(); } catch (FormatException) { } try { mat_prod_code_name2 = dat_reader.GetValue(4).ToString(); } catch (FormatException) { } try { steel_grade_num = Convert.ToInt32(dat_reader.GetValue(5).ToString()); } catch (FormatException) { } try { fy1 = Convert.ToDouble(dat_reader.GetValue(6).ToString()); } catch (FormatException) { } try { fu1 = Convert.ToDouble(dat_reader.GetValue(7).ToString()); } catch (FormatException) { } try { fy2 = Convert.ToDouble(dat_reader.GetValue(8).ToString()); } catch (FormatException) { } try { fu2 = Convert.ToDouble(dat_reader.GetValue(9).ToString()); } catch (FormatException) { } try { gamaM0 = Convert.ToDouble(dat_reader.GetValue(10).ToString()); } catch (FormatException) { } try { gamaM1 = Convert.ToDouble(dat_reader.GetValue(11).ToString()); } catch (FormatException) { } try { gamaM2 = Convert.ToDouble(dat_reader.GetValue(12).ToString()); } catch (FormatException) { } try { betaw = Convert.ToDouble(dat_reader.GetValue(13).ToString()); } catch (FormatException) { } try { eta_shear = Convert.ToDouble(dat_reader.GetValue(14).ToString()); } catch (FormatException) { } try { _E = Convert.ToDouble(dat_reader.GetValue(15).ToString()); } catch (FormatException) { } try { _G = Convert.ToDouble(dat_reader.GetValue(16).ToString()); } catch (FormatException) { } try { nu_pois = Convert.ToDouble(dat_reader.GetValue(17).ToString()); } catch (FormatException) { } try { alpha_temp = Convert.ToDouble(dat_reader.GetValue(18).ToString()); } catch (FormatException) { } #endregion } } catch (FormatException) { } #endregion sql2 = "Select csprof_namenum, csprof_name, csprofshape, csprof_production, csprodcode1_name1, csprodcode1_name2, csprodcode2_name1, csprodcode2_name2, csproducer1, csproducer2, csprof_weight,h, b, bh, bd, tw, tf, r, r1, r2, r3, hi, d, d1, e, e_apostrof, ez, ey, w, w1, v, v1, v2, eel, epl, D_tube, t_tube, A, A_su, Af, Aw, Ay_v, Az_v, Av, Iy, Wy_el, Wy1, Wy2, Wy_pl, iy_r, Sy, Iz, Wz_el, Wz1, Wz2, Wz_pl, iz_r, Sz, IT, Wt, Iw, ss, ys, ym, Id, Ieta, Weta, ieta_r, Ixi, Wxi2, Wxi13,ixi_r, Iyz, omega_w, izf, iz1, ipc, ay, aeta, ip, ia, Ww1, Ww2, Sw3, iw1, k, a1, tg_fi, cy1, ty1, cz1, tz1, cy2, ty2, cz2, tz2 from sections where csprof_name like '" + combo2 + "'"; #region Database DATA-SECTIONS variables reader dat_conn = DatabaseConnection.getInstance(); dat_reader = dat_conn.getDBReader(sql2); try { while (dat_reader.Read()) { // CROSS-SECTION DATABASE DATA #region Data list // 0 - 9 try { csprof_namenum = Convert.ToInt16(dat_reader.GetValue(0).ToString()); } catch (FormatException) { } try { csprof_name = dat_reader.GetValue(1).ToString(); } catch (FormatException) { } try { csprofshape = Convert.ToInt16(dat_reader.GetValue(2).ToString()); } catch (FormatException) { } try { csprof_production = Convert.ToInt16(dat_reader.GetValue(3).ToString()); } catch (FormatException) { } try { csprodcode1_name1 = dat_reader.GetValue(4).ToString(); } catch (FormatException) { } try { csprodcode1_name2 = dat_reader.GetValue(5).ToString(); } catch (FormatException) { } try { csprodcode2_name1 = dat_reader.GetValue(6).ToString(); } catch (FormatException) { } try { csprodcode2_name2 = dat_reader.GetValue(7).ToString(); } catch (FormatException) { } try { csproducer1 = dat_reader.GetValue(8).ToString(); } catch (FormatException) { } try { csproducer2 = dat_reader.GetValue(9).ToString(); } catch (FormatException) { } // 10-19 csprof_weight = Convert.ToDouble(dat_reader.GetValue(10).ToString()); try { h = Convert.ToDouble(dat_reader.GetValue(11).ToString()); } catch (FormatException) { } try { b = Convert.ToDouble(dat_reader.GetValue(12).ToString()); } catch (FormatException) { } try { bh = Convert.ToDouble(dat_reader.GetValue(13).ToString()); } catch (FormatException) { } try { bd = Convert.ToDouble(dat_reader.GetValue(14).ToString()); } catch (FormatException) { } try { tw = Convert.ToDouble(dat_reader.GetValue(15).ToString()); } catch (FormatException) { } try { tf = Convert.ToDouble(dat_reader.GetValue(16).ToString()); } catch (FormatException) { } try { r = Convert.ToDouble(dat_reader.GetValue(17).ToString()); } catch (FormatException) { } try { r1 = Convert.ToDouble(dat_reader.GetValue(18).ToString()); } catch (FormatException) { } try { r2 = Convert.ToDouble(dat_reader.GetValue(19).ToString()); } catch (FormatException) { } // 20-29 try { r3 = Convert.ToDouble(dat_reader.GetValue(20).ToString()); } catch (FormatException) { } try { hi = Convert.ToDouble(dat_reader.GetValue(21).ToString()); } catch (FormatException) { } try { d = Convert.ToDouble(dat_reader.GetValue(22).ToString()); } catch (FormatException) { } try { d1 = Convert.ToDouble(dat_reader.GetValue(23).ToString()); } catch (FormatException) { } try { e = Convert.ToDouble(dat_reader.GetValue(24).ToString()); } catch (FormatException) { } try { e_apostrof = Convert.ToDouble(dat_reader.GetValue(25).ToString()); } catch (FormatException) { } try { ez = Convert.ToDouble(dat_reader.GetValue(26).ToString()); } catch (FormatException) { } try { ey = Convert.ToDouble(dat_reader.GetValue(27).ToString()); } catch (FormatException) { } try { w = Convert.ToDouble(dat_reader.GetValue(28).ToString()); } catch (FormatException) { } try { w1 = Convert.ToDouble(dat_reader.GetValue(29).ToString()); } catch (FormatException) { } // 30-39 try { v = Convert.ToDouble(dat_reader.GetValue(30).ToString()); } catch (FormatException) { } try { v1 = Convert.ToDouble(dat_reader.GetValue(31).ToString()); } catch (FormatException) { } try { v2 = Convert.ToDouble(dat_reader.GetValue(32).ToString()); } catch (FormatException) { } try { eel = Convert.ToDouble(dat_reader.GetValue(33).ToString()); } catch (FormatException) { } try { epl = Convert.ToDouble(dat_reader.GetValue(34).ToString()); } catch (FormatException) { } try { _D_tube = Convert.ToDouble(dat_reader.GetValue(35).ToString()); } catch (FormatException) { } try { t_tube = Convert.ToDouble(dat_reader.GetValue(36).ToString()); } catch (FormatException) { } try { _A = Convert.ToDouble(dat_reader.GetValue(37).ToString()); } catch (FormatException) { } try { _A_su = Convert.ToDouble(dat_reader.GetValue(38).ToString()); } catch (FormatException) { } try { _Af = Convert.ToDouble(dat_reader.GetValue(39).ToString()); } catch (FormatException) { } // 40-49 try { _Aw = Convert.ToDouble(dat_reader.GetValue(40).ToString()); } catch (FormatException) { } try { _Ay_v = Convert.ToDouble(dat_reader.GetValue(41).ToString()); } catch (FormatException) { } try { _Az_v = Convert.ToDouble(dat_reader.GetValue(42).ToString()); } catch (FormatException) { } try { _Av = Convert.ToDouble(dat_reader.GetValue(43).ToString()); } catch (FormatException) { } try { _Iy = Convert.ToDouble(dat_reader.GetValue(44).ToString()); } catch (FormatException) { } try { _Wy_el = Convert.ToDouble(dat_reader.GetValue(45).ToString()); } catch (FormatException) { } try { _Wy1 = Convert.ToDouble(dat_reader.GetValue(46).ToString()); } catch (FormatException) { } try { _Wy2 = Convert.ToDouble(dat_reader.GetValue(47).ToString()); } catch (FormatException) { } try { _Wy_pl = Convert.ToDouble(dat_reader.GetValue(48).ToString()); } catch (FormatException) { } try { iy_r = Convert.ToDouble(dat_reader.GetValue(49).ToString()); } catch (FormatException) { } // 50-59 try { _Sy = Convert.ToDouble(dat_reader.GetValue(50).ToString()); } catch (FormatException) { } try { _Iz = Convert.ToDouble(dat_reader.GetValue(51).ToString()); } catch (FormatException) { } try { _Wz_el = Convert.ToDouble(dat_reader.GetValue(52).ToString()); } catch (FormatException) { } try { _Wz1 = Convert.ToDouble(dat_reader.GetValue(53).ToString()); } catch (FormatException) { } try { _Wz2 = Convert.ToDouble(dat_reader.GetValue(54).ToString()); } catch (FormatException) { } try { _Wz_pl = Convert.ToDouble(dat_reader.GetValue(55).ToString()); } catch (FormatException) { } try { iz_r = Convert.ToDouble(dat_reader.GetValue(56).ToString()); } catch (FormatException) { } try { _Sz = Convert.ToDouble(dat_reader.GetValue(57).ToString()); } catch (FormatException) { } try { _IT = Convert.ToDouble(dat_reader.GetValue(58).ToString()); } catch (FormatException) { } try { _Wt = Convert.ToDouble(dat_reader.GetValue(59).ToString()); } catch (FormatException) { } // 60-69 try { _Iw = Convert.ToDouble(dat_reader.GetValue(60).ToString()); } catch (FormatException) { } try { ss = Convert.ToDouble(dat_reader.GetValue(61).ToString()); } catch (FormatException) { } try { ys = Convert.ToDouble(dat_reader.GetValue(62).ToString()); } catch (FormatException) { } try { ym = Convert.ToDouble(dat_reader.GetValue(63).ToString()); } catch (FormatException) { } try { _Id = Convert.ToDouble(dat_reader.GetValue(64).ToString()); } catch (FormatException) { } try { _Ieta = Convert.ToDouble(dat_reader.GetValue(65).ToString()); } catch (FormatException) { } try { _Weta = Convert.ToDouble(dat_reader.GetValue(66).ToString()); } catch (FormatException) { } try { ieta_r = Convert.ToDouble(dat_reader.GetValue(67).ToString()); } catch (FormatException) { } try { _Ixi = Convert.ToDouble(dat_reader.GetValue(68).ToString()); } catch (FormatException) { } try { _Wxi2 = Convert.ToDouble(dat_reader.GetValue(69).ToString()); } catch (FormatException) { } // 70-79 try { _Wxi13 = Convert.ToDouble(dat_reader.GetValue(70).ToString()); } catch (FormatException) { } try { ixi_r = Convert.ToDouble(dat_reader.GetValue(71).ToString()); } catch (FormatException) { } try { _Iyz = Convert.ToDouble(dat_reader.GetValue(72).ToString()); } catch (FormatException) { } try { omega_w = Convert.ToDouble(dat_reader.GetValue(73).ToString()); } catch (FormatException) { } try { izf = Convert.ToDouble(dat_reader.GetValue(74).ToString()); } catch (FormatException) { } try { iz1 = Convert.ToDouble(dat_reader.GetValue(75).ToString()); } catch (FormatException) { } try { ipc = Convert.ToDouble(dat_reader.GetValue(76).ToString()); } catch (FormatException) { } try { ay = Convert.ToDouble(dat_reader.GetValue(77).ToString()); } catch (FormatException) { } try { aeta = Convert.ToDouble(dat_reader.GetValue(78).ToString()); } catch (FormatException) { } try { ip = Convert.ToDouble(dat_reader.GetValue(79).ToString()); } catch (FormatException) { } // 80-89 try { ia = Convert.ToDouble(dat_reader.GetValue(80).ToString()); } catch (FormatException) { } try { _Ww1 = Convert.ToDouble(dat_reader.GetValue(81).ToString()); } catch (FormatException) { } try { _Ww2 = Convert.ToDouble(dat_reader.GetValue(82).ToString()); } catch (FormatException) { } try { _Sw3 = Convert.ToDouble(dat_reader.GetValue(83).ToString()); } catch (FormatException) { } try { iw1 = Convert.ToDouble(dat_reader.GetValue(84).ToString()); } catch (FormatException) { } try { k = Convert.ToDouble(dat_reader.GetValue(85).ToString()); } catch (FormatException) { } try { a1 = Convert.ToDouble(dat_reader.GetValue(86).ToString()); } catch (FormatException) { } try { tg_fi = Convert.ToDouble(dat_reader.GetValue(87).ToString()); } catch (FormatException) { } try { cy1 = Convert.ToDouble(dat_reader.GetValue(88).ToString()); } catch (FormatException) { } try { ty1 = Convert.ToDouble(dat_reader.GetValue(89).ToString()); } catch (FormatException) { } // 90-99 try { cz1 = Convert.ToDouble(dat_reader.GetValue(90).ToString()); } catch (FormatException) { } try { tz1 = Convert.ToDouble(dat_reader.GetValue(91).ToString()); } catch (FormatException) { } try { cy2 = Convert.ToDouble(dat_reader.GetValue(92).ToString()); } catch (FormatException) { } try { ty2 = Convert.ToDouble(dat_reader.GetValue(93).ToString()); } catch (FormatException) { } try { cz2 = Convert.ToDouble(dat_reader.GetValue(94).ToString()); } catch (FormatException) { } try { tz2 = Convert.ToDouble(dat_reader.GetValue(95).ToString()); } catch (FormatException) { } #endregion } } catch (FormatException) { } #endregion // Data from Form: EN1993-1-1MessageBoxes.cs this.item3_check = item3; this.item4_check = item4; this.item5_check = item5; this.item6_check = item6; }
// Display the result set recursively expanding chapterDepth deep public void DisplayReader(OleDbDataReader myDataReader, ref uint count, uint alignment, int chapterDepth) { try { // compute alignment StringBuilder indent = new StringBuilder((int) alignment); indent.Append(' ', (int) alignment); while (myDataReader.Read()) { // add alignment StringBuilder row = new StringBuilder(indent.ToString()); // for all columns for (int i = 0; i < myDataReader.FieldCount; i++) { // null columns if (myDataReader.IsDBNull(i)) { row.Append("NULL;"); } else { //vector columns object[] myArray = myDataReader.GetValue(i) as object[]; if (myArray != null) { DisplayValue(myArray, row); } else { //check for chapter columns from "group on" queries if (myDataReader.GetFieldType(i).ToString() != "System.Data.IDataReader") { //regular columns are displayed here row.Append(myDataReader.GetValue(i)); } else { //for a chapter column type just display the colum name row.Append(myDataReader.GetName(i)); } } row.Append(';'); } } if (chapterDepth >= 0) { this.ScrubberGUIInst.DebugPrint(row.ToString()); count++; } // for each chapter column for (int i = 0; i < myDataReader.FieldCount; i++) { if (myDataReader.GetFieldType(i).ToString() == "System.Data.IDataReader") { OleDbDataReader Reader = myDataReader.GetValue(i) as OleDbDataReader; DisplayReader(Reader, ref count, alignment + 8, chapterDepth - 1); } } } } finally { myDataReader.Close(); myDataReader.Dispose(); } }
// Constructor for searched volunteer position public Position(uint gvid, char gvo_gvp) { // Declarations uint gvoid = 0, gvpid = 0; string position = null, drivercat = null, drivercatdoc = null, drivertrans = null; string query = ""; // Command if (gvo_gvp == 'o') query = string.Format("SELECT gvo_id, gvp_id, gvp_position, gvp_driver_cat, gvp_driver_cat_doc, gvp_driver_trans " + "FROM gfrc_volunteer_position WHERE gvo_id = {0}", gvid); else if (gvo_gvp == 'p') query = string.Format("SELECT gvo_id, gvp_id, gvp_position, gvp_driver_cat, gvp_driver_cat_doc, gvp_driver_trans " + "FROM gfrc_volunteer_position WHERE gvp_id = {0}", gvid); try { using (conn) { conn.Open(); cmd = new OleDbCommand(query, conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { UInt32.TryParse(rdr.GetValue(0).ToString(), out gvoid); UInt32.TryParse(rdr.GetValue(1).ToString(), out gvpid); position = rdr.GetString(2); drivercat = rdr.GetString(3); drivercatdoc = rdr.GetString(4); drivertrans = rdr.GetString(5); } } } catch (Exception e) { string exception = e.ToString(); gvoid = 0; gvpid = 0; position = ""; drivercat = ""; drivercatdoc = ""; drivertrans = ""; } finally { if (rdr != null) rdr.Close(); } if (conn != null) { conn.Close(); } _gvpID = gvpid; _gvoID = gvoid; _Position = position; _DriverCat = drivercat; _DriverCatDoc = drivercatdoc; _DriverTrans = drivertrans; }
private void cmbClientes_SelectedIndexChanged(object sender, EventArgs e) { cmbPaquetes.Items.Clear(); //Limpia el combobox de paquetes //Consulta sql consulta = "SELECT Numero FROM Paquetes WHERE Cliente = " + (cmbClientes.SelectedIndex +1); //Se crea el comando cmd = new OleDbCommand(consulta, Con); Con.Open(); //Abre conexión DR = cmd.ExecuteReader(); //Ejectura datareader while (DR.Read()) //Mientras siga leyendo cmbPaquetes.Items.Add(DR.GetValue(0)); //Añado al combobox los datos de la columna que saque de la base de datos Con.Close(); //Cierra conexión }
private void loadCombo1() { string item; comboBox1.Items.Clear(); dat_reader = dat_conn.getDBReader("Select mat_name from ALUMINIUM_32a where id_Aluminium_T32a not in (1,2,3) order by id_Aluminium_T32a"); while (dat_reader.Read()) { item = dat_reader.GetValue(0).ToString(); comboBox1.Items.Add(item); } }
private void Form1_Load(object sender, EventArgs e) { string consulta= "SELECT Nombre from Clientes"; //Crea comando. cmd = new OleDbCommand(consulta, Con); Con.Open(); //Abre conexión DR = cmd.ExecuteReader(); //Ejecuta datareader while (DR.Read()) //Mientras tenga datos por leer { cmbClientes.Items.Add(DR.GetValue(0)); //Añado los nombres al combobox } Con.Close(); //Cierra conexión //Nueva consulta consulta = "SELECT descripcion FROM CatalogoMovimientos"; //Crea comando cmd = new OleDbCommand(consulta, Con); Con.Open(); //Abre conexión DR = cmd.ExecuteReader(); //Ejecutar datareader while (DR.Read()) //Mientras sigan datos por leer QueMov.Add(DR.GetValue(0)); //Se añaden las descripciones de los movimientos Con.Close(); //Cierra conexión }
//loading of combobox1 //data from mat_name from table STEEL in database //loading all elements from column mat_num except 0,1,List_name,Unit private void loadCombo1() { string item; comboBox1.Items.Clear(); dat_reader = dat_conn.getDBReader("Select mat_name from Steel where id_steel not in (1,2,3) order by id_steel"); // if cell type is text - string '2' while (dat_reader.Read()) { item = dat_reader.GetValue(0).ToString(); comboBox1.Items.Add(item); } }
public Vector<vQualification> listQualifications(uint gvoid) { // Declarations Vector<vQualification> quals = new Vector<vQualification>(); uint gvqid = 0; string qualification = null; vQualification input = new vQualification(); // Command string query = string.Format("SELECT gvq_id, gvq_qual " + "FROM gfrc_volunteer_qualification WHERE gvo_id = {0}", gvoid); try { using (conn) { conn.Open(); cmd = new OleDbCommand(query, conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { if (!UInt32.TryParse(rdr.GetValue(0).ToString(), out gvqid)) gvqid = 0; qualification = rdr.GetString(1); if (gvqid != 0) { input = new vQualification(gvqid, gvoid, qualification); quals.Add(input); } } } } finally { if (rdr != null) rdr.Close(); } if (conn != null) { conn.Close(); } return quals; }
public string loginProperty(string x) { openConnection(); string value = ""; rder = new OleDbCommand("SELECT IDENTITY FROM UserIds WHERE USERID='" + x + "'", con); dr = rder.ExecuteReader(); while (dr.Read()) { value = dr.GetValue(0).ToString(); } con.Close(); Console.WriteLine("Value :" + value); return value; }
private DataSet ConvertDataReaderToDataSet(OleDbDataReader reader) { DataSet dataSet = new DataSet(); DataTable schemaTable = reader.GetSchemaTable(); DataTable dataTable = new DataTable(); for (int cntr = 0; cntr < schemaTable.Rows.Count; ++cntr) { DataRow dataRow = schemaTable.Rows[cntr]; string columnName = dataRow["ColumnName"].ToString(); DataColumn column = new DataColumn(columnName, dataRow["ColumnName"].GetType()); dataTable.Columns.Add(column); } while (reader.Read()) { DataRow dataRow = dataTable.NewRow(); for (int cntr = 0; cntr < reader.FieldCount; ++cntr) { dataRow[cntr] = reader.GetValue(cntr); } dataTable.Rows.Add(dataRow); } dataSet.Tables.Add(dataTable); return dataSet; }
public Vector<Holiday> listHolidays(uint gvoid) { // Declarations Vector<Holiday> quals = new Vector<Holiday>(); uint gvhid = 0, modifiedby = 0; DateTime datemodified = new DateTime(1901, 1, 1), start = new DateTime(1901, 1, 1), end = new DateTime(1901, 1, 1); Holiday input = new Holiday(); // Declarations // Command string query = string.Format("SELECT gvh_id, gvh_start, gvh_end, date_modified, modified_by " + "FROM gfrc_volunteer_holiday WHERE gvo_id = {0}", gvoid); try { using (conn) { conn.Open(); cmd = new OleDbCommand(query, conn); rdr = cmd.ExecuteReader(); while (rdr.Read()) { if (UInt32.TryParse(rdr.GetValue(0).ToString(), out gvhid)) { start = rdr.GetDateTime(1); if (!DateTime.TryParse(rdr.GetValue(2).ToString(), out end)) end = new DateTime(1901, 1, 1); if (!DateTime.TryParse(rdr.GetValue(14).ToString(), out datemodified)) datemodified = new DateTime(1901, 1, 1); if (!UInt32.TryParse(rdr.GetValue(15).ToString(), out modifiedby)) modifiedby = 0; input = new Holiday(gvhid, gvoid, start, end, datemodified, modifiedby); quals.Add(input); } } } } finally { if (rdr != null) rdr.Close(); } if (conn != null) { conn.Close(); } return quals; }
private bool IsEmptyRow(OleDbDataReader dataReader) { bool empty = true; for (int i = 0; i < dataReader.FieldCount; i++) { if (dataReader.GetValue(i).ToString() != "") { empty = false; break; } } return empty; }
public CMat_02_00(string combo1) { m_sMatType = 2; string sql1; sql1 = "Select mat_num, mat_name, mat_prod_code_num, mat_prod_code_name1, mat_prod_code_name2, concrete_grade_num, fck, fck_cube, fctm, fcm, fctk0_05, fctk0_95, epsilon_c1, epsilon_cu1, epsilon_c2, epsilon_cu2, epsilon_c3, epsilon_cu3, n, gamaMc, Ecm, Ec, G, nu_pois, alpha_temp from Concrete where mat_name like '" + combo1 + "'"; // Database DATA-CONCRETE variables reader dat_conn = DatabaseConnection.getInstance(); dat_reader = dat_conn.getDBReader(sql1); try { while (dat_reader.Read()) { // CONCRETE DATABASE DATA #region Data list try { mat_num = Convert.ToInt16(dat_reader.GetValue(0).ToString()); } catch (FormatException) { } try { mat_name = dat_reader.GetValue(1).ToString(); } catch (FormatException) { } try { mat_prod_code_num = Convert.ToInt16(dat_reader.GetValue(2).ToString()); } catch (FormatException) { } try { mat_prod_code_name1 = dat_reader.GetValue(3).ToString(); } catch (FormatException) { } try { mat_prod_code_name2 = dat_reader.GetValue(4).ToString(); } catch (FormatException) { } try { concrete_grade_num = Convert.ToInt32(dat_reader.GetValue(5).ToString()); } catch (FormatException) { } try { fck = Convert.ToDouble(dat_reader.GetValue(6).ToString()); } catch (FormatException) { } try { fck_cube = Convert.ToDouble(dat_reader.GetValue(7).ToString()); } catch (FormatException) { } try { fctm = Convert.ToDouble(dat_reader.GetValue(8).ToString()); } catch (FormatException) { } try { fcm = Convert.ToDouble(dat_reader.GetValue(9).ToString()); } catch (FormatException) { } try { fctk0_05 = Convert.ToDouble(dat_reader.GetValue(10).ToString()); } catch (FormatException) { } try { fctk0_95 = Convert.ToDouble(dat_reader.GetValue(11).ToString()); } catch (FormatException) { } try { epsilon_c1 = Convert.ToDouble(dat_reader.GetValue(12).ToString()); } catch (FormatException) { } try { epsilon_cu1 = Convert.ToDouble(dat_reader.GetValue(13).ToString()); } catch (FormatException) { } try { epsilon_c2 = Convert.ToDouble(dat_reader.GetValue(14).ToString()); } catch (FormatException) { } try { epsilon_cu2 = Convert.ToDouble(dat_reader.GetValue(15).ToString()); } catch (FormatException) { } try { epsilon_c3 = Convert.ToDouble(dat_reader.GetValue(16).ToString()); } catch (FormatException) { } try { epsilon_cu3 = Convert.ToDouble(dat_reader.GetValue(17).ToString()); } catch (FormatException) { } try { d_n = Convert.ToDouble(dat_reader.GetValue(18).ToString()); } catch (FormatException) { } try { d_gamaMc = Convert.ToDouble(dat_reader.GetValue(19).ToString()); } catch (FormatException) { } try { d_Ecm = Convert.ToDouble(dat_reader.GetValue(20).ToString()); } catch (FormatException) { } try { d_Ec = Convert.ToDouble(dat_reader.GetValue(21).ToString()); } catch (FormatException) { } try { d_G = Convert.ToDouble(dat_reader.GetValue(22).ToString()); } catch (FormatException) { } try { d_nu_pois = Convert.ToDouble(dat_reader.GetValue(23).ToString()); } catch (FormatException) { } try { d_alpha_temp = Convert.ToDouble(dat_reader.GetValue(24).ToString()); } catch (FormatException) { } #endregion } } catch (FormatException) { } }
//loading of combobox2 //data from column csprof_name from table Sections in database private void loadCombo2() { string item; comboBox2.Items.Clear(); dat_reader = dat_conn.getDBReader("Select csprof_name from Sections where id_sections not in (1,2,3) order by id_sections");//,3,24,43,62,80,105,130,155,180,222,278)"); while (dat_reader.Read()) { item = dat_reader.GetValue(0).ToString(); comboBox2.Items.Add(item); } }