C# Data.DataView类代码示例

 public void GetMenuTreeTable()
 {
     DataTable dtMenu = this.systemidao.GetMenuList();
     DataView dv = new DataView(dtMenu);
     dv.RowFilter = " ParentId = '0'";
     int eRowIndex = 0;
     foreach (DataRowView drv in dv)
     {
         string trID = "node-" + eRowIndex.ToString();
         this.TableTree_Menu.Append("<tr id='" + trID + "'>");
         this.TableTree_Menu.Append("<td style='width: 230px;padding-left:20px;'><span class=\"folder\">" + drv["Menu_Name"].ToString() + "</span></td>");
         if (!string.IsNullOrEmpty(drv["Menu_Img"].ToString()))
         {
             this.TableTree_Menu.Append("<td style='width: 30px;text-align:center;'><img src='../../Themes/images/32/" + drv["Menu_Img"].ToString() + "' style='width:16px; height:16px;vertical-align: middle;' alt=''/></td>");
         }
         else
         {
             this.TableTree_Menu.Append("<td style='width: 30px;text-align:center;'><img src='../../Themes/images/32/5005_flag.png' style='width:16px; height:16px;vertical-align: middle;' alt=''/></td>");
         }
         this.TableTree_Menu.Append("<td style='width: 60px;text-align:center;'>" + this.GetMenu_Type(drv["Menu_Type"].ToString()) + "</td>");
         this.TableTree_Menu.Append("<td style='width: 60px;text-align:center;'>" + drv["Target"].ToString() + "</td>");
         this.TableTree_Menu.Append("<td style='width: 60px;text-align:center;'>" + drv["Sort"].ToString() + "</td>");
         this.TableTree_Menu.Append("<td>" + drv["NavigateUrl"].ToString() + "</td>");
         this.TableTree_Menu.Append("<td style='display:none'>" + drv["Menu_Id"].ToString() + "</td>");
         this.TableTree_Menu.Append("</tr>");
         this.TableTree_Menu.Append(this.GetTableTreeNode(drv["Menu_Id"].ToString(), dtMenu, trID));
         eRowIndex++;
     }
 }

        public AdminGUI()
        {
            InitializeComponent();
            SelectDA.getComboBox(comboBox2, "SELECT * FROM Suppliers ORDER BY CompanyName");
            DataSet ds = SelectDA.SelectDS("SELECT ProductID,ProductName,CompanyName,UnitPrice FROM Products,Suppliers WHERE Products.SupplierID = Suppliers.SupplierID");
            DataView dv = new DataView(ds.Tables[0]);
            dataGridView3.DataSource = dv;
            textBox10.Enabled = false;
            textBox9.Enabled = false;
            comboBox2.Enabled = false;
            textBox8.Enabled = false;
            button8.Visible = false;
            textBox6.Visible = false;
            textBox7.Visible = false;
            label7.Visible = false;
            label8.Visible = false;
            button9.Visible = false;
            button10.Visible = false;

            EnableTextBox(false);
            ClearTextBox();
            cbTypeSearch.SelectedIndex = 1;
            showData("");
            InitializeMemberData();
        }

        public void InitializeMemberData()
        {
            DataSet ds = EmployeeDA.SelectDS();
            DataView dv = new DataView(ds.Tables[0]);
            dataGridView1.DataSource = dv;

            dataGridView1.Enabled = true;
            textBox1.Enabled = false;
            textBox2.Enabled = false;
            textBox3.Enabled = false;
            textBox4.Enabled = false;
            textBox6.Enabled = false;
            textBox7.Enabled = false;
            comboBox1.Enabled = false;
            button1.Visible = true;
            button2.Visible = true;
            button3.Visible = true;
            button8.Visible = false;
            button9.Visible = false;
            button10.Visible = false;

            textBox1.Clear();
            textBox2.Clear();
            textBox3.Clear();
            textBox4.Clear();
            textBox6.Clear();
            textBox7.Clear();
            comboBox1.Text = "";
        }

 private void frmVentasPesosInter_Load(object sender, EventArgs e)
 {
     this.Location = new Point(50, 50);
     System.Drawing.Icon ico = Properties.Resources.icono_app;
     this.Icon = ico;
     this.ControlBox = true;
     this.MaximizeBox = false;
     FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
     DataTable tblLocales = BL.GetDataBLL.Locales();
     DataTable tblFormasPago = BL.GetDataBLL.FormasPago();
     DataView viewLocales = new DataView(tblLocales);
     viewLocales = new DataView(tblLocales);
     viewLocales.RowFilter = "IdLocalLOC <>'2' AND IdLocalLOC <>'1'";
     lstLocales.DataSource = viewLocales;
     lstLocales.DisplayMember = "NombreLOC";
     lstLocales.ValueMember = "IdLocalLOC";
     tblFormasPago = BL.GetDataBLL.FormasPago();
     cmbForma.ValueMember = "IdFormaPagoFOR";
     cmbForma.DisplayMember = "DescripcionFOR";
     cmbForma.DropDownStyle = ComboBoxStyle.DropDown;
     cmbForma.DataSource = tblFormasPago;
     cmbForma.SelectedValue = -1;
     cmbForma.BackColor = Color.White;
     AutoCompleteStringCollection formasPagoColection = new AutoCompleteStringCollection();
     foreach (DataRow row in tblFormasPago.Rows)
     {
         formasPagoColection.Add(Convert.ToString(row["DescripcionFOR"]));
     }
     cmbForma.AutoCompleteCustomSource = formasPagoColection;
     cmbForma.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
     cmbForma.AutoCompleteSource = AutoCompleteSource.CustomSource;
     cmbForma.SelectedValue = 99;
     lstLocales.SelectionMode = SelectionMode.One;
     lstLocales.SelectedIndex = -1;
 }

        public override void Run(ServiceController[] services, Form mainForm, DataGrid serviceGrid)
        {
            var addedMachine = QuickDialog2.DoQuickDialog("Add A Machine's Services", "Machine Name:",".","Pattern  ^(Enable|EPX):","");

            if (addedMachine != null)
            {

                MachineName = addedMachine[0];
                this.SearchPattern = addedMachine[1];
                try
                {
                    DataGrid dgrid = serviceGrid;

                    this.addView = (DataView)dgrid.DataSource;

                    CurrencyManager bm = (CurrencyManager)dgrid.BindingContext[this.addView];
                    ArrayList arrSelectedRows = new ArrayList();

                    this.addView = (DataView)bm.List;

                    mainForm.Invoke(new InvokeDelegate(this.AddMachineInGUIThread));

                    serviceGrid.Refresh();

                }
                finally
                {
                    addedMachine = null;
                    addView = null;
                }

            }
        }

 public void ExportToTxt(DataView dv)
 {
     string fn = "bf" + Common.ChineseToSpell.GetChineseSpell(cmbLb.SelectedValue.ToString()).ToLower();//此处把值转换为拼音
     SaveFileDialog saveFileDialog1 = new SaveFileDialog();
     saveFileDialog1.Filter = "txt(*.txt)|*.txt";
     saveFileDialog1.FilterIndex = 0;
     saveFileDialog1.RestoreDirectory = true;
     saveFileDialog1.CreatePrompt = true;
     saveFileDialog1.Title = "导出txt文件到 ";
     DateTime now = DateTime.Now;
     saveFileDialog1.FileName = fn;
     saveFileDialog1.ShowDialog();
     Stream myStream;
     myStream = saveFileDialog1.OpenFile();
     StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
     for (int rowNo = 0; rowNo < dv.Count; rowNo++)
     {
         String tempstr = "";
         for (int columnNo = 0; columnNo < dv.Table.Columns.Count; columnNo++)
         {
             if (columnNo > 0)
             {
                 tempstr += "\t ";
             }
             tempstr += dv.Table.Rows[rowNo][columnNo].ToString();
         }
         sw.WriteLine(tempstr);
     }
     sw.Close();
     myStream.Close();
 }

 /// <summary>
 /// 菜单树列表
 /// </summary>
 public void GetMenuTreeTable()
 {
     DataTable dtList = system_idao.GetMenuBind();
     DataTable dtRoleRight = system_idao.InitRoleRight(_key);
     if (DataTableHelper.IsExistRows(dtList))
     {
         DataTable dtButoon = DataTableHelper.GetNewDataTable(dtList, "Menu_Type = '3'");
         DataTable dtMenu = DataTableHelper.GetNewDataTable(dtList, "Menu_Type < '3'");
         DataView dv = new DataView(dtMenu);
         dv.RowFilter = " ParentId = '0'";
         int eRowIndex = 0;
         foreach (DataRowView drv in dv)
         {
             string trID = "node-" + eRowIndex.ToString();
             StrTree_Menu.Append("<tr id='" + trID + "'>");
             StrTree_Menu.Append("<td style='width: 200px;padding-left:20px;'><span class=\"folder\">" + drv["Menu_Name"] + "</span></td>");
             if (!string.IsNullOrEmpty(drv["Menu_Img"].ToString()))
                 StrTree_Menu.Append("<td style='width: 30px;text-align:center;'><img src='/Themes/images/32/" + drv["Menu_Img"] + "' style='width:16px; height:16px;vertical-align: middle;' alt=''/></td>");
             else
                 StrTree_Menu.Append("<td style='width: 30px;text-align:center;'><img src='/Themes/images/32/5005_flag.png' style='width:16px; height:16px;vertical-align: middle;' alt=''/></td>");
             StrTree_Menu.Append("<td style=\"width: 23px; text-align: left;\"><input id='ckb" + trID + "' onclick=\"ckbValueObj(this.id)\" style='vertical-align: middle;margin-bottom:2px;' type=\"checkbox\" " + GetChecked(drv["Menu_Id"].ToString(), dtRoleRight) + "  value=\"" + drv["Menu_Id"] + "\" name=\"checkbox\" /></td>");
             StrTree_Menu.Append("<td>" + GetButton(drv["Menu_Id"].ToString(), dtButoon, trID, dtRoleRight) + "</td>");
             StrTree_Menu.Append("</tr>");
             //创建子节点
             StrTree_Menu.Append(GetTableTreeNode(drv["Menu_Id"].ToString(), dtMenu, trID, dtButoon, dtRoleRight));
             eRowIndex++;
         }
     }
 }

        public void initTrvTree(TreeNodeCollection treeNodes, string strParentIndex, DataView dvList)
        {
            try
            {
                TreeNode tempNode;
                DataView dvList1;
                string currentNum;
                dvList1 = dvList;
                // select the datarow that it's parentcode is strParentIndex
                DataRow[] dataRows = dvList.Table.Select("parentCode ='" + strParentIndex + "'");
                foreach (DataRow dr in dataRows)
                {
                    tempNode = new TreeNode();
                    tempNode.Text = dr["bookTypeCode"].ToString() + "-"
                        + dr["bookTypeName"].ToString();
                    // tag property is save data about this treenode
                    tempNode.Tag = new treeNodeData(dr["bookTypeCode"].ToString(),
                        dr["bookTypeName"].ToString(), dr["bookTypeExplain"].ToString(),
                        dr["currentCode"].ToString(), dr["parentCode"].ToString());

                    currentNum = dr["currentCode"].ToString();
                    treeNodes.Add(tempNode);
                    // call rucursive
                    TreeNodeCollection temp_nodes = treeNodes[treeNodes.Count - 1].Nodes;
                    initTrvTree(temp_nodes, currentNum, dvList1);
                }
            }
            catch (Exception)
            {
                MessageBox.Show("初始化TreeView失败");
            }
        }

		public void GetReady ()
		{
			dataTable = new DataTable ("itemTable");
			dc1 = new DataColumn ("itemId");
			dc2 = new DataColumn ("itemName");
			dc3 = new DataColumn ("itemPrice");
			dc4 = new DataColumn ("itemCategory");
			
			dataTable.Columns.Add (dc1);
			dataTable.Columns.Add (dc2);
			dataTable.Columns.Add (dc3);
			dataTable.Columns.Add (dc4);
			DataRow dr;
			seed = 123;
			rowCount = 5;
			rndm = new Random (seed);
			for (int i = 1; i <= rowCount; i++) {
				dr = dataTable.NewRow ();
				dr["itemId"] = "item " + i;
				dr["itemName"] = "name " + rndm.Next ();
				dr["itemPrice"] = "Rs. " + (rndm.Next () % 1000);
				dr["itemCategory"] = "Cat " + ((rndm.Next () % 10) + 1);
				dataTable.Rows.Add (dr);
			}
			dataTable.AcceptChanges ();
			dataView = new DataView (dataTable);
			dataView.ListChanged += new ListChangedEventHandler (OnListChanged);
			listChangedArgs = null;
		}

 public override void EgyediEgyszeruInit()
 {
     EgyszeruTabla = new DataTable("PARTNER");
     Sqlinterface.Select(EgyszeruTabla, FakUserInterface.AktualCegconn, "PARTNER", "", " order by SZOVEG ", false);
     for (int i = 0; i < EgyszeruTabla.Rows.Count; i++)
     {
         DataRow egyrow = EgyszeruTabla.Rows[i];
         if (egyrow.RowState != DataRowState.Deleted)
         {
             bool van = false;
             for (int j = 0; j < partneridk.Length; j++)
             {
                 if (egyrow["PARTNER_ID"].ToString() == partneridk[j])
                 {
                     van = true;
                     break;
                 }
             }
             if (!van)
                 egyrow.Delete();
         }
     }
     EgyszeruTablaView = new DataView(EgyszeruTabla);
     EgyszeruIdNev = "PARTNER_ID";
     EgyszeruMegnevColumnNev = "SZOVEG";
 }

        //private int len = 2;
        public void RootNode(TreeNode pNode)
        {
            if (ds == null)
                return;
            DataView dvTree = new DataView(ds.Tables[0]);
            //dvTree.RowFilter = "len(Code)=" + len.ToString();
            dvTree.RowFilter = "Parent_Code=0";//Rank=1";
            foreach (DataRowView Row in dvTree)
            {
                TreeNode Node = this.Nodes.Add(Row["Code"].ToString(), "[" + Row["Code"].ToString() + "]" + Row["Name"].ToString(), 1);
                //AddNode(Node, len);
                AddNode(Node);
            }
            this.ExpandAll();
            if (m_SelectName.Trim() == "")
                return;
            foreach (TreeNode nt in this.Nodes)
            {
                if (nt.Name == SelectStringByLen(2))
                {
                    this.SelectedNode = nt;
                    if (m_SelectName.Length > 2)
                        Select(nt);
                    return;
                }

            }
        }

		[Test] public void CancelEdit()
		{
			DataTable dt = DataProvider.CreateParentDataTable();
			DataView dv = new DataView(dt);

			DataRowView drv = dv[0];

			drv.BeginEdit();
			drv["String1"] = "ChangeValue";

			// check Proposed value
			Assert.AreEqual("ChangeValue" , dt.Rows[0]["String1",DataRowVersion.Proposed] , "DRV5");

			// check IsEdit
			Assert.AreEqual(true, drv.IsEdit , "DRV6");

			// check Proposed value
			drv.CancelEdit();
			Assert.AreEqual(false, dt.Rows[0].HasVersion(DataRowVersion.Proposed) , "DRV7");

			// check current value
			Assert.AreEqual("1-String1" , dt.Rows[0]["String1",DataRowVersion.Current ] , "DRV8");

			// check IsEdit after cancel edit
			Assert.AreEqual(false, drv.IsEdit , "DRV9");
		}

        private void ArrayBinding_Load(object sender, System.EventArgs e)
        {
            // Access database
            System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm mainForm = (System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm)this.ParentForm;

            // The XML document
            string fileNameString = mainForm.applicationPath + "\\data\\data.xml";
            string fileNameSchema = mainForm.applicationPath + "\\data\\data.xsd";

            // Initializes a new instance of the DataSet class
            DataSet custDS = new DataSet();

            // Reads an XML schema into the DataSet.
            custDS.ReadXmlSchema( fileNameSchema );

            // Reads XML schema and data into the DataSet.
            custDS.ReadXml( fileNameString );

            // Initializes a new instance of the DataView class
            DataView firstView = new DataView(custDS.Tables[0]);

            Chart1.Series.Clear();
            // Since the DataView implements and IEnumerable, pass the reader directly into
            // the DataBindTable method with the name of the column used for the X value.
            Chart1.DataBindTable(firstView, "Name");

            // Set series appearance
            Chart1.Series[0].ChartType = SeriesChartType.Bar;
            Chart1.Series[0].Font = new Font("Trebuchet MS", 8);
            Chart1.Series[0].Color = System.Drawing.Color.FromArgb(220, 224,64,10);
            Chart1.Series[0].BorderWidth = 0;
        }

		public void AddNewTest ()
		{
			DataView dv = new DataView (dt);
			IBindingList ib = (IBindingList) dv;
			ib.ListChanged += new ListChangedEventHandler (OnListChanged);

			try {
				args = null;
				object o = ib.AddNew ();
				Assert.AreEqual (typeof (DataRowView), o.GetType (), "#1");
				Assert.AreEqual (ListChangedType.ItemAdded, args.ListChangedType, "#1.1");
				Assert.AreEqual (4, args.NewIndex, "#1.2");
				Assert.AreEqual (-1, args.OldIndex, "#1.3");

				DataRowView r = (DataRowView) o;
				Assert.AreEqual (25, r ["id"], "#2"); 
				Assert.AreEqual (DBNull.Value, r ["name"], "#3"); 
				Assert.AreEqual (5, dv.Count, "#4");

				args = null;
				r.CancelEdit ();
				Assert.AreEqual (ListChangedType.ItemDeleted, args.ListChangedType, "#4.1");
				Assert.AreEqual (4, args.NewIndex, "#4.2");
				Assert.AreEqual (-1, args.OldIndex, "#4.3");
				Assert.AreEqual (4, dv.Count, "#5");
			} finally {
				ib.ListChanged -= new ListChangedEventHandler (OnListChanged);
			}
		}

        private void chartServiceTestNumber_Load(object sender, EventArgs e)
        {
            chart1.Series["Series2"].Points.Clear();

            GetSummary();

            DataView dv = new DataView(_dataSet.Tables[0]);

            foreach (DataRowView rowView in dv)
            {
                DataRow row = rowView.Row;
                _total = _total + (decimal)row["NoofTest"];
            }

            for (int i=0;i<dv.Count;i++)
            {
             decimal percentage= decimal.Round(((decimal)dv[i]["NoofTest"]), 4, MidpointRounding.AwayFromZero);
             dv[i]["percentage"] = percentage;
            }

            chart1.Series["Series2"].LegendText ="#VALX , #VALY , (#PERCENT)";
            chart1.Series["Series2"].Points.DataBindXY(dv, "AreaName", dv, "percentage");
            chart1.Series["Series2"].IsValueShownAsLabel = false;
            chart1.Series["Series2"]["PieLabelStyle"] = "Disabled";
            chart1.Titles[0].Text = _chartTitle;
        }