本文整理汇总了C#中System.Data.DataSet.get_Tables方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.get_Tables方法的具体用法?C# DataSet.get_Tables怎么用?C# DataSet.get_Tables使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.get_Tables方法的7个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetParameterOptions
public static DataSet GetParameterOptions(int paramId, int thisParamVal, DataSet optionDS)
{
int maskI = 255;
DataSet dataSet = new DataSet();
DataTable dataTable = new DataTable();
IEnumerator enumerator = optionDS.get_Tables().get_Item(0).get_Columns().GetEnumerator();
try
{
while (enumerator.MoveNext())
{
DataColumn dataColumn = (DataColumn)enumerator.get_Current();
dataTable.get_Columns().Add(new DataColumn(dataColumn.get_ColumnName(), dataColumn.get_DataType()));
}
}
finally
{
IDisposable disposable = enumerator as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
dataTable.get_Columns().Add(new DataColumn("Selected", typeof(bool)));
dataTable.get_Columns().Add(new DataColumn("ValueText", typeof(string)));
dataTable.get_Columns().Add(new DataColumn("Checked", typeof(string)));
enumerator = optionDS.get_Tables().get_Item(0).get_Rows().GetEnumerator();
try
{
while (enumerator.MoveNext())
{
DataRow dataRow = (DataRow)enumerator.get_Current();
int num = Convert.ToInt32(dataRow.get_Item("fldParamGroupID"));
int num2 = Convert.ToInt32(dataRow.get_Item("fldOptionVal"));
int num3 = Convert.ToInt32(dataRow.get_Item("fldTypeID"));
try
{
maskI = Convert.ToInt32(dataRow.get_Item("fldMask").ToString(), 2);
}
catch
{
maskI = 255;
}
switch (num3)
{
case 1:
case 4:
{
DataRow dataRow2 = dataTable.NewRow();
IEnumerator enumerator2 = optionDS.get_Tables().get_Item(0).get_Columns().GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
DataColumn dataColumn2 = (DataColumn)enumerator2.get_Current();
dataRow2.set_Item(dataColumn2.get_ColumnName(), dataRow.get_Item(dataColumn2.get_ColumnName()));
}
}
finally
{
IDisposable disposable = enumerator2 as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
string text = "0x" + num2.ToString("X2");
bool flag;
if (num3 == 1)
{
flag = Common.IsSelected(maskI, num2, thisParamVal);
}
else
{
flag = ((num2 & thisParamVal) == num2);
}
dataRow2.set_Item("Selected", flag);
if (flag)
{
dataRow2.set_Item("Checked", "Checked");
}
dataRow2.set_Item("ValueText", text);
dataTable.get_Rows().Add(dataRow2);
break;
}
case 2:
{
num = 1;
int i = 48;
while (i < 122)
{
if (i <= 57 || (i >= 65 && i <= 90) || i >= 97)
{
DataRow dataRow3 = dataTable.NewRow();
string text = Convert.ToChar(i).ToString();
bool flag = Common.IsSelected(maskI, i, thisParamVal);
dataRow3.set_Item("fldOptionVal", i);
dataRow3.set_Item("fldTypeID", num3);
dataRow3.set_Item("fldTypeDesc", Constants.OptionType.ASCII.ToString());
dataRow3.set_Item("fldFullDesc", text);
dataRow3.set_Item("fldOptionGroup", 1);
//.........这里部分代码省略.........
示例2: GetDataSourceSelector
public static ICollection GetDataSourceSelector(DataSet gds, int valField, int textField)
{
DataTable dataTable = new DataTable(gds.get_Tables().get_Item(0).get_TableName());
dataTable.get_Columns().Add(new DataColumn(Constants.DropDownColumnTypes.Val, typeof(string)));
dataTable.get_Columns().Add(new DataColumn(Constants.DropDownColumnTypes.Text, typeof(string)));
DataRow dataRow = dataTable.NewRow();
dataRow.set_Item(0, 0);
dataRow.set_Item(1, Constants.Unassigned);
dataTable.get_Rows().Add(dataRow);
int count = gds.get_Tables().get_Item(0).get_Rows().get_Count();
if (count > 0)
{
IEnumerator enumerator = gds.get_Tables().get_Item(0).get_Rows().GetEnumerator();
try
{
while (enumerator.MoveNext())
{
DataRow dataRow2 = (DataRow)enumerator.get_Current();
dataRow = dataTable.NewRow();
dataRow.set_Item(0, dataRow2.get_Item(valField));
dataRow.set_Item(1, dataRow2.get_Item(textField));
dataTable.get_Rows().Add(dataRow);
}
}
finally
{
IDisposable disposable = enumerator as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
}
return new DataView(dataTable);
}
示例3: FillT5
private void FillT5(ref DataSet ds, ref string message, int importType)
{
bool flag = false;
int num = 0;
int num2 = 0;
string text = "";
string text2 = "";
string text3 = "";
string text4 = "";
int count = ds.get_Tables().get_Item(0).get_Rows().get_Count();
int count2 = ds.get_Tables().get_Item(0).get_Columns().get_Count();
int i = 0;
while (i < count && !flag)
{
DataRow dataRow = ds.get_Tables().get_Item(0).get_Rows().get_Item(i);
for (int j = 0; j < count2; j++)
{
string text5 = dataRow.get_Item(j).ToString().Trim();
int num3 = text5.ToLower().IndexOf("parameter number", 0);
if (num3 >= 0)
{
flag = true;
num = i + 1;
num2 = j;
break;
}
}
i++;
}
int num4 = 0;
string text6 = "";
if (flag)
{
for (i = num; i < count; i++)
{
DataRow dataRow2 = ds.get_Tables().get_Item(0).get_Rows().get_Item(i);
string text7 = dataRow2.get_Item(num2).ToString().Trim();
string text8 = dataRow2.get_Item(num2 + 1).ToString().Trim();
string text9 = dataRow2.get_Item(num2 + 2).ToString().Trim();
string text10 = dataRow2.get_Item(num2 + 3).ToString().Trim();
string text11 = dataRow2.get_Item(num2 + 4).ToString().Trim();
string text12 = dataRow2.get_Item(num2 + 5).ToString().Trim();
string text13 = dataRow2.get_Item(num2 + 6).ToString().Trim();
string text14 = dataRow2.get_Item(num2 - 1).ToString().Trim();
if (text14 != "")
{
if (importType == 1)
{
text3 = text14.Replace("Block No ", "");
}
else
{
text3 = Convert.ToInt32(text14, 16).ToString();
}
}
if (text7 != "")
{
text = text7.Trim(ParamSpec.TrimChars);
text = text.Trim();
DataRow dataRow3 = this.ss.Parameters.NewRow();
dataRow3.set_Item("fldParameter", text);
dataRow3.set_Item("fldName", text8);
dataRow3.set_Item("fldFrame", text3);
this.ss.Parameters.get_Rows().Add(dataRow3);
num4 = 0;
text2 = "";
text6 = "";
}
if (text9 != "")
{
text2 = text9;
}
if (text11 != "")
{
DataRow dataRow4 = this.ss.Options.NewRow();
dataRow4.set_Item("fldParameter", text);
dataRow4.set_Item("fldDescription", text2);
dataRow4.set_Item("fldSubDesc", text10);
string value = this.GetValue(text13, text12, out text4);
dataRow4.set_Item("fldValue", value);
dataRow4.set_Item("fldError", value == "");
try
{
dataRow4.set_Item("fldMask", text4.Substring(0, 8));
}
catch
{
dataRow4.set_Item("fldMask", text4);
}
if (dataRow4.get_Item("fldMask").ToString() != text6)
{
num4++;
}
text6 = dataRow4.get_Item("fldMask").ToString();
dataRow4.set_Item("fldSplit", num4.ToString());
dataRow4.set_Item("fldFormat", text12 + text13);
dataRow4.set_Item("fldFormat", dataRow4.get_Item("fldFormat").ToString().Replace("0x0x", "0x"));
dataRow4.set_Item("fldType", text11);
dataRow4.set_Item("fldError", text11 == "");
this.ss.Options.get_Rows().Add(dataRow4);
//.........这里部分代码省略.........
示例4: FillEUCD
private void FillEUCD(ref DataSet ds)
{
bool flag = false;
int num = 0;
string text = "";
string text2 = "";
int num2 = 0;
int count = ds.get_Tables().get_Item(0).get_Rows().get_Count();
int count2 = ds.get_Tables().get_Item(0).get_Columns().get_Count();
int i = 0;
while (i < count && !flag)
{
DataRow dataRow = ds.get_Tables().get_Item(0).get_Rows().get_Item(i);
for (int j = 0; j < count2; j++)
{
string text3 = dataRow.get_Item(j).ToString().Trim();
if (text3.ToLower() == "nbr")
{
flag = true;
num = i + 1;
num2 = j;
break;
}
}
i++;
}
if (flag)
{
for (i = num; i < count; i++)
{
DataRow dataRow2 = ds.get_Tables().get_Item(0).get_Rows().get_Item(i);
string text4 = dataRow2.get_Item(num2).ToString().Trim();
string text5 = dataRow2.get_Item(num2 + 1).ToString().Trim();
string text6 = dataRow2.get_Item(num2 + 2).ToString().Trim();
string text7 = dataRow2.get_Item(num2 + 11).ToString().Trim();
string paramValue = dataRow2.get_Item(num2 + 8).ToString().Trim();
try
{
text2 = text7.Substring(0, text7.ToLower().IndexOf("byte"));
text2 = text2.Replace(":", "");
text2 = text2.Replace("Block", "");
text2 = text2.Trim();
}
catch
{
text2 = "";
}
if (text4 != "")
{
text = text4.Trim(ParamSpec.TrimChars);
text = text.Trim();
DataRow dataRow3 = this.ss.Parameters.NewRow();
dataRow3.set_Item("fldParameter", text);
dataRow3.set_Item("fldName", text5);
dataRow3.set_Item("fldFrame", text2.Trim());
this.ss.Parameters.get_Rows().Add(dataRow3);
}
if (text6 != "")
{
DataRow dataRow4 = this.ss.Options.NewRow();
dataRow4.set_Item("fldParameter", text);
dataRow4.set_Item("fldDescription", text6);
dataRow4.set_Item("fldSplit", "1");
dataRow4.set_Item("fldMask", "11111111");
string text8 = Common.ConvertToInt(paramValue, 2).ToString();
dataRow4.set_Item("fldValue", text8);
dataRow4.set_Item("fldError", text8 == "");
dataRow4.set_Item("fldType", Constants.Config.DefaultParamType);
this.ss.Options.get_Rows().Add(dataRow4);
}
}
return;
}
}
示例5: ReadXmlSerializable
protected override void ReadXmlSerializable(XmlReader reader)
{
this.Reset();
DataSet dataSet = new DataSet();
dataSet.ReadXml(reader);
if (dataSet.get_Tables().get_Item("Frame") != null)
{
base.get_Tables().Add(new MulticanDataset.FrameDataTable(dataSet.get_Tables().get_Item("Frame")));
}
base.set_DataSetName(dataSet.get_DataSetName());
base.set_Prefix(dataSet.get_Prefix());
base.set_Namespace(dataSet.get_Namespace());
base.set_Locale(dataSet.get_Locale());
base.set_CaseSensitive(dataSet.get_CaseSensitive());
base.set_EnforceConstraints(dataSet.get_EnforceConstraints());
base.Merge(dataSet, false, 1);
this.InitVars();
}
示例6: MulticanDataset
protected MulticanDataset(SerializationInfo info, StreamingContext context)
{
string text = (string)info.GetValue("XmlSchema", typeof(string));
if (text != null)
{
DataSet dataSet = new DataSet();
dataSet.ReadXmlSchema(new XmlTextReader(new StringReader(text)));
if (dataSet.get_Tables().get_Item("Frame") != null)
{
base.get_Tables().Add(new MulticanDataset.FrameDataTable(dataSet.get_Tables().get_Item("Frame")));
}
base.set_DataSetName(dataSet.get_DataSetName());
base.set_Prefix(dataSet.get_Prefix());
base.set_Namespace(dataSet.get_Namespace());
base.set_Locale(dataSet.get_Locale());
base.set_CaseSensitive(dataSet.get_CaseSensitive());
base.set_EnforceConstraints(dataSet.get_EnforceConstraints());
base.Merge(dataSet, false, 1);
this.InitVars();
}
else
{
this.InitClass();
}
base.GetSerializationData(info, context);
CollectionChangeEventHandler collectionChangeEventHandler = new CollectionChangeEventHandler(this.SchemaChanged);
base.get_Tables().add_CollectionChanged(collectionChangeEventHandler);
base.get_Relations().add_CollectionChanged(collectionChangeEventHandler);
}
示例7: Import
//.........这里部分代码省略.........
break;
}
}
num3++;
}
}
finally
{
IDisposable disposable = enumerator as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
if (vehicleModule.BuildTypes.get_Count() != arrayList.get_Count())
{
throw new CarConfigException("Incorrect no of blocks in import file compared to those in the database.");
}
int i = 1;
for (int j = 0; j < vehicleModule.BuildTypes.get_Count(); j++)
{
int num10 = 1;
BuildType buildType = (BuildType)vehicleModule.BuildTypes.get_Item(j);
VDFBlock vDFBlock3 = (VDFBlock)arrayList.get_Item(j);
int size = vDFBlock3.Size;
if (buildType.FrameCount)
{
for (i = num3; i < size + num3; i++)
{
ConfigByte configByte3 = (ConfigByte)this.Params.get_Item(i - 1);
if (num10 == 1)
{
dataSet = DataAccess.GetVehicleFrameParameterIDs(configByte3.ParamValue.ToString(), buildType.ID, this.VehicleInstId);
if (dataSet.get_Tables().get_Item(0).get_Rows().get_Count() == 0)
{
text = text + "Frame 0x" + configByte3.ParamValueHex.ToString() + " does not exist in the database. All bytes will not be imported.<br>";
error = true;
}
else
{
num4 = configByte3.ParamValue;
}
}
else if (dataSet.get_Tables().get_Item(0).get_Rows().get_Count() > 0)
{
try
{
DataRow dataRow = dataSet.get_Tables().get_Item(0).get_Rows().get_Item(num10 - 2);
DataAccess.UpdateParamInst(this.VehicleInstId.ToString(), dataRow.get_Item(0).ToString(), configByte3.ParamValue.ToString(), 1, this.UserName, reason);
}
catch (SqlException)
{
throw;
}
catch
{
string text2 = text;
text = string.Concat(new string[]
{
text2,
"Frame 0x",
num4.ToString("x2"),
" byte ",
(num10 - 1).ToString(),
" missing from the database.<br>"
});