public void Fact() { var connection = default (DbConnection); var reader = default(DbDataReader); try { connection = KandaXunitProviderFactory.Instance.CreateConnection(); connection.Open(); var schema = connection.GetTablesSchema(); reader = new DataTableReader(schema); while (reader.Read()) { var name = reader.GetString(reader.GetOrdinal(@"TABLE_NAME")); var type = reader.GetString(reader.GetOrdinal(@"TABLE_TYPE")); //this.transformEntity(name, type); this.transformInsertTable(name, type); } } finally { if (reader != null) { reader.Close(); } if (connection != null) { connection.Close(); } } }
public void TransformTextFact() { var connection = default(DbConnection); var reader = default(DbDataReader); try { connection = this._factory.CreateConnection(); connection.Open(); var schema = connection.GetTablesSchema(); reader = new DataTableReader(schema); while (reader.Read()) { var name = TextTemplateFact.GetTableName(reader); var type = TextTemplateFact.GetTableType(reader); var context = new InsertTableContext(name, type) { ProcedureNamePrefix = @"usp_", ProcedureNameSuffix = @"", }; var template = new InsertTableTemplate(context); template.Initialize(); var text = template.TransformText(); // TODO : } } finally { if (reader != null) { reader.Close(); } if (connection != null) { connection.Close(); } } }
public void CtorTest () { dt.Rows [1].Delete (); DataTableReader reader = new DataTableReader (dt); try { int i = 0; while (reader.Read ()) i++; reader.Close (); Assert.AreEqual (2, i, "no. of rows iterated is wrong"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'MyDataBaseDataSet1.mainbilll' table. You can move, or remove it, as needed. this.mainbilllTableAdapter.Fill(this.MyDataBaseDataSet1.mainbilll); DataTable table = this.MyDataBaseDataSet1.Tables[1]; DataTableReader read = new DataTableReader(table); while (read.Read()) { comboBox1.Items.Add(read.GetInt32(0)); } read.Close(); this.reportViewer1.RefreshReport(); //Microsoft.Reporting.WinForms.ReportPageSettings settings = this.reportViewer1.LocalReport.GetDefaultPageSettings(); //settings.Margins.Bottom = 25; //settings.Margins.Top = 25; //settings.Margins.Left = 25; //settings.Margins.Right = 25; //Microsoft.Reporting.WinForms. }
public void InvalidIndexTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); int i = (int) reader [90]; // kidding, ;-) i++; // to supress warning } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void AccessBeforeReadTest () { DataTableReader reader = new DataTableReader (dt); try { int i = (int) reader [0]; i++; // to supress warning } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void ClearTest () { DataTableReader reader = null; try { reader = new DataTableReader (dt); reader.Read (); // first row reader.Read (); // second row dt.Clear (); try { int i = (int) reader [0]; i++; // supress warning Assert.Fail("#1 should have thrown RowNotInTableException"); } catch (RowNotInTableException) {} // clear and add test reader.Close (); reader = new DataTableReader (dt); reader.Read (); // first row reader.Read (); // second row dt.Clear (); dt.Rows.Add (new object [] {8, "mono 8"}); dt.AcceptChanges (); bool success = reader.Read (); Assert.IsFalse (success, "#2 is always invalid"); // clear when reader is not read yet reader.Close (); reader = new DataTableReader (dt); dt.Clear (); dt.Rows.Add (new object [] {8, "mono 8"}); dt.AcceptChanges (); success = reader.Read (); Assert.IsTrue (success, "#3 should add"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void DeletePreviousAndAcceptChangesTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); // first row reader.Read (); // second row dt.Rows [0].Delete (); dt.AcceptChanges (); Assert.AreEqual (2, (int) reader [0], "#1 should not affect the current position"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void GetTest () { dt.Columns.Add ("nullint", typeof (int)); dt.Rows [0] ["nullint"] = 333; DataTableReader reader = new DataTableReader (dt); try { reader.Read (); int ordinal = reader.GetOrdinal ("nullint"); // Get by name Assert.AreEqual (1, (int) reader ["id"], "#1 should be able to get by name"); Assert.AreEqual (333, reader.GetInt32 (ordinal), "#2 should get int32"); Assert.AreEqual ("System.Int32", reader.GetDataTypeName (ordinal), "#3 data type should match"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void MultipleResultSetsTest () { DataTable dt1 = new DataTable ("test2"); dt1.Columns.Add ("x", typeof (string)); dt1.Rows.Add (new object [] {"test"} ); dt1.Rows.Add (new object [] {"test1"} ); dt1.AcceptChanges (); DataTable [] collection = new DataTable [] { dt, dt1 } ; DataTableReader reader = new DataTableReader (collection); try { int i = 0; do { while (reader.Read ()) i++; } while (reader.NextResult ()); Assert.AreEqual (5, i, "#1 rows should be of both the tables"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void SchemaTest () { DataTable another = new DataTable ("another"); another.Columns.Add ("x", typeof (string)); another.Rows.Add (new object [] {"test 1" }); another.Rows.Add (new object [] {"test 2" }); another.Rows.Add (new object [] {"test 3" }); DataTableReader reader = new DataTableReader (new DataTable [] { dt, another }); try { DataTable schema = reader.GetSchemaTable (); Assert.AreEqual (dt.Columns.Count, schema.Rows.Count, "#1 should be same"); Assert.AreEqual (dt.Columns [1].DataType.ToString (), schema.Rows [1] ["DataType"].ToString (), "#2 data type should match"); reader.NextResult (); //schema should change here schema = reader.GetSchemaTable (); Assert.AreEqual (another.Columns.Count, schema.Rows.Count, "#3 should be same"); Assert.AreEqual (another.Columns [0].DataType.ToString (), schema.Rows [0] ["DataType"].ToString (), "#4 data type should match"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void SeeTheModifiedTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); // first row dt.Rows [1] ["name"] = "mono changed"; reader.Read (); string value = reader [1].ToString (); Assert.AreEqual ("mono changed", value, "#2 reader should have moved to 3rd row"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void IgnoreDeletedRowsDynamicTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); // first row dt.Rows [1].Delete (); reader.Read (); // it should be 3rd row string value = reader [0].ToString (); Assert.AreEqual ("3", value, "#1 reader should have moved to 3rd row"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
private void backbone(Akt akten) { label1.Text = tk.vuxna.ToString(); label2.Text = tk.ungdom.ToString(); label3.Text = tk.barn.ToString(); label5.Text = tk.biljetter[tk.fuskIgen].forestallning.namn; label6.Text = tk.biljetter[tk.fuskIgen].akter.namn; rk2(); // label8.Text = tk.totalpris.ToString() + " Kr"; // radiokoll(); den var här förut, funkade, beehövs den`? //Akt temp = new Akt(); //temp = tk.akter[tk.antal]; // int id = tk.biljetter[tk.fuskIgen].akter.id; int id = akten.id; string query = "select * from biljett where akt_id = "; query += id.ToString(); NpgsqlDataAdapter da = new NpgsqlDataAdapter(query, conn); da.Fill(dt); int x = 0; x = tk.vuxna + tk.barn + tk.ungdom; /* if (x >= 8) { MessageBox.Show("Tyvärr finns inte tillräkligt med plats, utanför"); this.Hide(); Huvudsidan hu = new Huvudsidan(); hu.ShowDialog(); Close(); }*/ //Här ska tk metoden ligga, kanske :p foreach (DataRow row in dt.Rows) { if ((bool)row["fri_placering"] == true) { } else { /* if (x >= 8) { MessageBox.Show("Tyvärr finns inte tillräkligt med plats, innanför"); this.Hide(); Huvudsidan hu = new Huvudsidan(); hu.ShowDialog(); Close(); } else { */ string platsid = row["plats_id"].ToString(); bool vecka = false; DateTime dt = new DateTime(); // dt = (DateTime)row["tidsstampel"]; if ((bool)row["reserverad"] == true) { DateTime dat = (DateTime)row["tidsstampel"]; DateTime nu = DateTime.Now; TimeSpan ts = new TimeSpan(7, 0, 0, 0); //TimeSpan elapsed = nu.Subtract(dat); DateTime test = tk.biljetter[0].forestallning.forsaljningsslut.Subtract(ts); if (test < DateTime.Now) { vecka = true; } } string query2 = "select nummer from platser where id =" + platsid; NpgsqlDataAdapter da2 = new NpgsqlDataAdapter(query2, conn); DataTable dt2 = new DataTable(); da2.Fill(dt2); DataTableReader dr = new DataTableReader(dt2); string platsnamn = ""; while (dr.Read()) { string fusk = "button_"; platsnamn = dr[0].ToString(); fusk += platsnamn; gk(button_A1, fusk, vecka, platsid, id); gk(button_A2, fusk, vecka, platsid, id); gk(button_A3, fusk, vecka, platsid, id); gk(button_A4, fusk, vecka, platsid, id); gk(button_A5, fusk, vecka, platsid, id); gk(button_A6, fusk, vecka, platsid, id); gk(button_A7, fusk, vecka, platsid, id); gk(button_A8, fusk, vecka, platsid, id); gk(button_B1, fusk, vecka, platsid, id); gk(button_B2, fusk, vecka, platsid, id); gk(button_B3, fusk, vecka, platsid, id); gk(button_B4, fusk, vecka, platsid, id); gk(button_B5, fusk, vecka, platsid, id); gk(button_B6, fusk, vecka, platsid, id); gk(button_B7, fusk, vecka, platsid, id); gk(button_B8, fusk, vecka, platsid, id); gk(button_D1, fusk, vecka, platsid, id); gk(button_D2, fusk, vecka, platsid, id); gk(button_D3, fusk, vecka, platsid, id); gk(button_D4, fusk, vecka, platsid, id); gk(button_D5, fusk, vecka, platsid, id); gk(button_D6, fusk, vecka, platsid, id); gk(button_D7, fusk, vecka, platsid, id); gk(button_D8, fusk, vecka, platsid, id); gk(button_F1, fusk, vecka, platsid, id); gk(button_F2, fusk, vecka, platsid, id); gk(button_F3, fusk, vecka, platsid, id); gk(button_F4, fusk, vecka, platsid, id); gk(button_F5, fusk, vecka, platsid, id); gk(button_F6, fusk, vecka, platsid, id); gk(button_F7, fusk, vecka, platsid, id); gk(button_F8, fusk, vecka, platsid, id); gk(button_H1, fusk, vecka, platsid, id); gk(button_H2, fusk, vecka, platsid, id); gk(button_H3, fusk, vecka, platsid, id); gk(button_H4, fusk, vecka, platsid, id); gk(button_H5, fusk, vecka, platsid, id); gk(button_H6, fusk, vecka, platsid, id); gk(button_H7, fusk, vecka, platsid, id); gk(button_H8, fusk, vecka, platsid, id); gk(button_G1, fusk, vecka, platsid, id); gk(button_G2, fusk, vecka, platsid, id); gk(button_G3, fusk, vecka, platsid, id); gk(button_G4, fusk, vecka, platsid, id); gk(button_G5, fusk, vecka, platsid, id); gk(button_G6, fusk, vecka, platsid, id); gk(button_G7, fusk, vecka, platsid, id); gk(button_G8, fusk, vecka, platsid, id); gk(button_E1, fusk, vecka, platsid, id); gk(button_E2, fusk, vecka, platsid, id); gk(button_E3, fusk, vecka, platsid, id); gk(button_E4, fusk, vecka, platsid, id); gk(button_E5, fusk, vecka, platsid, id); gk(button_E6, fusk, vecka, platsid, id); gk(button_E7, fusk, vecka, platsid, id); gk(button_E8, fusk, vecka, platsid, id); gk(button_C1, fusk, vecka, platsid, id); gk(button_C2, fusk, vecka, platsid, id); gk(button_C3, fusk, vecka, platsid, id); gk(button_C4, fusk, vecka, platsid, id); gk(button_C5, fusk, vecka, platsid, id); gk(button_C6, fusk, vecka, platsid, id); gk(button_C7, fusk, vecka, platsid, id); gk(button_C8, fusk, vecka, platsid, id); // } } dr.Close(); x++; } } }
public void DontSeeTheEarlierRowsTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); // first row reader.Read (); // second row // insert a row at position 0 DataRow r = dt.NewRow (); r [0] = 0; r [1] = "adhi bagavan"; dt.Rows.InsertAt (r, 0); Assert.AreEqual (2, (int) reader.GetInt32 (0), "#1 should not alter the position"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void CloseTest () { DataTableReader reader = new DataTableReader (dt); try { int i = 0; while (reader.Read () && i < 1) i++; reader.Close (); reader.Read (); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void AddAtPointTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); // first row reader.Read (); // second row DataRow r = dt.NewRow (); r [0] = 0; r [1] = "same point"; dt.Rows.InsertAt (r, 1); dt.Rows.Add (new object [] { 4, "mono 4"}); // should not affect the counter Assert.AreEqual (2, (int) reader [0], "#1 should not affect the current position"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void GetOrdinalTest () { DataTableReader reader = new DataTableReader (dt); try { Assert.AreEqual (1, reader.GetOrdinal ("name"), "#1 get ordinal should work even" + " without calling Read"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void DeleteLastAndAcceptChangesTest2 () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); // first row reader.Read (); // second row reader.Read (); // third row dt.Rows [2].Delete (); // delete row, where reader points to dt.AcceptChanges (); // accept the action Assert.AreEqual (2, (int) reader [0], "#1 should point to the first row"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void NoRowsTest () { dt.Rows.Clear (); dt.AcceptChanges (); DataTableReader reader = new DataTableReader (dt); try { Assert.IsFalse (reader.Read (), "#1 there are no rows"); Assert.IsFalse (reader.NextResult (), "#2 there are no further resultsets"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void MultipleDeleteTest () { dt.Rows.Add (new object [] {4, "mono 4"}); dt.Rows.Add (new object [] {5, "mono 5"}); dt.Rows.Add (new object [] {6, "mono 6"}); dt.Rows.Add (new object [] {7, "mono 7"}); dt.Rows.Add (new object [] {8, "mono 8"}); dt.AcceptChanges (); DataTableReader reader = new DataTableReader (dt); try { reader.Read (); // first row reader.Read (); reader.Read (); reader.Read (); reader.Read (); dt.Rows [3].Delete (); dt.Rows [1].Delete (); dt.Rows [2].Delete (); dt.Rows [0].Delete (); dt.Rows [6].Delete (); dt.AcceptChanges (); Assert.AreEqual (5, (int) reader [0], "#1 should keep pointing to 5"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void NoTablesTest () { DataTableReader reader = new DataTableReader (new DataTable [] {}); try { reader.Read (); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void RowInAccessibleTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); reader.Read (); // 2nd row dt.Rows [1].Delete (); string value = reader [1].ToString (); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void ReadAfterClosedTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); reader.Close (); reader.Read (); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void loadTableName(ComboBox cb) { System.Data.DataTable dt = ocon.GetSchema("Tables"); DataTableReader dtr = new DataTableReader(dt); cb.Items.Clear(); cb.Text = ""; while (dtr.Read()) { cb.Items.Add(dtr["Table_Name"]); } dtr.Close(); }
public void ExecuteReader(string command, Action<System.Data.Common.DbDataReader> action) { if (command == "SELECT GETDATE()") { var dataTable = new DataTable("mocktable"); dataTable.Columns.Add("column0", typeof(DateTime)); dataTable.Rows.Add(new DateTime(2001, 2, 3, 4, 5, 6, 7)); var dataReader = new DataTableReader(dataTable); while (dataReader.Read()) action(dataReader); dataReader.Close(); } else throw new NotImplementedException(); }