CSharp Sqldatareader Demo – ADO.Net Database

<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.SqlClient" %><html>
  <head>
    <title>Data Reader</title>
  </head>
  <body>
    <h1>Data Reader</h1>
    Total Products listed =
    <asp:DataGrid id="dgCount" runat="server"
                  BorderWidth=0 ShowHeader=False />
    <br/>
    <asp:DataGrid id="dgData" runat="server" />
  </body>
</html><script language="VB" runat="server">
Sub Page_Load(Source As Object, E As EventArgs)
  Dim strConnection As String = "Data Source=whsql-v08.prod.mesa1.secureserver.net;Initial Catalog=DB_49907;User ID=w3mentoruser;Password='password';"
  Dim objConnection As New SqlConnection(strConnection)
  objConnection.Open()  Dim strSQLcount As String
  strSQLcount = "SELECT COUNT(FirstName) FROM Employee"  Dim objCommand As New SqlCommand(strSQLcount, objConnection)
  Dim objReader As SqlDataReader = objCommand.ExecuteReader()  dgCount.DataSource = objReader
  dgCount.DataBind()  objReader.Close()  Dim strProcName As String
  strProcName = "SELECT * FROM Employee"
  objCommand.CommandText = strProcName  objReader = objCommand.ExecuteReader()  dgData.DataSource = objReader
  dgData.DataBind()  objConnection.Close()
End Sub
</script>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.