protected void Page_Load(object sender, EventArgs e) { mySelectCommand.CommandType = CommandType.Text; mySelectCommand.CommandText = "SELECT Name, FoodTypeID FROM FoodType ORDER BY Name DESC"; myReader = mySelectCommand.ExecuteReader(); bool notEoF; //read first row from database notEoF = myReader.Read(); //read row by row until the last row if (ddlCategory.Items.Count == 0) { ddlCategory.Items.Add("All Categories"); while (notEoF) { ddlCategory.Items.Add(myReader["Name"].ToString()); ddlCategory.Items[ddlCategory.Items.Count - 1].Value = myReader["FoodTypeID"].ToString(); notEoF = myReader.Read(); } } myReader.Close(); if(!Page.IsPostBack) { getDB(); } }
public void loadData() { try { lvexaminee.Items.Clear(); //OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=db.accdb"); conn.Open(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM examineetbl", conn); OleDbDataReader dr; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { lvexaminee.Items.Add(dr[0].ToString()); lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[1].ToString()); lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[2].ToString()); lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[3].ToString()); lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[4].ToString()); lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[8].ToString()); } } dr.Close(); conn.Close(); } catch (OleDbException ex) { MessageBox.Show(ex.Message); throw; } }
protected void Page_Load(object sender, EventArgs e) { objBD = new bd(); objUtils = new utils(); rsRedes = objBD.ExecutaSQL("SELECT REP_CIDADE, REP_UF FROM RedesParticipantes where REP_ATIVO = 1"); if (rsRedes == null) { throw new Exception(); } if (rsRedes.HasRows) { int contador = 1; while (rsRedes.Read()) { if (contador % 2 == 0) { listadireita.InnerHtml += "<li>" + rsRedes["REP_CIDADE"] + " - " + rsRedes["REP_UF"] + "</li>"; } else { listaesquerda.InnerHtml += "<li>" + rsRedes["REP_CIDADE"] + " - " + rsRedes["REP_UF"] + "</li>"; } contador++; } } }
/// <summary> Creates and writes source code for all Messages and Groups.</summary> public static void makeAll(System.String baseDirectory, System.String version) { //get list of messages ... using (System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection) { System.String sql = getMessageListQuery(version); System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = sql; System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); System.Collections.ArrayList messages = new System.Collections.ArrayList(); System.Collections.ArrayList chapters = new System.Collections.ArrayList(); while (rs.Read()) { messages.Add(System.Convert.ToString(rs[1 - 1])); chapters.Add(System.Convert.ToString(rs[2 - 1])); } rs.Close(); NormativeDatabase.Instance.returnConnection(conn); if (messages.Count == 0) { log.Warn("No version " + version + " messages found in database " + conn.Database); } for (int i = 0; i < messages.Count; i++) { make((System.String)messages[i], baseDirectory, (System.String)chapters[i], version); } } }
public void PopulaTela() { rsListar = objBD.ExecutaSQL("EXEC site_psCriacaoDocumentadasPorID '" + Request["CDO_ID"] + "' "); if (rsListar == null) { throw new Exception(); } if (rsListar.HasRows) { rsListar.Read(); CDO_ID.Attributes.Add("value", Request["CDO_ID"].ToString()); titu_criacoes.InnerHtml = objUtils.RemoveHTML(rsListar["CDO_TAREFA"].ToString()); criador.InnerHtml = rsListar["ADM_NOME"].ToString(); data.InnerHtml = rsListar["CDO_DATA"].ToString(); box_descritivo.InnerHtml = rsListar["CDO_DESCRITIVO"].ToString(); video_criacoes.Attributes.Add("src", "https://www.youtube.com/embed/" + rsListar["CDO_VIDEO"].ToString()); // aRelato.Attributes.Add("href", "/enviar-relato.aspx?CDO_ID=" + Request["CDO_ID"] + ""); relato_detalhe.InnerHtml = "<strong>" + rsListar["TOTAL_RELATOS"].ToString() + " Relatos Enviados</strong>"; totalComentarios.InnerHtml = rsListar["TOTAL_COMENTARIOS"].ToString() + " Comentário"; if (Convert.ToInt16(rsListar["TOTAL_COMENTARIOS"]) > 1) { totalComentarios.InnerHtml += "s"; } } else { Response.Redirect("/criacoes-documentadas"); } rsListar.Close(); rsListar.Dispose(); }
private void Disciplines_Load(object sender, EventArgs e) { //dataGridView1.DataSource = MainForm.FunctionOfAdding(nameoftable); var data1 = new List <Dvapolya>(); Date_baseone = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb"); Date_baseone.Open(); dabse.OleDbCommand com1 = new dabse.OleDbCommand("Select Название, Шифр FROM Специальности", Date_baseone); dabse.OleDbDataReader resulter1 = com1.ExecuteReader(); while (resulter1.Read() == true) { var mc = new Dvapolya { secondpole = resulter1[0].ToString().Trim(), firstpole = resulter1[1].ToString().Trim() }; data1.Add(mc); } comboBox1.DataSource = data1; comboBox1.DisplayMember = "secondpole"; comboBox1.ValueMember = "firstpole"; }
/// <summary> /// Connect to user meal database and finds record for current user. If current user does not exist, creates a generic record for user in db. /// </summary> private void ConnectToDb() { conn = new OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= userMeals.mdb;"; try { conn.Open(); cmd = new OleDbCommand(selectString, conn); reader = cmd.ExecuteReader(); //Reads all records into two lists, one with users, the other with the user meals. Each index corresponds 1 to 1. while(reader.Read()) { customMealProfiles.Add(reader["UserName"].ToString()); customMeals.Add(new CustomMeals(reader["Meal 1"].ToString(), reader["Meal 2"].ToString(), reader["Meal 3"].ToString(), reader["Meal 4"].ToString(), reader["Meal 5"].ToString(), reader["Meal 6"].ToString(), reader["Meal 7"].ToString(), reader["Meal 8"].ToString(), reader["Meal 9"].ToString(), reader["Meal 10"].ToString())); } //Is user does not exist, creates generic record for user in db. if(!customMealProfiles.Contains(CurrentUser)) { string insertString = "INSERT INTO userMeals ([UserName],[Meal 1],[Meal 2],[Meal 3],[Meal 4],[Meal 5],[Meal 6],[Meal 7],[Meal 8],[Meal 9],[Meal 10]) VALUES (@User, @Meal1, @meal2, @meal3, @meal4, @meal5, @meal6, @meal7, @meal8, @meal9, @meal10)"; cmd = new OleDbCommand(insertString, conn); cmd.Parameters.AddWithValue("@User", CurrentUser); cmd.Parameters.AddWithValue("@Meal1", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal2", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal3", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal4", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal5", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal6", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal7", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal8", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal9", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.Parameters.AddWithValue("@Meal10", "Combo #1 $5.29;Spicy Dog $1.99"); cmd.ExecuteNonQuery(); } else { int index = customMealProfiles.IndexOf(CurrentUser); meals = new List<string>(); meals.Add(customMeals.ElementAt(index).Meal1); meals.Add(customMeals.ElementAt(index).Meal2); meals.Add(customMeals.ElementAt(index).Meal3); meals.Add(customMeals.ElementAt(index).Meal4); meals.Add(customMeals.ElementAt(index).Meal5); meals.Add(customMeals.ElementAt(index).Meal6); meals.Add(customMeals.ElementAt(index).Meal7); meals.Add(customMeals.ElementAt(index).Meal8); meals.Add(customMeals.ElementAt(index).Meal9); meals.Add(customMeals.ElementAt(index).Meal10); } } catch(Exception ex) { MessageBox.Show("Error encounters. Error message as follows: " + ex.Message); } finally { conn.Close(); } }
// column1 column2 column3 // **** *** ***** // ** *** // If inserting into column 2, we are inserting into an existing row // if inserting into column 1 or 3, we are creating a new row private bool ShouldInsertIntoNewRow(OleDb.OleDbConnection conn, string columnName) { OleDb.OleDbCommand command = new OleDb.OleDbCommand(); command.Connection = conn; command.CommandText = "SELECT TOP 1 * FROM `Sheet1$` WHERE `" + columnName + "` IS NULL"; int ct = 0; try { OleDb.OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { ct++; } reader.Close(); } catch (OleDb.OleDbException) { Forms.MessageBox.Show(Strings.error, Strings.errorCaption); } if (ct > 0) { return(false); } else { return(true); } }
/// <summary> /// Boundingbox of dataset /// </summary> /// <returns>boundingbox</returns> public GeoAPI.Geometries.IEnvelope GetExtents() { GeoAPI.Geometries.IEnvelope box = null; using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString)) { string strSQL = "Select Min(" + this.XColumn + ") as MinX, Min(" + this.YColumn + ") As MinY, " + "Max(" + this.XColumn + ") As MaxX, Max(" + this.YColumn + ") As MaxY FROM " + this.Table; if (!String.IsNullOrEmpty(_defintionQuery)) //If a definition query has been specified, add this as a filter on the query { strSQL += " WHERE " + _defintionQuery; } using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn)) { conn.Open(); using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader()) { if (dr.Read()) { //If the read row is OK, create a point geometry from the XColumn and YColumn and return it if (dr[0] != DBNull.Value && dr[1] != DBNull.Value && dr[2] != DBNull.Value && dr[3] != DBNull.Value) { box = SharpMap.Converters.Geometries.GeometryFactory.CreateEnvelope((double)dr[0], (double)dr[1], (double)dr[2], (double)dr[3]); } } } conn.Close(); } } return(box); }
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); } }
private System.Data.DataTable createTable(System.Data.DataTable mpTBLFIELD) { mpTBLFIELD = new DataTable(); if (mlDDLREPORTNAME.SelectedItem.Value != "InvDeliverySummary.rdlc") { mlSQLTEMP = "SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'INV_DELIVERY_STATUS_BRANCH'"; } else { mlSQLTEMP = "SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'INV_DELIVERY_STATUS'"; } mlRSTEMP = mlOBJGS.DbRecordset(mlSQLTEMP, "PB", mlCOMPANYID); if (mlRSTEMP.HasRows) { //mlDATAROW = mpTBLFIELD.NewRow(); mlDCOL = new DataColumn("CHECK", typeof(System.Boolean)); mlDCOL.DefaultValue = false; mpTBLFIELD.Columns.Add(mlDCOL); while (mlRSTEMP.Read()) { if (mlRSTEMP["DATA_TYPE"].ToString() == "varchar" || mlRSTEMP["DATA_TYPE"].ToString() == "nvarchar" || mlRSTEMP["DATA_TYPE"].ToString() == "char" || mlRSTEMP["DATA_TYPE"].ToString() == "nchar" || mlRSTEMP["DATA_TYPE"].ToString() == "ntext") { mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.String)); mlDCOL.DefaultValue = ""; } else if (mlRSTEMP["DATA_TYPE"].ToString() == "decimal" || mlRSTEMP["DATA_TYPE"].ToString() == "numeric" || mlRSTEMP["DATA_TYPE"].ToString() == "float") { mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.Decimal)); mlDCOL.DefaultValue = 0; } else if (mlRSTEMP["DATA_TYPE"].ToString() == "bigint" || mlRSTEMP["DATA_TYPE"].ToString() == "int" || mlRSTEMP["DATA_TYPE"].ToString() == "smallint") { mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.Int64)); mlDCOL.DefaultValue = 0; } else if (mlRSTEMP["DATA_TYPE"].ToString() == "tinyint") { mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.Boolean)); mlDCOL.DefaultValue = 0; } else if (mlRSTEMP["DATA_TYPE"].ToString() == "datetime" || mlRSTEMP["DATA_TYPE"].ToString() == "smalldatetime" || mlRSTEMP["DATA_TYPE"].ToString() == "timestamp") { mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.DateTime)); mlDCOL.DefaultValue = DateTime.Now; } if (!string.IsNullOrEmpty(mlRSTEMP["DATA_TYPE"].ToString())) { mpTBLFIELD.Columns.Add(mlDCOL); //mlDATAROW[mlRSTEMP["COLUMN_NAME"].ToString()] = mlDCOL.DefaultValue; } } //mpTBLFIELD.Rows.Add(mlDATAROW); } return(mpTBLFIELD); }
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); }
protected void Button2_Click(object sender, EventArgs e) { string s_add, r_add, message, heading,muid; s_add = Session["us_name"].ToString(); r_add = TextBox1.Text; heading = TextBox3.Text; message = TextBox2.Text; rec_mail te = new rec_mail(); conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail"); conn.Open(); cmd = new OleDbCommand("insert into messages values(m_id.nextval,'" + heading + "','" + message + "'," + file_name + "',sysdate,sysdate,'Draft')", conn); dr = cmd.ExecuteReader(); cmd = new OleDbCommand("insert into mail_exchange values('" + s_add + "',m_id.currval,sysdate,sysdate,'" + r_add + "')", conn); dr = cmd.ExecuteReader(); cmd = new OleDbCommand("insert into draft values(m_id.currval)", conn); dr = cmd.ExecuteReader(); dr.Close(); cmd = new OleDbCommand("select m_id.currval from dual", conn); dr = cmd.ExecuteReader(); dr.Read(); muid = dr[0].ToString(); dr.Close(); conn.Close(); Label1.Text = "Message Saved. Your message id is " + muid; Label1.Visible = true; dr.Close(); conn.Close(); }
public void SimpleValue() { try { BeginCase("check simple value"); //prepare data base.PrepareDataForTesting(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString); con = new OleDbConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString); con.Open(); cmd = new OleDbCommand("Select BirthDate From Employees where EmployeeID = 100", con); rdr = cmd.ExecuteReader(); rdr.Read(); DateTime dt = rdr.GetDateTime(0); //will be 1988-May-31 15:33:44 Compare(dt,new DateTime(1988,5,31,15,33,44,00)); } catch(Exception ex) { exp = ex; } finally { if (rdr != null && !rdr.IsClosed) { rdr.Close(); } if (con != null && con.State != ConnectionState.Closed) { con.Close(); } EndCase(exp); exp = null; } }
public List <string> GetSqlList(String SQLquery) { //make an Oledbcommandobject OleDbCommand cmd = null; //make an Oledbdatareader System.Data.OleDb.OleDbDataReader Reader = null; //connects to the database and catches if there is a problem connecting List <string> sqlViewRequests = new List <string>(); //Initializing list so things can be stored in it cmd = new OleDbCommand(SQLquery, Connection); try { Reader = cmd.ExecuteReader(); while (Reader.Read()) // while there is still information to be read, pull that information out and add it to the list { sqlViewRequests.Add(Convert.ToString((Reader[0]))); //Converting reader output to string } Reader.Close(); } catch (InvalidOperationException) { Connection.Close(); } Reader.Close(); return(sqlViewRequests); }
protected void Button1_Click(object sender, EventArgs e) { string raw,s_add, message, heading,muid; string[] r_add = new string[100]; int i; s_add = Session["us_name"].ToString(); raw = TextBox1.Text; heading = TextBox3.Text; message = TextBox2.Text; r_add=raw.Split(','); rec_mail te = new rec_mail(); conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail"); conn.Open(); if (file_name == null) file_name = "NA"; cmd = new OleDbCommand("insert into messages values(m_id.nextval,'" + heading + "','" + message + "','" + file_name + "',sysdate,sysdate,'delivered')", conn); dr = cmd.ExecuteReader(); dr.Close(); for (i = 0; i < r_add.Length; i++) { cmd = new OleDbCommand("insert into mail_exchange values('" + s_add + "',m_id.currval,sysdate,sysdate,'" + r_add[i].ToString() + "')", conn); dr = cmd.ExecuteReader(); } dr.Close(); cmd = new OleDbCommand("select m_id.currval from dual", conn); dr = cmd.ExecuteReader(); dr.Read(); muid=dr[0].ToString(); dr.Close(); conn.Close(); Label1.Text = "Message Sent. Your message id is " +muid; Label1.Visible = true; }
/// <summary> /// 重写application的内容 /// </summary> public static void reWriteApplication() { ListItem li; BulletedList fulllist = new BulletedList(); newClasses.superConn scnn = new newClasses.superConn("DATA.MDB"); scnn.open(); string _sql = "SELECT * FROM T_SUBMENU WHERE MENU_ENABLE=TRUE ORDER BY MENU_CLASSID,MENU_ORDER DESC"; System.Data.OleDb.OleDbDataReader dr = scnn.GetDataReader(_sql); while (dr.Read()) { li = new ListItem(); li.Text = dr["menu_ttl"].ToString(); li.Value = dr["menu_url"].ToString(); li.Attributes.Add("classid", dr["menu_classid"].ToString());//增加一个classid属性 fulllist.Items.Add(li); } scnn.close(); HttpContext.Current.Application.Lock(); HttpContext.Current.Application["submenu"] = fulllist; HttpContext.Current.Application.UnLock(); }
public void Ultimas() { rsLista = objBD.ExecutaSQL("select top 3 F.FTO_ID, U.USU_NOME, U.USU_USUARIO, FME_MENSAGEM, CONVERT(VARCHAR(10),FME_DH_PUBLICACAO, 103) AS FME_DH_PUBLICACAO, T.FTO_TITULO from ForumMensagem F inner join ForumTopicos T on (T.FTO_ID = F.FTO_ID) inner join Usuario U ON (U.USU_ID = F.USU_ID) where RED_ID = " + Session["redeID"] + " and F.FME_ATIVO = 1 order by F.FME_DH_PUBLICACAO desc"); if (rsLista == null) { throw new Exception(); } if (rsLista.HasRows) { while (rsLista.Read()) { ultimasMensagens.InnerHtml += " <div class=\"txt blog_txt txt_forum\">"; ultimasMensagens.InnerHtml += " <div class=\"txt\">"; ultimasMensagens.InnerHtml += " <a href=\"/forum-lista/" + objUtils.GerarURLAmigavel(rsLista["FTO_TITULO"].ToString()) + "/1\" title=\"" + rsLista["FTO_TITULO"] + "\"><p>" + objUtils.CortarString(true, 100, rsLista["FME_MENSAGEM"].ToString()) + "</p></a>"; ultimasMensagens.InnerHtml += " <p class=\"destque_forum\">Mensagem enviada por: <a href='/perfil/" + rsLista["USU_USUARIO"].ToString() + "' title='" + rsLista["USU_NOME"].ToString() + "'>" + rsLista["USU_NOME"].ToString() + "</a></p>"; ultimasMensagens.InnerHtml += " <p class=\"destque_forum\">Enviada em: <b>" + rsLista["FME_DH_PUBLICACAO"].ToString() + "</b></p>"; ultimasMensagens.InnerHtml += " <p class=\"destque_forum\">Tópico: <b><a href=\"/forum-lista/" + objUtils.GerarURLAmigavel(rsLista["FTO_TITULO"].ToString()) + "/1\" title=\"" + rsLista["FTO_TITULO"] + "\">" + rsLista["FTO_TITULO"].ToString() + "</a></b></p><br /><br />"; ultimasMensagens.InnerHtml += " </div>"; ultimasMensagens.InnerHtml += " </div>"; } } rsLista.Close(); rsLista.Dispose(); }
public void ExcluirFoto() { rs = objBD.ExecutaSQL("select USU_ID, USU_FOTO from Usuario where USU_ID = '" + Session["usuID"] + "' "); if (rs == null) { throw new Exception(); } if (rs.HasRows) { rs.Read(); if (rs["USU_FOTO"].ToString().Length < 1) { Response.Redirect("editar-foto-perfil"); Response.End(); } else { //Excluir a foto fisicamente //File.Delete(Server.MapPath("~/upload/imagens/usuarios/" + rs["USU_FOTO"].ToString())); //File.Delete(Server.MapPath("~/upload/imagens/usuarios/" + rs["USU_FOTO"].ToString().Replace("" + rs["USU_ID"] + "_", ""))); //Excluir a foto do BD; objBD.ExecutaSQL("update Usuario set USU_FOTO = null where USU_ID = '" + Session["usuID"] + "' "); } } //Retornar para a Listagem Response.Redirect("editar-foto-perfil"); Response.End(); }
/// <summary> /// Get result of a Query in String form /// </summary> /// <param name="sqlStatment">The SQL Query</param> /// <returns>Result of Query in a String</returns> public String GetData(String sqlStatment) { string outputString = "null"; try { OpenConection(); cmd = new OleDbCommand(sqlStatment, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader["Deleted"].ToString().Equals("False")) { outputString = reader["Lec_Name"].ToString(); outputString += "$" + reader["Initials"].ToString(); outputString += "$" + reader["Email"].ToString(); outputString += "$" + reader["MaxHours"].ToString(); outputString += "$" + reader["MaxConsecHours"].ToString(); outputString += "$" + reader["MinSlotsPerDay"].ToString(); outputString += "$"; } else { outputString = "N/A"; } } CloseConnection(); } catch { // MessageBox.Show("Failed to get data from source"); } return outputString; }
public List <Person> fillComboBox() //fill Combo { List <Person> personList = new List <Person>(); try { command.CommandText = "SELECT * FROM Tperson"; command.CommandType = CommandType.Text; connection.Open(); System.Data.OleDb.OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { Person p = new Person(); p.Id = Convert.ToInt32(reader["ID"].ToString()); p.FirstName = reader["FirstName"].ToString(); p.LastName = reader["LastName"].ToString(); personList.Add(p); } return(personList); } catch (Exception e) { throw e; } finally { if (connection != null) { connection.Close(); } } }
public tbProdutividadeDTO BuscaPorID(tbProdutividadeDTO prodDTO) { String sSQL = MontaQuery(prodDTO); tbProdutividadeDTO prodAux = new tbProdutividadeDTO(); //tbFabricanteDTO fabri = new tbFabricanteDTO(); //tbFabricanteBLL fabriBLL = new tbFabricanteBLL(); try { conexao = (OleDbConnection)CriaConexaoOleDb(); drOleDb = cria_DataReader_OleDb(sSQL, conexao); while (drOleDb.Read()) { prodAux.idProdutividade = (int)drOleDb["idProdutividade"]; prodAux.dsLinguagem = (string)drOleDb["dsLinguagem"]; prodAux.vlAlta = (float)(double)drOleDb["vlAlta"]; prodAux.vlBaixa = (float)(double)drOleDb["vlBaixa"]; prodAux.vlMedia = (float)(double)drOleDb["vlMedia"]; //tbFabricanteDTO fabriAux = new tbFabricanteDTO(); //fabriAux.idFabricante = (int)drOleDb["idFabricante"]; //prodAux.fabricante = fabriBLL.BuscaPorID(fabriAux); } } catch (SystemException e) { erro = e.Message; } return prodAux; }
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; }
private void SUBMIT_Click(object sender, EventArgs e) { if (DAY.Text != "" ) { com.Connection = con; com.CommandText = "select * from MCA1 where DAY='" + DAY.Text + "' "; dr1 = com.ExecuteReader(); if (dr1.Read()) { MessageBox.Show("data has been read"); /* DAY.Text = " "; DAY.Enabled = false; SUBMIT.Text = " "; SUBMIT.Enabled = false; string count0 = Convert.ToString(dr.GetString(2)); SUBCODE.Text = count0; */ } else { MessageBox.Show("opppsss"); } } else { MessageBox.Show("Plzzz insert all entries "); } }
private void gen_btn_Click(object sender, EventArgs e) { string department = comboBox1.Text; sqlQuery = "SELECT * FROM EMPLOYEES WHERE DEPARTMENT LIKE '" + department + "' ORDER BY last_name asc"; cmd.CommandText = sqlQuery; cmd.Connection = cn; dr = cmd.ExecuteReader(); using (StreamWriter sw = new StreamWriter("C:/Users/Developer/Desktop/itpl project/itplProject/payrolls/payroll_"+ department +"_"+ DateTime.Now.ToString("mm-dd-yy")+".txt")) { sw.WriteLine("Report Generated at : " + DateTime.Now); sw.WriteLine(" Department, Last Name, First Name, Salary"); sw.WriteLine("---------------------------------"); while (dr.Read()) { sw.Write(dr["department"].ToString()); sw.Write(", "+ dr["last_name"].ToString()); sw.Write(", " + dr["first_name"].ToString()); sw.Write(", " + dr["salary"].ToString()); sw.WriteLine(); } sw.WriteLine("---------------------------------"); sw.Close(); dr.Close(); this.Close(); MessageBox.Show("Check your File Directory!"); } }
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("Всё хорошо!!!"); }
/// <summary> /// get all the items from the db /// </summary> public void ConnectToAccess() { conn = new OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= nuwaymenu.mdb;"; try { conn.Open(); cmd = new OleDbCommand(selectString, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { string st = reader["Item"].ToString() + "-" + reader["Description"] + " $" + reader["Price"]; items.Add(st); } } catch (Exception ex) { MessageBox.Show("Failed to connect to data source"); } finally { conn.Close(); } }
public bool sprawdzHaslo(String login, String haslo) { bool czyLogin = false; com = new OleDbCommand("Select login,haslo FROM Konto WHERE login='******'", MyConn); MyConn.Open(); dr = com.ExecuteReader(); while (dr.Read()) { if (dr[0].ToString() == login) { czyLogin = true; } else { czyLogin = false; } } if (czyLogin == true) { com = new OleDbCommand("Select haslo FROM Konto WHERE login='******'", MyConn); } return true; }
/// <summary> /// Returns the geometry corresponding to the Object ID /// </summary> /// <param name="oid">Object ID</param> /// <returns>geometry</returns> public IGeometry GetGeometryByID(int oid) { GeoAPI.Geometries.IGeometry geom = null; using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString)) { string strSQL = "Select " + this.XColumn + ", " + this.YColumn + " FROM " + this.Table + " WHERE " + this.ObjectIdColumn + "=" + oid.ToString(); using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn)) { conn.Open(); using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader()) { if (dr.Read()) { //If the read row is OK, create a point geometry from the XColumn and YColumn and return it if (dr[0] != DBNull.Value && dr[1] != DBNull.Value) { geom = SharpMap.Converters.Geometries.GeometryFactory.CreatePoint((double)dr[0], (double)dr[1]); } } } conn.Close(); } } return(geom); }
public void listarBanner(int RED_ID) { try { rsBanner = objBD.ExecutaSQL("EXEC site_psBanner "+RED_ID+" "); if (rsBanner == null) { throw new Exception(); } if (rsBanner.HasRows) { while (rsBanner.Read()) { banner.InnerHtml += "<div class='banner'>"; banner.InnerHtml += " <a href='" + rsBanner["BAN_LINK"] + "' title='" + rsBanner["BAN_LEGENDA"] + "'><img width='752px' height='208px' src='/upload/imagens/banners/" + rsBanner["BAN_IMAGEM"] + "' alt='" + rsBanner["BAN_LEGENDA"] + "'/></a>"; banner.InnerHtml += "</div>"; } } rsBanner.Close(); rsBanner.Dispose(); } catch (Exception) { throw; } }
public static string LoadById(int id) { string sql = "SELECT * FROM CUSTOMER WHERE CUSTID = " + id.ToString() + ""; string name = ""; try { cn = new OleDbConnection(path); cn.Open(); cmd.Connection = cn; cmd.CommandText = sql; cmd.CommandType = CommandType.TableDirect; dr = cmd.ExecuteReader(); dr.Read(); name = dr[1].ToString(); } catch (Exception e) { } finally { if (dr != null && !dr.IsClosed) { dr.Close(); } cmd.Dispose(); cn.Close(); } return name; }
public List <Object> getValues(string queryString) { List <Object> results = new List <Object>(); configureConnection(); using (conn) { System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(queryString, conn); try { conn.Open(); System.Data.OleDb.OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { Object[] nextRow = new Object[reader.FieldCount]; reader.GetValues(nextRow); results.Add(nextRow); } return(results); } catch (Exception e) { Console.WriteLine(e.ToString()); return(null); } } }
public void ListarConfig(string ID) { if (string.IsNullOrWhiteSpace(ID) == false) { rsConfig = objBD.ExecutaSQL("EXEC site_psListarConfig " + ID); if (rsConfig == null) { throw new Exception(); } if (rsConfig.HasRows) { rsConfig.Read(); USU_ID.Attributes.Add("value", rsConfig["USU_ID"].ToString()); USU_NOME.Attributes.Add("value", rsConfig["USU_NOME"].ToString()); USU_EMAIL.Attributes.Add("value", rsConfig["USU_EMAIL"].ToString()); ListItem li = CAR_ID.Items.FindByValue(rsConfig["CAR_ID"].ToString()); li.Selected = true; //pivacidade if (rsConfig["PRI_PERFIL"].ToString() == "True") { sim_perfil.Checked = true; } else { nao_perfil.Checked = true; } if (rsConfig["PRI_BLOG"].ToString() == "True") { sim_blog.Checked = true; } else { nao_blog.Checked = true; } if (rsConfig["PRI_FOTOS"].ToString() == "True") { sim_midia.Checked = true; } else { nao_midia.Checked = true; } if (rsConfig["PRI_FOTOS"].ToString() == "True") { sim_video.Checked = true; } else { nao_video.Checked = true; } //notificaoes if (rsConfig["NOT_BLOG"].ToString() == "True") { sim_blog2.Checked = true; } else { nao_blog2.Checked = true; } if (rsConfig["NOT_GALERIA"].ToString() == "True") { sim_galeria.Checked = true; } else { nao_galeria.Checked = true; } if (rsConfig["NOT_FORUM"].ToString() == "True") { sim_forum.Checked = true; } else { nao_forum.Checked = true; } if (rsConfig["NOT_DOCUMENTADAS"].ToString() == "True") { sim_criacao.Checked = true; } else { nao_criacao.Checked = true; } InsereCategoria(infantil); InsereCategoria(fundamental); } } }
private void actualizador() { Conector(); comando.CommandText = "select * from t_articulos"; Lector = comando.ExecuteReader(); int registros = 0; while (Lector.Read() == true) { DatosCosa[registros]=new Articulo(); //Cosa = new Articulo(); DatosCosa[registros].CodigoArti = Convert.ToInt32(Lector["id_articulo"]); DatosCosa[registros].NombreArti = Lector["n_articulo"].ToString(); DatosCosa[registros].Precio = Convert.ToDouble(Lector["precio"]); // DatosCosa[registros] = Cosa; registros++; } Lector.Close(); comando.CommandText = "select * from t_clientes"; Lector = comando.ExecuteReader(); registros = 0; // DatosFulano = new Clientes[50]; while (Lector.Read() == true) {//Fulano=new Clientes(); DatosFulano[registros]=new Clientes(); DatosFulano[registros].Barrio=Convert.ToInt32(Lector["id_barrio"]); DatosFulano[registros].Calle=Lector["calle"].ToString(); DatosFulano[registros].CodigoClle=Convert.ToInt32(Lector["id_cliente"]); DatosFulano[registros].NombreClie=Lector["n_cliente"].ToString(); DatosFulano[registros].NumeroCa=Convert.ToInt32(Lector["calle_nro"]); //DatosFulano[registros]=Fulano; registros++; } Lector.Close(); conexion.Close(); }
public void FillCombo() { try { con = new OleDbConnection(cs); con.Open(); string ct = "select RTRIM(CategoryName) from Category order by CategoryName"; cmd = new OleDbCommand(ct); cmd.Connection = con; rdr = cmd.ExecuteReader(); while (rdr.Read()) { cmbCategory.Items.Add(rdr[0]); } con.Close(); con = new OleDbConnection(cs); con.Open(); string ct1 = "select RTRIM(CompanyName) from Company order by CompanyName"; cmd = new OleDbCommand(ct1); cmd.Connection = con; rdr = cmd.ExecuteReader(); while (rdr.Read()) { cmbCompany.Items.Add(rdr[0]); } con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cbLevel_SelectedIndexChanged(object sender, EventArgs e) { try { lvRanking.Items.Clear(); sqlStr = "SELECT TOP 10 * FROM rankinglogs WHERE levelnumber = " + cbLevel.Text.Substring(6).Trim() + " ORDER BY Point"; conn.Open(); cmd = new OleDbCommand(sqlStr,conn); reader = cmd.ExecuteReader(); int i = 1; while(reader.Read()) { ListViewItem lvi = new ListViewItem(i+""); lvi.SubItems.Add(reader["Nickname"].ToString()); lvi.SubItems.Add(reader["Point"].ToString()); lvi.SubItems.Add(reader["TimeSave"].ToString()); lvRanking.Items.Add(lvi); i++; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { try { conn.Close(); } catch { } } }
/// <summary> /// Returns geometry Object IDs whose bounding box intersects 'envelope' /// </summary> /// <param name="envelope"></param> /// <returns></returns> public ICollection <int> GetObjectIDsInView(IEnvelope envelope) { Collection <int> objectlist = new Collection <int>(); using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString)) { string strSQL = "Select " + this.ObjectIdColumn + " FROM " + this.Table + " WHERE "; if (!String.IsNullOrEmpty(_defintionQuery)) { strSQL += _defintionQuery + " AND "; } //Limit to the points within the boundingbox strSQL += this.XColumn + " BETWEEN " + envelope.MinX.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + envelope.MaxX.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + this.YColumn + " BETWEEN " + envelope.MaxY.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + envelope.MinY.ToString(SharpMap.Map.numberFormat_EnUS); using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn)) { conn.Open(); using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader()) { while (dr.Read()) { if (dr[0] != DBNull.Value) { objectlist.Add((int)dr[0]); } } } conn.Close(); } } return(objectlist); }
/// <summary> /// Returns geometry Object IDs whose bounding box intersects 'bbox' /// </summary> /// <param name="bbox"></param> /// <returns></returns> public List <uint> GetObjectIDsInView(SharpMap.Geometries.BoundingBox bbox) { List <uint> objectlist = new List <uint>(); using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString)) { string strSQL = "Select " + this.ObjectIdColumn + " FROM " + this.Table + " WHERE "; if (_defintionQuery != null && _defintionQuery != "") { strSQL += _defintionQuery + " AND "; } //Limit to the points within the boundingbox strSQL += this.XColumn + " BETWEEN " + bbox.Left.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.Right.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + this.YColumn + " BETWEEN " + bbox.Bottom.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.Top.ToString(SharpMap.Map.numberFormat_EnUS); using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn)) { conn.Open(); using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader()) { while (dr.Read()) { if (dr[0] != DBNull.Value) { objectlist.Add((uint)(int)dr[0]); } } } conn.Close(); } } return(objectlist); }
protected void Button1_Click(object sender, EventArgs e) { conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail"); string u_name, password; u_name = TextBox1.Text; password = TextBox2.Text; rec_mail rr = new rec_mail(); string comp=rr.un_enc(u_name, password); //u_name = raw_u_name + password[2]; //Response.Write(u_name); conn.Open(); cmd=new OleDbCommand ("select enc_fun(user_id,password) from username where user_id='"+ u_name +"'",conn); dr = cmd.ExecuteReader(); //dr.Read(); //Response.Write(raw_u_name + dr["password"].ToString()[2]); if (dr.HasRows == false) Label2.Visible = true; else { dr.Read(); if (dr[0].ToString() == comp) { Session["us_name"] = u_name; Response.Redirect("Mail_box.aspx"); } else Label2.Visible = true; } dr.Close(); conn.Close(); }
/// <summary> /// Returns geometries within the specified bounding box /// </summary> /// <param name="bbox"></param> /// <returns></returns> public ICollection <IGeometry> GetGeometriesInView(IEnvelope bbox, double minGeometrySize) { Collection <GeoAPI.Geometries.IGeometry> features = new Collection <GeoAPI.Geometries.IGeometry>(); using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString)) { string strSQL = "Select " + this.XColumn + ", " + this.YColumn + " FROM " + this.Table + " WHERE "; if (!String.IsNullOrEmpty(_defintionQuery)) { strSQL += _defintionQuery + " AND "; } //Limit to the points within the boundingbox strSQL += this.XColumn + " BETWEEN " + bbox.MinX.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.MaxX.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + this.YColumn + " BETWEEN " + bbox.MaxY.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.MinY.ToString(SharpMap.Map.numberFormat_EnUS); using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn)) { conn.Open(); using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader()) { while (dr.Read()) { if (dr[0] != DBNull.Value && dr[1] != DBNull.Value) { features.Add(SharpMap.Converters.Geometries.GeometryFactory.CreatePoint((double)dr[0], (double)dr[1])); } } } conn.Close(); } } return(features); }
private void BookCatalog_Load(object sender, EventArgs e) { try{ // creating a connection sConn = " Provider=Microsoft.ACE.OLEDB.12.0 ; Data Source = finalprojectC#.accdb"; OleDbConnection dbConn = new OleDbConnection(sConn); dbConn.Open(); // creating a sql query sql = "SELECT * FROM Books_online ORDER BY BookName ASC, Book_Price ASC;"; OleDbCommand dbCmd = new OleDbCommand(); dbCmd.CommandText = sql; dbCmd.Connection = dbConn; //Create a dbreader object dbReader = dbCmd.ExecuteReader(); while (dbReader.Read()) { // adding book name and price to listbox fprice = Convert.ToDouble(dbReader["Book_Price"]); this.listBox1.Items.Add(dbReader["BookName"].ToString() + " " + "$" + dbReader["Book_Price"]); } dbReader.Close(); dbConn.Close(); } catch (System.Exception exc) { label1.Text = exc.Message; } }
//Constructor - Initializes the object with data and connects to the database. public MeasurementUncertainityCalculator() { string path; path = Path.GetDirectoryName(Application.ExecutablePath); try { connection = new OleDbConnection(); connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DB\\UC.mdb;Persist Security Info=False"; connection.Open(); command = new OleDbCommand(); command.Connection = connection; command.CommandText = "SELECT count(Sample_Number) FROM InputTable"; reader = command.ExecuteReader(); while (reader.Read()) { no_of_obs = (Double.Parse(reader[0].ToString())); } reader.Close(); reader = null; } catch (Exception e) { Console.WriteLine(e.Message); } }
void LoadPicFile(Dictionary <string, ObjItem> dr) { string strSQL = "SELECT PICFILE FROM LKEQ.EQCARDEXPLAINREC WHERE CHOSCODE=" + dr["医疗机构编码"].ToString() + " AND CARDID=" + dr["卡片ID"].ToString(); string cnnstr = ConfigurationManager.AppSettings["LKEQ_Conn"].ToString(); //string cnnstr = "Provider = OraOLEDB.Oracle.1; Data Source = orcl; User ID = HIS; Password =linker;Persist Security Info=True"; //string cnnstr = System.Configuration.ConfigurationManager.ConnectionStrings["LKEQ_Conn"].ToString(); OleDbConnection con = new OleDbConnection(cnnstr); try { con.Open(); } catch { } OleDbCommand cmd = new OleDbCommand(strSQL, con); System.Data.OleDb.OleDbDataReader drSM = cmd.ExecuteReader(); while (drSM.Read()) { if (drSM["PICFILE"] != DBNull.Value) //照片字段里有值才能进到方法体显示图片,否则清空pb { MemoryStream ms = new MemoryStream((byte[])drSM["PICFILE"]); //把照片读到MemoryStream里 bytPicLoad = (byte[])drSM["PICFILE"]; Image imageBlob = Image.FromStream(ms, true); //用流创建Image pictureBox1.Image = imageBlob; //输出图片 } else//照片字段里没值,清空pb { pictureBox1.Image = null; } } }
public void populaLista() { rsPlay = objBD.ExecutaSQL("select PLI_ID, PLI_TITULO, PLI_URL from PlayList where PLI_ATIVO = 1 order by PLI_DH_CADASTRO desc"); if (rsPlay == null) { throw new Exception(); } if (rsPlay.HasRows) { while (rsPlay.Read()) { if (aux == 1) { objVideo.InnerHtml += "<iframe width=\"480\" height=\"269\" src=\""+rsPlay["PLI_URL"].ToString()+"\" frameborder=\"0\" allowfullscreen></iframe>"; } System.Web.UI.WebControls.ListItem R = new System.Web.UI.WebControls.ListItem(); R.Value = rsPlay["PLI_ID"].ToString(); R.Text = rsPlay["PLI_TITULO"].ToString(); slPlayList.Items.Add(R); aux++; } } rsPlay.Close(); rsPlay.Dispose(); }
protected void gravarVideo(object sender, EventArgs e) { try { rsGravar = objBD.ExecutaSQL("EXEC admin_piuUsuarioVideos '" + Request["VID_ID"] + "','" + Session["usuID"] + "', '" + Request["VID_TITULO"] + "','" + Request["VID_LINK"].Replace("http://youtu.be/", "").Replace("https://www.youtube.com/watch?v=", "").Replace("https://youtu.be/", "") + "','" + Request["VID_LINK"].Replace("http://youtu.be/", "http://i.ytimg.com/vi/").Replace("https://www.youtube.com/watch?v=", "http://i.ytimg.com/vi/").Replace("https://youtu.be/", "http://i.ytimg.com/vi/") + "/mqdefault.jpg', '" + Request["VID_DESCRICAO"] + "'"); if (rsGravar == null) { throw new Exception(); } if (rsGravar.HasRows) { rsGravar.Read(); } //Libera o BD e Memória VerificarMedalhas(); rsGravar.Close(); rsGravar.Dispose(); //Retornar para a Listagem Response.Redirect("meus-videos.aspx?alert=Vídeo publicado com sucesso!"); Response.End(); } catch (Exception) { throw; } }
/// <summary> /// Returns geometries within the specified bounding box /// </summary> /// <param name="bbox"></param> /// <returns></returns> public List <SharpMap.Geometries.Geometry> GetGeometriesInView(SharpMap.Geometries.BoundingBox bbox) { List <Geometries.Geometry> features = new List <SharpMap.Geometries.Geometry>(); using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString)) { string strSQL = "Select " + this.XColumn + ", " + this.YColumn + " FROM " + this.Table + " WHERE "; if (_defintionQuery != null && _defintionQuery != "") { strSQL += _defintionQuery + " AND "; } //Limit to the points within the boundingbox strSQL += this.XColumn + " BETWEEN " + bbox.Left.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.Right.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + this.YColumn + " BETWEEN " + bbox.Bottom.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.Top.ToString(SharpMap.Map.numberFormat_EnUS); using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn)) { conn.Open(); using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader()) { while (dr.Read()) { if (dr[0] != DBNull.Value && dr[1] != DBNull.Value) { features.Add(new SharpMap.Geometries.Point((double)dr[0], (double)dr[1])); } } } conn.Close(); } } return(features); }
//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; }
protected void Button1_Click1(object sender, EventArgs e) { string strGroupName, strGroupContent; DateTime dtmCreateDate; if (txtGroupName.Text == "") { this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('请填写群组名称!')</script>"); return; } strGroupName = txtGroupName.Text; strGroupContent = txtGroupName.Text; string strsql; myGroup = AccessDateHelper.ExecuteReader("select * from [Group] where UserID=" + Convert.ToInt16(myUserID) + ""); if (myGroup.Read()) { strsql = "update [Group] set GroupName='" + strGroupName + "',GroupContent='" + strGroupContent + "' where GroupID=" + Convert.ToInt16(myGroup["GroupID"]) + ""; } else { strsql = "insert into [Group] (GroupName,GroupContent,UserID) values ('" + strGroupName + "','" + strGroupContent + "',"+Convert.ToInt16(myUserID)+")"; } if (AccessDateHelper.ExecuteNonQuery(strsql) > 0) { this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('群组更改成功!');try{ window.opener.RefreshForm() }catch(e){};</script>"); } else { this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('新建试题失败!')</script>"); } }
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; }
private void button3_Click(object sender, EventArgs e) { String surname; String groupName; String specialityName; String formOfEducation; String yearsofEducation; List <String> surnameMas = new List <String>(); List <String> groupNameMas = new List <String>(); List <String> specialityNameMas = new List <String>(); List <String> formOfEducationMas = new List <String>(); List <String> yearsofEducationMas = new List <String>(); var Command = new dabse.OleDbCommand("SELECT Студенты.Фамилия, Группы.Название, Специальности.Название, Студенты.Форма_обучения, Специальности.Срок_обучения FROM Группы, Группы_обучение, Студенты, Специальности WHERE Группы.Номер = Группы_обучение.Номер_группы AND Группы_обучение.Шифр_студента = Студенты.Шифр AND Студенты.Специальность = Специальности.Шифр AND Студенты.Шифр = " + thirdshifrsudenta.Text + "AND Группы_обучение.Год = " + thirdnameofsubject.Text, Date_baseone); dabse.OleDbDataReader Ask3 = Command.ExecuteReader(); while (Ask3.Read() == true) { surname = Ask3[0].ToString(); groupName = Ask3[1].ToString(); specialityName = Ask3[2].ToString(); formOfEducation = Ask3[3].ToString(); yearsofEducation = Ask3[4].ToString(); surnameMas.Add(surname); groupNameMas.Add(groupName); specialityNameMas.Add(specialityName); formOfEducationMas.Add(formOfEducation); yearsofEducationMas.Add(yearsofEducation); } wooord.Application wordApp = new wooord.Application(); wordApp.Visible = true; object oMissing = Type.Missing; wooord.Document wordDoc; wooord.Paragraph wordPar; wooord.Range wordRan; wordDoc = wordApp.Documents.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing); //задаём форматирование для первого абзаца, которое будет так же и для всего документа, но //это не страшно. Последующие абзацы будут иметь другое форматирование Object begin = Type.Missing; Object end = Type.Missing; wordRan = wordDoc.Range(ref begin, ref end); wordRan.ParagraphFormat.Alignment = wooord.WdParagraphAlignment.wdAlignParagraphCenter; wordRan.Text = "Справка"; //теперь задаём форматирование следующего абзаца wordPar = wordDoc.Paragraphs.Add(ref oMissing); wordDoc.Paragraphs[2].Range.ParagraphFormat.Alignment = wooord.WdParagraphAlignment.wdAlignParagraphLeft; wordDoc.Paragraphs[2].Range.Font.Size = 10; wordDoc.Paragraphs[2].Range.Text = "Студент " + surnameMas[0] + " обучается в группе " + groupNameMas[0] + " по специальности " + specialityNameMas[0] + ". Форма обучения – " + formOfEducationMas[0] + ". Срок обучения – " + yearsofEducationMas[0] + "."; }
private void button1_Click(object sender, EventArgs e) { String name; String mark; List <String> one = new List <String>(); List <String> two = new List <String>(); command = new dabse.OleDbCommand("Select Дисциплины.Название, Дисциплины_обучение.Балл From Дисциплины, Дисциплины_обучение, Студенты Where Дисциплины.Код = Дисциплины_обучение.Код_дисциплины and Студенты.Шифр = Дисциплины_обучение.Шифр_студента and Студенты.Шифр = " + firststudensshifr.Text + " order by Дисциплины_обучение.Балл, Дисциплины.Название", Date_baseone); dabse.OleDbDataReader result = command.ExecuteReader(); wooord.Application app = new wooord.Application(); Object missing = Type.Missing; app.Documents.Add(ref missing, ref missing, ref missing, ref missing); wooord.Document docec = app.ActiveDocument; wooord.Range range = docec.Paragraphs[docec.Paragraphs.Count].Range; while (result.Read()) { name = result[1].ToString(); mark = result[0].ToString(); one.Add(name); two.Add(mark); } int len = two.Count; docec.Tables.Add(range, len + 1, 2, ref missing, ref missing); docec.Tables[1].Cell(1, 1).Range.Text = "Название дисциплины"; docec.Tables[1].Cell(1, 2).Range.Text = "Балл"; for (int i = 0; i < len; i++) { docec.Tables[1].Cell(i + 2, 1).Range.Text = two[i]; docec.Tables[1].Cell(i + 2, 2).Range.Text = one[i]; } wooord.Border[] bords = new wooord.Border[6]; wooord.Table table = docec.Tables[docec.Tables.Count]; bords[0] = table.Borders[wooord.WdBorderType.wdBorderLeft]; bords[1] = table.Borders[wooord.WdBorderType.wdBorderRight]; bords[2] = table.Borders[wooord.WdBorderType.wdBorderTop]; bords[3] = table.Borders[wooord.WdBorderType.wdBorderBottom]; bords[4] = table.Borders[wooord.WdBorderType.wdBorderVertical]; bords[5] = table.Borders[wooord.WdBorderType.wdBorderHorizontal]; foreach (wooord.Border border in bords) { border.LineStyle = wooord.WdLineStyle.wdLineStyleSingle; border.Color = wooord.WdColor.wdColorBlack; } app.Visible = true; }
public static System.Data.DataTable getTable(string 参数_数据库路径, string 参数_SQL语句) { //初始化 System.Data.DataTable dt = new System.Data.DataTable(); try { //1、建立连接 C#操作Access之读取mdb string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + 参数_数据库路径 + ";"; System.Data.OleDb.OleDbConnection odcConnection = new System.Data.OleDb.OleDbConnection(strConn); //2、打开连接 C#操作Access之读取mdb odcConnection.Open(); //建立SQL查询 System.Data.OleDb.OleDbCommand odCommand = odcConnection.CreateCommand(); //3、输入查询语句 C#操作Access之读取mdb odCommand.CommandText = 参数_SQL语句; //建立读取 System.Data.OleDb.OleDbDataReader odrReader = odCommand.ExecuteReader(); //查询并显示数据 int size = odrReader.FieldCount; for (int i = 0; i < size; i++) { //Console.WriteLine("{0} {1}", "列", odrReader.GetName(i).ToString()); dt.Columns.Add(odrReader.GetName(i).ToString(), typeof(string)); } while (odrReader.Read()) { System.Data.DataRow dr = dt.NewRow(); for (int i = 0; i < size; i++) { //Console.WriteLine("{0} {1}", odrReader.GetName(i).ToString(), odrReader[odrReader.GetName(i)].ToString()); dr[odrReader.GetName(i).ToString()] = odrReader[odrReader.GetName(i)].ToString(); } dt.Rows.Add(dr); } //关闭连接 C#操作Access之读取mdb odrReader.Close(); odcConnection.Close(); return(dt); } catch { return(dt); } }
private void GroupsStudy_Load(object sender, EventArgs e) { Date_baseone.Open(); var data1 = new List <Dvapolya>(); var data2 = new List <Dvapolya>(); var data3 = new List <string>(); dabse.OleDbCommand com1 = new dabse.OleDbCommand("Select Название, Номер FROM Группы", Date_baseone); dabse.OleDbDataReader resulter1 = com1.ExecuteReader(); while (resulter1.Read() == true) { var mc = new Dvapolya { secondpole = resulter1[0].ToString().Trim(), firstpole = resulter1[1].ToString().Trim() }; data1.Add(mc); } dabse.OleDbCommand com2 = new dabse.OleDbCommand("Select Фамилия, Имя, Отчество, Шифр FROM Студенты", Date_baseone); dabse.OleDbDataReader resulter2 = com2.ExecuteReader(); while (resulter2.Read() == true) { var mc = new Dvapolya { secondpole = resulter2[0].ToString().Trim() + " " + resulter2[1].ToString().Trim() + " " + resulter2[2].ToString().Trim(), firstpole = resulter2[3].ToString().Trim() }; data2.Add(mc); } dabse.OleDbCommand com3 = new dabse.OleDbCommand("SELECT DISTINCT (Группы_обучение.Год) FROM Группы_обучение", Date_baseone); dabse.OleDbDataReader resulter3 = com3.ExecuteReader(); while (resulter3.Read() == true) { var mc = resulter3[0].ToString().Trim(); data3.Add(mc); } comboBox1.DataSource = data1; comboBox1.DisplayMember = "secondpole"; comboBox1.ValueMember = "firstpole"; comboBox2.DataSource = data2; comboBox2.DisplayMember = "secondpole"; comboBox2.ValueMember = "firstpole"; comboBox3.DataSource = data3; }
public static void GetAllProtocolIP() { string strSql; try { tVehInfo nVehInfo = null; System.Data.OleDb.OleDbCommand GetProTypeCommand = null; System.Data.OleDb.OleDbDataReader GetProTypeReader = null; strSql = "select distinct IpAddress,type,TaxiNo from vehicle"; GetProTypeCommand = myConn.CreateCommand(); GetProTypeCommand.CommandText = strSql; GetProTypeReader = GetProTypeCommand.ExecuteReader(); CarInfo_Hash = new Hashtable(); while (GetProTypeReader.Read()) { nVehInfo = new tVehInfo(); nVehInfo.ipaddress = GetProTypeReader["IpAddress"].ToString(); if (GetProTypeReader["type"].ToString().ToUpper() == "TCP") { nVehInfo.isendtype = 1; } else { nVehInfo.isendtype = 0; } if (CarInfo_Hash.ContainsKey((string)GetProTypeReader["IpAddress"])) { CarInfo_Hash[(string)GetProTypeReader["IpAddress"]] = nVehInfo; } else { CarInfo_Hash.Add((string)GetProTypeReader["IpAddress"], nVehInfo); } } GetProTypeReader.Close(); GetProTypeReader = null; GetProTypeCommand.Dispose(); } catch (Exception ce) { GprsServer.WriteErrLog("GetAllProtocolIP", ce.Message.ToString() + ce.StackTrace.ToString()); if (myConn.State.ToString() == "Closed") { Conndb(); } return; } }
public static void Carregar_Banco_Dados() { myConnection.Open(); myReader = myCommand.ExecuteReader(); MessageBox.Show("ServerVersion: " + myConnection.ServerVersion + "\nDataSource: " + myConnection.DataSource.ToString()); while (myReader.Read()) { MessageBox.Show("Codigo:" + myReader["Codigo"]); } }
private void countReturned(string mpDATEAWAL, string mpDATEAKHIR) { mlSQL = "SELECT RETURNED FROM INV_DELIVERY_STATUS WHERE RETURNEDDATE BETWEEN '" + mpDATEAWAL + "' AND '" + mpDATEAKHIR + "'"; mlREADER = mlOBJGS.DbRecordset(mlSQL, "PB", mlCOMPANYID); if (mlREADER.HasRows) { while (mlREADER.Read()) { this.mlRETURNED.Text = mlREADER["RETURNED"].ToString(); } } else { this.mlRETURNED.Text = "0"; } }
private void countProceeds(string mpDATEAWAL, string mpDATEAKHIR) { mlSQL = "SELECT PROCEEDS FROM INV_DELIVERY_STATUS WHERE PROCEEDSDATE BETWEEN '" + mpDATEAWAL + "' AND '" + mpDATEAKHIR + "'"; mlREADER = mlOBJGS.DbRecordset(mlSQL, "PB", mlCOMPANYID); if (mlREADER.HasRows) { while (mlREADER.Read()) { this.mlPROCEEDS.Text = mlREADER["PROCEEDS"].ToString(); } } else { this.mlPROCEEDS.Text = "0"; } }
/// <summary> /// 输出blob /// </summary> /// <param name="strSql"></param> /// <returns></returns> public byte[] OutputBlob(string strSql) { //string block="SELECT image from test_image WHERE id = 100";//INTO :b // Set command to create Anonymous PL/SQL Block command.CommandText = strSql + ""; command.CommandType = System.Data.CommandType.Text; System.Data.OleDb.OleDbDataReader reader; // The anonymous PL/SQL block retrieves the images as an output parameter try { //cmd.ExecuteNonQuery(); reader = command.ExecuteReader(); } catch (OleDbException ex) { this.Err = "执行产生错误!" + ex.Message; this.ErrCode = strSql; this.DBErrCode = ex.ErrorCode; this.WriteErr(); return(null); } catch (Exception ex) { this.Err = ex.Message; this.ErrorException = ex.InnerException + "+ " + ex.Source; this.WriteErr(); return(null); } reader.Read(); // Create a byte array byte[] byteData = new byte[0]; // fetch the value of Oracle parameter into the byte array //byteData = (byte[])(cmd.Parameters[0].Value); try { byteData = (byte[])(reader[0]); } catch {} reader.Close(); return(byteData); }
private void Students_Load(object sender, EventArgs e) { var data1 = new List <Dvapolya>(); Date_baseone = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb"); Date_baseone.Open(); dabse.OleDbCommand com1 = new dabse.OleDbCommand("Select Название, Шифр FROM Специальности", Date_baseone); dabse.OleDbDataReader resulter = com1.ExecuteReader(); while (resulter.Read() == true) { var mc = new Dvapolya { secondpole = resulter[0].ToString().Trim(), firstpole = resulter[1].ToString().Trim() }; data1.Add(mc); } specialnost.DataSource = data1; specialnost.DisplayMember = "secondpole"; specialnost.ValueMember = "firstpole"; var data2 = new List <Dvapolya>(); var nc = new Dvapolya { secondpole = "обучается", firstpole = "1" }; data2.Add(nc); var nc1 = new Dvapolya { secondpole = "отчислен", firstpole = "2" }; data2.Add(nc1); priznakotchis.DataSource = data2; priznakotchis.DisplayMember = "secondpole"; priznakotchis.ValueMember = "firstpole"; }
/// <summary> Queries the normative database for a list of segments comprising /// the message structure. The returned list may also contain strings /// that denote repetition and optionality. Choice indicators (i.e. begin choice, /// next choice, end choice) for alternative segments are ignored, so that the class /// structure allows all choices. The matter of enforcing that only a single choice is /// populated can't be handled by the class structure, and should be handled elsewhere. /// </summary> private static SegmentDef[] getSegments(System.String message, System.String version) { /*String sql = "select HL7Segments.seg_code, repetitional, optional, description " + * "from (HL7MsgStructIDSegments inner join HL7Segments on HL7MsgStructIDSegments.seg_code = HL7Segments.seg_code " + * "and HL7MsgStructIDSegments.version_id = HL7Segments.version_id) " + * "where HL7Segments.version_id = 6 and message_structure = '" + message + "' order by seq_no";*/ System.String sql = getSegmentListQuery(message, version); //System.out.println(sql.toString()); SegmentDef[] segments = new SegmentDef[200]; //presumably there won't be more than 200 //UPGRADE_NOTE: There are other database providers or managers under System.Data namespace which can be used optionally to better fit the application requirements. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1208'" using (System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection) { //UPGRADE_TODO: Method 'java.sql.Connection.createStatement' was converted to 'SupportClass.TransactionManager.manager.CreateStatement' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlConnectioncreateStatement'" System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); //UPGRADE_TODO: Interface 'java.sql.ResultSet' was converted to 'System.Data.OleDb.OleDbDataReader' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlResultSet'" System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = sql; System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); int c = -1; while (rs.Read()) { System.String name = SegmentGenerator.altSegName(System.Convert.ToString(rs[1 - 1])); bool repeating = rs.GetBoolean(2 - 1); bool optional = rs.GetBoolean(3 - 1); System.String desc = System.Convert.ToString(rs[4 - 1]); System.String groupName = System.Convert.ToString(rs[6 - 1]); //ignore the "choice" directives ... the message class structure has to include all choices ... // if this is enforced (i.e. exception thrown if >1 choice populated) this will have to be done separately. if (!(name.Equals("<") || name.Equals("|") || name.Equals(">"))) { c++; segments[c] = new SegmentDef(name, groupName, !optional, repeating, desc); } } rs.Close(); SegmentDef[] ret = new SegmentDef[c + 1]; Array.Copy(segments, 0, ret, 0, c + 1); return(ret); } }