VB.NET & IsDBNull() - IsDBNull() : Returns a Boolean value indicating whether an expression evaluates to the System.DBNull class.
ShotDev Focus:
- VB.NET & IsDBNull()
Example
IsDBNull.aspx
- <%@ Page Language="VB" %>
- <%@ import Namespace="System.Data" %>
- <%@ import Namespace="System.Data.OleDb" %>
- <script runat="server">
- Sub Page_Load(sender As Object, e As EventArgs)
- Dim strConnString As String
- Dim objConn As OledbConnection
- strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("shotdev/mydatabase.mdb")&";Jet OLEDB:Database Password=;"
- objConn = New OleDbConnection(strConnString)
- objConn.Open()
- Dim dtAdapter As OleDbDataAdapter
- Dim dt As New DataTable
- Dim strSQL As String
- strSQL = "SELECT * FROM customer WHERE CustomerID = 'C003' "
- dtAdapter = New OleDbDataAdapter(strSQL, objConn)
- dtAdapter.Fill(dt)
- If dt.Rows.Count > 0 Then
- IF NOT IsDBNull(dt.Rows(0)("Name")) Then
- Me.lblText.Text = dt.Rows(0)("Name")
- End IF
- End IF
- objConn.Close()
- objConn = Nothing
- End Sub
- </script>
- <html>
- <head>
- <title>ShotDev.Com Tutorial</title>
- </head>
- <body>
- <form runat="server">
- <asp:Label id="lblText" runat="server"></asp:Label>
- </form>
- </body>
- </html>
Screenshot
.
.
.
Download this script.
Loading ...