C# DataSet.Clear方法代码示例

        /* Выполняем удаление выбранных элементов */
        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 + " - - - Запись удалена!");
                }
            }
        }

        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";
            }
        }

        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";
            }
        }

        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;
        }

        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;
        }

        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 { }
          
        }

        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;
            }
        }

        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;
        }

        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;
        }

        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();
        }

 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;
 }

 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);
             }
         }
     }
 }

        // 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;
        }

        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();
        }

        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;
        }