title: avoid checking for DataRow.IsDBNull on each column?
body: <p>My code is 2x longer than it would be if I could automatically set <code>IsDBNull</code> to <code>""</code> or simply roll over it without an error.</p>
  
  <p>This is my code:</p>
  
  <pre><code>Dim conn As New SqlConnection
  conn.ConnectionString = Module1.DBConn2
  Dim sqlCommand = New SqlCommand("SELECT * FROM table", conn)
  conn.Open()
  Dim sqlDataset As DataSet = New DataSet()
  Dim sqlDataAdapter As SqlDataAdapter = New SqlDataAdapter(sqlCommand)
  sqlDataAdapter.Fill(sqlDataset)
  conn.Close()
  
  For Each rs As DataRow In sqlDataset.Tables(0).Rows
      If Not IsDBNull(rs("column")) Then
          Response.Write(rs("column"))
      Else
          Response.Write("")
      End If
  
      Response.Write("some stuff to write")
  
      If Not IsDBNull(rs("column2")) Then
          Response.Write(rs("column2"))
      Else
          Response.Write("")
      End If
  Next
  </code></pre>
  
  <p>In that case I'd just like to type <code>Response.Write(rs("column"))</code> instead of the <code>If</code> statement, and if <code>column</code> <code>IsDBNull</code> then output an empty string.</p>
  
  <p>How can I do this?</p>
  
  <p>Many thanks in advance!</p>