Parameters
- i
Return Value
The value of the specified column as a byte.
static void GetMyByte(SqlConnection myConnection) { SqlCommand cmd = new SqlCommand("SELECT * FROM Test.AllTypes"); cmd.Connection = myConnection; myConnection.Open(); try { SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); byte recievedByte = reader.GetByte(reader.GetOrdinal("ByteCol")); reader.Close(); } finally { myConnection.Close(); } }
Shared Sub GetMyByte(ByVal myConnection As SqlConnection) Dim cmd As New SqlCommand("SELECT * FROM Test.AllTypes") cmd.Connection = myConnection myConnection.Open() Try Dim reader As SqlDataReader = cmd.ExecuteReader reader.Read() Dim recievedByte As Byte = reader.GetByte(reader.GetOrdinal("ByteCol")) reader.Close() Finally myConnection.Close() End Try End Sub