本文整理汇总了C#中System.Data.DataView.Find方法的典型用法代码示例。如果您正苦于以下问题:C# DataView.Find方法的具体用法?C# DataView.Find怎么用?C# DataView.Find使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataView
的用法示例。
在下文中一共展示了DataView.Find方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Int32 IdInt = Convert.ToInt32(Request.Params["id"]);
if (IdInt == 0)
{
IdInt = Convert.ToInt32(Session["id"]);
}
else Session["id"] = IdInt;
SqlConnection sqlConn = GetConnection();
sqlConn.Open();
string sqlStr = "select * from Teacher where TeacherID = " + IdInt + "";
SqlCommand sqlComm = new SqlCommand(sqlStr, sqlConn);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = sqlComm;
DataSet ds = new DataSet();
sda.Fill(ds, "Teacher");
DataView dv = new DataView(ds.Tables["Teacher"], "", "TeacherID", DataViewRowState.CurrentRows);
int rowIndex = dv.Find(IdInt);
//Image1.ImageUrl = dv[rowIndex]["MyPhoto"].ToString().Trim();
Image1.ImageUrl = "~/images/person/" + dv[rowIndex]["MyPhoto"].ToString();
SqlDataSource1.FilterExpression = "TeacherID = " + IdInt + "";
DetailsView1.DataSourceID = "SqlDataSource1";
DetailsView1.DataBind();
}
}
示例2: btnTimKiem_Click
private void btnTimKiem_Click(object sender, EventArgs e)
{
XmlTextReader reader = new XmlTextReader("NhanVien.xml");
DataSet ds = new DataSet();
ds.ReadXml(reader);
DataView dv = new DataView(ds.Tables[0]);
dv.Sort = "MaNhanVien";
reader.Close();
int index = dv.Find(txtTimKiem.Text);
if (index == -1)
{
MessageBox.Show("Không tìm thấy");
txtTimKiem.Text = "";
txtTimKiem.Focus();
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("Mã nhân viên");
dt.Columns.Add("Họ và tên");
dt.Columns.Add("Ngày sinh");
dt.Columns.Add("Địa chỉ");
dt.Columns.Add("Số điện thoại");
dt.Columns.Add("Email");
object[] list = { dv[index]["MaNhanVien"], dv[index]["TenNhanVien"],dv[index]["NgaySinh"], dv[index]["DiaChi"], dv[index]["SDT"], dv[index]["Email"]};
dt.Rows.Add(list);
dgvNhanVien.DataSource = dt;
txtTimKiem.Text = "";
}
}
示例3: btnTimKiem_Click
private void btnTimKiem_Click(object sender, EventArgs e)
{
XmlTextReader reader = new XmlTextReader("Hang.xml");
DataSet ds = new DataSet();
ds.ReadXml(reader);
DataView dv = new DataView(ds.Tables[0]);
dv.Sort = "MaHang";
reader.Close();
int index = dv.Find(txtTimKiem.Text);
if (index == -1)
{
MessageBox.Show("Không tìm thấy");
txtTimKiem.Text = "";
txtTimKiem.Focus();
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("Mã hàng");
dt.Columns.Add("Tên hàng");
dt.Columns.Add("Đơn vị tính");
dt.Columns.Add("Đơn giá");
dt.Columns.Add("Sô lượng");
dt.Columns.Add("Mã NCC");
object[] list = { dv[index]["MaHang"], dv[index]["TenHang"],dv[index]["DonViTinh"], dv[index]["DonGia"], dv[index]["SoLuong"], dv[index]["MaNCC"]};
dt.Rows.Add(list);
dgvHang.DataSource = dt;
txtTimKiem.Text = "";
}
}
示例4: GetRtValue
public bool GetRtValue(int nNum, numInf[] nrst, int sNum, strInf[] srst)
{
try
{
using (SqlCommand cmd = new SqlCommand("SELECT a.TAG,a.VALUE,a.TIME FROM REALVALUE a INNER JOIN TAGCONFIG b ON b.TYPE=0 AND a.TAG=b.TAG ORDER BY b.ID_KEY", _con))
using (SqlDataAdapter dad = new SqlDataAdapter(cmd))
using (DataTable dtbl = new DataTable())
{
dad.Fill(dtbl);
using (DataView dvw = new DataView(dtbl, "", "TAG", DataViewRowState.CurrentRows))
{
for (int i = 0; i < nrst.Length; ++i)
{
int idx = dvw.Find(nrst[i].srcId);
if (-1 != idx)
{
nrst[i].val = Convert.ToSingle(dvw[idx][1]);
nrst[i].dtm = Convert.ToDateTime(dvw[idx][2]);
}
}
}
}
using (SqlCommand cmd = new SqlCommand("SELECT a.TAG,a.VALUE,a.TIME FROM REALVALUE a INNER JOIN TAGCONFIG b ON b.TYPE=1 AND a.TAG=b.TAG ORDER BY b.ID_KEY", _con))
using (SqlDataAdapter dad = new SqlDataAdapter(cmd))
using (DataTable dtbl = new DataTable())
{
dad.Fill(dtbl);
using (DataView dvw = new DataView(dtbl, "", "TAG", DataViewRowState.CurrentRows))
{
for (int i = 0; i < srst.Length; ++i)
{
int idx = dvw.Find(srst[i].srcId);
if (-1 != idx)
{
srst[i].val = dvw[idx][1].ToString();
srst[i].dtm = Convert.ToDateTime(dvw[idx][2]);
}
}
}
}
return true;
}
catch (Exception ex)
{
DisConnect();
Connect();
err.WrtMsg(ex.Message);
return false;
}
}
示例5: FillAllParents
private static void FillAllParents(string id, DataView view, bool includingSelf, SCSimpleObjectCollection parents)
{
int index = view.Find(id);
if (index >= 0)
{
DataRow row = view[index].Row;
if (includingSelf)
parents.Add(MapDataRowToSimpleObject(row));
FillAllParentsRecursively(row["ParentID"].ToString(), view, parents);
}
}
示例6: CompareAndAddUserExtendData
private static void CompareAndAddUserExtendData(DataTable srcTable, DataTable targetTable, DataView compareView)
{
//提出要添加的行
foreach (DataRow dr in srcTable.Rows)
{
int index = compareView.Find(dr["ID"]);
if (index == -1)
{
//添加新纪录
DataRow newdr = targetTable.NewRow();
AD2DBHelper.CopyDataRow(dr, newdr,
"ID", "MOBILE", "OFFICE_TEL", "GENDER", "NATION", "IM_ADDRESS");
targetTable.Rows.Add(newdr);
}
}
}
示例7: CompareAndAddUserData
private static void CompareAndAddUserData(DataTable srcTable, DataTable targetTable, DataView compareView)
{
//提出要添加的行
foreach (DataRow dr in srcTable.Rows)
{
int index = compareView.Find(dr["GUID"]);
if (index == -1)
{
//添加新纪录
DataRow newdr = targetTable.NewRow();
AD2DBHelper.CopyDataRow(dr, newdr,
"GUID", "FIRST_NAME", "LAST_NAME", "LOGON_NAME", "PWD_TYPE_GUID", "USER_PWD",
"RANK_CODE", "POSTURAL", "PINYIN", "E_MAIL");
targetTable.Rows.Add(newdr);
}
}
}
示例8: CompareAndAddOguData
private static void CompareAndAddOguData(DataTable srcTable, DataTable targetTable, DataView compareView, AD2DBTransferContext context)
{
//提出要添加的行
foreach (DataRow dr in srcTable.Rows)
{
int index = compareView.Find(dr["GUID"]);
if (index == -1)
{
//添加新纪录
DataRow newdr = targetTable.NewRow();
UpdateSort(dr, context);
AD2DBHelper.CopyDataRow(dr, newdr,
"GUID", "PARENT_GUID", "OBJ_NAME", "DISPLAY_NAME", "DESCRIPTION", "DESCRIPTION",
"ALL_PATH_NAME", "ORIGINAL_SORT", "CHILDREN_COUNTER", "GLOBAL_SORT", "RANK_CODE",
"INNER_SORT", "ORG_TYPE", "ORG_CLASS", "STATUS", "SEARCH_NAME");
targetTable.Rows.Add(newdr);
}
}
}
示例9: CheckUserAccount
public static Boolean CheckUserAccount(string pUserName, string pPassword)
{
try
{
DataView dv = new DataView(clsDeclare.glbDataSet.Tables["SYS_User"]);
dv.Sort = "UserName";
int index = dv.Find(pUserName);
if (index < 0)
{
return false;
}
if (Security.Encrypte(pPassword) != dv[index]["Password"].ToString())
{
return false;
}
return true;
}
catch
{
return false;
}
}
示例10: FilePrint
/// <summary>
/// Print out the Hierarchy using FastReports template.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FilePrint(object sender, EventArgs e)
{
FastReportsWrapper ReportingEngine = new FastReportsWrapper("Account Hierarchy");
if (!ReportingEngine.LoadedOK)
{
ReportingEngine.ShowErrorPopup();
return;
}
if (!FMainDS.AAccount.Columns.Contains("AccountPath"))
{
FMainDS.AAccount.Columns.Add("AccountPath", typeof(String));
FMainDS.AAccount.Columns.Add("AccountLevel", typeof(Int32));
}
DataView PathView = new DataView(FMainDS.AAccountHierarchyDetail);
PathView.Sort = "a_reporting_account_code_c";
DataView AccountView = new DataView(FMainDS.AAccount);
AccountView.Sort = "a_account_code_c";
// I need to make the "AccountPath" field that will be used to sort the table for printout:
foreach (DataRowView rv in PathView)
{
DataRow Row = rv.Row;
String AccountCode = Row["a_reporting_account_code_c"].ToString();
String Path = Row["a_report_order_i"] + "-" + AccountCode + '~';
Int32 Level = 0;
String ReportsTo = Row["a_account_code_to_report_to_c"].ToString();
while (ReportsTo != "")
{
Int32 ParentIdx = PathView.Find(ReportsTo);
if (ParentIdx >= 0)
{
DataRow ParentRow = PathView[ParentIdx].Row;
ReportsTo = ParentRow["a_account_code_to_report_to_c"].ToString();
Path = ParentRow["a_report_order_i"] + "-" + ParentRow["a_reporting_account_code_c"].ToString() + "~" + Path;
Level++;
if (Level > 100) // Surely this is a fault. If I just break here,
{
break; // the report will print and I should be able to see what the fault is.
}
}
else
{
ReportsTo = "";
}
}
Int32 AccountIdx = AccountView.Find(AccountCode);
DataRow AccountRow = AccountView[AccountIdx].Row;
AccountRow["AccountPath"] = Path;
AccountRow["AccountLevel"] = Level;
}
AccountView.Sort = "AccountPath";
DataTable SortedByPath = AccountView.ToTable();
ReportingEngine.RegisterData(SortedByPath, "AccountHierarchy");
ReportingEngine.RegisterData(FMainDS.AAnalysisAttribute, "AnalysisAttribute");
TRptCalculator Calc = new TRptCalculator();
ALedgerRow LedgerRow = FMainDS.ALedger[0];
Calc.AddParameter("param_ledger_number_i", LedgerRow.LedgerNumber);
Calc.AddStringParameter("param_ledger_name", LedgerRow.LedgerName);
if (ModifierKeys.HasFlag(Keys.Control))
{
ReportingEngine.DesignReport(Calc);
}
else
{
ReportingEngine.GenerateReport(Calc);
}
}
示例11: generateBainaryMatchData
public bool generateBainaryMatchData()
{
DataTable dt = new DataTable();
genologyDAL genology = new genologyDAL();
string LeftChild = "";
string RightChild = "";
bool status = false;
DataRow dr = null;
try
{
dt = getStakeJoiningList();
DataTable dtnode = getMatchingNodeList();
DataTable dtParent = getStakeJoiningParentList();
for (int i = 0; i < dt.Rows.Count; i++)
{
InserNode = new DataTable();
InserNode.Columns.Add(new DataColumn("NodeId"));
InserNode.Columns.Add(new DataColumn("ChildId"));
InserNode.Columns.Add(new DataColumn("Amount"));
InserNode.Columns.Add(new DataColumn("Position"));
LeftChild = "";
RightChild = "";
findLeftRight(dt.Rows[i]["PleacementId"].ToString(), out LeftChild, out RightChild);
if (LeftChild != "")
{
viststack.Push(LeftChild);
DataView view = new DataView(dt);
view.RowFilter = "UserId = '" + LeftChild + "'";
DataView viewNode = new DataView(dtnode);
viewNode.Sort = "ChildId";
viewNode.RowFilter = "NodeID = '" + dt.Rows[i]["PleacementId"].ToString() + "'";
if (viewNode.Count > 0)
{
int index = viewNode.Find(view[0]["UserId"].ToString());
if (index == -1)
{
if (Convert.ToDecimal(view[0]["StakeAmount"].ToString()) > 0)
{
dr = InserNode.NewRow();
dr["NodeId"] = dt.Rows[i]["PleacementId"].ToString();
dr["ChildId"] = view[0]["UserId"].ToString();
dr["Amount"] = view[0]["StakeAmount"].ToString();
dr["Position"] = "L";
InserNode.Rows.Add(dr);
}
}
}
else
{
if (Convert.ToDecimal(view[0]["StakeAmount"].ToString()) > 0)
{
dr = InserNode.NewRow();
dr["NodeId"] = dt.Rows[i]["PleacementId"].ToString();
dr["ChildId"] = view[0]["UserId"].ToString();
dr["Amount"] = view[0]["StakeAmount"].ToString();
dr["Position"] = "L";
InserNode.Rows.Add(dr);
}
}
VisitChildrenByParentId(dt.Rows[i]["PleacementId"].ToString(), dt, dtnode, "L");
}
if (RightChild != "")
{
viststack.Push(RightChild);
DataView view = new DataView(dt);
view.RowFilter = "UserId = '" + RightChild + "'";
DataView viewNode = new DataView(dtnode);
viewNode.Sort = "ChildId";
viewNode.RowFilter = "NodeID = '" + dt.Rows[i]["PleacementId"].ToString() + "'";
if (viewNode.Count > 0)
{
int index = viewNode.Find(view[0]["UserId"].ToString());
if (index == -1)
{
if (Convert.ToDecimal(view[0]["StakeAmount"].ToString()) > 0)
{
dr = InserNode.NewRow();
dr["NodeId"] = dt.Rows[i]["PleacementId"].ToString();
dr["ChildId"] = view[0]["UserId"].ToString();
dr["Amount"] = view[0]["StakeAmount"].ToString();
dr["Position"] = "R";
InserNode.Rows.Add(dr);
}
}
}
else
{
if (Convert.ToDecimal(view[0]["StakeAmount"].ToString()) > 0)
{
dr = InserNode.NewRow();
dr["NodeId"] = dt.Rows[i]["PleacementId"].ToString();
dr["ChildId"] = view[0]["UserId"].ToString();
dr["Amount"] = view[0]["StakeAmount"].ToString();
//.........这里部分代码省略.........
示例12: SetValues
public void SetValues()
{
//set the values of the txtboxes
//note that we need both dataviews (they could be differnt versions of the same
//dataset but either way, we need two, one sorted by waterbodyid and one by
//waterbodyname.
LoadWaterDataSet();
DataView dvWatersheds = new DataView(objdsWatersheds.Tables["DE-Watersheds"],"","WaterBodyID", DataViewRowState.CurrentRows);
int j = dvWatersheds.Find(Session["SelectedWaterBodyID"].ToString());
txtwaterbodyid.Text = dvWatersheds[j]["WaterBodyID"].ToString();
txtwaterbodyname.Text = dvWatersheds[j]["WaterBodyName"].ToString();
txtwatershed.Text = dvWatersheds[j]["DrainageCd"].ToString();
}
示例13: SetCaptionDefault
private void SetCaptionDefault(Control ctr, Form pForm, string pLanguage, DataView dv)
{
dv.Sort = "FormName,ControlName,Language";
int index;
DataRowView row;
object[] keys = new object[3];
keys[0] = pForm.Name;
keys[1] = ctr.Name;
keys[2] = pLanguage;
index = dv.Find(keys);
if (index >= 0)
{
row = dv[index];
ctr.Text = row["Text"].ToString();
}
}
示例14: SetCaption
private void SetCaption(DevExpress.XtraEditors.RadioGroup pRadioGroup, Form pForm, string pLanguage, DataView dv)
{
dv.Sort = "FormName,ControlName,Language";
int index;
DataRowView row;
object[] keys = new object[3];
foreach (DevExpress.XtraEditors.Controls.RadioGroupItem ctr in pRadioGroup.Properties.Items)
{
keys[0] = pForm.Name;
keys[1] = ctr.Description;
keys[2] = pLanguage;
index = dv.Find(keys);
if (index >= 0)
{
row = dv[index];
ctr.Description = row["Text"].ToString();
}
}
}
示例15: GetRowByKey
public DataRow GetRowByKey(string pTable, string pSort, object pValues, DataSet pDataset)
{
if (!pDataset.Tables.Contains(pTable))
{
return null;
}
DataView dv = new DataView(pDataset.Tables[pTable]);
dv.Sort = pSort;
int index = dv.Find(pValues);
if (index >= 0)
{
return pDataset.Tables[pTable].Rows[index];
}
return null;
}