本文整理汇总了C#中System.Data.SqlClient.SqlDataReader.GetSqlDateTime方法的典型用法代码示例。如果您正苦于以下问题：C# SqlDataReader.GetSqlDateTime方法的具体用法？C# SqlDataReader.GetSqlDateTime怎么用？C# SqlDataReader.GetSqlDateTime使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlDataReader的用法示例。
在下文中一共展示了SqlDataReader.GetSqlDateTime方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DownloadBatchRow
public DownloadBatchRow(SqlDataReader reader)
{
OriginalKey = reader.GetInt32(reader.GetOrdinal("OriginalKey"));
PackageId = reader.GetString(reader.GetOrdinal("PackageId"));
PackageVersion = reader.GetString(reader.GetOrdinal("PackageVersion"));
PackageListed = reader.GetBoolean(reader.GetOrdinal("PackageListed"));
PackageTitle = GetNullableField(reader, reader.GetOrdinal("PackageTitle"));
PackageDescription = GetNullableField(reader, reader.GetOrdinal("PackageDescription"));
PackageIconUrl = GetNullableField(reader, reader.GetOrdinal("PackageIconUrl"));
DownloadUserAgent = reader.GetString(reader.GetOrdinal("DownloadUserAgent"));
DownloadOperation = reader.GetString(reader.GetOrdinal("DownloadOperation"));
DownloadTimestamp = reader.GetSqlDateTime(reader.GetOrdinal("DownloadTimestamp"));
DownloadProjectTypes = NormalizeProjectTypes(GetNullableField(reader, reader.GetOrdinal("DownloadProjectTypes")));
DownloadDependentPackageId = GetNullableField(reader, reader.GetOrdinal("DownloadDependentPackageId"));
}示例2: GetDateTimeTest
public void GetDateTimeTest ()
{
cmd.CommandText = "Select type_datetime,10,convert(datetime,null)";
cmd.CommandText += "from datetime_family where id=1";
reader = cmd.ExecuteReader ();
reader.Read ();
// Test for standard exceptions
GetMethodTests("DateTime");
// Test if data is returned correctly
Assert.AreEqual (datetimeRow["type_datetime"], reader.GetDateTime(0),
"#2 DataValidation Failed");
// Test for standard exceptions
GetMethodTests("SqlDateTime");
// Test if data is returned correctly
Assert.AreEqual (datetimeRow["type_datetime"], reader.GetSqlDateTime(0).Value,
"#2 DataValidation Failed");
reader.Close ();
}示例3: ConvertFromRow
private static MembershipEntry ConvertFromRow(SqlDataReader results, out string eTag, out int tableVersion, out string versionETag)
{
var entry = new MembershipEntry();
int port = results.GetInt32(PortIdx);
int gen = results.GetInt32(GenerationIdx);
entry.SiloAddress = SiloAddress.New(new IPEndPoint(IPAddress.Parse(results.GetString(AddressIdx)), port), gen);
entry.HostName = results.GetString(HostNameIdx);
entry.Status = (SiloStatus)results.GetInt32(StatusIdx);
if (!results.GetSqlInt32(ProxyPortIdx).IsNull)
entry.ProxyPort = results.GetInt32(ProxyPortIdx);
if (!results.GetSqlBoolean(PrimaryIdx).IsNull)
entry.IsPrimary = results.GetBoolean(PrimaryIdx);
entry.RoleName = results.GetString(RoleNameIdx);
entry.InstanceName = results.GetString(InstanceNameIdx);
if (!results.GetSqlInt32(UpdateZoneIdx).IsNull)
entry.UpdateZone = results.GetInt32(UpdateZoneIdx);
if (!results.GetSqlInt32(FaultZoneIdx).IsNull)
entry.FaultZone = results.GetInt32(FaultZoneIdx);
if (!results.GetSqlDateTime(StartTimeIdx).IsNull)
entry.StartTime = results.GetDateTime(StartTimeIdx);
if (!results.GetSqlDateTime(IAmAliveTimeIdx).IsNull)
entry.IAmAliveTime = results.GetDateTime(IAmAliveTimeIdx);
eTag = results.GetString(ETagIdx);
tableVersion = (int)results.GetInt64(VersionIdx);
versionETag = results.GetString(VersionETagIdx);
var suspectingSilosString = results.GetSqlString(SuspectingSilosIdx);
var suspectingTimesString = results.GetSqlString(SuspectingTimesIdx);
List<SiloAddress> suspectingSilos = new List<SiloAddress>();
List<DateTime> suspectingTimes = new List<DateTime>();
if (!suspectingSilosString.IsNull && !string.IsNullOrEmpty(suspectingSilosString.Value))
{
string[] silos = suspectingSilosString.Value.Split('|');
foreach (string silo in silos)
{
suspectingSilos.Add(SiloAddress.FromParsableString(silo));
}
}
if (!suspectingTimesString.IsNull && !string.IsNullOrEmpty(suspectingTimesString.Value))
{
string[] times = suspectingTimesString.Value.Split('|');
foreach (string time in times)
{
suspectingTimes.Add(TraceLogger.ParseDate(time));
}
}
if (suspectingSilos.Count != suspectingTimes.Count)
throw new OrleansException(String.Format("SuspectingSilos.Length of {0} as read from SQL table is not eqaul to SuspectingTimes.Length of {1}", suspectingSilos.Count, suspectingTimes.Count));
for (int i = 0; i < suspectingSilos.Count; i++)
{
entry.AddSuspector(suspectingSilos[i], suspectingTimes[i]);
}
return entry;
}示例4: DownloadBatchRow
public DownloadBatchRow(SqlDataReader reader)
{
OriginalKey = reader.GetInt32(reader.GetOrdinal("OriginalKey"));
PackageId = reader.GetString(reader.GetOrdinal("PackageId"));
PackageVersion = reader.GetString(reader.GetOrdinal("PackageVersion"));
DownloadUserAgent = reader.GetString(reader.GetOrdinal("DownloadUserAgent"));
DownloadOperation = reader.GetString(reader.GetOrdinal("DownloadOperation"));
DownloadTimestamp = reader.GetSqlDateTime(reader.GetOrdinal("DownloadTimestamp"));
}