本文整理汇总了C#中System.Data.DataTableReader.Close方法的典型用法代码示例。如果您正苦于以下问题:C# DataTableReader.Close方法的具体用法?C# DataTableReader.Close怎么用?C# DataTableReader.Close使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataTableReader
的用法示例。
在下文中一共展示了DataTableReader.Close方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: TransformTextFact
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(); }
}
}
示例2: Fact
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(); }
}
}
示例3: CtorTest
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 ();
}
}
示例4: Form1_Load
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.
}
示例5: InvalidIndexTest
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 ();
}
}
示例6: AccessBeforeReadTest
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 ();
}
}
示例7: ClearTest
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 ();
}
}
示例8: DeletePreviousAndAcceptChangesTest
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 ();
}
}
示例9: GetTest
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 ();
}
}
示例10: MultipleResultSetsTest
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 ();
}
}
示例11: SchemaTest
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 ();
}
}
示例12: SeeTheModifiedTest
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 ();
}
}
示例13: IgnoreDeletedRowsDynamicTest
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 ();
}
}
示例14: backbone
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);
//.........这里部分代码省略.........
示例15: DontSeeTheEarlierRowsTest
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 ();
}
}