本文整理汇总了C#中System.Data.DataSet.Clear方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.Clear方法的具体用法?C# DataSet.Clear怎么用?C# DataSet.Clear使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.Clear方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: removeInTable
/* Выполняем удаление выбранных элементов */
void removeInTable(String _tableName, String _value)
{
if(_tableName == "Фирмы") _deleteMySQL.SqlCommand = "DELETE FROM firms WHERE (firm_name = '" + _value + "' AND firm_delete = 1)";
if(_tableName == "ТМЦ") _deleteMySQL.SqlCommand = "DELETE FROM tmc WHERE (tmc_name = '" + _value + "' AND tmc_delete = 1)";
if(_tableName == "Склады") _deleteMySQL.SqlCommand = "DELETE FROM store WHERE (store_name = '" + _value + "' AND store_delete = 1)";
if(_tableName == "Ед.Изм") _deleteMySQL.SqlCommand = "DELETE FROM units WHERE (units_name = '" + _value + "' AND units_delete = 1)";
if(_tableName == "Вид налога") _deleteMySQL.SqlCommand = "DELETE FROM typeTax WHERE (typeTax_name = '" + _value + "' AND typeTax_delete = 1)";
if(_tableName == "Сотрудники") _deleteMySQL.SqlCommand = "DELETE FROM staff WHERE (staff_name = '" + _value + "' AND staff_delete = 1)";
if(_tableName == "План счетов") _deleteMySQL.SqlCommand = "DELETE FROM planAccounts WHERE (planAccounts_name = '" + _value + "' AND planAccounts_delete = 1)";
if(_tableName == "Документ") {
ClassMySQL_Full _removeDocMySQL = new ClassMySQL_Full();
DataSet _removeDocDataSet = new DataSet();
_removeDocMySQL.SelectSqlCommand = "SELECT * FROM journal WHERE (journal_number = '" + _value + "' AND journal_delete = 1)";
_removeDocDataSet.Clear();
_removeDocDataSet.DataSetName = "journal";
if(_removeDocMySQL.ExecuteFill(_removeDocDataSet, "journal")){
_deleteMySQL.SqlCommand = "DELETE FROM tabularSection WHERE (tabularSection_id_doc = '" + _removeDocDataSet.Tables["journal"].Rows[0]["journal_id_doc"].ToString() + "')";
if(_deleteMySQL.ExecuteNonQuery())
{
_deleteMySQL.SqlCommand = "DELETE FROM journal WHERE (journal_number = '" + _value + "' AND journal_delete = 1)";
if(_deleteMySQL.ExecuteNonQuery())
{
listBox1.Items.Add("[" + _tableName + "] " + _value + " - - - Запись удалена!");
}
}
}
}else{
if(_deleteMySQL.ExecuteNonQuery())
{
listBox1.Items.Add("[" + _tableName + "] " + _value + " - - - Запись удалена!");
}
}
}
示例2: Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
try
{
Session["voter"] = TextBox2.Text;
Session["voter_nic"] = TextBox1.Text;
ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter("select * from reg where nic =" + TextBox1.Text + " and fam=" + TextBox2.Text, con);
SqlCommandBuilder cb = new SqlCommandBuilder(ad);
ds.Clear();
ad.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
Response.Redirect("login_voter.aspx");
Label1.Text="Invalid Username Or Password";
// Response.Write(" <script >alert ('Wrong') </script>");
}
else
{
//Response.Write(" <script >alert ('congrates') </script>");
Response.Redirect("voter_Home.aspx");
con.Close();
}
}
catch(Exception ex){
Label1.Text="Invalid Username Or Password";
}
}
示例3: Button1_Click1
protected void Button1_Click1(object sender, EventArgs e)
{
System.Threading.Thread.Sleep(3000);
if (TextBox1.Text == "" && TextBox2.Text == "")
{
Label1.Text = "Invalid ID or Password";
}
else
{
Session["a"] = TextBox1.Text;
ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter("select * from adm_info where username ='" + TextBox1.Text + "' and pass='" + TextBox2.Text + "'", con);
SqlCommandBuilder cb = new SqlCommandBuilder(ad);
ds.Clear();
ad.Fill(ds);
if (TextBox2.Text == "" || ds.Tables[0].Rows.Count == 0)
{
Label1.Text = "Invalid ID or Password";
}
else
{
//Response.Write(" <script >alert ('congrates') </script>");
Response.Redirect("default.aspx");
con.Close();
}
Label1.Text = "Invalid ID or Password";
}
}
示例4: admin_checkOut
private bool admin_checkOut(string loginID, string password)
{
bool login = false;
SqlConnection sqlconnection = new SqlConnection(conStr);
string comStr = string.Format("select Sys_NAME, Sys_PASSWORD from dboSys where Sys_IID = \'{0}\'" ,loginID);
dataSet = new DataSet();
dataSet.Clear();
dataSet = SqlCommondClass.GetDataSet(comStr, "dboSys", sqlconnection);
if (dataSet.Tables[0].Rows.Count == 0)
{
login = false;
return login;
}
if (dataSet.Tables[0].Rows[0][1].ToString().Trim().Equals(password.Trim()))
{
this.sysLogin = true;
this.loginName = dataSet.Tables[0].Rows[0][0].ToString().Trim();
login = true;
return login;
}
return login;
}
示例5: LoadContacts
public DataSet LoadContacts(string xmlFilePath)
{
_xmlFilePath = xmlFilePath;
_contactsDataSet = new DataSet();
//_contactsDataView = new DataView();
_contactsDataSet.Clear();
if (File.Exists(_xmlFilePath))
{
_contactsDataSet.ReadXml(_xmlFilePath, XmlReadMode.ReadSchema);
//_contactsDataView = _contactsDataSet.Tables[0].DefaultView;
}
else
{
DataTable dtContacts = new DataTable("Contacts");
dtContacts.Columns.Add(new DataColumn("ContactNo", typeof(string)));
dtContacts.Columns.Add(new DataColumn("Identity", typeof(string)));
dtContacts.Columns.Add(new DataColumn("FriendlyName", typeof(string)));
dtContacts.Columns.Add(new DataColumn("Status", typeof(string)));
_contactsDataSet.Tables.Add(dtContacts);
//_contactsDataView = _contactsDataSet.Tables[0].DefaultView;
}
return _contactsDataSet;
}
示例6: CargarDatos
public void CargarDatos(ComboBox cmb, DataSet data, String str,String consulta)
{
try
{
Command.CommandText = consulta;
Adapter.SelectCommand = Command;
data.Clear();
Adapter.Fill(data, str);
cmb.Items.Clear();
foreach (DataRow r in data.Tables[0].Rows)
{
if (r[1].ToString() != "")
{
cmb.Items.Add(r[2].ToString() + " - " + r[1].ToString() + "," + r[0].ToString());
}
else
{
cmb.Items.Add(r[2].ToString() + " - " + r[0].ToString());
}
}
}
catch { }
}
示例7: extraerDatos
public DataSet extraerDatos(String NombreHoja, String RutaArchivo)
{
try
{
//Inicialización de las variables
OleDbConnection conexion = new OleDbConnection();
OleDbCommand comando = new OleDbCommand();
OleDbDataAdapter adaptador = new OleDbDataAdapter();
DataSet dsexcel = new DataSet();
String ExcelPath = "";
String data = "";
dsexcel.Clear();
data = NombreHoja;
ExcelPath = RutaArchivo.ToLower();
conexion.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelPath + "; Extended Properties= \"Excel 8.0;HDR=YES;IMEX=1\"";
conexion.Open();
comando.CommandText = "SELECT * FROM [" + data + "$] where valido=1";
comando.Connection = conexion;
adaptador.SelectCommand = comando;
adaptador.Fill(dsexcel);
conexion.Close();
return dsexcel;
}
catch (Exception)
{
return null;
}
}
示例8: dgvselectioncommand
public DataSet dgvselectioncommand()
{
DataSet ds = new DataSet();
try
{
ds.Clear();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sql, gl.oleconnection);
if (teacher != null && teacher != "")
dataAdapter.SelectCommand.Parameters.Add("teacher", OleDbType.VarChar, 50).Value = teacher;
if (infraction != null && infraction != "")
dataAdapter.SelectCommand.Parameters.Add("infraction", OleDbType.VarChar, 20).Value = infraction;
if (firstname != null && firstname != "")
{
dataAdapter.SelectCommand.Parameters.Add("firstname", OleDbType.VarChar, 20).Value = firstname;
dataAdapter.SelectCommand.Parameters.Add("lastname", OleDbType.VarChar, 20).Value = lastname;
dataAdapter.SelectCommand.Parameters.Add("studentid", OleDbType.VarChar, 20).Value = studentid;
}
if (learningcenter != "")
dataAdapter.SelectCommand.Parameters.Add("learningcenter", OleDbType.VarChar, 255).Value = learningcenter;
dataAdapter.SelectCommand.CommandType = CommandType.Text;
dataAdapter.Fill(ds);
}
catch (Exception) { }
return ds;
}
示例9: llenaGrid
public void llenaGrid()
{
DataSet dsGrid = new DataSet();
dsGrid.Clear();
if (cbGrupo.SelectedValue != null)
{
int selectedValue = ((ComboBoxItem)cbGrupo.SelectedItem).intValue;
dsGrid = datamanager.ConsultaDatos("exec dbo.[segGrupoMiembro] " + selectedValue.ToString());
dataGrid.IsReadOnly = !permiteModificar;
dataGrid.ItemsSource = dsGrid.Tables[0].DefaultView;
dataGrid.Columns[2].Visibility = System.Windows.Visibility.Hidden;
dataGrid.Columns[3].Visibility = System.Windows.Visibility.Hidden;
dataGrid.Columns[4].Visibility = System.Windows.Visibility.Hidden;
dataGrid.Columns[0].Width = 250;
dataGrid.Columns[0].IsReadOnly = true;
dataGrid.Columns[0].Header = "Usuario";
dataGrid.Columns[1].Header = "Miembro";
datamanager.ConexionCerrar();
}
btnAceptar.IsEnabled = false;
btnAceptar_png.IsEnabled = false;
}
示例10: fnPopulatedgv1
public void fnPopulatedgv1()
{
// Show default datagrid - Hap[pens to be a Donations file at the moment - Change CRH???
SqlConnection conDGV1;
SqlDataAdapter daDGV1;
DataSet dsdgv1 = new DataSet();
conDGV1 = new SqlConnection(VARtxtGAPConnection);
dsdgv1.Clear();
conDGV1.Open();
daDGV1 = new SqlDataAdapter("select * from vw_RECENT_BUILDS", conDGV1);
daDGV1.Fill(dsdgv1);
conDGV1.Close();
conDGV1.Dispose();
dgv1.DataSource = dsdgv1.Tables[0];
// Code to force seconds to be shown
// http://social.msdn.microsoft.com/Forums/en-US/2055d187-1d71-4771-8113-d590f62731b6/datagridviewcolumn-display-datetime-with-seconds-milliseconds-?forum=winforms
foreach (DataGridViewColumn dc in dgv1.Columns)
{
if (dc.ValueType == typeof(System.DateTime))
{
dc.DefaultCellStyle.Format = "dd/MM/yyyy HH:mm:ss";
}
}
// Resize columns in datagrid
dgv1.AutoResizeColumns();
}
示例11: SortDataSet
public static DataSet SortDataSet(DataSet ds,DataView view)
{
ds.Clear();
DataRow dr;
foreach (DataRowView row in view)
{
dr = ds.Tables[0].NewRow();
dr["ID"] = row["ID"];
dr["NV_ID"] = row["NV_ID"];
dr["TEN_NV"] = row["TEN_NV"];
dr["NGAY_DAU_TUAN"] = row["NGAY_DAU_TUAN"];
dr["ST2"] = row["ST2"];
dr["CT2"] = row["CT2"];
dr["ST3"] = row["ST3"];
dr["CT3"] = row["CT3"];
dr["ST4"] = row["ST4"];
dr["CT4"] = row["CT4"];
dr["ST5"] = row["ST5"];
dr["CT5"] = row["CT5"];
dr["ST6"] = row["ST6"];
dr["CT6"] = row["CT6"];
dr["ST7"] = row["ST7"];
dr["CT7"] = row["CT7"];
if(ds.Tables[0].Select("NV_ID=" + HelpNumber.ParseInt64(row["NV_ID"])).Length==0)
ds.Tables[0].Rows.Add(dr);
}
return ds;
}
示例12: GetAll
public DataSet GetAll(string empresaid, tb_cm_ordendecompradet BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCmOrdendecompradet_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local;
cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc;
cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc;
cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
ds.Clear();
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
示例13: ExecuteSelect
// 2 methodes:
// - Lezen uit database
// - Uitvoeren ander command (update, insert, delete)
public static DataTable ExecuteSelect(string SQL)
{
// Aanmaken van dataset
// Hierin komt de uitvoer (=dynaset) van de query
DataSet DS = new DataSet();
// Aanmaken dataAdapter
// Deze zorgt voor de vertaling van SQL naar C#
// Denk maar aan een soort tolk
SqlDataAdapter DA;
// Het configureren van de dataAdapter
DA = new SqlDataAdapter(SQL, clStam.Connstr);
// Voordat je een dataset gaat gebruiken moet je deze leegmaken
DS.Clear();
// Gebruik de dataAdapter om de dataset te vullen
DA.Fill(DS);
// Pak uit de dataset de EERSTE tabel omdat de dataset leeg was, is dit het resultaat van de query
DataTable DT = DS.Tables[0];
// Geef de datatable terug
return DT;
}
示例14: AutoIncrementColumns
public void AutoIncrementColumns()
{
execSQL("DROP TABLE IF EXISTS Test");
execSQL("CREATE TABLE Test (id int(10) unsigned NOT NULL auto_increment primary key)");
execSQL("INSERT INTO Test VALUES(NULL)");
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Test", conn);
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds);
Assert.AreEqual(1, ds.Tables[0].Rows[0]["id"]);
DataRow row = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(row);
try
{
da.Update(ds);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
ds.Clear();
da.Fill(ds);
Assert.AreEqual(1, ds.Tables[0].Rows[0]["id"]);
Assert.AreEqual(2, ds.Tables[0].Rows[1]["id"]);
cb.Dispose();
}
示例15: GetSampleProgram_ID
public int GetSampleProgram_ID(string strSample_ID)
{
int nProgram_ID = -1;
int nCountDetections = 0;
string SQL_Statement = "Select Detection,Name,idsample_programs FROM sample_programs ";
DataSet ds_SamplePrograms = new DataSet();
ds_SamplePrograms.Clear();
ds_SamplePrograms = myHC.GetDataSetFromSQLCommand(SQL_Statement);
DataTable dt_SamplePrograms = null;
if (ds_SamplePrograms.Tables[0] != null)
{
dt_SamplePrograms = ds_SamplePrograms.Tables[0];
foreach (DataRow dr_SampleProgram in dt_SamplePrograms.Rows)
{
if (CheckDetection(dr_SampleProgram["Detection"].ToString(), strSample_ID))
{
nProgram_ID = (int)dr_SampleProgram["idsample_programs"];
nCountDetections++;
mySave.InsertRow((int)Definition.Message.D_MESSAGE, strSample_ID + " match to " + dr_SampleProgram["Detection"].ToString() + " --> Program " + dr_SampleProgram["Name"].ToString() + "");
}
}
}
if(nProgram_ID == -1)
{
nProgram_ID = GetDefaultProgram();
mySave.InsertRow((int)Definition.Message.D_ALARM, @"no match for " + strSample_ID + " found in program detection pool, got "
+ myHC.GetNameFromID((int)Definition.SQLTables.SAMPLE_PROGRAM,nProgram_ID) + " (id:" + nProgram_ID + ") as default");
}
// MessageBox.Show(nProgram_ID.ToString());
if (nCountDetections > 1) { mySave.InsertRow((int)Definition.Message.D_ALARM, "found more than one(" + nCountDetections + ") matches to " + strSample_ID + " in programm detection pool"); }
return nProgram_ID;
}