public static ChatMessage FromDbDataRecord(DbDataRecord record) { ChatMessage msg = new ChatMessage(record.GetString(C_SENDER), record.GetString(C_BODY), DateTime.Parse(record.GetString(C_DATE)), record.GetString(C_ID), SqlDatabase.StringOrNull(record, C_EDIT)); return(msg); }
public static string GetString(this DbDataRecord dr, string columnName) { Check.ArgNotNull(dr, nameof(dr)); int ordinal = dr.GetOrdinal(columnName); return(dr.GetString(ordinal)); }
public static string StringOrNull(DbDataRecord reader, int column) { if (reader.IsDBNull(column)) { return(null); } else { return(reader.GetString(column)); } }
public Film ConvertRecordToFilm(DbDataRecord rec) { if (rec == null || rec.FieldCount < filmRecFieldCount) { return(null); } var film = new Film { Id = rec.GetInt32((int)FilmColumns.Id), Picture = GetImageFromDbRec(rec.GetString((int)FilmColumns.Picture)), Name = rec.GetString((int)FilmColumns.Name), Country = rec.GetString((int)FilmColumns.Country), Year = rec.GetInt32((int)FilmColumns.Year), Producer = new Producer(rec.GetString((int)FilmColumns.Producer)), MainActors = new List <Actor>() }; return(film); }
public static Roomdata FromDbDataRecord(DbDataRecord record) { Roomdata r = new Roomdata(record.GetString(COL_ROOM)); r.LastMessageDt = SqlDatabase.StringOrNull(record, COL_LASTMESSAGEDT); r.Subject = SqlDatabase.StringOrNull(record, COL_SUBJECT); r.DoJoin = (JoinMode)record.GetInt32(COL_DO_JOIN); r.DisplayName = SqlDatabase.StringOrNull(record, COL_DISPLAY_NAME); r.LastSeenDt = SqlDatabase.StringOrNull(record, COL_LASTSEENDT); r.Notify = (NotifyMode)record.GetInt32(COL_NOTIFY); r.DisplayPosition = record.GetInt32(COL_DISPLAY_POSITION); return(r); }
public ActorToFilm ConvertRecordToActorToFilm(DbDataRecord rec) { if (rec == null || rec.FieldCount < actorToFilmFieldCount) { return(null); } var actorToFilm = new ActorToFilm { FilmId = rec.GetInt32((int)ActorToFilmColumn.FilmId), Actor = new Actor(rec.GetString((int)ActorToFilmColumn.ActorName)) }; return(actorToFilm); }
//Entity Provider private static void PrintEntityResults(DbConnection conn, DbCommand cmd, string commandText) { cmd.CommandType = CommandType.Text; cmd.CommandText = commandText; if (conn.State == ConnectionState.Closed) { conn.Open(); } var dr = cmd.ExecuteReader(CommandBehavior.SequentialAccess); while (dr.Read()) { DbDataRecord record = (DbDataRecord)dr[0]; Console.WriteLine(record.GetInt32(0) + ": " + record.GetString(1)); } }
// <Snippet1> public static void Main() { try { DataTable userTable = new DataTable("peopleTable"); userTable.Columns.Add("Id", typeof(int)); userTable.Columns.Add("Name", typeof(string)); // Note that even if you create the DataTableReader // before adding the rows, the enumerator can still // visit all the rows. DataTableReader reader = userTable.CreateDataReader(); userTable.Rows.Add(new object[] { 1, "Peter" }); userTable.Rows.Add(new object[] { 2, "Mary" }); userTable.Rows.Add(new object[] { 3, "Andy" }); userTable.Rows.Add(new object[] { 4, "Russ" }); IEnumerator enumerator = reader.GetEnumerator(); // Keep track of whether the row to be deleted // has actually been deleted yet. This allows // this sample to demonstrate that the enumerator // is able to survive row deletion. bool isRowDeleted = false; while (enumerator.MoveNext()) { DbDataRecord dataRecord = (DbDataRecord)enumerator.Current; // While the enumerator is active, delete a row. // This doesn't affect the behavior of the enumerator. if (!isRowDeleted) { isRowDeleted = true; userTable.Rows[2].Delete(); } Console.WriteLine(dataRecord.GetString(1)); } } catch (Exception ex) { Console.WriteLine(ex); } Console.ReadLine(); }
public void GetEnumeratorTest() { this.fixture.ExecuteCommand(command => { command.CommandText = "SELECT * FROM ORDERS"; using (var reader = command.ExecuteReader()) { IEnumerator enumerator = reader.GetEnumerator(); while (enumerator.MoveNext()) { DbDataRecord record = (DbDataRecord)enumerator.Current; Assert.Equal(reader.FieldCount, record.FieldCount); Assert.Equal(reader.GetInt32(0), record.GetInt32(0)); Assert.Equal(reader.GetString(1), record.GetString(1)); Assert.Equal(reader.GetInt32(2), record.GetInt32(2)); Assert.Equal(reader.GetDateTime(3), record.GetDateTime(3)); Assert.Equal(reader.GetDateTime(4), record.GetDateTime(4)); Assert.Equal(reader.GetValue(5), record.GetValue(5)); Assert.Equal(reader.GetInt32(6), record.GetInt32(6)); Assert.Equal(reader.GetDecimal(7), record.GetDecimal(7)); reader.Read(); } } }); }
//***************************************************************************** // Method: ShowSubmissionDetails // // Purpose: Set textbox text's of the selected submission object //***************************************************************************** private void ShowSubmissionDetails(DbDataRecord record) { // Setup the SQL command string sql = "SELECT * FROM Submission WHERE AssignmentName = '" + record.GetString(0) + "';"; SqlCommand command = new SqlCommand(sql, sqlConn); // Retrieve the data from the database SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { // set text fields assignmentTextBox.Text = reader.GetString(0); categoryTextBox.Text = reader.GetString(1); gradeTextBox.Text = reader.GetDouble(2).ToString(); } } }