DbDataReader.GetInt32(Int32) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
When overridden in a derived class, gets the value of the specified column as a 32-bit signed integer.
public:
abstract int GetInt32(int ordinal);public abstract int GetInt32 (int ordinal);abstract member GetInt32 : int -> intPublic MustOverride Function GetInt32 (ordinal As Integer) As IntegerParameters
- ordinal
- Int32
The zero-based column ordinal.
Returns
The value of the specified column.
Implements
Exceptions
The column index is out of range.
The specified cast is not valid.
Remarks
private static void GetCredits(String connectionString)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
String queryString = "Select [CourseID],[Title],[Credits] from [MySchool].[dbo].[Course]";
using (DbCommand command = new SqlCommand(queryString, conn))
{
conn.Open();
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
// Credits column is the integer column, and you can use the GetInt32 method
// to return a 32-bit signed integer.
Console.WriteLine("Course:{0,-15} Credits:{1}",reader[1],reader.GetInt32(2));
}
}
}
}
}
Applies to
See also
Vertu í samstarfi við okkur á GitHub
Heimildina fyrir þetta efni er að finna á GitHub, þar sem þú getur líka búið til og farið yfir vandamál og sameinað beiðnir. Frekari upplýsingar er að finna í framlagshandbók okkar.
