private static void show(MySqlDataReader reader) { while (reader.Read()){ for (int i =0; i< reader.FieldCount; i++) { Console.Write ("{0} = {1} ", reader.GetName (i), reader [reader.GetName (i)]); } Console.WriteLine (" "); } }
public Entregador(MySqlDataReader rs) { try { int i = 0; while (true) { switch (rs.GetName(i)) { case "cpf": this.cpf = rs.GetString(i); break; case "nome": this.nome = rs.GetString(i); break; case "telefone": if (this.telefone == null) this.telefone = new model.Telefone(); this.telefone.Numero = rs.GetString(i); break; case "placa": this.placa = rs.GetString(i); break; default: throw new Exception("Propriedade não encontrada"); } i++; } } catch { } }
public Fornecedor(MySqlDataReader rs) { try { int i = 0; while (true) { switch (rs.GetName(i)) { case "cnpj": this.cnpj = rs.GetString(i); break; case "nome": this.nome = rs.GetString(i); break; case "endereco_rua": if (this.endereco == null) this.endereco = new model.Endereco(); this.endereco.Rua = rs.GetString(i); break; case "endereco_numero": if (this.endereco == null) this.endereco = new model.Endereco(); this.endereco.Numero = rs.GetString(i); break; case "endereco_complemento": if (this.endereco == null) this.endereco = new model.Endereco(); this.endereco.Complemento = rs.GetString(i); break; case "endereco_bairro": if (this.endereco == null) this.endereco = new model.Endereco(); this.endereco.Bairro = rs.GetString(i); break; case "endereco_cep": if (this.endereco == null) this.endereco = new model.Endereco(); this.endereco.Cep = rs.GetString(i); break; case "endereco_cidade": if (this.endereco == null) this.endereco = new model.Endereco(); this.endereco.Cidade = rs.GetString(i); break; case "endereco_estado": if (this.endereco == null) this.endereco = new model.Endereco(); this.endereco.Estado = rs.GetString(i); break; case "telefone_ddd": if (this.telefone == null) this.telefone = new model.Telefone(); this.telefone.Ddd = rs.GetString(i); break; case "telefone_tel": if (this.telefone == null) this.telefone = new model.Telefone(); this.telefone.Numero = rs.GetString(i); break; default: throw new Exception("Propriedade não encontrada"); } i++; } } catch { } }
private static void showColumnNames(MySqlDataReader mySqlDataReader) { //SOLUCION MIA int numeroColumnas = mySqlDataReader.FieldCount; for (int i=0;i<numeroColumnas;i++) { Console.Write (mySqlDataReader.GetName(i) + " "); } /*SOLUCION PROFESOR 1 Console.WriteLine ("showColumnNames..."); for (int index = 0; index < mySqlDataReader.FieldCount; index++) { Console.WriteLine ("index=" + index + " columna=" + mySqlDataReader.GetName (index)); } */ /*SOLUCION PROFESOR 2 CON ARRAY int count= mySqlDataReader.FieldCount; string[] columNames = new string[count]; for(int index =0; index <count; index++){ columNames [index] = mySqlDataReader.GetName (index); } foreach (string columnName in columnNames){ console.WriteLine ("Columna=" +columnName); } */ }
private static void showColumNames(MySqlDataReader mysqlDataReader) { // SOLUCION YO int columns = mysqlDataReader.FieldCount; //Console.Write (columns); for (int i=0; i < columns; i++) { Console.Write (mysqlDataReader.GetName(i)+" "); } // // OTRA OPCION // int count = mysqlDataReader.FieldCount; //cuenta las columnas // List<string> columnNames = new List<string> (); //crea una lista // for (int i=0; i< count; i++) { //la recorre // columnNames.Add (mysqlDataReader.GetName (i)); return columnNames.ToArray (); // } // /* SOLUCION PROFESOR // int columns = mysqlDataReader.FieldCount; // String [] columnNames = new string[columns]; // for (int i=0; i<columns;i++){ // columnNames [i] = mysqlDataReader.GetName (i); // }*/ }
public System.Data.DataTable DataReaderToDataTable(MySqlDataReader Reader) { System.Data.DataTable dt = new System.Data.DataTable(); System.Data.DataColumn dc; System.Data.DataRow dr; ArrayList arr = new ArrayList(); int i; for(i=0;i<Reader.FieldCount;i++) { dc = new System.Data.DataColumn(); dc.ColumnName = Reader.GetName(i); arr.Add(dc.ColumnName); dt.Columns.Add(dc); } while(Reader.Read()) { dr = dt.NewRow(); for (i=0;i<Reader.FieldCount;i++) { dr[(string)arr[i]] = Reader[i].ToString(); } dt.Rows.Add(dr); } Reader.Close(); return dt; }
private static void showColumNames(MySqlDataReader mySqlDataReader) { for (int i = 0; i < mySqlDataReader.FieldCount; i++) { Console.WriteLine ("Columna: " + mySqlDataReader.GetName (i)); } Console.WriteLine (" "); }
public static void debugvar(MySqlDataReader dataReader) { for (int i = 0; i < dataReader.FieldCount; i++) { Console.WriteLine("[" + dataReader.GetName(i) + "] = " + dataReader[i]); } Console.WriteLine("===================================================="); }
private static string[] getColumnNames(MySqlDataReader mySqlDataReader) { int count = mySqlDataReader.FieldCount; string[] columnNames = new string[count]; for (int i = 0; i < count; i++) columnNames [i] = mySqlDataReader.GetName (i); return columnNames; }
public static string[] getColumnNames(MySqlDataReader mySqlDataReader) { int count = mySqlDataReader.FieldCount; List<string> columnNames = new List<string> (); for (int index = 0; index < count; index++) columnNames.Add (mySqlDataReader.GetName (index)); return columnNames.ToArray(); }
private static string[] showColumnNames(MySqlDataReader mysqldatareader) { int columns = mysqldatareader.FieldCount; string[] columnasNombre = new string[columns]; for (int i=columns-1; i>=0; i--) columnasNombre[i] = mysqldatareader.GetName (i); return columnasNombre; }
private static IEnumerable<string> getcolumNames2(MySqlDataReader mysqlDataReader) { int numCol=mysqlDataReader.FieldCount; List<string> columNames= new List<string>(); for(int i=0;i<numCol;i++) columNames.Add(mysqlDataReader.GetName(i)); return columNames; }
private static IEnumerable<string> getColumnNames(MySqlDataReader mySqlDataReader) { int fieldCount = mySqlDataReader.FieldCount; string[] columnNames = new string[ fieldCount ]; for (int index = 0; index < fieldCount; index++) columnNames[index] = mySqlDataReader.GetName (index); return columnNames; }
private static IEnumerable<string> getColumnNames2(MySqlDataReader mySqlDataReader) { int fieldCount = mySqlDataReader.FieldCount; List<string> columnNames = new List<string>(); for (int index = 0; index < fieldCount; index++) columnNames.Add ( mySqlDataReader.GetName(index) ); return columnNames; }
private static void showColumnNames(MySqlDataReader mySqlDataReader) { String columnName = ""; for (int i=0; i<mySqlDataReader.FieldCount; i++) { columnName = mySqlDataReader.GetName (i); Console.WriteLine ("posicion "+i+ " = "+columnName+" "); } }
public DBRowDescriptor(ref MySqlDataReader res) { int column = res.FieldCount; for (int i = 0; i < column; i++) { AddColumn(res.GetName(i), this.GetType(i, ref res)); } }
private static IEnumerable<string> getcolumNames(MySqlDataReader mysqlDataReader) { string[] names=new string [mysqlDataReader.FieldCount]; int numCol=mysqlDataReader.FieldCount; for(int i=0;i<numCol;i++){ names[i]=mysqlDataReader.GetName(i); } return names; }
private static void showColumnNames(MySqlDataReader mySqlDataReader) { Console.WriteLine ("Columnas:"); for (int i = 0; i < mySqlDataReader.FieldCount; i++) { Console.WriteLine("nº = " + i + " // nombre: " + mySqlDataReader.GetName (i)); } Console.WriteLine (""); }
//----------------------------------------------------------------------------------------------------------- private static string[] getColumns(MySqlDataReader mysqldatareader) { int count = mysqldatareader.FieldCount; List<string> columNames = new List<string> (); for (int i =0; i<count; i++) { columNames.Add (mysqldatareader.GetName(i)); } return columNames.ToArray (); }
public static void showColumNames(MySqlDataReader mySqlDataReader) { // METODO QUE MUESTRA NUMERO Y NOMBRE DE LAS COLUMNAS Console.WriteLine ("COLUMNAS :"); //string[] columNames = getColumNames (mySqlDataReader); //Console.WriteLine (string.Join(",",columNames)); // ES LO MISMO QUE EL FOR DE ABAJO for (int i=0; i < mySqlDataReader.FieldCount; i++) Console.WriteLine ("num columa= " + i + ", nombre= " + mySqlDataReader.GetName (i)); }
private static string[] getColumNames(MySqlDataReader mySqlDataReader) { string[] names = new string[mySqlDataReader.FieldCount]; int numColum = mySqlDataReader.FieldCount; //Obtencion de las cabeceras for (int i = 0; i<numColum; i++){ names[i]=mySqlDataReader.GetName(i); } return names; }
//-----------------------SQL BUTTONS------------------------------------------------------------------------------------ private void button1_Click(object sender, EventArgs e) { flag = 0; establishConnection(); if (flag == 1) { textBox8.Text = "Invalid SQL Connection"; textBox8.Text += System.Environment.NewLine + "Try Again!"; } else { //textBox8.Text = "Valid SQL Connection"; string stringInput = textBox2.Text; if (stringInput == "") { textBox8.Clear(); textBox8.Text = "Error Invalid Input. Try Again!"; return; } int input = Int32.Parse(stringInput); try { int nid = input; string query = String.Format(@" SELECT title FROM news WHERE news_id = {0};", nid); MySql.Data.MySqlClient.MySqlCommand cmd = new MySqlCommand(query, conn); MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader(); textBox8.Clear(); textBox8.AppendText(String.Format("{0}", reader.GetName(0))); textBox8.Text += System.Environment.NewLine; while (reader.Read()) { //Console.WriteLine(reader[0]); textBox8.Text += reader[0]; textBox8.Text += System.Environment.NewLine; } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } } }
private static void showColumnNames(MySqlDataReader mySqlDataReader) { Console.Write ("======================================================"); Console.WriteLine (); for (int index = 0; index < mySqlDataReader.FieldCount; index++){ Console.Write (" " + mySqlDataReader.GetName(index) + " "); } Console.WriteLine (); Console.Write ("======================================================"); Console.WriteLine (); }
public static void showColumnNames(MySqlDataReader mySqlDataReader) { int numeroColumnas = mySqlDataReader.FieldCount; string nombreColumnas = null; for (int i=0; i < numeroColumnas; i++) { nombreColumnas += "Columna "+i+" :"+ mySqlDataReader.GetName (i)+ " "; } Console.WriteLine (nombreColumnas); }
//----------------------------------------------------------------------------------------------------------- private static void showColumnNames(MySqlDataReader mysqldatareader) { String columnName=""; String[] array = new String[mysqldatareader.FieldCount]; for (int i=0; i<mysqldatareader.FieldCount; i++) { columnName = mysqldatareader.GetName(i); array [i] = columnName; Console.WriteLine (columnName+" "); } }
public static string[] getColumnNames(MySqlDataReader mySqlDataReader) { // int count = mySqlDataReader.FieldCount; // string[] columnNames = new string[count]; // for (int index = 0; index < count; index++) // columnNames [index] = mySqlDataReader.GetName (index); // return columnNames; int count = mySqlDataReader.FieldCount; List<string> columNames = new List<string> (); for (int index = 0; index < count; index++) columNames.Add (mySqlDataReader.GetName (index)); return columNames.ToArray (); }
public static string[] getColumNames(MySqlDataReader mySqlDataReader) { // METODO QUE DEVUELVE UNA LISTA CON LA LINEA DE LA TABLA. (PUEDE HACERSE DEVOLVIENDO UN STRING) int count = mySqlDataReader.FieldCount; //string[] columNames = new string[count]; //for(int i=0;i<count;i++){ // ColumNames[i]=mySqlDataReader.GetName (i)} //return columNames List<string> columNames = new List<string> (); for(int i =0;i<count;i++) columNames.Add (mySqlDataReader.GetName(i)); return columNames.ToArray(); //PARA PASARLO A ARRAY USAR EL METODO .TOARRAY() }
public static void show(MySqlDataReader mySqlDataReader) { int numeroRegistro = mySqlDataReader.VisibleFieldCount; Console.WriteLine (""); int numeroColumnas = mySqlDataReader.FieldCount; string fila = null; for (int i=0; i <= numeroRegistro; i++) { mySqlDataReader.Read (); for (int j=0; j< numeroColumnas; j++) { fila += mySqlDataReader.GetName (j)+": " +mySqlDataReader.GetValue (j).ToString () + " "; } Console.WriteLine (fila); fila = null; } }
private System.Data.DataTable ConvertToDataTable(MySqlDataReader Reader) { int index = 0; string ColumnName; System.Data.DataTable dt = new System.Data.DataTable(); while(Reader.Read()) { ColumnName = Reader.GetName(index); dt.Columns.Add(ColumnName); // dt. index++; } return dt; }
private void Form2_Load(object sender, EventArgs e) { myDReader = myCmd.ExecuteReader(); string[] arr = new string[100]; for (int i = 0; i < myDReader.FieldCount; i++) { dataGridView1.Columns.Add(i.ToString(), myDReader.GetName(i)); } while (myDReader.Read()) { for (int i = 0; i < myDReader.FieldCount; i++) { arr[i] = myDReader.GetString(i); } dataGridView1.Rows.Add(arr); } myDReader.Close(); }
/** * 将MySqlDataReader对象读取为二维数组 * */ public List <Dictionary <string, object> > GetResult(MySqlDataReader mySqlDataReader) { if (connection.State == ConnectionState.Closed) { return(null); } if (mySqlDataReader != null) { //判断列数 List <Dictionary <string, object> > result = new List <Dictionary <string, object> >(); try { while (mySqlDataReader.Read()) { Dictionary <string, object> tempRow = new Dictionary <string, object>(); for (int i = 0; i < mySqlDataReader.FieldCount; i++) { var val = mySqlDataReader.GetValue(i); string str; if (val.GetType() == typeof(DateTime)) { str = ((DateTime)val).ToString("yyyy-MM-dd HH-mm-ss"); } else { str = val.ToString(); } tempRow.Add(mySqlDataReader.GetName(i), val); } result.Add(tempRow); } } catch (MySqlException e) { throw e; } mySqlDataReader.Close(); IntegratedResult = result; return(result); } IntegratedResult = null; return(null); }
internal void ProcessOutputParameters(MySqlDataReader reader) { this.AdjustOutputTypes(reader); if ((reader.CommandBehavior & CommandBehavior.SchemaOnly) != CommandBehavior.Default) { return; } reader.Read(); string text = "@_cnet_param_"; for (int i = 0; i < reader.FieldCount; i++) { string text2 = reader.GetName(i); if (text2.StartsWith(text, StringComparison.OrdinalIgnoreCase)) { text2 = text2.Remove(0, text.Length); } this.command.Parameters.GetParameterFlexible(text2, true).Value = reader.GetValue(i); } }
private MySqlDataReader GetHackedOuputParameters() { if (outSelect.Length == 0) { return(null); } MySqlCommand cmd = new MySqlCommand("SELECT " + outSelect, Connection); MySqlDataReader reader = cmd.ExecuteReader(); // since MySQL likes to return user variables as strings // we reset the types of the readers internal value objects // this will allow those value objects to parse the string based // return values ResultSet results = reader.ResultSet; for (int i = 0; i < reader.FieldCount; i++) { string fieldName = reader.GetName(i); fieldName = fieldName.Remove(0, ParameterPrefix.Length + 1); MySqlParameter parameter = Parameters.GetParameterFlexible(fieldName, true); IMySqlValue v = MySqlField.GetIMySqlValue(parameter.MySqlDbType); if (v is MySqlBit) { MySqlBit bit = (MySqlBit)v; bit.ReadAsString = true; results.SetValueObject(i, bit); } else { results.SetValueObject(i, v); } } if (!reader.Read()) { reader.Close(); return(null); } return(reader); }
public void WriteToFile(string Filename, MySqlDataReader dr) { Filename = @"C:\Reportes\" + Filename; using (System.IO.StreamWriter fs = new System.IO.StreamWriter(Filename)) { // Loop through the fields and add headers for (int i = 0; i < dr.FieldCount; i++) { string name = dr.GetName(i); if (name.Contains(",")) name = "\"" + name + "\""; if (i != dr.FieldCount - 1) fs.Write(name + ","); else fs.Write(name); } fs.WriteLine(); // Loop through the rows and output the data while (dr.Read()) { for (int i = 0; i < dr.FieldCount; i++) { string value = dr[i].ToString(); if (value.Contains(",")) value = "\"" + value + "\""; if (i != dr.FieldCount - 1) fs.Write(value + ","); else fs.Write(value); } fs.WriteLine(); } fs.Close(); fs.Dispose(); } }
private static string Export_GetInsertStatementHeader(RowsDataExportMode rowsExportMode, string tableName, MySqlDataReader rdr) { if (rdr == null) { throw new ArgumentNullException(nameof(rdr)); } var sb = new StringBuilder(); switch (rowsExportMode) { case RowsDataExportMode.Insert: sb.Append("INSERT INTO `"); break; case RowsDataExportMode.InsertIgnore: sb.Append("INSERT IGNORE INTO `"); break; case RowsDataExportMode.Replace: sb.Append("REPLACE INTO `"); break; } sb.Append(tableName); sb.Append("`("); for (var i = 0; i < rdr.FieldCount; i++) { if (i > 0) { sb.Append(","); } sb.Append("`"); sb.Append(rdr.GetName(i)); sb.Append("`"); } sb.Append(") VALUES"); return(sb.ToString()); }
private MySqlSchemaCollection GetTable(string sql) { MySqlSchemaCollection c = new MySqlSchemaCollection(); MySqlCommand cmd = new MySqlCommand(sql, connection); MySqlDataReader reader = cmd.ExecuteReader(); // add columns for (int i = 0; i < reader.FieldCount; i++) c.AddColumn(reader.GetName(i), reader.GetFieldType(i)); using (reader) { while (reader.Read()) { MySqlSchemaRow row = c.AddRow(); for (int i = 0; i < reader.FieldCount; i++) row[i] = reader.GetValue(i); } } return c; }
private void AdjustOutputTypes(MySqlDataReader reader) { for (int i = 0; i < reader.FieldCount; i++) { string text = reader.GetName(i); if (text.IndexOf("_cnet_param_") != -1) { text = text.Remove(0, "_cnet_param_".Length + 1); } IMySqlValue iMySqlValue = MySqlField.GetIMySqlValue(this.command.Parameters.GetParameterFlexible(text, true).MySqlDbType); if (iMySqlValue is MySqlBit) { MySqlBit mySqlBit = (MySqlBit)iMySqlValue; mySqlBit.ReadAsString = true; reader.ResultSet.SetValueObject(i, mySqlBit); } else { reader.ResultSet.SetValueObject(i, iMySqlValue); } } }
private MySqlSchemaCollection GetTable(string sql) { MySqlSchemaCollection mySqlSchemaCollection = new MySqlSchemaCollection(); MySqlCommand mySqlCommand = new MySqlCommand(sql, this.connection); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); for (int i = 0; i < mySqlDataReader.FieldCount; i++) { mySqlSchemaCollection.AddColumn(mySqlDataReader.GetName(i), mySqlDataReader.GetFieldType(i)); } using (mySqlDataReader) { while (mySqlDataReader.Read()) { MySqlSchemaRow mySqlSchemaRow = mySqlSchemaCollection.AddRow(); for (int j = 0; j < mySqlDataReader.FieldCount; j++) { mySqlSchemaRow[j] = mySqlDataReader.GetValue(j); } } } return(mySqlSchemaCollection); }
protected MySqlSchemaCollection QueryCollection(string name, string sql) { MySqlSchemaCollection c = new MySqlSchemaCollection(name); MySqlCommand cmd = new MySqlCommand(sql, connection); MySqlDataReader reader = cmd.ExecuteReader(); for (int i = 0; i < reader.FieldCount; i++) { c.AddColumn(reader.GetName(i), reader.GetFieldType(i)); } using (reader) { while (reader.Read()) { MySqlSchemaRow row = c.AddRow(); for (int i = 0; i < reader.FieldCount; i++) { row[i] = reader.GetValue(i); } } } return(c); }