private void PopulateList(SqlCeDataReader reader, List<Business.CommApplication> list) { while (reader.Read()) { var cap = new Business.CommApplication(); cap.ID = Convert.ToInt32(reader["ID"]); cap.Name = reader["Name"].ToString(); cap.Path = reader["Path"].ToString(); cap._recordExists = true; cap._hasChanged = false; list.Add(cap); } }
public static TRonda GetRondaFromDr(SqlCeDataReader dr) { TRonda r = new TRonda(); bool primero = true; while (dr.Read()) { if (primero) { r.rondaId = dr.GetInt32(0); r.nombre = dr.GetString(1); r.tag = dr.GetString(2); r.tagf = dr.GetString(3); r.RondasPuntos = new List<TRondaPunto>(); primero = false; } TRondaPunto rp = new TRondaPunto(); TPunto p = new TPunto(); TEdificio e = new TEdificio(); TGrupo g = new TGrupo(); rp.rondaPuntoId = dr.GetInt32(4); rp.orden = dr.GetInt32(5); p.puntoId = dr.GetInt32(6); p.nombre = dr.GetString(7); e.edificioId = dr.GetInt32(8); p.tag = dr.GetString(9); e.nombre = dr.GetString(10); g.grupoId = dr.GetInt32(11); g.nombre = dr.GetString(12); p.cota = dr.GetString(13); p.cubiculo = dr.GetString(14); r.mintime = dr.GetInt32(15); r.maxtime = dr.GetInt32(16); p.csnmax = dr.GetInt32(17); p.csnmargen = dr.GetInt32(18); p.lastcontrol = dr.GetDateTime(19); e.Grupo = g; p.Edificio = e; rp.Punto = p; rp.Ronda = r; r.RondasPuntos.Add(rp); } return r; }
//повернути типи тестів для того щоб користувач вибрав тип тесту який створює public string[] GetTestTypes() { List <string> result = new List <string>(); using (SqlCeConnection connection = new SqlCeConnection(connectionString)) { connection.Open(); using (SqlCeCommand cmd = connection.CreateCommand()) { cmd.CommandText = "SELECT DISTINCT TestType FROM Test WHERE OwnerId=@id OR OwnerId=@userId"; cmd.Parameters.AddWithValue("@userId", userId); cmd.Parameters.AddWithValue("@id", constId); SqlCeDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string type = dr["TestType"].ToString(); result.Add(type); } } } return(result.ToArray()); }
public bool Exist(string username, DailyUsageBO usage, out DailyUsageBO data) { using (SqlCeCommand cmd = new SqlCeCommand(String.Format("SELECT * FROM {0} WHERE day = @day", username), DataBaseFactory.Instance.GetConnection())) { cmd.Parameters.Add(new SqlCeParameter("@day", SqlDbType.DateTime) { Value = usage.Day }); using (SqlCeDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { data = ReadRecord(dr); return(true); } } } data = null; return(false); }
private void button2_Click(object sender, EventArgs e) { string cmdstr = "SELECT * FROM CANDIDATE WHERE S_ID=@CSID"; SqlCeConnection sqlcon = new SqlCeConnection(constr); SqlCeCommand sqlcmd = new SqlCeCommand(cmdstr, sqlcon); sqlcmd.Parameters.AddWithValue("@CSID", comboBox1.Text); try { sqlcon.Open(); SqlCeDataReader sdr = sqlcmd.ExecuteReader(); while (sdr.Read()) { textBox2.Text = sdr[1].ToString(); string g = sdr[2].ToString(); if (g == "M") { radioButton1.Checked = true; } else if (g == "F") { radioButton2.Checked = true; } textBox4.Text = sdr[3].ToString(); textBox5.Text = sdr[4].ToString(); textBox3.Text = sdr[5].ToString(); } sqlcon.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public Form71(int licence) { // // Required for Windows Form Designer support // //lic = licence; string connectionString; lic = licence; connectionString = "DataSource=Baza.sdf; Password=matrix1"; SqlCeConnection cn = new SqlCeConnection(connectionString); cn.Open(); SqlCeCommand cmd2 = cn.CreateCommand(); cmd2.CommandText = "SELECT * FROM opcje WHERE id = 1"; cmd2.Prepare(); SqlCeDataReader dr = cmd2.ExecuteReader(); while (dr.Read()) { transfer = dr.GetString(1); com = dr.GetString(2); ip = dr.GetString(3); ufile = dr.GetString(4); dfile = dr.GetString(5); bdll = dr.GetString(6); bflag = dr.GetBoolean(7); ipflag = dr.GetBoolean(8); port = dr.GetInt32(9); skaner = dr.GetString(10); } cn.Close(); InitializeComponent(); this.Height = Screen.PrimaryScreen.Bounds.Height; this.Width = Screen.PrimaryScreen.Bounds.Width; Update(); }
public static int GetIdByClassesId(int classesId) { int result = -1; try { SqlCeCommand command = new SqlCeCommand(@"SELECT Id FROM Courses WHERE ClassesId = @classesid", Connection); command.Parameters.AddWithValue("@classesid", classesId); SqlCeDataReader reader = command.ExecuteReader(); reader.Read(); result = (int)reader["Id"]; reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(result); }
private bool populateInvoiceStatements(DateTime openingDate, AccountStatementDataSet dataset) { string sql = getInvoiceRetrievalSQL(openingDate); string errorText; SqlCeConnection connection = Global.getDatabaseConnection(out errorText); try { using (SqlCeCommand command = connection.CreateCommand()) { command.CommandText = sql; using (SqlCeDataReader reader = command.ExecuteReader()) { AccountStatementDataSet.AccountStatementRow row; while (reader.Read()) { row = dataset.AccountStatement.NewAccountStatementRow(); row.TransactionDate = reader.GetDateTime(1); row.Description = "Invoice# " + reader.GetInt32(0) + " issued"; row.DebitAmount = reader.GetDecimal(2); dataset.AccountStatement.AddAccountStatementRow(row); } } } } catch (Exception ex) { string message = "An error occurred in fetching the account details from " + "the database. The error text is as follows:\n" + Global.getExceptionText(ex); Cursor.Current = Cursors.Default; MessageBox.Show(message, "Error Occurred", MessageBoxButtons.OK, MessageBoxIcon.Error); ErrorLogger.LogError(ex); return(false); } return(true); }
/// <summary> /// Returns list of dates from the range that contain at least one schedule with built routes. /// </summary> /// <param name="dateFrom">Start date used to query schedules.</param> /// <param name="dateTo">Finish date used to query schedules.</param> /// <returns>List of dates from the range that contain at least one schedule with built routes.</returns> /// <remarks> /// Schedule with built routes is a schedule where at least one order is assigned. /// </remarks> public IList <DateTime> SearchDaysWithBuiltRoutes(DateTime dateFrom, DateTime dateTo) { SqlCeCommand cmd = new SqlCeCommand( QUERY_DAYS_WITH_BUILT_ROUTES, _DataService.StoreConnection); cmd.Parameters.Add(new SqlCeParameter("date_from", dateFrom.Date)); cmd.Parameters.Add(new SqlCeParameter("date_to", dateTo.Date)); List <DateTime> dates = new List <DateTime>(); using (SqlCeDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { dates.Add(reader.GetDateTime(0)); } } return(dates); }
public List <GeometryColumn> GetGeometryColumns() { List <GeometryColumn> list = new List <GeometryColumn>(); SqlCeDataReader sqlCeDataReader = _sqlCeDb.GetDataReader(_tableName, null, SortOrder.None) as SqlCeDataReader; if (sqlCeDataReader == null) { return(list); } while (sqlCeDataReader.Read()) { list.Add(new GeometryColumn() { TableName = sqlCeDataReader["G_TABLE_NAME"].ToString(), GeometryType = Convert.ToInt32(sqlCeDataReader["GEOMETRY_TYPE"]) }); } sqlCeDataReader.Close(); sqlCeDataReader.Dispose(); return(list); }
public void PdaSiparisBaslikOku(System.Windows.Forms.Label label) { SqlConn.Open(); CeConn.Open(); string sql = " select count(*) from SiparisBaslik"; SqlCeCommand cmd = new SqlCeCommand(sql, CeConn); int i = Convert.ToInt16(cmd.ExecuteScalar().ToString()); sql = " select * from SiparisBaslik"; cmd.CommandText = sql; SqlCeDataReader rdr = cmd.ExecuteReader(); int k = 0; while (rdr.Read()) { PdaSiparisBaslikYaz( rdr["Musteri_Kodu"].ToString(), rdr["Musteri_Adi"].ToString(), rdr["Plasiyer_Kodu"].ToString(), Convert.ToDateTime(rdr["Teslim_Tarihi"].ToString()), Convert.ToInt16(rdr["Vade_Gunu"].ToString()), rdr["Odeme_Sekli"].ToString().ToLower(), Convert.ToDateTime(rdr["Siparis_Tarihi"].ToString()), Convert.ToInt16(rdr["Siparis_No"].ToString())); label.Text = i.ToString() + "/" + k.ToString(); System.Windows.Forms.Application.DoEvents(); k += 1; } sql = "delete from SiparisBaslik"; cmd.CommandText = sql; cmd.ExecuteNonQuery(); CeConn.Close(); SqlConn.Close(); }
public void LoadDataToSettings() { try { SqlCeDataReader reader = DA.GetData("select * from EmailSettings"); while (reader.Read()) { emailAddress = reader["EmailAddress"].ToString(); userName = reader["UserName"].ToString(); password = reader["Password"].ToString(); mailServer = reader["EmailServer"].ToString(); schedule = (DateTime)reader["Schedule"]; port = (int)reader["Port"]; recepients = reader["Recepients"].ToString(); } } catch (Exception ex) { throw ex; } }
private void txt_ascode_KeyPress(object sender, KeyPressEventArgs e) { NAME = string.Empty; if (e.KeyChar == Convert.ToChar(Keys.Enter)) { if (txt_ascode.Text == null || txt_ascode.Text == "") { MessageBox.Show("ใส่ข้อมูลไม่ครบ"); } else { try { string ASSETID = txt_ascode.Text.ToString(); txt_ctcode.Focus(); using (SqlCeConnection con = new SqlCeConnection(strcon)) { con.Open(); string sql_check = @"SELECT NAME FROM MAS_ASSET WHERE ASSETID = '" + ASSETID + "'"; using (SqlCeCommand command = new SqlCeCommand(sql_check, con)) { using (SqlCeDataReader reader = command.ExecuteReader()) { while (reader.Read()) { NAME = (reader["NAME"].ToString()); } } } con.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }
public List <SoldProduct> GetSoldProducts() { List <SoldProduct> soldProducts = new List <SoldProduct>(); string sql = "SELECT * FROM SoldProduct"; using (SqlCeConnection conn = new SqlCeConnection(Storage.ConnectionString)) { try { conn.Open(); } catch { MessageBox.Show("Невозможно установить соединение с базой данных!", "Ошибка подключения", MessageBoxButtons.OK, MessageBoxIcon.Error); return(soldProducts); } SqlCeCommand command = new SqlCeCommand(sql, conn); using (SqlCeDataReader reader = command.ExecuteReader()) { while (reader.Read()) { soldProducts.Add(new SoldProduct { Id = (int)reader[0], CategoryId = (int)reader[1], CreditId = (int)reader[2], Name = reader[3].ToString(), Price = (decimal)reader[4], AddAmount = (decimal)reader[5], Discount = (decimal)reader[6], Total = (decimal)reader[7] }); } } } return(soldProducts); }
public static void SetMeasureTime() { SqlCeConnection con = new SqlCeConnection(Properties.Settings.Default.lcmsConnectionString); if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); SqlCeCommand bkCmd = new SqlCeCommand("select * from time", con); bkCmd.CommandType = CommandType.Text; SqlCeDataReader bkDr = bkCmd.ExecuteReader(); if (bkDr.Read()) { BKManager.supposeMillSecond = Convert.ToDouble(bkDr["sample"]) * 60 * 1000; BKManager.supposeSecond = Convert.ToDouble(bkDr["sample"]) * 60; } bkDr.Close(); con.Close(); }
public static TTipoAnomalia GetTTipoAnomalia(int id, SqlCeConnection conn) { TTipoAnomalia ta = null; string sql = String.Format("SELECT * FROM TipoAnomalia WHERE tipo_anomalia_id={0}", id); using (SqlCeCommand cmd = conn.CreateCommand()) { cmd.CommandText = sql; SqlCeDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ta = new TTipoAnomalia(); ta.TipoAnomaliaId = dr.GetInt32(0); ta.Nombre = dr.GetString(1); } if (!dr.IsClosed) { dr.Close(); } } return(ta); }
public void Refresh() { this.Clear(); using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(m_User)) { cmd.CommandText = "SELECT id, clr_name, parent_id FROM TypeDefinitions"; SqlCeDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { TypeDefinition info = new TypeDefinition(); info.Id = Convert.ToInt32(reader["id"]); info.ClrName = reader["clr_name"].ToString(); object result = reader["parent_id"]; info.ParentId = (result is DBNull || result == null) ? -1 : Convert.ToInt32(result); this.Add(info.Id, info); } } }
public void loadCompatibilities() { // Add Compatibilities to List ArrayList theCompatibilities = new ArrayList(); openDB(); SqlCeCommand cmd = TecanDatabase.CreateCommand(); cmd.CommandText = "SELECT CompatibilityName, CompatibilityID FROM Compatibility ORDER BY CompatibilityName"; SqlCeDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { theCompatibilities.Add(new Compatibilities(reader[0].ToString(), reader[1].ToString())); } reader.Dispose(); TecanDatabase.Close(); compatibilitiesListBox.DataSource = theCompatibilities; compatibilitiesListBox.DisplayMember = "Name"; compatibilitiesListBox.ValueMember = "ID"; }
public long TicketsCargados(long SemanaID) { long lngResult = 0; List <SqlCeParameter> lstParameters = new List <SqlCeParameter>(); lstParameters.Add(new SqlCeParameter("SemanaID", SemanaID)); string query = "SELECT COUNT(1) AS Result FROM " + tablename + " WHERE SemanaID = ?"; SqlCeDataReader rdrLector = AccesoDatos.ExecuteReader(query, CommandType.Text, lstParameters, conn); if (rdrLector != null) { if (rdrLector.Read()) { lngResult = rdrLector.GetInt32(0); } rdrLector.Close(); } return(lngResult); }
private Exame ObterExame(string nome) { //objeto medico que será retornado pelo método Exame exame = new Exame(); //instância da conexão SqlCeConnection conn = new SqlCeConnection(@"Data Source=C:\Users\Wallace\Contacts\Desktop\Projeto Teste implementação\Bancodedados.sdf;Password=123"); //string com o comando a ser executado string sql = "SELECT * from Exame WHERE Nome = @Nome"; //instância do comando recebendo como parâmetro //a string com o comando e a conexão SqlCeCommand cmd = new SqlCeCommand(sql, conn); //informo o parâmetro do comando cmd.Parameters.AddWithValue("@Nome", nome); //abro conexão conn.Open(); //instância do leitor SqlCeDataReader leitor = cmd.ExecuteReader(); //enquanto leitor lê while (leitor.Read()) { //passo os valores para o objeto paciente //que será retornado exame.Id = Convert.ToInt32(leitor["Id"].ToString()); } //fecha conexão conn.Close(); //Retorno o objeto paciente cujo o //nome é igual ao informado no parâmetro return(exame); }
private void btnSinleRow_Click(object sender, System.EventArgs e) { SqlCeDataReader obj_Reader = SqlHelper.ExecuteReader(ssceconn, CommandType.Text, "Select * from Customer"); string str_result = ""; while (obj_Reader.Read()) { str_result = str_result + "Customer ID : " + obj_Reader.GetInt32(0).ToString() + "\r\n"; str_result = str_result + "Name : " + obj_Reader.GetString(1) + " " + obj_Reader.GetString(2) + "\r\n"; str_result = str_result + "Address : " + obj_Reader.GetString(3) + "\r\n"; str_result = str_result + "City: " + obj_Reader.GetString(4) + "\r\n"; str_result = str_result + "State : " + obj_Reader.GetString(5) + "\r\n"; str_result = str_result + "Zip : " + obj_Reader.GetString(6) + "\r\n"; str_result = str_result + "Country : " + obj_Reader.GetString(7) + "\r\n"; str_result = str_result + "Phone : " + obj_Reader.GetString(8) + "\r\n"; str_result = str_result + "\r\n"; } txtResult.Text = str_result; //(ssceconn ,CommandType.Text ,"Select * fro" }
public static void SyncDataToServer() { string query = "select q_query from LTB_QUERY"; List <string> list = new List <string>(); using (SqlCeDataReader reader = LocalDataService.GetInstance().ExecuteReader(query)) { while (reader.Read()) { list.Add(reader.GetString(0)); } } foreach (string text in list) { DataService.GetInstance().ExecuteNonQuery(text); } string delText = "delete from LTB_QUERY"; //LocalDataService.GetInstance().ExecuteNonQuery(delText); }
/// <summary> /// Leera de la base de datos y los almacenara en una clase. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPOO_Click(object sender, EventArgs e) { try { string query = @" Select * from Auto"; _conn = new SqlCeConnection(_conectionString); _conn.Open(); _cmd = new SqlCeCommand(query, _conn); List <ClsCar> lst = new List <ClsCar>(); SqlCeDataReader reader = _cmd.ExecuteReader(); while (reader.Read()) { ClsCar car = new ClsCar(); car.Model = reader["Modelo"].ToString(); car.Year = Convert.ToInt32(reader["Año"]); car.Maker = reader["Fabricante"].ToString(); car.Type = (TypeCar)Convert.ToInt32(reader["Tipo"]); lst.Add(car); } StringBuilder result = new StringBuilder(); foreach (ClsCar item in lst) { result.AppendLine(item.GetAllInformation); } txtResults.Text = result.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Mensaje de error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static TGrupo GetGrupo(int id, SqlCeConnection conn) { TGrupo g = null; using (SqlCeCommand cmd = conn.CreateCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = String.Format("SELECT * FROM grupos WHERE grupoId = {0}", id); using (SqlCeDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { g = GetGrupoFromDr(dr); } if (!dr.IsClosed) { dr.Close(); } } } return(g); }
/// <summary> /// Charge la liste complète de tous les tireurs depuis la base de donnée /// </summary> public void GetAllTireurs() { Clear(); using (SqlCeConnection con = new SqlCeConnection(BaseDeDonnee.InfoConnexion)) { con.Open(); using (SqlCeCommand com = new SqlCeCommand("SELECT * FROM tireurs ORDER BY nom ASC", con)) { SqlCeDataReader objReader = com.ExecuteReader(); while (objReader.Read()) { int id = objReader.GetInt32(0); int idEquipe = objReader.GetInt32(1); string nom = objReader.GetString(2); DateTime dateDeNaissance = objReader.GetDateTime(3); Add(new Tireur(id, idEquipe, nom, dateDeNaissance)); } } } }
private void button2_Click(object sender, EventArgs e) { bool flag = true; try { SqlCeConnection conn = new SqlCeConnection("Data Source=D:\\containerinfo.sdf;Persist Security Info=False;"); conn.Open(); SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = "select count(position) from container where containerid='" + textBox1.Text + "'"; SqlCeDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { if ((int)rd[0] == 0) { MessageBox.Show("Container does not exist"); flag = false; } } if (flag) { cmd.CommandText = "delete from container where containerid='" + textBox1.Text + "'"; cmd.ExecuteNonQuery(); label14.Text = "Container deleted successfully!"; } cmd.CommandText = "select * from container where yardnum='" + yardid + "' and col='" + col + "' and rowid='" + row + "'"; cmd.ExecuteNonQuery(); SqlCeDataAdapter sd = new SqlCeDataAdapter(cmd); DataTable dt = new DataTable(); sd.Fill(dt); dataGridView1.DataSource = dt; conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static TPrograma GetTPrograma(int id, SqlCeConnection conn) { TPrograma programa = null; using (SqlCeCommand cmd = conn.CreateCommand()) { cmd.CommandText = String.Format("SELECT * FROM Programa WHERE programa_id = {0}", id); SqlCeDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { programa = new TPrograma() { ProgramaId = dr.GetInt32(0), FechaProgramada = dr.GetDateTime(1), Usuario = GetTUsuario(dr.GetInt32(2), conn), Estado = dr.GetString(3), Comentarios = dr.GetString(4), Abm = dr.GetByte(5) }; } if (!dr.IsClosed) { dr.Close(); } //if (programa != null) //{ // // Ahora buscamos las revisiones asociadas. // cmd.CommandText = String.Format("SELECT * FROM Revision WHERE programa_id = {0}", programa.ProgramaId); // dr = cmd.ExecuteReader(); // while (dr.Read()) // { // TRevision tr = CntSciTerminal.GetTRevision(dr.GetInt32(0), conn); // if (tr != null) programa.Revisiones.Add(tr); // } // if (!dr.IsClosed) dr.Close(); //} } return(programa); }
public static List <string> Select_gameModes(string endpoint) { string connStr = "Data Source = mydatabase.sdf;"; List <string> line = new List <string>(); SqlCeConnection conn = new SqlCeConnection(connStr); conn.Open(); SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = string.Format("SELECT * FROM gameModes WHERE endpoint = '{0}'", endpoint); SqlCeDataReader w = cmd.ExecuteReader(); int i = 0; while (w.Read()) { line.Add(w["gameModes"].ToString()); i++; } conn.Close(); return(line); }
private bool duplicate(SqlCeConnection conn, string catname, string query) { try { SqlCeDataReader reader = null; SqlCeCommand cmd = new SqlCeCommand(query, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { if (catname.ToLower() == reader.GetString(0).ToLower()) { return(true); } } return(false); } catch (Exception ex) { MessageBox.Show("Error occured while checking for duplicate entry"); return(true); } }
internal static List <String> LoadProducts(TypeFood typeFood) { if (dbCon.State == ConnectionState.Closed) { dbCon.Open(); } string sqGetAllProductsFromType = @"SELECT ProductName, Category FROM Products WHERE (Category = N'" + typeFood.ToString() + "')"; SqlCeCommand cmd = new SqlCeCommand(sqGetAllProductsFromType, dbCon); SqlCeDataReader reader = cmd.ExecuteReader(); List <string> result = new List <string>(); while (reader.Read()) { result.Add((string)reader["ProductName"]); } dbCon.Close(); return(result); }
public static TAdministrador GetTAdministrador(int id, SqlCeConnection conn) { TAdministrador administrador = null; using (SqlCeCommand cmd = conn.CreateCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = String.Format("SELECT * FROM Administradores WHERE administradorId = {0}", id); using (SqlCeDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { administrador = GetAdministradorFromDr(dr); } if (!dr.IsClosed) { dr.Close(); } } } return(administrador); }
public static TAdministrador GetLogin(string login, string password, SqlCeConnection conn) { TAdministrador administrador = null; using (SqlCeCommand cmd = conn.CreateCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = String.Format("SELECT * FROM administradores WHERE login = '******' AND password = '******'", login, password); using (SqlCeDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { administrador = GetAdministradorFromDr(dr); } if (!dr.IsClosed) { dr.Close(); } } } return(administrador); }
public Hashtable[] getMediaTable() { Hashtable[] table; sqlRdr = new SqlCeCommand("SELECT COUNT(*) FROM Media", sc).ExecuteReader(); sqlRdr.Read(); int numFiles = (int)sqlRdr[0]; table = new Hashtable[numFiles]; int rowCount = 0; string query = "SELECT * FROM Media;"; sqlCmd = new SqlCeCommand(query, sc); sqlRdr = sqlCmd.ExecuteReader(); while (sqlRdr.Read()) { table[rowCount] = new Hashtable(); table[rowCount]["media_id"] = (int)sqlRdr["media_id"]; table[rowCount]["url"] = (string)sqlRdr["url"]; table[rowCount]["filename"] = (string)sqlRdr["filename"]; table[rowCount]["file_extension"] = (string)sqlRdr["file_extension"]; table[rowCount]["type_id"] = (int)sqlRdr["type_id"]; table[rowCount]["width"] = (int)sqlRdr["width"]; table[rowCount]["height"] = (int)sqlRdr["height"]; table[rowCount]["date_start"] = DateTime.Parse(sqlRdr["date_start"].ToString()); table[rowCount]["date_end"] = DateTime.Parse(sqlRdr["date_end"].ToString()); rowCount++; } Console.WriteLine(table.Length); return table; }
public void removeDups() { Hashtable[] table = getMediaTable("date_end", Order.DESC); for (int rowA = 0; rowA < table.Length; rowA++) { for (int rowB = 0; rowB < table.Length; rowB++) { if (rowA == rowB) { break; } else { if (table[rowA]["url"].ToString()==table[rowB]["url"].ToString()) { sqlRdr = executeQuery("SELECT COUNT(*) FROM Media WHERE url = '" + table[rowA]["url"].ToString() + "'"); sqlRdr.Read(); int numDups = (int)sqlRdr[0]; while (numDups > 1) { Console.WriteLine("Deleting dups."); removeFirstOccurance(table[rowA]["url"].ToString()); numDups--; } } } } } }
public string[] grabURLs() { string[] mediaURLs; sqlRdr = new SqlCeCommand("SELECT COUNT(*) FROM Media", sc).ExecuteReader(); sqlRdr.Read(); int numFiles = (int)sqlRdr[0]; int count = 0; string query = "SELECT url FROM Media;"; sqlCmd = new SqlCeCommand(query, sc); sqlRdr = sqlCmd.ExecuteReader(); mediaURLs = new string[numFiles]; while (sqlRdr.Read()) { mediaURLs[count] = sqlRdr["url"].ToString(); count++; } return mediaURLs; }
public string[] grabActiveURLs() { ArrayList mediaURLs = new ArrayList(); string query = "SELECT * FROM Media;"; sqlCmd = new SqlCeCommand(query, sc); sqlRdr = sqlCmd.ExecuteReader(); while (sqlRdr.Read()) { if ((DateTime.Parse(sqlRdr["date_start"].ToString()) <= DateTime.Now) && (DateTime.Parse(sqlRdr["date_end"].ToString()) >= DateTime.Now)) { Console.WriteLine("Okay"); mediaURLs.Add(sqlRdr["url"].ToString()); } } return mediaURLs.ToArray(typeof(string)) as string[]; }
private DataTable ReaderToDT(SqlCeDataReader dataReader) { DataTable dt = new DataTable(); foreach (DataRow dr in dataReader.GetSchemaTable().Rows) { dt.Columns.Add(dr["ColumnName"] as string, (Type)(dr["DataType"])); } while (dataReader.Read()) { DataRow dr = dt.NewRow(); foreach (DataColumn dc in dt.Columns) { dr[dc] = dataReader[dc.ColumnName]; } dt.Rows.Add(dr); } return dt; }
private bool DoReadMeaningId(SqlCeDataReader reader, ref Guid meaningId) { lock (_connVocabulary) { bool success = reader.Read(); if (success) { meaningId = (Guid)reader[0]; } return success; } }
/// <summary> /// Converts a SqlCeDataReader to a DataSet /// <param name='reader'> /// SqlDataReader to convert.</param> /// <returns> /// DataSet filled with the contents of the reader.</returns> /// </summary> public static DataSet ConvertDataReaderToDataSet(SqlCeDataReader reader, string tabela) { DataSet dataSet = new DataSet(); do { // Create new data table DataTable schemaTable = reader.GetSchemaTable(); DataTable dataTable = new DataTable(tabela); if (schemaTable != null) { // A query returning records was executed for (int i = 0; i < schemaTable.Rows.Count; i++) { DataRow dataRow = schemaTable.Rows[i]; // Create a column name that is unique in the data table string columnName = (string)dataRow["ColumnName"]; //+ "<C" + i + "/>"; // Add the column definition to the data table DataColumn column = new DataColumn(columnName, (Type)dataRow["DataType"]); dataTable.Columns.Add(column); } dataSet.Tables.Add(dataTable); // Fill the data table we just created while (reader.Read()) { DataRow dataRow = dataTable.NewRow(); for (int i = 0; i < reader.FieldCount; i++) dataRow[i] = reader.GetValue(i); dataTable.Rows.Add(dataRow); } } else { // No records were returned DataColumn column = new DataColumn("RowsAffected"); dataTable.Columns.Add(column); dataSet.Tables.Add(dataTable); DataRow dataRow = dataTable.NewRow(); dataRow[0] = reader.RecordsAffected; dataTable.Rows.Add(dataRow); } } while (reader.NextResult()); return dataSet; }