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 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); }
public void addGame(Game obj, int num) { try { database = new OleDbConnection(connectionString); database.Open(); string queryString = "INSERT INTO Game (Title, Description, Publisher, ReleaseDate, Rating, PurchasePrice, Copies) " + "VALUES ('" + obj.Title + "', '" + obj.Description + "', '" + obj.Publisher + "', '" + obj.ReleaseDate + "', '" + obj.Rating + "', '" + obj.Price + "', '" + obj.Copies + "')"; string queryString2 = "SELECT * FROM Game WHERE Title = '" + obj.Title + "'"; string queryString3; OleDbCommand cmd = new OleDbCommand(queryString, database); OleDbCommand cmd2 = new OleDbCommand(queryString2, database); count = cmd.ExecuteNonQuery(); reader = cmd2.ExecuteReader(); Game temp = new Game(); reader.Read(); temp.Id = Int32.Parse(reader["ID"].ToString()); temp.Title = reader["Title"].ToString(); temp.Description = reader["Description"].ToString(); temp.Publisher = reader["Publisher"].ToString(); temp.ReleaseDate = reader["ReleaseDate"].ToString(); temp.Rating = reader["Rating"].ToString(); temp.Price = Double.Parse(reader["PurchasePrice"].ToString()); temp.Copies = Int32.Parse(reader["Copies"].ToString()); queryString3 = "INSERT INTO GameCopy (CheckedOut, GameID) " + "VALUES (false, '" + temp.Id + "')"; OleDbCommand cmd3 = new OleDbCommand(queryString3, database); for (int i = 0; i < num; i++) count2 = cmd3.ExecuteNonQuery(); if (count >= 1) MessageBox.Show(obj.Title + " has been added!"); else MessageBox.Show("Error: Could not add game!"); reader.Close(); database.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); reader.Close(); database.Close(); } }
public void PopularBlog(int RED_ID) { rsBlog = objBD.ExecutaSQL("EXEC site_psPostBlog " + RED_ID + " "); if (rsBlog == null) { throw new Exception(); } if (rsBlog.HasRows) { while (rsBlog.Read()) { ulPost.InnerHtml += " <li><a href=\"/post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\" title=\"Titulo da postagem\">"; if (string.IsNullOrWhiteSpace(rsBlog["POS_IMAGEM"].ToString()) == false) { ulPost.InnerHtml += " <img src='/upload/imagens/blog/thumb-" + rsBlog["POS_IMAGEM"].ToString() + "'>"; } else { ulPost.InnerHtml += " <img src='images/img-post-blog-padrao.png'>"; } ulPost.InnerHtml += " </a>"; ulPost.InnerHtml += " <p class=\"titu_post_home\"><a href=\"post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\">" + objUtils.CortarString(true, 36, rsBlog["POS_TITULO"].ToString()) + "</a></p>"; ulPost.InnerHtml += " <p class=\"desc_post_home\"><a href=\"post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\">" + objUtils.RemoveHTML(objUtils.CortarString(true, 110, rsBlog["POS_TEXTO"].ToString())) + "</a></p>"; //ulPost.InnerHtml += " <p class=\"desc_post_home\"> </p>"; ulPost.InnerHtml += " <a href=\"/post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\" class=\"btn\">LEIA MAIS</a>"; ulPost.InnerHtml += " </li>"; } } rsBlog.Dispose(); rsBlog.Close(); }
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 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(); }
public void mudarGaleria(int id) { rsGaleria = objBD.ExecutaSQL("select AFO_ID, AFO_TITULO, AFO_KEY from AlbumFotos where AFO_ID = "+id+" order by AFO_DH_CADASTRO desc"); if (rsGaleria == null) { throw new Exception(); } if (rsGaleria.HasRows) { rsGaleria.Read(); retorno += "<object width=\"468\" height=\"297\">"; retorno += " <param name=\"flashvars\" value=\"offsite=true&lang=en-us&page_show_url=%2Fphotos%2Fbrincamusicais%2Fsets%2F" + rsGaleria["AFO_KEY"] + "%2Fshow%2F&page_show_back_url=%2Fphotos%2Fbrincamusicais%2Fsets%2F" + rsGaleria["AFO_KEY"] + "%2F&set_id=" + rsGaleria["AFO_KEY"] + "&jump_to=\"></param>"; retorno += " <param name=\"movie\" value=\"https://www.flickr.com/apps/slideshow/show.swf?v=1811922554\"></param>"; retorno += " <param name=\"allowFullScreen\" value=\"true\"></param>"; retorno += " <embed type=\"application/x-shockwave-flash\" src=\"https://www.flickr.com/apps/slideshow/show.swf?v=1811922554\" allowfullscreen=\"true\" flashvars=\"offsite=true&lang=en-us&page_show_url=%2Fphotos%2Fbrincamusicais%2Fsets%2F" + rsGaleria["AFO_KEY"] + "%2Fshow%2F&page_show_back_url=%2Fphotos%2Fbrincamusicais%2Fsets%2F" + rsGaleria["AFO_KEY"] + "%2F&set_id=" + rsGaleria["AFO_KEY"] + "&jump_to=\" width=\"468\" height=\"297\"></embed>"; retorno += "</object>"; retorno += "|"; retorno += ""+id+""; retorno += "|"; } Response.Write(retorno); rsGaleria.Close(); rsGaleria.Dispose(); }
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 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 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; } }
/// <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(); }
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 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; } }
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); } }
//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; }
// 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); } }
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; }
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(); }
//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); } }
public void AlterarDados(tbVendedorDTO vendedor) { String sSQL = ""; sSQL += "UPDATE tbVendedor SET dsNome = @dsNome, dtNascimento = @dtNascimento WHERE idVendedor = @idVendedor "; conexao = (OleDbConnection)CriaConexaoOleDb(); command = new OleDbCommand(sSQL, conexao); command.CommandType = CommandType.Text; OleDbParameter parametro = command.Parameters.Add("@dsNome", OleDbType.VarChar); parametro.Value = vendedor.dsNome; parametro = command.Parameters.Add("@dtNascimento", OleDbType.Date); parametro.Value = vendedor.dtNascimento; parametro = command.Parameters.Add("@idVendedor", OleDbType.Integer); parametro.Value = vendedor.idVendedor; try { drOleDb = command.ExecuteReader(); drOleDb.Close(); conexao.Close(); } catch (SystemException e) { erro = e.Message; } }
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; } }
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!"); } }
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 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; }
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> /// 检验是否存在数据 /// </summary> /// <returns></returns> public bool ExistData(string SQL) { bool ret = false; try { System.Data.OleDb.OleDbDataReader dr = ReturnDataReader(SQL); if (dr.HasRows) { ret = true; } dr.Close(); } catch (Exception Ex) { throw new Exception(SQL + Ex.ToString()); } finally { if (null == transaction) { Close(); } } return(ret); }
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; }
public void AlterarDados(tbVendaDTO venda) { String sSQL = ""; sSQL += "UPDATE tbVenda SET idProduto = @idProduto, idVendedor = @idVendedor, qtQuantidade = @qtQuantidade WHERE idVenda = @idVenda "; conexao = (OleDbConnection)CriaConexaoOleDb(); command = new OleDbCommand(sSQL, conexao); command.CommandType = CommandType.Text; OleDbParameter parametro = command.Parameters.Add("@idProduto", OleDbType.Integer); parametro.Value = venda.Produto.idProduto; parametro = command.Parameters.Add("@idVendedor", OleDbType.Integer); parametro.Value = venda.Vendedor.idVendedor; parametro = command.Parameters.Add("@qtQuantidade", OleDbType.Integer); parametro.Value = venda.qtQuantidade; parametro = command.Parameters.Add("@idVenda", OleDbType.Integer); parametro.Value = venda.idVenda; try { drOleDb = command.ExecuteReader(); drOleDb.Close(); conexao.Close(); } catch (SystemException e) { erro = e.Message; } }
//protected override int Fill(DataTable dataTable, IDataReader dataReader) { // return base.Fill(dataTable, dataReader); //} private int FillFromRecordset(object data, UnsafeNativeMethods.ADORecordsetConstruction recordset, string?srcTable, out bool incrementResultCount) { incrementResultCount = false; IntPtr chapter; /*ODB.DB_NULL_HCHAPTER*/ object?result; try { result = recordset.get_Rowset(); chapter = recordset.get_Chapter(); } catch (Exception e) { // UNDONE - should not be catching all exceptions!!! if (!ADP.IsCatchableExceptionType(e)) { throw; } throw ODB.Fill_EmptyRecordSet("ADODBRecordSet", e); } if (null != result) { CommandBehavior behavior = (MissingSchemaAction.AddWithKey != MissingSchemaAction) ? 0 : CommandBehavior.KeyInfo; behavior |= CommandBehavior.SequentialAccess; OleDbDataReader?dataReader = null; try { // initialized with chapter only since we don't want ReleaseChapter called for this chapter handle ChapterHandle chapterHandle = ChapterHandle.CreateChapterHandle(chapter); dataReader = new OleDbDataReader(null, null, 0, behavior); dataReader.InitializeIRowset(result, chapterHandle, ADP.RecordsUnaffected); dataReader.BuildMetaInfo(); incrementResultCount = (0 < dataReader.FieldCount); if (incrementResultCount) { if (data is DataTable) { return(base.Fill((DataTable)data, dataReader)); } else { return(base.Fill((DataSet)data, srcTable !, dataReader, 0, 0)); } } } finally { dataReader?.Close(); } } return(0); }
public void PopulaTela() { rsListar = objBD.ExecutaSQL("EXEC site_psCriacaoDocumentadasPorID '" + Request["CDO_ID"] + "' "); if (rsListar == null) { throw new Exception(); } if (rsListar.HasRows) { rsListar.Read(); 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(); divDevolutiva.InnerHtml = rsListar["CDO_DEVOLUTIVA"].ToString(); if (!string.IsNullOrWhiteSpace(rsListar["CDO_VIDEO"].ToString())) { video_criacoes.Attributes.Add("src", "https://www.youtube.com/embed/" + rsListar["CDO_VIDEO"].ToString()); } else { titulovideo.Visible = false; video_criacoes.Visible = false; } if (!string.IsNullOrWhiteSpace(rsListar["CDO_VIDEO_DEVOLUTIVA"].ToString())) { video_devolutiva.Attributes.Add("src", "https://www.youtube.com/embed/" + rsListar["CDO_VIDEO_DEVOLUTIVA"].ToString()); } else { titulovideodevolutiva.Visible = false; video_criacoesdevolutiva.Visible = false; } idCDO.Attributes.Add("value", Request["CDO_ID"].ToString()); idCDO1.Attributes.Add("value", Request["CDO_ID"].ToString()); relato_detalhe.InnerHtml = "<strong>" + rsListar["TOTAL_RELATOS"].ToString() + " Relatos Enviados</strong>"; totalComentarios.InnerHtml = "<a href='javascript:void(0)' onClick='verComentarios2(1," + Request["CDO_ID"] + ");'> " + rsListar["TOTAL_COMENTARIOS"].ToString() + " Comentário"; if (Convert.ToInt16(rsListar["TOTAL_COMENTARIOS"]) > 1) { totalComentarios.InnerHtml += "s"; } totalComentarios.InnerHtml += "</a>"; } else { Response.Redirect("/criacoes-documentadas"); } rsListar.Close(); rsListar.Dispose(); }
public void PopulaBlog() { rsBlog = objBD.ExecutaSQL("EXEC site_PostBlogPorTitulo '" + Request["titulo"] + "' "); if (rsBlog == null) { throw new Exception(); } if (rsBlog.HasRows) { rsBlog.Read(); //facebook // metaTitle.Content = "Projeto Brincadeiras Musicais da Palavra Cantada - Blog"; metaTitle.Content = "" + rsBlog["POS_TITULO"].ToString() + ""; metaImage.Content = "http://projetopalavracantada.net/images/logo-fb.png"; //metaDescription.Content = "" + rsBlog["POS_TITULO"].ToString() + ""; metaDescription.Content = "" + rsBlog["POS_TEXTO"].ToString() + ""; metaURL.Content = "http://projetopalavracantada.net/post/" + Request["titulo"] + ""; var USU_ID_BLOG = rsBlog["USU_ID"].ToString(); if (!string.IsNullOrWhiteSpace(USU_ID_BLOG)) { var USU_ID_SESSAO = Session["usuId"].ToString(); if (USU_ID_BLOG == USU_ID_SESSAO) { Response.Redirect("../meu-post/" + Request["titulo"]); } } // liFace.InnerHtml = "<iframe src=\"//www.facebook.com/plugins/like.php?href=http%3A%2F%2Fprojetopalavracantada.net%2Fpost%2F" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "&width&layout=button_count&action=like&show_faces=true&share=true&height=21&appId=404437276390840\" scrolling=\"no\" frameborder=\"0\" style=\"border:none; overflow:hidden; height:21px;\" allowTransparency=\"true\"></iframe>"; if (!string.IsNullOrWhiteSpace(rsBlog["RED_ID"].ToString())) { //breadcrumb breadcrumb.InnerHtml = "<a href='/' title='Home'>Home</a> >> <strong><a href=\"/blog-regional\">Blog-Regional</a></strong> >> " + rsBlog["POS_TITULO"] + " "; } else { //breadcrumb breadcrumb.InnerHtml = "<a href='/' title='Home'>Home</a> >> <strong>Blog</strong> >> " + rsBlog["POS_TITULO"] + " "; } if (string.IsNullOrWhiteSpace(rsBlog["POS_IMAGEM"].ToString()) == true) { imgPost.Attributes.Add("style", "display:none;"); } //imagem imgPost.Src = "/upload/imagens/blog/big-" + rsBlog["POS_IMAGEM"].ToString() + ""; logPost.InnerHtml += "Publicado por <strong><i>" + rsBlog["USU_NOME"] + rsBlog["ADM_NOME"] + "</i></strong> em <strong><i>" + rsBlog["POS_DH_PUBLICACAO"].ToString() + "</i></strong> na categoria: <strong><i>" + rsBlog["PCA_TITULO"].ToString() + "</i></strong><br/><br/>"; //Texto txtPost.InnerHtml += "<p class='tit_post'>" + rsBlog["POS_TITULO"] + "</p>"; txtPost.InnerHtml += "" + rsBlog["POS_TEXTO"].ToString() + ""; //liGPlus.InnerHtml = "<div class='g-plus' data-action='share' data-annotation='bubble' data-href='href=\"/post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\"'></div>"; } rsBlog.Close(); rsBlog.Dispose(); }
public void FiltrarPesquisa(string RED_ID, string CDO_TAREFA) { rsLista = objBD.ExecutaSQL("EXEC admin_psCriacaoDocumentadaFiltro '" + RED_ID + "', '" + CDO_TAREFA + "'"); if (rsLista == null) { throw new Exception(); } string resposta = ""; if (rsLista.HasRows) { resposta += " <thead>"; resposta += " <tr>"; resposta += " <th>Data</th>"; resposta += " <th style=\"width:300px;\">Proposta</th>"; resposta += " <th style=\"width:200px;\">Rede</th>"; resposta += " <th style=\"width:200px;\">Status</th>"; resposta += " <th style=\"width:85px;\">Ações</th>"; resposta += " </tr>"; resposta += " </thead>"; while (rsLista.Read()) { resposta += " <tr id='tr_" + rsLista["CDO_ID"].ToString() + "' class=\"\">"; resposta += " <td>" + rsLista["CDO_DATA"].ToString() + "</td>"; resposta += " <td>" + objUtils.CortarString(true, 90, rsLista["CDO_TAREFA"].ToString()) + "</td>"; resposta += " <td>" + rsLista["RED_NOME"].ToString() + "</td>"; if (rsLista["CDO_STATUS"].ToString() == "Ativa") { resposta += " <td><select class='input' onchange='arquivar(" + rsLista["CDO_ID"].ToString() + ", this);'><option value='Ativa' selected='selected'>Ativa</option><option value='Arquivada'>Arquivada</option></select></td>"; } else { resposta += " <td><select class='input' onchange='arquivar(" + rsLista["CDO_ID"].ToString() + ", this);'><option value='Ativa'>Ativa</option><option selected='selected' value='Arquivada'>Arquivada</option></select></td>"; } resposta += " <td><ul class=\"icons_table\"><li><a id='" + rsLista["CDO_ID"].ToString() + "' onclick='popularFormulario(this.id);' href=\"javascript:void(0)\" class=\"img_del\"><img src=\"images/editar.png\"></a></li><li><a id='" + rsLista["CDO_ID"].ToString() + "' onclick='excluir(this.id);' href=\"javascript:void(0)\" class=\"img_del\"><img src=\"images/lixo.png\"></a></li></ul>"; resposta += " </tr>"; } resposta += " </tbody>"; } else { resposta += " <thead>"; resposta += " <tr>"; resposta += " <td colspan=\"5\">Nenhum resultado para esta pesquisa</td>"; resposta += " </tr>"; resposta += " </thead>"; } Response.Write(resposta); Response.End(); rsLista.Close(); rsLista.Dispose(); }
/// <summary> /// 执行sql /// </summary> /// <param name="strSql"></param> /// <param name="strDataSet"></param> /// <returns></returns> public int ExecQuery(string strSql, ref string strDataSet, string strXSLFileName) { this.command.Connection = this.con as OleDbConnection; this.command.CommandType = System.Data.CommandType.Text; this.command.Parameters.Clear(); this.command.CommandText = strSql + ""; try { this.TempReader1 = this.command.ExecuteReader(); XmlDocument doc = new XmlDocument(); XmlNode root; XmlElement node, row; doc.AppendChild(doc.CreateXmlDeclaration("1.0", "GB2312", "")); if (strXSLFileName != null && strXSLFileName != "") { string PI = "type='text/xsl' href='" + strXSLFileName + "'"; System.Xml.XmlProcessingInstruction xmlProcessingInstruction = doc.CreateProcessingInstruction("xml-stylesheet", PI); doc.AppendChild(xmlProcessingInstruction); } root = doc.CreateElement("Table"); doc.AppendChild(root); while (this.TempReader1.Read()) { row = doc.CreateElement("Row"); for (int i = 0; i < this.TempReader1.FieldCount; i++) { node = doc.CreateElement("Column"); node.SetAttribute("Name", this.TempReader1.GetName(i).ToString()); node.InnerText = this.TempReader1[i].ToString() + ""; row.AppendChild(node); } root.AppendChild(row); } strDataSet = doc.OuterXml; TempReader1.Close(); } catch (OleDbException ex) { this.Err = "执行产生错误!" + ex.Message; this.ErrCode = strSql; this.DBErrCode = ex.ErrorCode; this.WriteErr(); return(-1); } catch (Exception ex) { this.Err = "执行语句产生错误!" + ex.Message; this.ErrorException = ex.InnerException + "+ " + ex.Source; this.ErrCode = strSql; this.WriteErr(); return(-1); } WriteDebug("执行查询sql语句!" + strSql); return(0); }
public Member CheckLogin(string _userName, string _password) { Member memer = null; try { Conn = db.openConn(); sb = new StringBuilder(); sb.Remove(0, sb.Length); sb.Append(" SELECT ID,UserName,PasswordMember,Email,MemberType FROM tbMember "); sb.Append(" WHERE (UserName='******')"); sb.Append(" AND (PasswordMember='" + _password + "')"); string sql; sql = sb.ToString(); com = new OleDbCommand(); com.CommandText = sql; com.CommandType = CommandType.Text; com.Connection = Conn; dr = com.ExecuteReader(); if (dr.HasRows) { DataTable dt = new DataTable(); dt.Load(dr); foreach (DataRow drw in dt.Rows) { memer = new Member(); memer.ID = Convert.ToInt32(drw["ID"].ToString()); memer.UserName = Convert.ToString (drw["UserName"].ToString()); memer.Password = Convert.ToString(drw["PasswordMember"].ToString()); memer.Email = Convert.ToString(drw["Email"].ToString()); memer.MemmerType = Convert.ToInt32(drw["MemberType"].ToString()); } } dr.Close(); } catch (Exception ex) { Conn.Close(); return null; throw ex; } finally { Conn.Close(); } return memer; }
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); } }
public void PopulaExcluidos() { divExcluidos.InnerHtml = "<table class=\"table\" id=\"tabela\" cellspacing=\"0\">"; rsLista = objBD.ExecutaSQL("EXEC admin_psRedesPorAtivo 0"); if (rsLista == null) { throw new Exception(); } if (rsLista.HasRows) { divExcluidos.InnerHtml += " <thead>"; divExcluidos.InnerHtml += " <tr>"; divExcluidos.InnerHtml += " <th style=\"width:8px;\">ID</th>"; divExcluidos.InnerHtml += " <th>Titulo</th>"; divExcluidos.InnerHtml += " <th>Cidade</th>"; divExcluidos.InnerHtml += " <th>UF</th>"; divExcluidos.InnerHtml += " <th>Data de Criação</th>"; divExcluidos.InnerHtml += " <th>Quantidade de Usuários</th>"; divExcluidos.InnerHtml += " <th style=\"width:71px;\">Ações</th>"; divExcluidos.InnerHtml += " </tr>"; divExcluidos.InnerHtml += " </thead>"; divExcluidos.InnerHtml += " <tbody>"; while (rsLista.Read()) { divExcluidos.InnerHtml += " <tr id='tr_" + rsLista["RED_ID"].ToString() + "' class=\"\">"; divExcluidos.InnerHtml += " <td>" + rsLista["RED_ID"].ToString() + "</td>"; divExcluidos.InnerHtml += " <td>" + rsLista["RED_TITULO"].ToString() + "</td>"; divExcluidos.InnerHtml += " <td>" + rsLista["RED_CIDADE"].ToString() + "</td>"; divExcluidos.InnerHtml += " <td>" + rsLista["RED_UF"].ToString() + "</td>"; divExcluidos.InnerHtml += " <td>" + rsLista["RED_DATA_CRIACAO"].ToString() + "</td>"; divExcluidos.InnerHtml += " <td>" + rsLista["RED_QTD_USUARIO"].ToString() + "</td>"; divExcluidos.InnerHtml += " <td><a href=\"javascript:void(0)\" id='" + rsLista["RED_ID"].ToString() + "' onclick='restoreRede(this.id);' class=\"img_del\"><img src=\"images/restore.png\"></a>"; divExcluidos.InnerHtml += " </tr>"; } divExcluidos.InnerHtml += " </tbody>"; } else { divExcluidos.InnerHtml += " <thead>"; divExcluidos.InnerHtml += " <tr>"; divExcluidos.InnerHtml += " <th>Nenhum registro cadastrado até o momento!</th>"; divExcluidos.InnerHtml += " </tr>"; divExcluidos.InnerHtml += " </thead>"; } rsLista.Close(); rsLista.Dispose(); divExcluidos.InnerHtml += "</table>"; }
private void btnSave_Click(object sender, EventArgs e) { if (txtCompanyName.Text == string.Empty) { MessageBox.Show("Please enter company name", "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error); txtCompanyName.Focus(); return; } try { con = new OleDbConnection(cs); con.Open(); var ct = "select CompanyName from Company where CompanyName='" + txtCompanyName.Text + "'"; cmd = new OleDbCommand(ct); cmd.Connection = con; rdr = cmd.ExecuteReader(); if (rdr.Read()) { MessageBox.Show("มีชื่อผู้ผลิตนี้อยู่แล้ว", "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error); txtCompanyName.Text = string.Empty; txtCompanyName.Focus(); if ((rdr != null)) { rdr.Close(); } return; } con = new OleDbConnection(cs); con.Open(); var cb = "insert into Company(CompanyName) VALUES ('" + txtCompanyName.Text + "')"; cmd = new OleDbCommand(cb); cmd.Connection = con; cmd.ExecuteReader(); con.Close(); MessageBox.Show("บันทึกข้อมูลสำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information); Autocomplete(); btnSave.Enabled = false; } catch (Exception ex) { MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 关闭数据库连接 /// </summary> public static void Close(OleDbDataReader dr) { if (dr != null) { if ( !dr.IsClosed ) { dr.Close(); } dr.Dispose(); dr = null; } }
public void PopulaLista() { string objetolista = ""; objetolista = "<table class=\"table\" id=\"tabela\" cellspacing=\"0\">"; rsLista = objBD.ExecutaSQL("select * from SobreProjeto where SOB_ID = 2"); if (rsLista == null) { throw new Exception(); } if (rsLista.HasRows) { objetolista += " <thead>"; objetolista += " <tr>"; objetolista += " <th style=\"width:60px;\">ID</th>"; objetolista += " <th style=\"width:600px;\">Titulo</th>"; objetolista += " <th style=\"width:90px;\">Ações</th>"; objetolista += " </tr>"; objetolista += " </thead>"; objetolista += " <tbody>"; while (rsLista.Read()) { objetolista += " <tr id='tr_" + rsLista["SOB_ID"].ToString() + "' class=\"\">"; objetolista += " <td>" + rsLista["SOB_ID"].ToString() + "</td>"; objetolista += " <td>" + rsLista["SOB_TITULO"].ToString() + "</td>"; objetolista += " <td><ul class=\"icons_table\"><li><a href=\"javascript:void(0)\" id='" + rsLista["SOB_ID"].ToString() + "' onclick='popularFormulario(this.id);' class=\"img_edit\"><img src=\"images/editar.png\"></a></li></ul>"; objetolista += " </tr>"; } objetolista += " </tbody>"; } else { objetolista += " <thead>"; objetolista += " <tr>"; objetolista += " <th>Nenhum registro cadastrado até o momento!</th>"; objetolista += " </tr>"; objetolista += " </thead>"; } rsLista.Close(); rsLista.Dispose(); objetolista += "</table>"; divLista.InnerHtml = objetolista; }
public static List <string> GetReqInfo(int reqID) { //This Function is used for getting Req+ID info for populating rows. Each item pulls out into a list that can be referenced individually. { //make an Oledbcommandobject OleDbCommand cmd = null; //make an Oledbdatareader System.Data.OleDb.OleDbDataReader Reader = null; //Making Query string query = "SELECT * FROM Requests WHERE Req_ID =" + reqID; //connects to the database and catches if there is a problem connecting List <string> reqIDList = new List <string>(); //Initializing list so things can be stored in it cmd = new OleDbCommand(query, 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 { reqIDList.Add(Convert.ToString(Reader["Travel"])); reqIDList.Add(Convert.ToString(Reader["Est_Total_Cost"])); reqIDList.Add(Convert.ToString(Reader["Emp_ID"])); reqIDList.Add(Convert.ToString(Reader["Description"])); reqIDList.Add(Convert.ToString(Reader["Begin_Date"])); reqIDList.Add(Convert.ToString(Reader["End_Date"])); reqIDList.Add(Convert.ToString(Reader["Decision_Date"])); reqIDList.Add(Convert.ToString(Reader["Status"])); reqIDList.Add(Convert.ToString(Reader["Current_Approval"])); } Reader.Close(); } catch (InvalidOperationException) { Connection.Close(); } Reader.Close(); return(reqIDList); } }
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; } }
/// <summary> /// 执行sql语句 重载 /// </summary> /// <param name="strSql"></param> /// <param name="strDataSet">返回DataSet xml</param> /// <returns></returns> public int ExecQuery(string strSql, ref string strDataSet) { this.command.Connection = this.con as OleDbConnection; this.command.CommandType = System.Data.CommandType.Text; this.command.Parameters.Clear(); this.command.CommandText = strSql + ""; try { this.TempReader1 = this.command.ExecuteReader(); XmlDocument doc = new XmlDocument(); XmlNode root; XmlNode node, table; root = doc.CreateElement("DataSet"); doc.AppendChild(root); while (this.TempReader1.Read()) { table = doc.CreateElement("Table"); for (int i = 0; i < this.TempReader1.FieldCount; i++) { node = doc.CreateElement(this.TempReader1.GetName(i).ToString()); node.InnerText = this.TempReader1[i].ToString() + ""; table.AppendChild(node); } root.AppendChild(table); } strDataSet = doc.OuterXml; TempReader1.Close(); } catch (OleDbException ex) { this.Err = "执行产生错误!" + ex.Message; this.ErrCode = strSql; this.DBErrCode = ex.ErrorCode; this.WriteErr(); return(-1); } catch (Exception ex) { this.Err = "执行语句产生错误!" + ex.Message; this.ErrorException = ex.InnerException + "+ " + ex.Source; this.ErrCode = strSql; this.WriteErr(); return(-1); } WriteDebug("执行查询sql语句!" + strSql); return(0); }
private int FillFromRecord(object data, UnsafeNativeMethods.ADORecordConstruction record, string srcTable) { object?result; try { result = record.get_Row(); } catch (Exception e) { // UNDONE - should not be catching all exceptions!!! if (!ADP.IsCatchableExceptionType(e)) { throw; } throw ODB.Fill_EmptyRecord("adodb", e); } if (null != result) { CommandBehavior behavior = (MissingSchemaAction.AddWithKey != MissingSchemaAction) ? 0 : CommandBehavior.KeyInfo; behavior |= CommandBehavior.SequentialAccess | CommandBehavior.SingleRow; OleDbDataReader?dataReader = null; try { dataReader = new OleDbDataReader(null, null, 0, behavior); dataReader.InitializeIRow(result, ADP.RecordsUnaffected); dataReader.BuildMetaInfo(); if (data is DataTable) { return(base.Fill((DataTable)data, dataReader)); } else { return(base.Fill((DataSet)data, srcTable, dataReader, 0, 0)); } } finally { dataReader?.Close(); } } return(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); }
/// <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); } }
private static bool checkTableExist(string tableName, System.Data.OleDb.OleDbConnection dbconn) { try { System.Data.OleDb.OleDbCommand cmd = new OleDbCommand("select * from " + tableName, dbconn); System.Data.OleDb.OleDbDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.Default); reader.Close(); return(true); } catch (System.Data.OleDb.OleDbException exc) { // Older version than 1.1 if (exc.Message.IndexOf("cannot find the input table") == -1) { Trace.WriteLine("Ops, unknown System.Data.OleDb.OleDbException while checking for db upgrade:\r\n" + exc.ToString()); } return(false); } }
private string GetDBImage(int Index, Accusoft.ImagXpressSdk.ImageXView iXView) { string ImageName; long retter; int bufferSize = 16777216; byte[] outByte = new byte[bufferSize - 1]; string stringConnection = (strProvider + strDataSource); string stringSQL = "SELECT * FROM [tblImages]"; dbConnection.ConnectionString = (strProvider + strDataSource); dbConnection.Open(); System.Data.OleDb.OleDbCommand dbCommandGet = new OleDbCommand(stringSQL, dbConnection); System.Data.OleDb.OleDbDataReader dbReader = dbCommandGet.ExecuteReader(CommandBehavior.Default); int i = 0; while ((i <= Index)) { dbReader.Read(); i = (i + 1); } retter = dbReader.GetBytes(2, 0, outByte, 0, bufferSize); MemoryStream stmBLOBData = new MemoryStream(outByte); ImageName = dbReader["ImageName"].ToString(); dbReader.Close(); try { iXView.Image = Accusoft.ImagXpressSdk.ImageX.FromStream(imagXpress1, stmBLOBData, loLoadOptions); } catch (Accusoft.ImagXpressSdk.ImagXpressException ex) { AccusoftError(ex, lblError); } if ((dbConnection.State == ConnectionState.Open)) { dbConnection.Close(); dbConnection.Dispose(); } return(ImageName); }
public static string getStr(string 参数_数据库路径, string 参数_SQL语句) { //初始化 string 返回文本 = ""; 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; odrReader.Read(); 返回文本 = odrReader[odrReader.GetName(0)].ToString(); //关闭连接 C#操作Access之读取mdb odrReader.Close(); odcConnection.Close(); return(返回文本); } catch { return(返回文本); } }
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++; } }
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(); }
/// <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 using (System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection) { 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(); 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); } }
private static List <string> comboboxFiller(string String1) { var Connect = new OleDiBi.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb"); Connect.Open(); var data = new List <string>(); OleDiBi.OleDbCommand COM = new OleDiBi.OleDbCommand(String1, Connect); OleDiBi.OleDbDataReader RESULT = COM.ExecuteReader(); while (RESULT.Read() == true) { var map = RESULT[0].ToString(); data.Add(map); } RESULT.Close(); Connect.Close(); return(data); }
//method to return id value public static string GetID(String SQLquery) { //make an Oledbcommandobject OleDbCommand cmd = null; //make an Oledbdatareader System.Data.OleDb.OleDbDataReader Reader = null; string PrimaryKeyID = null; //connects to the database and catches if there is a problem connecting cmd = new OleDbCommand(SQLquery, Connection); try { Reader = cmd.ExecuteReader(); } catch (InvalidOperationException) { Connection.Close(); } Reader.Close(); return(PrimaryKeyID); }
public static void Deletar_Registro(System.String Codigo) { string myDeleteQuery = "DELETE FROM Produto WHERE Codigo='" + Codigo + "'"; OleDbCommand myCommand2 = new OleDbCommand(myDeleteQuery); myCommand2.Connection = Geral.ECF.myConnection; myConnection.Close(); myConnection.Open(); myCommand2.ExecuteNonQuery(); //Geral.ECF.myReader = Geral.ECF.myCommand.ExecuteReader(); /*OleDbCommand myCommand2 = new OleDbCommand(myDeleteQuery); * myCommand2.Connection = myConnection; * myConnection.Open(); * myCommand2.ExecuteNonQuery(); * myCommand2.Connection.Close(); */ myReader.Close(); myConnection.Close(); }
/// <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 ... //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.String sql = getMessageListQuery(version); //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 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])); } //UPGRADE_ISSUE: Method 'java.sql.Statement.close' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javasqlStatementclose'" rs.Close(); NormativeDatabase.Instance.returnConnection(conn); if (messages.Count == 0) { //UPGRADE_ISSUE: Method 'java.lang.System.getProperty' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javalangSystem'" 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); } } }
private void Form1_Load(object sender, System.EventArgs e) { //***The SetSolutionName, SetSolutionKey and possibly the SetOEMLicenseKey methods must be called to distribute the runtime*** //imagXpress1.Licensing.SetSolutionName("YourSolutionName"); //imagXpress1.Licensing.SetSolutionKey(12345,12345,12345,12345); //imagXpress1.Licensing.SetOEMLicenseKey("1.0.AStringForOEMLicensingContactAccusoftSalesForMoreInformation�"); // Because in this sample the ImageX object is always located in the ImageXView // tell the ImageXView component to dispose of the ImageX object when itself is // disposed. Otherwise, we would have to dispose of the ImageX object in the Form's // Dispose method before the components.Dispose() section. imageXView1.AutoImageDispose = true; int bufferSize = 16777216; byte[] outByte = new byte[bufferSize - 1]; string stringConnection = (strProvider + strDataSource); string stringSQL = "SELECT * FROM [tblImages]"; try { //Create a new load options object so we can recieve events from the images we load loLoadOptions = new Accusoft.ImagXpressSdk.LoadOptions(); } catch (Accusoft.ImagXpressSdk.ImagXpressException ex) { AccusoftError(ex, lblError); } // Note that this database does not support 64-bit so the target platform // for this project must be set to x86 strCurrentDatabase = Application.StartupPath + "..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\Common\\Images\\DatabaseInteraction.mdb"; String strCurrentDir = System.IO.Path.Combine(Application.StartupPath, @"..\..\..\..\..\..\..\..\..\..\Common\Images\"); if (System.IO.Directory.Exists(strCurrentDir)) { System.IO.Directory.SetCurrentDirectory(strCurrentDir); } strCurrentDir = System.IO.Directory.GetCurrentDirectory(); strDataSource = "Data Source=" + strCurrentDatabase; stringSQL = "SELECT * FROM [tblImages]"; imageXView1.AutoScroll = true; dbConnection = new OleDbConnection(); dbInsertCommand = new System.Data.OleDb.OleDbCommand(); dbInsertCommand.CommandText = "INSERT INTO tblImages([Image], ImageName) VALUES (?, ?)"; dbInsertCommand.Connection = dbConnection; dbInsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Image", System.Data.OleDb.OleDbType.VarBinary, 0, "Image")); dbInsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("ImageName", System.Data.OleDb.OleDbType.VarWChar, 255, "ImageName")); dbDeleteCommand = new System.Data.OleDb.OleDbCommand(); dbUpdateCommand = new System.Data.OleDb.OleDbCommand(); dbDeleteCommand.CommandText = "DELETE FROM tblImages WHERE (ID = ?) AND (ImageName = ? OR ? IS NULL AND ImageName IS NULL)"; dbDeleteCommand.Connection = dbConnection; dbDeleteCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ID", System.Data.DataRowVersion.Original, null)); dbDeleteCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ImageName", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ImageName", System.Data.DataRowVersion.Original, null)); dbDeleteCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ImageName1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ImageName", System.Data.DataRowVersion.Original, null)); dbConnection.ConnectionString = strProvider + strDataSource; dbConnection.Open(); System.Data.OleDb.OleDbCommand dbCommandGet = new OleDbCommand(stringSQL, dbConnection); System.Data.OleDb.OleDbDataReader dbReader = dbCommandGet.ExecuteReader(CommandBehavior.Default); int i = 0; while (dbReader.Read()) { CmbBxImages.Items.Add(dbReader["ImageName"].ToString()); if ((i == 0)) { CmbBxImages.Text = dbReader["ImageName"].ToString(); } i = (i + 1); } dbReader.Close(); dbConnection.Close(); // Load the first Image in the List GetDBImage(0, imageXView1); bFormLoadComplete = true; }
protected void Page_Load(object sender, System.EventArgs e) { string formato_html; if (Session["loggeado"] == null) { Response.Redirect(System.Configuration.ConfigurationManager.AppSettings["urlRoot"].ToString() + "/ingreso.aspx", true); } string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BaseSqlServer"].ConnectionString; string formato_id = Session["formato_id"].ToString(); string archivo_excel = Session["archivo_excel"].ToString(); using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString)) { string strQuery = "SELECT html FROM matricula.mailxls_formato WHERE id = " + formato_id + ";"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strQuery, connection); connection.Open(); System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); formato_html = dr[0].ToString(); connection.Close(); Session.Add("formato_html", formato_html); } System.Data.OleDb.OleDbConnection cnExcel = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(archivo_excel) + ";Extended Properties=Excel 8.0"); System.Data.OleDb.OleDbCommand cmdExcel = new System.Data.OleDb.OleDbCommand("select * from [Hoja1$]", cnExcel); cnExcel.Open(); System.Data.OleDb.OleDbDataReader drExcel = cmdExcel.ExecuteReader(); int numero_campos = drExcel.FieldCount; string[] nombre_campos = new string[numero_campos]; int j = 1; for (int i = 0; i < numero_campos; i++) { nombre_campos[i] = "{" + drExcel.GetName(i).Trim() + "}"; } if (drExcel.Read()) { for (int i1 = 0; i1 < numero_campos; i1++) { formato_html = formato_html.Replace(nombre_campos[i1], drExcel[i1].ToString()); } } while (drExcel.Read()) { if (drExcel[0].ToString() != "") { j++; } } lblFormato.Text = "<p align=\"right\">" + numero_campos.ToString() + " campos ha reemplazar.<br />" + j.ToString() + " destinatarios.</p>"; drExcel.Close(); cnExcel.Close(); if (formato_html.Contains("\\'")) { formato_html = formato_html.Replace("\\'", "'"); } if (formato_html.Contains("\\\"")) { formato_html = formato_html.Replace("\\\"", "\""); } formato_html = Server.HtmlDecode(formato_html); lblFormato.Text += formato_html; }
//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 override bool Check(ref List <Error> checkResult) { //System.Diagnostics.Stopwatch MyWatch = new System.Diagnostics.Stopwatch(); //MyWatch.Start(); System.Data.OleDb.OleDbDataReader reader = null; try { DataTable pRecordset = new DataTable(); if (m_structPara.strScript == "行政区层中行政区代码与行政区名称不匹配") { string strTemp = "select objectid,BSM,xzqdm, xzqmc,qsdwmc from(select a2.objectid,a2.BSM,a2.xzqdm,a2.xzqmc, a1.qsdwdm,a1.qsdwmc from qsdmb a1 inner join xzq a2 on left(a1.qsdwdm,12)=left(a2.xzqdm,12) where mid(qsdwdm,12,1)<>'0' and right(qsdwdm,7)='0000000') where Trim(a2.xzqmc)<>Trim(a1.qsdwmc)"; pRecordset = AdoDbHelper.GetDataTable(base.m_QueryConnection, strTemp); if (pRecordset == null || pRecordset.Rows.Count == 0) { string strLog = "当前规则的SQL查询语句设置有误,无法执行多表关系检查!"; SendMessage(enumMessageType.RuleError, strLog); return(false); } } else if (m_structPara.strScript.Contains("权属代码表不一致") || m_structPara.strScript.Contains("权属单位代码表不一致")) { reader = AdoDbHelper.GetQueryReader(base.m_QueryConnection, m_structPara.strClause) as OleDbDataReader; if (reader == null) { string strLog = "当前规则的SQL查询语句设置有误,无法执行多表关系检查!"; SendMessage(enumMessageType.RuleError, strLog); return(false); } pRecordset.Load(reader); } else { pRecordset = AdoDbHelper.GetDataTable(base.m_QueryConnection, m_structPara.strClause); if (pRecordset == null || pRecordset.Rows.Count == 0) { string strLog = "当前规则的SQL查询语句设置有误,无法执行多表关系检查!"; SendMessage(enumMessageType.RuleError, strLog); return(false); } } string strSql = ""; bool bTable = false; if (FtName1.Contains("表") || FtName2.Contains("表")) { if (m_structPara.strFtName2.Equals("qsdmb", StringComparison.OrdinalIgnoreCase)) { strSql = "update LR_ResultEntryRule set TargetFeatClass1= '" + FtName1 + "',TargetFeatClass2='" + FtName2 + "|' where RuleInstID='" + base.m_InstanceID + "'"; } else { strSql = "update LR_ResultEntryRule set TargetFeatClass1= '" + COMMONCONST.TABLENAME + "',TargetFeatClass2='|' where RuleInstID='" + base.m_InstanceID + "'"; bTable = true; } } else { strSql = "update LR_ResultEntryRule set TargetFeatClass1= '" + FtName1 + "',TargetFeatClass2='" + FtName2 + "|' where RuleInstID='" + base.m_InstanceID + "'"; } AdoDbHelper.ExecuteSql(m_ResultConnection, strSql); //获取需要特殊处理的规则别名 Hashtable hashtable = GetEnumHash(); if (hashtable.Contains(m_structPara.strAlias)) { if (m_structPara.strAlias.Equals("省级上报田坎系数与上报数据中田坎系数是否一致检查")) { checkResult = GetTKXSResult(pRecordset); } else { checkResult = GetAttrResult(pRecordset); } } else { checkResult = GetResult(pRecordset, bTable); } if (pRecordset != null) { pRecordset.Dispose(); return(true); } } catch (Exception ex) { SendMessage(enumMessageType.RuleError, string.Format("意外失败,信息:{0}", ex.Message)); SendMessage(enumMessageType.Exception, ex.ToString()); return(false); } finally { if (reader != null) { reader.Dispose(); reader.Close(); GC.Collect(); } } //MyWatch.Stop(); //System.Windows.Forms.MessageBox.Show("时间:" + MyWatch.ElapsedMilliseconds.ToString() + "毫秒"); return(true); }