本文整理汇总了C#中System.Data.DataView.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# DataView.Dispose方法的具体用法?C# DataView.Dispose怎么用?C# DataView.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataView
的用法示例。
在下文中一共展示了DataView.Dispose方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetfeederActivationCode
public string GetfeederActivationCode(string fid)
{
CheckHasRows();
DataView dv = new DataView(dtfeeder);
dv.RowFilter = "feederNumber = " + fid;
string returnval = "";
if (dv.Count > 0)
{
returnval = dv[0]["FeederActivationCode"].ToString();
}
dv.Dispose();
return returnval;
}
示例2: GetfeederPosX
public double GetfeederPosX(string fid)
{
CheckHasRows();
DataView dv = new DataView(dtfeeder);
dv.RowFilter = "feederNumber = " + fid;
double returnval = 0.0;
if (dv.Count > 0)
{
returnval = double.Parse(dv[0]["PosX"].ToString());
}
dv.Dispose();
return returnval;
}
示例3: addData
public void addData(int iAddCnt, int iScrollingRowIndex, DataView dv)
{
try
{
int iRowCnt = base.dgvLogData.Rows.Count + iAddCnt;
int count = base.m_dvLogData.Count;
int num3 = 0;
if (iAddCnt >= base.iMaxLogCnt)
{
base.m_dtLogData.Rows.Clear();
num3 = iAddCnt - base.iMaxLogCnt;
}
else if (iRowCnt > base.iMaxLogCnt)
{
for (int i = 1; i <= (iRowCnt - base.iMaxLogCnt); i++)
{
base.m_dvLogData.Delete((int) (count - i));
}
}
base.m_dvLogData.Sort = "";
DataRow row = null;
int num5 = 0;
while (num3 < iAddCnt)
{
row = dv[num3].Row;
num5 = base.dgvLogData.SelectedRows.Count;
base.m_dtLogData.ImportRow(row);
num3++;
}
base.SetCurrentRow(base.dgvLogData, iRowCnt, base.iMaxLogCnt, iAddCnt);
num5 = base.dgvLogData.SelectedRows.Count;
row = null;
base.m_dvLogData.Sort = "ReceTime DESC";
if (num5 == 0)
{
base.dgvLogData.ClearSelection();
}
if (iScrollingRowIndex >= 0)
{
base.dgvLogData.FirstDisplayedScrollingRowIndex = iScrollingRowIndex;
}
base.dgvLogData.Refresh();
dv.Dispose();
dv = null;
}
catch
{
}
}
示例4: GetComponentsHeight
public double GetComponentsHeight(string fid)
{
if (dscomponents.Tables.Count == 0)
{
POPComponentsTable();
}
DataView dv = new DataView(dscomponents.Tables[0]);
dv.RowFilter = "ComponentCode = " + fid;
double returnval = 0.0;
if (dv.Count > 0)
{
returnval = double.Parse(dv[0]["ComponentHeight"].ToString());
}
dv.Dispose();
return returnval;
}
示例5: GetfeederNumber
public string GetfeederNumber(string fid)
{
if (ds.Tables.Count == 0)
{
POPFeedersTable();
}
DataView dv = new DataView(ds.Tables[0]);
dv.RowFilter = "feederNumber = " + fid;
string returnval = "";
if (dv.Count > 0)
{
returnval = dv[0][0].ToString();
}
dv.Dispose();
return returnval;
}
示例6: GetfeederPosX
public double GetfeederPosX(string fid)
{
if (ds.Tables.Count == 0)
{
POPFeedersTable();
}
DataView dv = new DataView(ds.Tables[0]);
dv.RowFilter = "feederNumber = " + fid;
double returnval = 0.0;
if (dv.Count > 0)
{
returnval = double.Parse(dv[0][2].ToString());
}
dv.Dispose();
return returnval;
}
示例7: GetComponentPackage
public string GetComponentPackage(string fid)
{
if (dscomponents.Tables.Count == 0)
{
POPComponentsTable();
}
DataView dv = new DataView(dscomponents.Tables[0]);
dv.RowFilter = "ComponentCode = " + fid;
string returnval = "";
if (dv.Count > 0)
{
returnval = dv[0]["Package"].ToString();
}
dv.Dispose();
return returnval;
}
示例8: GetFeederPickPlusChipHeight
public bool GetFeederPickPlusChipHeight(string fid)
{
CheckHasRows();
DataView dv = new DataView(dtfeeder);
dv.RowFilter = "feederNumber = " + fid;
bool returnval = false;
if (dv.Count > 0)
{
if (dv[0]["PickPlusChipHeight"].ToString().Equals("True"))
{
returnval = true;
}
else
{
returnval = false;
}
}
dv.Dispose();
return returnval;
}
示例9: GetComponentTapeFeeder
public bool GetComponentTapeFeeder(string fid)
{
if (dscomponents.Tables.Count == 0)
{
POPComponentsTable();
}
DataView dv = new DataView(dscomponents.Tables[0]);
dv.RowFilter = "ComponentCode = " + fid;
bool returnval = false;
if (dv.Count > 0)
{
if (dv[0]["TapeFeeder"].ToString().Equals("True"))
{
returnval = true;
}
else
{
returnval = false;
}
}
dv.Dispose();
return returnval;
}
示例10: worker_DoWork
private void worker_DoWork(object sender, DoWorkEventArgs e)
{
// run all background tasks here
BackgroundWorker worker = sender as BackgroundWorker;
DataTable dtComponents = dsData.Tables["Components"];
DataView dv = new DataView(dtComponents);
dv.RowFilter = "Pick = 1";
int currentrow = 0;
int totalrows = dv.Count;
Nozzle1Xoffset = dh.Nozzle1Xoffset;
Nozzle1Yoffset = dh.Nozzle1Yoffset;
Nozzle2Xoffset = dh.Nozzle2Xoffset;
Nozzle2Yoffset = dh.Nozzle2Yoffset;
if (totalrows > 0)
{
/* Components table columns
ComponentCode
ComponentName
PlacementX
PlacementY
PlacementRotate
PlacementNozzle
* component list
* ComponentCode
* ComponentValue
* Package
*
* PlacementHeight
* FeederHeight
* FeederX
* FeederY
* VerifywithCamera
* TapeFeeder
* */
double pcbHeight = double.Parse(dsData.Tables["BoardInfo"].Rows[0][1].ToString());
double feedrate = 20000;
double feederPosX = 0;
double feederPosY = 0;
double feederPosZ = 0;
double placePosX = 0;
double placePosY = 0;
//double placePosZ = 0;
// double placePosA = 0;
// double placePosRotateZ = 0;
// double placePosRotateB = 0;
double ComponentRotation = 0;
double PlacementHeight = 0;
int PlacementNozzle = 1;
bool TapeFeeder = false;
while (currentrow < totalrows)
{
if (backgroundWorkerBuildPCB.CancellationPending)
{
e.Cancel = true;
dv.Dispose();
break;
}
PlacementNozzle = int.Parse(dv[currentrow]["PlacementNozzle"].ToString());
feederPosX = CalcXLocation(comp.GetFeederX(dv[currentrow]["ComponentCode"].ToString()),PlacementNozzle);
feederPosY = CalcYLocation(comp.GetFeederY(dv[currentrow]["ComponentCode"].ToString()),PlacementNozzle);
feederPosZ = comp.GetFeederHeight(dv[currentrow]["ComponentCode"].ToString());
PlacementHeight = comp.GetPlacementHeight(dv[currentrow]["ComponentCode"].ToString()) - pcbHeight;
TapeFeeder = comp.GetComponentTapeFeeder(dv[currentrow]["ComponentCode"].ToString());
placePosX = CalcXLocation(double.Parse(dv[currentrow]["PlacementX"].ToString()),PlacementNozzle);
placePosY = CalcYLocation(double.Parse(dv[currentrow]["PlacementY"].ToString()), PlacementNozzle);
ComponentRotation = double.Parse(dv[currentrow]["PlacementRotate"].ToString());
PlacementNozzle = int.Parse(dv[currentrow]["PlacementNozzle"].ToString());
if (currentrow == 0)
{
SetFeederOutputs(comp.GetFeederID(dv[currentrow]["ComponentCode"].ToString())); // send feeder to position
}
kf.MoveSingleFeed(feedrate, feederPosX, feederPosY, ClearHeight, ClearHeight, 0, 0);
if (comp.GetComponentTapeFeeder(dv[currentrow]["ComponentCode"].ToString()))
{
while (!usbController.getFeederReadyStatus())
//.........这里部分代码省略.........
示例11: Index_Ch_GetNav
private string Index_Ch_GetNav(string paramStr)
{
string paramValue = "";
string str2 = "";
string str3 = "";
string str4 = "10";
string str5 = "";
this.GetParamValue(paramStr, "navcss", ref paramValue);
this.GetParamValue(paramStr, "arrange", ref str2);
this.GetParamValue(paramStr, "compart", ref str3);
this.GetParamValue(paramStr, "navcount", ref str4);
this.GetParamValue(paramStr, "target", ref str5);
DataTable table = this.ChannelBll.GetList(false).ToTable();
DataView view = new DataView(table);
view.RowFilter = "isdisabled=0";
StringBuilder builder = new StringBuilder();
for (int i = 1; i <= view.Count; i++)
{
int chId = (int)view[i - 1]["chid"];
string str6 = view[i - 1]["content"].ToString();
string str7 = view[i - 1]["chname"].ToString();
if (str2 == "true")
{
if (((i % int.Parse(str4)) == 0) && (i != view.Count))
{
builder.Append(string.Format("<a href=\"{0}\" target=\"{1}\" title=\"{2}\" class=\"{3}\">{4}</a><br/>", new object[] { this.GetChannelUrl(chId), str5, str6, paramValue, str7 }));
}
else if (i == view.Count)
{
builder.Append(string.Format("<a href=\"{0}\" target=\"{1}\" title=\"{2}\" class=\"{3}\">{4}</a>", new object[] { this.GetChannelUrl(chId), str5, str6, paramValue, str7 }));
}
else
{
builder.Append(string.Format("<a href=\"{0}\" target=\"{1}\" title=\"{2}\" class=\"{3}\">{4}</a>{5}", new object[] { this.GetChannelUrl(chId), str5, str6, paramValue, str7, str3 }));
}
}
else
{
builder.Append(string.Format("{0}<a href=\"{1}\" target=\"{2}\" title=\"{3}\" class=\"{4}\">{5}</a></br>", new object[] { str3, this.GetChannelUrl(chId), str5, str6, paramValue, str7 }));
}
}
table.Dispose();
view.Dispose();
return builder.ToString();
}
示例12: GetIndexSpNav
private string GetIndexSpNav(string paramStr)
{
string paramValue = "";
string str2 = "";
string str3 = "";
string str4 = "10";
string str5 = "";
this.GetParamValue(paramStr, "navcss", ref paramValue);
this.GetParamValue(paramStr, "arrange", ref str2);
this.GetParamValue(paramStr, "compart", ref str3);
this.GetParamValue(paramStr, "navcount", ref str4);
this.GetParamValue(paramStr, "target", ref str5);
DataTable specials = this.SpecialBll.GetSpecials(0);
DataView view = new DataView(specials);
view.RowFilter = "islock=0";
StringBuilder builder = new StringBuilder();
for (int i = 0; i < view.Count; i++)
{
int specialId = (int)view[i]["ID"];
string str6 = view[i]["SpecialCName"].ToString();
if (str2 == "true")
{
if (i == int.Parse(str4))
{
builder.Append("<a href='");
builder.Append(this.GetSpecialUrl(specialId, 1));
builder.Append("' target='");
builder.Append(str5);
builder.Append("' class='");
builder.Append(paramValue);
builder.Append("'>");
builder.Append(str6);
builder.Append("</a><br/>");
}
else if (i >= (view.Count - 1))
{
builder.Append("<a href='");
builder.Append(this.GetSpecialUrl(specialId, 1));
builder.Append("' target='");
builder.Append(str5);
builder.Append("' class='");
builder.Append(paramValue);
builder.Append("'>");
builder.Append(str6);
builder.Append("</a>");
}
else
{
builder.Append("<a href='");
builder.Append(this.GetSpecialUrl(specialId, 1));
builder.Append("' target='");
builder.Append(str5);
builder.Append("' class='");
builder.Append(paramValue);
builder.Append("'>");
builder.Append(str6);
builder.Append("</a>");
builder.Append(str3);
}
}
else
{
builder.Append(str3);
builder.Append("<a href='");
builder.Append(this.GetSpecialUrl(specialId, 1));
builder.Append("' target='");
builder.Append(str5);
builder.Append("' class='");
builder.Append(paramValue);
builder.Append("'>");
builder.Append(str6);
builder.Append("</a><br/>");
}
}
specials.Dispose();
view.Dispose();
return builder.ToString();
}
示例13: bindPageInstitute
public string bindPageInstitute(DataTable dtInstitute, DataTable dtInstAdmis)
{
string xAxis = "";
string xData = "";
string xData2 = "";
StringBuilder builder = new StringBuilder();
builder.Append("$(function () {");
builder.Append("$('#container1').highcharts({").AppendLine();
builder.Append("chart: {").AppendLine();
builder.Append("type: 'bar'").AppendLine();
builder.Append(" },").AppendLine();
builder.Append("title: {").AppendLine();
builder.Append("text: 'Institute Wise Admission (" + dtInstitute.Rows[0]["AcademicYear"].ToString() + ")' ").AppendLine();
builder.Append(" },").AppendLine();
builder.Append("subtitle: {").AppendLine();
builder.Append("text: ''").AppendLine();
builder.Append("},").AppendLine();
builder.Append("xAxis: { type: 'category'").AppendLine();
//for (int cnt = 0; cnt < dtResult.Rows.Count; cnt++)
//{
// if (cnt == (dtResult.Rows.Count - 1))
// {
// xAxis = xAxis + "'" + dtResult.Rows[cnt]["Institute"].ToString() + "'";
// }
// else
// xAxis = xAxis + "'" + dtResult.Rows[cnt]["Institute"].ToString() + "',";
//}
//builder.Append("categories: [" + xAxis.ToString() + " ],").AppendLine();
//builder.Append("crosshair: true").AppendLine();
builder.Append(" },").AppendLine();
builder.Append("yAxis: { title: { text: 'No Of Students' }},").AppendLine();
builder.Append("legend: { enabled: false },").AppendLine();
builder.Append("tooltip: {headerFormat: '<span style='font-size:10px'>{point.key}</span><table>',").AppendLine();
builder.Append("pointFormat: '<tr><td style='color:{series.color};padding:0'>{series.name}: </td>' +").AppendLine();
builder.Append("'<td style='padding:0'><b>{point.y:.1f} Students </b></td></tr>',").AppendLine();
builder.Append("footerFormat: '</table>', shared: true,useHTML: true },").AppendLine();
builder.Append("plotOptions: { series: { pointPadding: 0, borderWidth: 0, dataLabels: { enabled: true } }},").AppendLine();
//builder.Append("legend: {layout: 'vertical', align: 'right', verticalAlign: 'top', x: -40, y: 80, floating: true, borderWidth: 1, backgroundColor: ((Highcharts.theme && Highcharts.theme.legendBackgroundColor) || '#FFFFFF'), shadow: true},").AppendLine();
builder.Append("series: [{").AppendLine();
builder.Append("name: 'Institute', colorByPoint: true,").AppendLine();
for (int cnt = 0; cnt < dtInstitute.Rows.Count; cnt++)
{
DataView dv = new DataView(dtInstAdmis);
dv.RowFilter = " Institute = '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "'";
DataTable dt = new DataTable();
string dataInner = "";
if (dv != null)
{
dt = dv.ToTable();
dv.Dispose();
if (dt.Rows.Count > 0)
{
for (int cnt1 = 0; cnt1 < dt.Rows.Count; cnt1++)
{
if (cnt1 == (dt.Rows.Count - 1))
{
dataInner = dataInner + "" + " [ '" + dt.Rows[cnt1]["AdmissionType"].ToString() + "', " + dt.Rows[cnt1]["TotalStudent"].ToString() + "]";
}
else
{
dataInner = dataInner + "" + " [ '" + dt.Rows[cnt1]["AdmissionType"].ToString() + "', " + dt.Rows[cnt1]["TotalStudent"].ToString() + "],";
}
}
}
else
{
dataInner = "";
}
}
if (cnt == (dtInstitute.Rows.Count - 1))
{
xData = xData + "" + " { name: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', y: " + dtInstitute.Rows[cnt]["TotalStudent"].ToString() + ", drilldown: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "'}";
if (dataInner !="")
xData2 = xData2 + "" + " { name: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', id: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', data: [" + dataInner + " ]}";
}
else
{
xData = xData + "" + " { name: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', y: " + dtInstitute.Rows[cnt]["TotalStudent"].ToString() + ", drilldown: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "'},";
if (dataInner!="")
xData2 = xData2 + "" + " { name: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "', id: '" + dtInstitute.Rows[cnt]["Institute"].ToString() + "',data: [" + dataInner + " ]},";
}
}
builder.Append("data: [" + xData + "]").AppendLine();
builder.Append("}] ").AppendLine();
builder.Append(", drilldown: { series: [").AppendLine();
builder.Append("" + xData2 + "").AppendLine();
builder.Append("] } ").AppendLine(); ///series End
builder.Append("}); }); ").AppendLine();
string innerString = builder.ToString().Replace("style='", "style=\"").Replace("'>", "\">");
return innerString;
// System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Submitted", innerString, true);
}
示例14: Bind
private void Bind()
{
int ChType = 1;
B_Dictionary dictionBll = new B_Dictionary();
DataTable chTypeDt = dictionBll.GetDictionary(ChType);
for (int i = 0; i < chTypeDt.Rows.Count; i++)
{
TreeNode chTypeNode = new TreeNode();
chTypeNode.ToolTip = "分类右键操作$" + chTypeDt.Rows[i]["id"].ToString();
chTypeNode.Text = chTypeDt.Rows[i]["DicName"].ToString();
chTypeNode.ImageUrl = "~/system/images/category.gif";
chTypeNode.NavigateUrl = "~/system/info/ChannelList.aspx?ChType=" + chTypeDt.Rows[i]["id"].ToString();
chTypeNode.Target = "ContentIframe";
tvNav.Nodes.Add(chTypeNode);
}
TreeNode chTypeOtherNode = new TreeNode();
chTypeOtherNode.ToolTip = "分类右键操作$0";
chTypeOtherNode.Text = "其他";
chTypeOtherNode.ImageUrl = "~/system/images/category.gif";
chTypeOtherNode.NavigateUrl = "~/system/info/ChannelList.aspx?ChType=0";
chTypeOtherNode.Target = "ContentIframe";
tvNav.Nodes.Add(chTypeOtherNode);
B_Channel channelBll = new B_Channel();
B_Column columnBll = new B_Column();
DataView channelDv = channelBll.GetList(false);
for (int i = 0; i < tvNav.Nodes.Count-1; i++)
{
int chType = int.Parse(chTypeDt.Rows[i]["id"].ToString());
DataTable chDt = channelDv.ToTable();
DataView chTypeDv = new DataView(chDt);
chTypeDv.RowFilter=string.Format("[chtype]={0}",chType);
for (int j = 0; j < chTypeDv.Count; j++)
{
TreeNode channelNode = new TreeNode();
channelNode.ToolTip = "频道右键操作$" + chTypeDv[j]["ChId"].ToString() + "$" + chTypeDv[j]["ChType"].ToString();
channelNode.Text = chTypeDv[j]["ChName"].ToString();
channelNode.ImageUrl = "~/system/images/folder.gif";
channelNode.NavigateUrl = "~/system/info/ColumnList.aspx?ChId=" + chTypeDv[j]["ChId"];
channelNode.Target = "ContentIframe";
tvNav.Nodes[i].ChildNodes.Add(channelNode);
}
for (int j = 0; j < chTypeDv.Count; j++)
{
DataView dv = columnBll.GetColumnListByChannelId((int)chTypeDv[j]["ChId"]);
DataTable dt = dv.ToTable();
dv.Dispose();
BindColumn(0, tvNav.Nodes[i].ChildNodes[j], dt, (int)chTypeDv[j]["ModelType"], (int)chTypeDv[j]["ChId"]);
}
chDt.Dispose();
chTypeDv.Dispose();
}
DataTable chDt2 = channelDv.ToTable();
DataView chTypeDv2 = new DataView(chDt2);
chTypeDv2.RowFilter = "[chtype]=0 or [chtype] is null";
for (int j = 0; j < chTypeDv2.Count; j++)
{
TreeNode channelNode = new TreeNode();
channelNode.ToolTip = "频道右键操作$" + chTypeDv2[j]["ChId"].ToString() + "$" + chTypeDv2[j]["ChType"].ToString();
channelNode.Text = chTypeDv2[j]["ChName"].ToString();
channelNode.ImageUrl = "~/system/images/folder.gif";
channelNode.NavigateUrl = "~/system/info/ColumnList.aspx?ChId=" + chTypeDv2[j]["ChId"];
channelNode.Target = "ContentIframe";
tvNav.Nodes[tvNav.Nodes.Count - 1].ChildNodes.Add(channelNode);
}
for (int j = 0; j < chTypeDv2.Count; j++)
{
DataView dv = columnBll.GetColumnListByChannelId((int)chTypeDv2[j]["ChId"]);
DataTable dt = dv.ToTable();
dv.Dispose();
BindColumn(0, tvNav.Nodes[tvNav.Nodes.Count - 1].ChildNodes[j], dt, (int)chTypeDv2[j]["ModelType"], (int)chTypeDv2[j]["ChId"]);
}
chDt2.Dispose();
chTypeDv2.Dispose();
}
示例15: PopulateDropDowns
private void PopulateDropDowns()
{
//getting all the drop downs and applying filter
foreach (Control ctrl in pageControls)
{
if (ctrl.GetType().Name == "DropDownList")
{
DropDownList ddl = (DropDownList)ctrl;
DataView dv = new DataView(lookUp, "ControlName='" + ddl.ID + "'", "SortOrder ", DataViewRowState.CurrentRows);
if (dv.Count > 0)
{
ddl.Items.Add(new ListItem("", ""));
ddl.AppendDataBoundItems = true;
ddl.DataSource = dv;
ddl.DataTextField = "FieldValue";
ddl.DataValueField = "FieldDescription";
ddl.DataBind();
//checking for duplicate values
Dictionary<string, string> dups = new Dictionary<string, string>();
int dupCount = 1;
foreach (ListItem liDups in ddl.Items)
{
if (dups.ContainsKey(liDups.Value))
{
liDups.Value += "~" + dupCount.ToString();
dupCount++;
}
else
{
dups.Add(liDups.Value, "");
}
}
//selecting the default value
string defaultValue = dv[0]["DefaultValue"] == DBNull.Value ? "" : dv[0]["DefaultValue"].ToString();
ListItem li = ddl.Items.FindByValue(defaultValue);
if (li != null)
{
li.Selected = true;
//break;
}
}
dv.Dispose();
}
}
}