本文整理汇总了C#中System.Data.DataView类的典型用法代码示例。如果您正苦于以下问题:C# DataView类的具体用法?C# DataView怎么用?C# DataView使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DataView类属于System.Data命名空间,在下文中一共展示了DataView类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetMenuTreeTable
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++;
}
}
示例2: AdminGUI
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();
}
示例3: 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 = "";
}
示例4: frmVentasPesosInter_Load
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;
}
示例5: Run
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;
}
}
}
示例6: ExportToTxt
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();
}
示例7: GetMenuTreeTable
/// <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++;
}
}
}
示例8: initTrvTree
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失败");
}
}
示例9: GetReady
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;
}
示例10: EgyediEgyszeruInit
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";
}
示例11: RootNode
//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;
}
}
}
示例12: CancelEdit
[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");
}
示例13: ArrayBinding_Load
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;
}
示例14: AddNewTest
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);
}
}
示例15: chartServiceTestNumber_Load
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;
}