本文整理汇总了C#中System.Data.DataSet.Reset方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.Reset方法的具体用法?C# DataSet.Reset怎么用?C# DataSet.Reset使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.Reset方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ExecuteSelectQuery
public DataTable ExecuteSelectQuery(NpgsqlCommand command, NpgsqlConnection conn)
{
try
{
if (conn == null)
{
return null;
}
DataTable dataTable = new DataTable();
DataSet dataSet = new DataSet();
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter(command);
dataSet.Reset();
dataAdapter.Fill(dataSet);
dataTable = dataSet.Tables[0];
conn.Close();
return dataTable.Rows.Count <= 0 ? null : dataTable;
}
catch (NpgsqlException ex)
{
Console.WriteLine(ex.Message);
return null;
}
}
示例2: SaveVar_Click
protected void SaveVar_Click(Object sender, EventArgs e)
{
#region 保存变量修改
dsSrc = LoadDataTable();
int row = 0;
//bool error = false;
foreach (object o in DataGrid1.GetKeyIDArray())
{
int id = int.Parse(o.ToString());
string variablename = DataGrid1.GetControlValue(row, "variablename").Trim();
string variablevalue = DataGrid1.GetControlValue(row, "variablevalue").Trim();
if (variablename == "" || variablevalue == "")
{
//error = true;
continue;
}
foreach (DataRow dr in dsSrc.Tables["TemplateVariable"].Rows)
{
if (id.ToString() == dr["id"].ToString())
{
dr["variablename"] = variablename;
dr["variablevalue"] = variablevalue;
break;
}
}
try
{
if (dsSrc.Tables[0].Rows.Count == 0)
{
File.Delete(Utils.GetMapPath("../../templates/" + DNTRequest.GetString("path") + "/templatevariable.xml"));
dsSrc.Reset();
dsSrc.Dispose();
}
else
{
string filename = Server.MapPath("../../templates/" + DNTRequest.GetString("path") + "/templatevariable.xml");
dsSrc.WriteXml(filename);
dsSrc.Reset();
dsSrc.Dispose();
Discuz.Cache.DNTCache cache = Discuz.Cache.DNTCache.GetCacheService();
cache.RemoveObject("/Forum/" + DNTRequest.GetString("path") + "/TemplateVariable");
base.RegisterStartupScript("PAGE", "window.location.href='global_templatevariable.aspx?templateid=" + DNTRequest.GetString("templateid") + "&path=" + DNTRequest.GetString("path") + "&templatename=" + DNTRequest.GetString("templatename") + "';");
}
}
catch
{
base.RegisterStartupScript("", "<script>alert('无法更新数据库.');window.location.href='global_templatevariable.aspx?templateid=" + DNTRequest.GetString("templateid") + "&path=" + DNTRequest.GetString("path") + "&templatename=" + DNTRequest.GetString("templatename") + "';</script>");
return;
}
row++;
}
#endregion
}
示例3: obtenerCajaActual
public Double obtenerCajaActual(DateTime fecha)
{
try
{
FuncionesGenerales.FuncionesGenerales fg = new FuncionesGenerales.FuncionesGenerales();
ConectarBD con = new ConectarBD();
DataSet Ds = new DataSet();
Double importe = 0.00;
String sSQL = "";
sSQL = "EXEC dbo.adp_ObtenerCajaActual";
sSQL = sSQL + " @fecha_mov = " + fg.fcSql(fecha.ToString(), "DATETIME");
Ds.Reset();
Ds = con.ejecutarQuerySelect(sSQL);
if (Ds.Tables[0].Rows.Count > 0)
{
importe = Double.Parse(Ds.Tables[0].Rows[0]["TOTAL"].ToString());
}
return importe;
}
catch (Exception e)
{
throw new System.ArgumentException("[Error] - [" + e.Message.ToString() + "]");
}
}
示例4: Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
id = DropDownList1.SelectedItem.ToString();
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
NpgsqlConnection conn = new NpgsqlConnection("Server=127.0.0.1;Port=5432;User Id=postgres;Password=projekt;Database=projekt;");
conn.Open();
// quite complex sql statement
string sql = "SELECT id_wyp FROM wyp_sali where id_sali='" + id + "'";
// data adapter making request from our connection
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn);
// i always reset DataSet before i do
// something with it.... i don't know why :-)
ds.Reset();
// filling DataSet with result from NpgsqlDataAdapter
da.Fill(ds);
// since it C# DataSet can handle multiple tables, we will select first
dt = ds.Tables[0];
int count = dt.Rows.Count;
for (int i = 0; i < count; i++)
{
string current = dt.Rows[i][0].ToString();
string sqlc = "SELECT * FROM wyposazenie where id_wyp='" + current + "'";
NpgsqlDataAdapter dac = new NpgsqlDataAdapter(sqlc, conn);
dac.Fill(ds1);
dt1 = ds1.Tables[0];
}
GridView1.DataSource = dt1;
GridView1.DataBind();
conn.Close();
}
示例5: initTexts
public void initTexts(object[] dataRow)
{
if (dataRow.Length == 0)
{
return;
}
this.dateTimePicker2.Value = Convert.ToDateTime(dataRow[1].ToString());
this.dateTimePicker3.Value = Convert.ToDateTime(dataRow[2].ToString());
this.textBox9.Text = dataRow[3].ToString();
DataTable dt;
string id = dataRow[0].ToString();
if (!String.Empty.Equals(id))
{
SqlDataAdapter adapter2 = new SqlDataAdapter(String.Format("EXEC [dbo].ksiazki_w_promocji {0}", id), conn);
DataSet set2 = new DataSet();
set2.Reset();
adapter2.Fill(set2);
dt = set2.Tables[0];
this.checkedListBox2.DataSource = dt;
this.checkedListBox2.DisplayMember = "tytul";
this.checkedListBox2.ValueMember = "isbn";
}
else {
dt = new DataTable();
}
for (int i = 0; i < checkedListBox2.Items.Count; i++)
{
checkedListBox2.SetItemChecked(i, true);
}
}
示例6: getPolygonPoints
public static IEnumerable<TerrainService.shPoint> getPolygonPoints(string polygon_guid)
{
List<TerrainService.shPoint> pntsList = new System.Collections.Generic.List<TerrainService.shPoint>();
string sql = "select * from polygon_points where polygon_guid='" + polygon_guid + "' order by point_num";
using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection))
using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, connection))
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
ds.Reset();
da.Fill(ds);
dt = ds.Tables[0];
if (dt == null || dt.Rows == null || dt.Rows.Count == 0)
{
return null;
}
foreach (DataRow row in dt.Rows)
{
TerrainService.shPoint mp = new TerrainService.shPoint();
mp.x = System.Convert.ToDouble(row["pointx"]);
mp.y = System.Convert.ToDouble(row["pointy"]);
pntsList.Add(mp);
}
}
return pntsList;
}
示例7: initData
public void initData()
{
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM [Promocje]", conn);
DataSet set = new DataSet();
set.Reset();
adapter.Fill(set);
DataTable datable = set.Tables["Table"];
int i = 0;
this.max = datable.Rows.Count;
DBHelper.Log(this.max.ToString());
datas = new object[max][];
foreach (DataRow dr in datable.Rows)
{
datas[i] = new object[6];
int v = 0;
foreach (string p in columns)
{
datas[i][v] = dr[p];
v++;
}
i++;
}
dualNumerator = new DualNumerator(datas, max);
initTexts(dualNumerator.GetFirst());
}
示例8: initData
public void initData()
{
Auth a = Auth.GetInstance();
string strcmd = "SELECT * FROM [Zamowienia] WHERE 1=1 ";
if (!a.IsAdmin()) {
strcmd += String.Format(" AND id_user = {0}", a.selectedUserId);
}
SqlDataAdapter adapter = new SqlDataAdapter(strcmd, conn);
DataSet set = new DataSet();
set.Reset();
adapter.Fill(set);
DataTable datable = set.Tables["Table"];
int i = 0;
this.max = datable.Rows.Count;
DBHelper.Log(this.max.ToString());
datas = new object[max][];
foreach (DataRow dr in datable.Rows)
{
datas[i] = new object[columns.Length];
int v = 0;
foreach (string p in columns)
{
datas[i][v] = dr[p];
v++;
}
i++;
}
dualNumerator = new DualNumerator(datas, max);
initTexts(dualNumerator.GetFirst());
}
示例9: consultar
public DataTable consultar(String query)
{
conectar();
SQLiteDataAdapter db = new SQLiteDataAdapter(query, conexion);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
ds.Reset();
db.Fill(ds);
dt = ds.Tables[0];
desconectar();
return dt;
/* SQLiteCommand cmd = new SQLiteCommand(query, conexion);
SQLiteDataReader datos = cmd.ExecuteReader();
// Leemos los datos de forma repetitiva
while (datos.Read())
{
string codigo = Convert.ToString(datos[0]);
string nombre = Convert.ToString(datos[1]);
// Y los mostramos
Console.WriteLine("Codigo: {0}, Nombre: {1}",
codigo, nombre);
}*/
}
示例10: extraerInformacion
public void extraerInformacion()
{
SQLiteConnection conexion = new SQLiteConnection("Data Source=../../archivos/bd.sqlite3;Version=3");
conexion.Open();
//Se conecta a la BD y trae los datos para, luego, llenar el DataSet
string strSQL = "select * from usuario";
SQLiteDataAdapter db = new SQLiteDataAdapter(strSQL, conexion);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
ds.Reset();
db.Fill(ds);
dt = ds.Tables[0];
//imprimimos los rows... habra que crear una clase para todas estas operaciones
foreach (DataRow a in dt.Rows)
{
Console.Write("Columna :" + a["id"] + "\n");
}
conexion.Close();
Console.ReadLine();
}
示例11: ExecuteDataSet
public static DataSet ExecuteDataSet(string SqlRequest, SQLiteConnection Connection)
{
DataSet dataSet = new DataSet();
dataSet.Reset();
SQLiteCommand cmd = new SQLiteCommand(SqlRequest, Connection);
try
{
Connection.Open();
SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(cmd);
dataAdapter.Fill(dataSet);
}
catch (SQLiteException ex)
{
Log.Write(ex);
//Debug.WriteLine(ex.Message);
throw; // пересылаем исключение на более высокий уровень
}
finally
{
Connection.Dispose();
}
return dataSet;
}
示例12: drExecute
public DataRow[] drExecute(string FileData, string sSql)
{
DataRow[] datarows = null;
SQLiteDataAdapter dataadapter = null;
DataSet dataset = new DataSet();
DataTable datatable = new DataTable();
try
{
using (SQLiteConnection con = new SQLiteConnection())
{
con.ConnectionString = @"Data Source=" + FileData + "; Version=3; New=False;";
con.Open();
using (SQLiteCommand sqlCommand = con.CreateCommand())
{
dataadapter = new SQLiteDataAdapter(sSql, con);
dataset.Reset();
dataadapter.Fill(dataset);
datatable = dataset.Tables[0];
datarows = datatable.Select();
k = datarows.Count();
}
con.Close();
}
}
catch(Exception ex)
{
// throw ex;
datarows = null;
}
return datarows;
}
示例13: GetDataTable
public static DataTable GetDataTable(string query)
{
DataSet tempDataSet = new DataSet();
SqliteDataAdapter tempAdapter = null;
try
{
__connection.Open();
tempAdapter = new SqliteDataAdapter(query, __connection);
tempDataSet.Reset();
tempAdapter.Fill(tempDataSet);
}
catch (Exception ex)
{
throw new InvalidOperationException("Error in the DataBase", ex);
}
finally
{
if (tempAdapter != null)
tempAdapter.Dispose();
__connection.Close();
}
return tempDataSet.Tables[0];
}
示例14: run
//Activate This Construntor to log All To Standard output
//public TestClass():base(true){}
//Activate this constructor to log Failures to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, false){}
//Activate this constructor to log All to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, true){}
//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
public void run()
{
Exception exp = null;
DataTable dt1 = GHTUtils.DataProvider.CreateParentDataTable();
DataTable dt2 = GHTUtils.DataProvider.CreateChildDataTable();
dt1.PrimaryKey = new DataColumn[] {dt1.Columns[0]};
dt2.PrimaryKey = new DataColumn[] {dt2.Columns[0],dt2.Columns[1]};
DataRelation rel = new DataRelation("Rel",dt1.Columns["ParentId"],dt2.Columns["ParentId"]);
DataSet ds = new DataSet();
ds.Tables.AddRange(new DataTable[] {dt1,dt2});
ds.Relations.Add(rel);
ds.Reset();
try
{
BeginCase("Reset - Relations");
Compare(ds.Relations.Count ,0 );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
try
{
BeginCase("Reset - Tables");
Compare(ds.Tables.Count ,0 );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
}
示例15: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
string rola;
FormsIdentity id =
(FormsIdentity)HttpContext.Current.User.Identity;
FormsAuthenticationTicket bilet = id.Ticket;
Label1.Text = "Zalogowany jako: " + User.Identity.Name;
// Get the stored user-data, in this case, our roles
rola = bilet.UserData;
if (rola != "admins") Response.Redirect("index.aspx");
DataSet ds = new DataSet();
DataTable dt = new DataTable();
NpgsqlConnection conn = new NpgsqlConnection("Server=127.0.0.1;Port=5432;User Id=postgres;Password=projekt;Database=projekt;");
conn.Open();
// quite complex sql statement
string sql = "SELECT * FROM sala";
// data adapter making request from our connection
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn);
// i always reset DataSet before i do
// something with it.... i don't know why :-)
ds.Reset();
// filling DataSet with result from NpgsqlDataAdapter
da.Fill(ds);
// since it C# DataSet can handle multiple tables, we will select first
dt = ds.Tables[0];
// connect grid to DataTable
GridView1.DataSource = dt;
GridView1.DataBind();
// since we only showing the result we don't need connection anymore
conn.Close();
}