protected override TreeNode AddNodeItem(TreeNode aTn, OleDbDataReader aReader, ref int aSI) { /// В pSQLString должен быть определен примерно такой select: /// ... /// SELECT /// refCode, refBName, 1, ... /// FROM /// rbRef /// ... TreeNode ntn = new TreeNode(aReader.GetString(1)); PCTVItemData tid = new PCTVItemData(); ntn.Tag = tid; tid.pPC.code = aReader.GetInt32(0); /// Added M.Tor 25.06.2008: tid.pText = aReader.GetString(1); if (aReader.GetInt32(2) > 0) ntn.Nodes.Add(new TreeNode()); if (aTn == null) { Nodes.Add(ntn); tid.pPath = tid.pCode.ToString(); } else { aTn.Nodes.Add(ntn); tid.pPath = ((PCTVItemData)aTn.Tag).pPath + pPathDelim + tid.pCode; } aSI = 3; return ntn; }
public void Initialise() { string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=phonebook.accdb"; OleDbConnection conn = new OleDbConnection(connectionString); string sql = "SELECT * FROM task ORDER BY id"; OleDbCommand cmd = new OleDbCommand(sql, conn); try { conn.Open(); reader = cmd.ExecuteReader(); reader.Read(); lblTask.Text = reader.GetString(1).ToString(); txtTask.Text = reader.GetString(2).ToString(); reader.Close(); conn.Close(); } catch { //MessageBox.Show(e.Message); } }
// 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; }
public Advertisement(OleDbDataReader reader) { this.StrId = reader.GetString(0); if (!reader.IsDBNull(1)) this.IntType = reader.GetInt32(1); else this.IntType = 3; if (!reader.IsDBNull(2)) this.StrContent = reader.GetString(2); else this.StrContent = ""; }
public Form_Update(OleDbDataReader oddr) { InitializeComponent(); connector = new DBconnector(); while (oddr.Read()) { tb_Name.Text = oddr.GetString(0); tb_Desc.Text = oddr.GetString(2); tb_Seq.Text = oddr.GetString(3); } }
public Form1() { InitializeComponent(); PC.list = new List<PC>(); PC.total = new List<PC>(); data.Columns.Add("Id", "Id"); data.Columns.Add("PC", "PC"); data.Columns.Add("Inicio", "Inicio"); data.Columns.Add("Tiempo", "Tiempo"); data.Columns.Add("Total", "Total"); data.Columns[3].Width = 130; data.Columns[3].Width = 130; r = MSAConnection.read("select * from item"); while (r.Read()) { String d = ""; PC p = new PC(); p.id = r.GetInt32(0); p.precio = r.GetInt32(2); if (!r.IsDBNull(3)) { //d = r.GetDateTime(3).ToString(); DateTime x = r.GetDateTime(3); d = x.Hour + ":" + x.Minute + ":" + x.Second; p.inicio = r.GetDateTime(3); PC.list.Add(p); } PC.total.Add(p); data.Rows.Add(r.GetInt32(0), r.GetString(1), d); } // MessageBox.Show(PC.total.Count + ""); thetimer.Start(); }
public Coupon(OleDbDataReader reader) { this.StrId = reader.GetString(0); if (!reader.IsDBNull(1)) this.StrSmallImg = reader.GetString(1); else this.strSmallImg = ""; if (!reader.IsDBNull(2)) this.StrLargeImg = reader.GetString(2); else this.StrLargeImg = ""; if (!reader.IsDBNull(3)) this.StrPrintImg = reader.GetString(3); else this.StrPrintImg = ""; }
public static void consultaUmLivro() { String aux = "select * from TabLivro where codigo ='" + Livro.getCodigo() + "'"; conecta(); strSQL = new OleDbCommand(aux, conn); result = strSQL.ExecuteReader(); Erro.setErro(false); if (result.Read()) { Livro.setTitulo(result.GetString(1)); Livro.setAutor(result.GetString(2)); Livro.setEditora(result.GetString(3)); Livro.setAno(result.GetString(4)); } else Erro.setMsg("Livro não cadastrado."); desconecta(); }
// // Validar o Utilizador que se ligou ao servidor // nome: O Nome de Utilizador // pass: Password // // Retorna: true se o utilizador foi encontrado na Base de Dados e se a password estava correcta // false se o utilizador não existe ou a password estava incorrecta // public bool ValidarUtilizador(String nome, String pass) { try { OleDbCommand cmdSQL = LigacaoBD.CreateCommand(); cmdSQL.CommandText = "SELECT * FROM tabela_utilizadores_src"; LeitorBD = cmdSQL.ExecuteReader(); while (LeitorBD.Read()) { if (LeitorBD.GetString(0) == nome && LeitorBD.GetString(1) == pass) { return true; } } } catch (OleDbException) { } return false; }
public Kontaktdaten() { InitializeComponent(); try { dBVerbindung = new OleDbConnection(verbindungsstring); dBVerbindung.Open(); offen = true; befehl = dBVerbindung.CreateCommand(); //Übersicht (DataGHridView) anzeigen befehl.CommandText = "select * from Kontakte;"; datenleser = befehl.ExecuteReader(); int row = 0; while (datenleser.Read()) { //leere zeile hinzufügen string[] row_init = { "", "", "", "", "" }; dataGridViewKontakte.Rows.Add(row_init); //GridView füllen dataGridViewKontakte.Rows[row].Cells[0].Value = datenleser.GetInt32(0).ToString(); dataGridViewKontakte.Rows[row].Cells[1].Value = datenleser.GetString(1); dataGridViewKontakte.Rows[row].Cells[2].Value = datenleser.GetString(2); dataGridViewKontakte.Rows[row].Cells[3].Value = datenleser.GetString(3); dataGridViewKontakte.Rows[row].Cells[4].Value = datenleser.GetString(4); dataGridViewKontakte.Rows[row].Cells[5].Value = datenleser.GetString(5); row = row + 1; } } catch (Exception ausnahme) { MessageBox.Show("Datenbankfehler: " + ausnahme.Message); } finally { if (offen == true) dBVerbindung.Close(); } }
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? } }
private void SaveColumnValues(OleDb.OleDbConnection conn, List <string> indexNames, ref Dictionary <string, int> dictionary) { //Call ReadColumnNames first! int indexNumber = 0; //just making sure column names are populated if (indexNames.Count() == 0) { return; } foreach (string index in indexNames) { //no need to prepare this command OleDb.OleDbCommand selectAll = new OleDb.OleDbCommand("SELECT `" + index + "` FROM `Sheet1$`", conn); try { OleDb.OleDbDataReader reader = selectAll.ExecuteReader(); while (reader.Read()) { //potentially throws invalid cast exception (null) if (!reader.IsDBNull(0)) { string word = reader.GetString(0); //clean word string cleanWord = Globals.ThisAddIn.HighlightManager.CleanWord(word); //save word if (Globals.ThisAddIn.HighlightManager.CanAddToDictionary(cleanWord)) { dictionary.Add(cleanWord, indexNumber); } } } reader.Close(); } catch (OleDb.OleDbException) { Forms.MessageBox.Show(Strings.error, Strings.errorCaption); } indexNumber++; } }
// 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 String ExecutaComando(string comandoSql) { StringBuilder lido = new StringBuilder(); cmd.CommandText = comandoSql; try { using (leitor = cmd.ExecuteReader()) { while (leitor.Read()) { lido.Append(leitor.GetString(0)); } } } finally { if (leitor != null) leitor.Close(); } return lido.ToString(); }
private static Penerbit MappingDtrToObject(OleDbDataReader dtr) { Penerbit penerbit = new Penerbit(); penerbit.PenerbitID = dtr[0] is DBNull ? 0 : dtr.GetInt32(0); penerbit.Nama = dtr[1] is DBNull ? string.Empty : dtr.GetString(1); return penerbit; }
private void Username_TextChanged(object sender, EventArgs e) { btnDelete.Enabled = true; btnUpdate_record.Enabled = true; try { txtUsername.Text = txtUsername.Text.TrimEnd(); con = new OleDbConnection(cs); con.Open(); cmd = con.CreateCommand(); cmd.CommandText = "SELECT username,user_password,nameofuser,contactno,email FROM registration WHERE username = '******'"; rdr = cmd.ExecuteReader(); if (rdr.Read()) { txtPassword.Text = (rdr.GetString(1).Trim()); txtName.Text = (rdr.GetString(2).Trim()); txtContact_no.Text = (rdr.GetString(3).Trim()); txtEmail_Address.Text = (rdr.GetString(4).Trim()); } if ((rdr != null)) { rdr.Close(); } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void GetPhotoData(string strLocation) { try { //Open our connection, provided that it isn't already open if (oleDbConnection1.State != ConnectionState.Open) { oleDbConnection1.Open(); } //Find out how many photos in our DB correspond to the selected location. m_intPhotoCount = GetPhotoCount(strLocation); //store m_intPhotoCount in a Session variable Session["s_intPhotoCount"] = m_intPhotoCount; //Use that value to size our TravelInfo array. if (m_intPhotoCount == 0) { //Exit this function if the PhotoCount query returned 0 results Console.WriteLine("PhotoCount returned 0 results. Please investigate."); return; } m_strTravelInfo = new string[m_intPhotoCount, 3]; //Initialize the location parameter to our GetPhotoInfoByLocation ADO Command Object oleDbCommandGetPhotoInfoByLocation = new OleDbCommand("GetPhotoInfoByLocation_sp", oleDbConnection1); oleDbCommandGetPhotoInfoByLocation.CommandType = CommandType.StoredProcedure; oleDbCommandGetPhotoInfoByLocation.Parameters.Clear(); oleDbCommandGetPhotoInfoByLocation.Parameters.Add("@Location", OleDbType.VarChar, 25); oleDbCommandGetPhotoInfoByLocation.Parameters["@Location"].Value = strLocation; //Use a DataReader to get the info from our database oleDbDataReader1 = oleDbCommandGetPhotoInfoByLocation.ExecuteReader(CommandBehavior.CloseConnection); int intLoopCounter = 0; //Loop through this data to populate our TravelInfo array. while (oleDbDataReader1.Read() == true) { m_strTravelInfo[intLoopCounter, 0] = oleDbDataReader1.GetString(0); //Filename m_strTravelInfo[intLoopCounter, 1] = oleDbDataReader1.GetString(1); //Caption m_strTravelInfo[intLoopCounter, 2] = oleDbDataReader1.GetString(2); //TravelDate intLoopCounter++; } oleDbDataReader1.Close(); //Display the first photo from our collection matching this location. m_intCurrentIndex = 0; //Store m_intCurrentIndex in a Session variable Session["s_intCurrentIndex"] = m_intCurrentIndex; //store the array in a Session object Session["s_strTravelInfo"] = m_strTravelInfo; } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { oleDbConnection1.Close(); } }
// 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; }
internal static List<User> searchUsers(string key) { List<User> list = new List<User>(); try { cmd = new OleDbCommand("SELECT * FROM Users WHERE Username LIKE '%" + key + "%';", conn); reader = cmd.ExecuteReader(); while (reader.Read()) { User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10)); list.Add(u); } return list; } catch (Exception e) { MessageBox.Show("Error getting usersList in searchUsers: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return null; } }
internal static List<User> GetUsers() { List<User> usersList = new List<User>(); try { cmd = new OleDbCommand("SELECT * FROM Users ORDER BY ID;", conn); reader = cmd.ExecuteReader(); while (reader.Read()) { User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10)); usersList.Add(u); } reader.Close(); return usersList; } catch (Exception e) { MessageBox.Show("Error getting usersList: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return null; } }
protected List<DBItem> GetVotesQueryCallback(OleDbDataReader reader) { List<DBItem> returnList = new List<DBItem> { }; if (reader.HasRows) { while (reader.Read()) { DBItem item = new DBItem(); item.Votes = reader.GetString(reader.GetOrdinal("Votes")); returnList.Add(item); } } return returnList; }
internal static List<string> getFoodTypes() { List<string> foodTypeList = new List<string>(); try { cmd = new OleDbCommand("SELECT DISTINCT FoodType FROM FoodList;", conn); reader = cmd.ExecuteReader(); while (reader.Read()) { foodTypeList.Add(reader.GetString(0)); } } catch (Exception ee) { reader.Close(); MessageBox.Show("getFoodTypes() error: " + ee.ToString()); } reader.Close(); return foodTypeList; }
//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 Result getUserInfo(string username) { Result r = new Result(); try { cmd = new OleDbCommand("SELECT * FROM Users WHERE Username = ?;", conn); cmd.Parameters.Add("Username", OleDbType.VarChar).Value = username; reader = cmd.ExecuteReader(); if (reader.Read()) { User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10)); r.user = u; r.success = true; } return r; } catch (Exception e) { MessageBox.Show("Error getting userInfo: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return null; } }
private static Buku MappingDtrToObject(OleDbDataReader dtr) { Buku buku = new Buku(); buku.ISBN = dtr[0] is DBNull ? string.Empty : dtr.GetString(0); buku.Judul = dtr[1] is DBNull ? string.Empty : dtr.GetString(1); buku.Edisi = dtr[2] is DBNull ? string.Empty : dtr.GetString(2); buku.Bahasa = dtr[3] is DBNull ? string.Empty : dtr.GetString(3); buku.Penerbit.Nama = dtr[4] is DBNull ? string.Empty : dtr.GetString(4); return buku; }
protected List<DBItem> GetSubmissionsQueryCallback(OleDbDataReader reader) { List<DBItem> returnList = new List<DBItem>(); if (reader.HasRows) { while (reader.Read()) { DBItem item = new DBItem(); item.ID = reader.GetInt32(reader.GetOrdinal("ID")); item.User = reader.GetString(reader.GetOrdinal("User")); item.DateTime = reader.GetDateTime(reader.GetOrdinal("DateTime")); item.Person = reader.GetString(reader.GetOrdinal("Person")); item.Rating = reader.GetString(reader.GetOrdinal("Rating")); item.Description = reader.GetString(reader.GetOrdinal("Description")); item.Votes = reader.GetString(reader.GetOrdinal("Votes")); returnList.Add(item); } } return returnList; }
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; }
internal static List<Order> getOrderList() { List<Order> ol = new List<Order>(); try { //IFNULL(SUM(score),'N') cmd = new OleDbCommand("SELECT Orders.UserID, Orders.FoodID, Orders.Quantity, Orders.TotalExpense, Orders.OrderDate, Orders.ReportID, Orders.Status, FoodList.FoodName, Users.Username, Orders.ID FROM (Users INNER JOIN Orders ON Users.ID = Orders.UserID) INNER JOIN FoodList ON Orders.FoodID = FoodList.ID ORDER BY Orders.OrderDate;", conn); reader = cmd.ExecuteReader(); while (reader.Read()) { Order o = new Order(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetDateTime(4), reader.GetInt32(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetInt32(9)); ol.Add(o); } reader.Close(); } catch (Exception ex) { //runs perfectly fine but theres an ERROR. I DONT KNOW WHY --> line 295 (reader.GetInt32(0)) OH NO! MessageBox.Show("getOrderList() error: " + ex.ToString()); } return ol; }
internal static List<Admin> GetAdmins() { List<Admin> adminList = new List<Admin>(); try { cmd = new OleDbCommand("SELECT * FROM Admins ORDER BY ID", conn); reader = cmd.ExecuteReader(); while (reader.Read()) { Admin a = new Admin(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7)); adminList.Add(a); } reader.Close(); return adminList; } catch (Exception e) { MessageBox.Show("Error getting admin list: " + e.Message, "Server Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return null; } }
protected void Page_Load(object sender, EventArgs e) { paramSexo = ""; paramNome = ""; try { paramSexo = Request["RadioButtonList1"]; paramNome = Request["TextBox1"]; if (paramSexo == null) paramSexo = ""; if (paramNome == null) paramNome = ""; } catch(Exception){}; Label1.Text = "Registros encontrados:"; String filtro1 = "", filtro2 = ""; if (paramSexo.Equals("Todos")) { filtro1 = " TRUE "; } else if (paramSexo.Equals("Masculino")) { filtro1 = " (sexo='M') "; } else if (paramSexo.Equals("Feminino")) { filtro1 = " (sexo='F') "; } else { filtro1 = " FALSE "; Label1.Text = ""; } filtro2 = " (nomeprof LIKE '%" + paramNome + "%') "; try { conexao = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/temp/Escola.mdb"); conexao.Open(); string sql = "select * from professores WHERE " + filtro1 + " AND " + filtro2 + " ORDER BY nomeprof"; stm = new OleDbCommand(sql, conexao); dr = stm.ExecuteReader(); String strHTML = ""; if (dr.HasRows) { //mostramos o cabeçalho da <table> somente se temos registros strHTML = "<TABLE name=profs border=1 width='65%'> <TR style='font-size: 14px; font-family: verdana; text-align: center; font-weight: 900; color: #009;'>" + "<TD> Código </TD><TD> Nome </TD>" + "<TD> Sexo </TD><TD> Salário </TD></TR>"; } while (dr.Read()) { int codigo = dr.GetInt16(0); //codprof String nome = dr.GetString(1); //nome String sexo = dr.GetString(2); //sexo float salario = dr.GetFloat(3); //salário strHTML += "<TR><TD style='font-size: 12px; font-family: verdana; text-align: center;'>" + codigo + "</TD><TD style='font-size: 12px; font-family: verdana; text-align: left;'> " + nome + "</TD><TD style='font-size: 12px; font-family: verdana; text-align: center;'>" + sexo + "</TD><TD style='font-size: 12px; font-family: verdana; text-align: center;'>" + salario + "</TD></TR>"; } strHTML += "</TABLE> <br/><br/><br/>"; LiteralControl lc = new LiteralControl(strHTML); Panel2.Controls.Add(lc); stm.Dispose(); dr.Close(); conexao.Close(); } catch (Exception exc) { Label1.Text = "Erro no processamento do BD - " + exc.Message; } }
///////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////// private string GetNullableString(OleDbDataReader reader, int col) { if (reader.IsDBNull(col) == false) { return reader.GetString(col); } return null; }
internal static List<FoodList> getFoodList() { List<FoodList> fl = new List<FoodList>(); try { cmd = new OleDbCommand("SELECT ID, FoodName, FoodPrice, FoodType FROM FoodList ORDER BY FoodName;", conn); reader = cmd.ExecuteReader(); while (reader.Read()) { FoodList fudList = new FoodList(reader.GetInt32(0).ToString(), reader.GetString(1), reader.GetInt32(2), reader.GetString(3)); fl.Add(fudList); } } catch (Exception ee) { reader.Close(); MessageBox.Show("getFoodList() error: " + ee.ToString()); } reader.Close(); return fl; }