本文整理汇总了C#中OracleDataReader.GetSchemaTable方法的典型用法代码示例。如果您正苦于以下问题:C# OracleDataReader.GetSchemaTable方法的具体用法?C# OracleDataReader.GetSchemaTable怎么用?C# OracleDataReader.GetSchemaTable使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类OracleDataReader
的用法示例。
在下文中一共展示了OracleDataReader.GetSchemaTable方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SqlResult
public SqlResult(OracleDataReader reader)
{
this.reader = reader;
DataTable schema = reader.GetSchemaTable();
columns = new DataColumn[reader.FieldCount];
int i = 0;
foreach (DataRow row in schema.Rows)
{
DataColumn col = new DataColumn(row[0].ToString(), (System.Type)row[11]);
columns[i++] = col;
}
}
示例2: addPhones
internal List<PhoneNum> addPhones(OracleDataReader rdr)
{
List<PhoneNum> result = null;
if (rdr.IsDBNull(rdr.GetOrdinal("PhoneNumber")))
{
return result;
}
string s = rdr["PhoneNumber"].ToString().Trim();
if (s == "")
{
return result;
}
result = new List<PhoneNum>(2);
PhoneNum phoneNum = new PhoneNum();
phoneNum.Number = s;
if (!rdr.IsDBNull(rdr.GetOrdinal("PhoneType")))
{
s = rdr["PhoneType"].ToString().Trim();
if (s != "")
{
phoneNum.Description = s;
}
}
result.Add(phoneNum);
if (rdr.GetSchemaTable().Columns.Contains("PhoneNumber2") && !rdr.IsDBNull(rdr.GetOrdinal("PhoneNumber2")))
{
s = rdr["PhoneNumber2"].ToString().Trim();
if (s == "")
{
return result;
}
phoneNum = new PhoneNum();
phoneNum.Number = s;
if (!rdr.IsDBNull(rdr.GetOrdinal("PhoneType2")))
{
s = rdr["PhoneType2"].ToString().Trim();
if (s != "")
{
phoneNum.Description = s;
}
}
result.Add(phoneNum);
}
return result;
}
示例3: addAddresses
internal List<Address> addAddresses(OracleDataReader rdr)
{
Address addr = new Address();
bool fHasData = false;
string s = "";
if (!rdr.IsDBNull(rdr.GetOrdinal("Street1")))
{
s = rdr["Street1"].ToString().Trim();
if (s != "")
{
addr.Street1 = s;
fHasData = true;
}
}
if (!rdr.IsDBNull(rdr.GetOrdinal("Street2")))
{
s = rdr["Street2"].ToString().Trim();
if (s != "")
{
addr.Street2 = s;
fHasData = true;
}
}
if (rdr.GetSchemaTable().Columns.Contains("Street3") && !rdr.IsDBNull(rdr.GetOrdinal("Street3")))
{
s = rdr["Street3"].ToString().Trim();
if (s != "")
{
addr.Street3 = s;
fHasData = true;
}
}
if (!rdr.IsDBNull(rdr.GetOrdinal("City")))
{
s = rdr["City"].ToString().Trim();
if (s != "")
{
addr.City = s;
fHasData = true;
}
}
if (!rdr.IsDBNull(rdr.GetOrdinal("State")))
{
s = rdr["State"].ToString().Trim();
if (s != "")
{
addr.State = s;
fHasData = true;
}
}
if (!rdr.IsDBNull(rdr.GetOrdinal("Zipcode")))
{
s = rdr["Zipcode"].ToString().Trim();
if (s != "")
{
addr.Zipcode = s;
fHasData = true;
}
}
if (!fHasData)
{
return null;
}
List<Address> result = new List<Address>(1);
result.Add(addr);
return result;
}