CSharp Catch Data Binding Exception (Vb.Net) – ADO.Net Database

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.Sqlclient" %>
<script runat="server">  Sub Button1_Click(sender As Object, e As EventArgs)
       Dim conn As New SqlConnection("Server=foo;Database=pubs;Trusted_Connection=true")
       Dim cmd As New SqlCommand("select * from authors", conn)       Try
         Conn.Open()
         DataGrid1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection)
         DataGrid1.DataBind()
       Catch ex As Exception
         Label1.Text = "Could not connect to the database - " & _
                     "please try again later."
       End Try
    End Sub</script>
<html>
<head>
</head>
<body>
    <form runat="server">
        <asp:Button id="Button1" onclick="Button1_Click" runat="server" Text="Button"></asp:Button>
        <asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>
        <asp:Label id="Label1" runat="server">Label</asp:Label>
        <!-- Insert content here -->
    </form>
</body>
</html>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.