本文整理汇总了C#中System.Data.Common.DbDataReader.Close方法的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader.Close方法的具体用法?C# DbDataReader.Close怎么用?C# DbDataReader.Close使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbDataReader
的用法示例。
在下文中一共展示了DbDataReader.Close方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ConvertDataReaderToDataTable
public static DataTable ConvertDataReaderToDataTable(DbDataReader reader)
{
try
{
DataTable table = new DataTable();
int fieldCount = reader.FieldCount;
for (int fieldIndex = 0; fieldIndex < fieldCount; ++fieldIndex)
{
table.Columns.Add(reader.GetName(fieldIndex), reader.GetFieldType(fieldIndex));
}
table.BeginLoadData();
object[] rowValues = new object[fieldCount];
while (reader.Read())
{
reader.GetValues(rowValues);
table.LoadDataRow(rowValues, true);
}
reader.Close();
table.EndLoadData();
return table;
}
catch (Exception ex)
{
throw new Exception("DataReader转换为DataTable时出错!", ex);
}
}
示例2: GetMFPAJ100FromIDataReader
private MFPAJ100Entity GetMFPAJ100FromIDataReader(DbDataReader dr)
{
MFPAJ100Entity dt = new MFPAJ100Entity();
if (dr.FieldCount > 0)
{
if (dr["MessageID"].ToString() != "" || dr["MessageID"] != null) dt.MessageID = Int32.Parse(dr["MessageID"].ToString());
dt.MessageType = dr["MessageType"].ToString();
dt.MessageDetail = dr["MessageDetail"].ToString();
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
if (dr["CreatorSID"].ToString() != "" || dr["CreatorSID"] != null) dt.CreatorSID = Int32.Parse(dr["CreatorSID"].ToString());
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
dr.Close();
return dt;
}
dr.Close();
return null;
}
示例3: GetProviderSpecificValues_Reader_Closed
public void GetProviderSpecificValues_Reader_Closed ()
{
cmd.CommandText = "SELECT * FROM employee";
rdr = cmd.ExecuteReader ();
rdr.Close ();
try {
rdr.GetProviderSpecificValues (null);
Assert.Fail ("#1");
} catch (InvalidOperationException ex) {
// Invalid attempt to call MetaData
// when reader is closed
Assert.AreEqual (typeof (InvalidOperationException), ex.GetType (), "#2");
Assert.IsNull (ex.InnerException, "#3");
Assert.IsNotNull (ex.Message, "#4");
}
}
示例4: ReaderToGObject
/// <summary>
/// Readers to G object.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
public static GObject ReaderToGObject(DbDataReader reader)
{
GObject result = null;
if (!reader.HasRows)
{
}
try
{
reader.Close();
reader = null;
}
catch (Exception)
{
reader = null;
}
return result;
}
示例5: GetColumnFromDataReader
public static List<object> GetColumnFromDataReader(DbDataReader dr, string columnName)
{
List<object> column = new List<object>();
try
{
while (dr.Read())
{
column.Add(dr[columnName]);
}
}
finally
{
if (dr != null && !dr.IsClosed)
{
dr.Close(); // Data Reader is done (read only, forward only)
dr.Dispose();
}
}
return column;
}
示例6: GetCategorys
public static List<Category> GetCategorys(DbDataReader dataReader)
{
List<Category> categorys = new List<Category>();
while (dataReader.Read())
{
Category category = new Category();
category.CategoryId = Convert.ToInt32(dataReader[CategoryField.CategoryId]);
category.CategoryGuid = (Guid)dataReader[CategoryField.CategoryGuid];
category.CategoryName = Convert.ToString(dataReader[CategoryField.CategoryName]);
category.ParentGuid = (Guid)dataReader[CategoryField.ParentGuid];
category.ParentCategoryName = dataReader[CategoryField.ParentCategoryName].ToString();
category.Rank = Convert.ToInt32(dataReader[CategoryField.Rank]);
category.ArticleType = (byte)dataReader[CategoryField.ArticleType];
if (dataReader[CategoryField.ThumbnailWidth] != DBNull.Value)
category.ThumbnailWidth = (int)dataReader[CategoryField.ThumbnailWidth];
if (dataReader[CategoryField.ThumbnailHeight] != DBNull.Value)
category.ThumbnailHeight = (int)dataReader[CategoryField.ThumbnailHeight];
category.RecordCount = (int)dataReader[CategoryField.RecordCount];
categorys.Add(category);
}
dataReader.Close();
return categorys;
}
示例7: GetOfferDetailObject
internal static List<OfferDetails> GetOfferDetailObject(DbDataReader reader)
{
OfferDetails hooOffer = null;
List<OfferDetails> allOffers = new List<OfferDetails>();
while (reader.Read())
{
hooOffer = new OfferDetails();
hooOffer.OfferId = reader.IsDBNull(reader.GetOrdinal("OfferId")) ? 0 : Convert.ToInt32(reader["OfferId"], CultureInfo.InvariantCulture);
hooOffer.OfferTitle = reader.IsDBNull(reader.GetOrdinal("OfferTitle")) ? string.Empty : Convert.ToString(reader["OfferTitle"], CultureInfo.InvariantCulture);
hooOffer.OfferDescription = reader.IsDBNull(reader.GetOrdinal("OfferDescription")) ? string.Empty : Convert.ToString(reader["OfferDescription"], CultureInfo.InvariantCulture);
hooOffer.ImageUrl = reader.IsDBNull(reader.GetOrdinal("OfferImageUrl")) ? string.Empty : Convert.ToString(reader["OfferImageUrl"], CultureInfo.InvariantCulture);
hooOffer.StartDate = reader.IsDBNull(reader.GetOrdinal("StartDate")) ? DateTime.Now : Convert.ToDateTime(reader["StartDate"], CultureInfo.InvariantCulture);
hooOffer.ExpireDate = reader.IsDBNull(reader.GetOrdinal("ExpireDate")) ? DateTime.Now : Convert.ToDateTime(reader["ExpireDate"], CultureInfo.InvariantCulture);
hooOffer.comments = reader.IsDBNull(reader.GetOrdinal("Comments")) ? string.Empty : Convert.ToString(reader["Comments"], CultureInfo.InvariantCulture);
hooOffer.Latitude = reader.IsDBNull(reader.GetOrdinal("Latitude")) ? 0 : Convert.ToDouble(reader["Latitude"], CultureInfo.InvariantCulture);
hooOffer.Longitude = reader.IsDBNull(reader.GetOrdinal("Longitude")) ? 0 : Convert.ToDouble(reader["Longitude"], CultureInfo.InvariantCulture);
hooOffer.City = reader.IsDBNull(reader.GetOrdinal("City")) ? string.Empty : Convert.ToString(reader["City"], CultureInfo.InvariantCulture);
hooOffer.OfferCategory = reader.IsDBNull(reader.GetOrdinal("OfferCategory")) ? string.Empty : Convert.ToString(reader["OfferCategory"], CultureInfo.InvariantCulture);
hooOffer.PromoCode = reader.IsDBNull(reader.GetOrdinal("PromoCode")) ? string.Empty : Convert.ToString(reader["PromoCode"], CultureInfo.InvariantCulture);
hooOffer.Ratings = reader.IsDBNull(reader.GetOrdinal("SumOfRating")) ? 0 : Convert.ToInt32(reader["SumOfRating"], CultureInfo.InvariantCulture);
hooOffer.Vendor = new Supplier();
hooOffer.Vendor.SupplierId = reader.IsDBNull(reader.GetOrdinal("SupplierId")) ? 0 : Convert.ToInt32(reader["SupplierId"], CultureInfo.InvariantCulture);
hooOffer.Vendor.SupplierName = reader.IsDBNull(reader.GetOrdinal("SupName")) ? string.Empty : Convert.ToString(reader["SupName"], CultureInfo.InvariantCulture);
hooOffer.Vendor.ContactNumber = reader.IsDBNull(reader.GetOrdinal("SupContactNumber")) ? string.Empty : Convert.ToString(reader["SupContactNumber"], CultureInfo.InvariantCulture);
hooOffer.Vendor.Email = reader.IsDBNull(reader.GetOrdinal("SupEmailId")) ? string.Empty : Convert.ToString(reader["SupEmailId"], CultureInfo.InvariantCulture);
hooOffer.Vendor.ImageUrl = ConfigurationManager.AppSettings["ImageFolder"].ToString();
hooOffer.Vendor.ImageUrl += reader.IsDBNull(reader.GetOrdinal("SupImageURL")) ? string.Empty : Convert.ToString(reader["SupImageURL"], CultureInfo.InvariantCulture);
hooOffer.Vendor.SupplierAddress = reader.IsDBNull(reader.GetOrdinal("SupAddress")) ? string.Empty : Convert.ToString(reader["SupAddress"], CultureInfo.InvariantCulture);
allOffers.Add(hooOffer);
}
reader.Close();
return allOffers;
}
示例8: GetPSACNFromIDataReader
private PSACNEntity GetPSACNFromIDataReader(DbDataReader dr)
{
PSACNEntity dt = new PSACNEntity();
if (dr.FieldCount > 0)
{
dt.PSACNCO = dr["PSACNCO"].ToString();
dt.PSACNNCN = dr["PSACNNCN"].ToString();
dt.PSACNNEN = dr["PSACNNEN"].ToString();
dt.PSACNNTW = dr["PSACNNTW"].ToString();
dt.PSACNPRE = dr["PSACNPRE"].ToString();
dt.PSACNDAT = dr["PSACNDAT"].ToString();
if (dr["PSACNLEN"].ToString() != "" || dr["PSACNLEN"] != null) dt.PSACNLEN = Int32.Parse(dr["PSACNLEN"].ToString());
if (dr["PSACNCUR"].ToString() != "" || dr["PSACNCUR"] != null) dt.PSACNCUR = Int32.Parse(dr["PSACNCUR"].ToString());
dt.PSACNPDA = dr["PSACNPDA"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
示例9: GetWorkflow_RequestBaseFromIDataReader
private Workflow_RequestBaseEntity GetWorkflow_RequestBaseFromIDataReader(DbDataReader dr)
{
Workflow_RequestBaseEntity dt = new Workflow_RequestBaseEntity();
if (dr.FieldCount > 0)
{
if (dr["RequestID"].ToString() != "" || dr["RequestID"] != null) dt.RequestID = Int32.Parse(dr["RequestID"].ToString());
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
if (dr["LastNodeID"].ToString() != "" || dr["LastNodeID"] != null) dt.LastNodeID = Int32.Parse(dr["LastNodeID"].ToString());
dt.LastRuleID = dr["LastRuleID"].ToString();
dt.LastRuleType = dr["LastRuleType"].ToString();
if (dr["LastNodeType"].ToString() != "" || dr["LastNodeType"] != null) dt.LastNodeType = Int32.Parse(dr["LastNodeType"].ToString());
if (dr["LastDeptLevel"].ToString() != "" || dr["LastDeptLevel"] != null) dt.LastDeptLevel = Int32.Parse(dr["LastDeptLevel"].ToString());
dt.LastOperatorID = dr["LastOperatorID"].ToString();
if (dr["CurrentNodeID"].ToString() != "" || dr["CurrentNodeID"] != null) dt.CurrentNodeID = Int32.Parse(dr["CurrentNodeID"].ToString());
dt.CurrentRuleID = dr["CurrentRuleID"].ToString();
dt.CurrentRuleType = dr["CurrentRuleType"].ToString();
if (dr["CurrentNodeType"].ToString() != "" || dr["CurrentNodeType"] != null) dt.CurrentNodeType = Int32.Parse(dr["CurrentNodeType"].ToString());
if (dr["CurrentDeptLevel"].ToString() != "" || dr["CurrentDeptLevel"] != null) dt.CurrentDeptLevel = Int32.Parse(dr["CurrentDeptLevel"].ToString());
dt.CurrentOperatorID = dr["CurrentOperatorID"].ToString();
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["Creator"].ToString() != "" || dr["Creator"] != null) dt.Creator = Int32.Parse(dr["Creator"].ToString());
dt.RequestStatus = dr["RequestStatus"].ToString();
dt.RequestName = dr["RequestName"].ToString();
if (dr["IsCancel"].ToString() != "" || dr["IsCancel"] != null) dt.IsCancel = Int32.Parse(dr["IsCancel"].ToString());
dt.AllParticipator = dr["AllParticipator"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
示例10: GetWorkflow_ReportMainFromIDataReader
private Workflow_ReportMainEntity GetWorkflow_ReportMainFromIDataReader(DbDataReader dr)
{
Workflow_ReportMainEntity dt = new Workflow_ReportMainEntity();
if (dr.FieldCount > 0)
{
if (dr["ReportID"].ToString() != "" || dr["ReportID"] != null) dt.ReportID = Int32.Parse(dr["ReportID"].ToString());
if (dr["ReportTypeID"].ToString() != "" || dr["ReportTypeID"] != null) dt.ReportTypeID = Int32.Parse(dr["ReportTypeID"].ToString());
dt.ReportName = dr["ReportName"].ToString();
if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
dt.WorkflowID = dr["WorkflowID"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
示例11: GetWorkflow_NodeTriggerConditionFromIDataReader
private Workflow_NodeTriggerConditionEntity GetWorkflow_NodeTriggerConditionFromIDataReader(DbDataReader dr)
{
Workflow_NodeTriggerConditionEntity dt = new Workflow_NodeTriggerConditionEntity();
if (dr.FieldCount > 0)
{
if (dr["ConditionID"].ToString() != "" || dr["ConditionID"] != null) dt.ConditionID = Int32.Parse(dr["ConditionID"].ToString());
dt.BatchSeq = Convert.ToByte(dr["BatchSeq"]);
dt.BranchBatchSeq = Convert.ToByte(dr["BranchBatchSeq"]);
if (dr["TriggerID"].ToString() != "" || dr["TriggerID"] != null) dt.TriggerID = Int32.Parse(dr["TriggerID"].ToString());
if (dr["FieldID"].ToString() != "" || dr["FieldID"] != null) dt.FieldID = Int32.Parse(dr["FieldID"].ToString());
dt.SymbolCode = dr["SymbolCode"].ToString();
dt.CompareToValue = dr["CompareToValue"].ToString();
dt.AndOr = dr["AndOr"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
示例12: GetWorkflow_BrowseTypeFromIDataReader
private Workflow_BrowseTypeEntity GetWorkflow_BrowseTypeFromIDataReader(DbDataReader dr)
{
Workflow_BrowseTypeEntity dt = new Workflow_BrowseTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["BrowseTypeID"].ToString() != "" || dr["BrowseTypeID"] != null) dt.BrowseTypeID = Int32.Parse(dr["BrowseTypeID"].ToString());
dt.BrowseTypeName = dr["BrowseTypeName"].ToString();
dt.BrowseTypeDesc = dr["BrowseTypeDesc"].ToString();
dt.BrowsePage = dr["BrowsePage"].ToString();
dt.Useflag = dr["Useflag"].ToString();
dt.BrowseValueSql = dr["BrowseValueSql"].ToString();
dt.BrowseSqlParam = dr["BrowseSqlParam"].ToString();
dr.Close();
return dt;
}
dr.Close();
return null;
}
示例13: GetWorkflow_BasicValidTypeFromIDataReader
private Workflow_BasicValidTypeEntity GetWorkflow_BasicValidTypeFromIDataReader(DbDataReader dr)
{
Workflow_BasicValidTypeEntity dt = new Workflow_BasicValidTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["ValidTypeID"].ToString() != "" || dr["ValidTypeID"] != null) dt.ValidTypeID = Int32.Parse(dr["ValidTypeID"].ToString());
dt.ValidTypeDesc = dr["ValidTypeDesc"].ToString();
dt.ValidErrorMsg = dr["ValidErrorMsg"].ToString();
dt.ValidRule = (dr["ValidRule"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
示例14: GetWorkflow_BaseFromIDataReader
private Workflow_BaseEntity GetWorkflow_BaseFromIDataReader(DbDataReader dr)
{
Workflow_BaseEntity dt = new Workflow_BaseEntity();
if (dr.FieldCount > 0)
{
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
dt.WorkflowName = dr["WorkflowName"].ToString();
dt.WorkflowDesc = dr["WorkflowDesc"].ToString();
if (dr["FlowTypeID"].ToString() != "" || dr["FlowTypeID"] != null) dt.FlowTypeID = Int32.Parse(dr["FlowTypeID"].ToString());
if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
if (dr["IsValid"].ToString() != "" || dr["IsValid"] != null) dt.IsValid = Int32.Parse(dr["IsValid"].ToString());
if (dr["IsMailNotice"].ToString() != "" || dr["IsMailNotice"] != null) dt.IsMailNotice = Int32.Parse(dr["IsMailNotice"].ToString());
if (dr["IsMsgNotice"].ToString() != "" || dr["IsMsgNotice"] != null) dt.IsMsgNotice = Int32.Parse(dr["IsMsgNotice"].ToString());
if (dr["IsTransfer"].ToString() != "" || dr["IsTransfer"] != null) dt.IsTransfer = Int32.Parse(dr["IsTransfer"].ToString());
if (dr["AttachDocPath"].ToString() != "" || dr["AttachDocPath"] != null) dt.AttachDocPath = Int32.Parse(dr["AttachDocPath"].ToString());
if (dr["HelpDocPath"].ToString() != "" || dr["HelpDocPath"] != null) dt.HelpDocPath = Int32.Parse(dr["HelpDocPath"].ToString());
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
示例15: GetWorkflow_AgentSettingFromIDataReader
private Workflow_AgentSettingEntity GetWorkflow_AgentSettingFromIDataReader(DbDataReader dr)
{
Workflow_AgentSettingEntity dt = new Workflow_AgentSettingEntity();
if (dr.FieldCount > 0)
{
if (dr["AgentID"].ToString() != "" || dr["AgentID"] != null) dt.AgentID = Int32.Parse(dr["AgentID"].ToString());
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
if (dr["BeAgentPersonID"].ToString() != "" || dr["BeAgentPersonID"] != null) dt.BeAgentPersonID = Int32.Parse(dr["BeAgentPersonID"].ToString());
if (dr["AgentPersonID"].ToString() != "" || dr["AgentPersonID"] != null) dt.AgentPersonID = Int32.Parse(dr["AgentPersonID"].ToString());
if (dr["AgentStartDate"].ToString() != "" || dr["AgentStartDate"].ToString() != null) dt.AgentStartDate = Convert.ToDateTime(dr["AgentStartDate"].ToString());
if (dr["AgentEndDate"].ToString() != "" || dr["AgentEndDate"].ToString() != null) dt.AgentEndDate = Convert.ToDateTime(dr["AgentEndDate"].ToString());
if (dr["CreateDate"].ToString() != "" || dr["CreateDate"].ToString() != null) dt.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString());
if (dr["Creator"].ToString() != "" || dr["Creator"] != null) dt.Creator = Int32.Parse(dr["Creator"].ToString());
dt.IsCancel = dr["IsCancel"].ToString();
dt.AllowCycle = dr["AllowCycle"].ToString();
dt.AllowCreate = dr["AllowCreate"].ToString();
if (dr["CancelOperator"].ToString() != "" || dr["CancelOperator"] != null) dt.CancelOperator = Int32.Parse(dr["CancelOperator"].ToString());
if (dr["CancelDate"].ToString() != "" || dr["CancelDate"].ToString() != null) dt.CancelDate = Convert.ToDateTime(dr["CancelDate"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}