using System; using System.Data.SqlClient; class Program { static void Main() { string connectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"; string sql = "SELECT * FROM myTable"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(sql, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { bool isActive = reader.GetBoolean(0); string name = reader.GetString(1); // do something with the data } reader.Close(); } } }
bool isActive = reader.IsDBNull(0) ? false : reader.GetBoolean(0);This example demonstrates how to handle NULL values in the SQL Server database. If the value in the first column is NULL, it sets the isActive variable to false. Otherwise, it retrieves the Boolean value from the first column. Package library: This code example uses the System.Data.SqlClient namespace, which is part of the .NET Framework Class Library. No external package library is required.