Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    Practical-05 Theory: Step 1

    Uploaded by

    sey
    The document describes steps to display parameterized data from a SQL database in an ASP.NET GridView control using a SQLDataReader. Step 1 involves creating an empty ASP.NET project and adding a WebForm with a GridView. Step 2 adds code behind to: 1) get a connection string, 2) execute a SQL query to retrieve data, 3) populate a DataTable from the SQLDataReader, and 4) bind the DataTable to the GridView. This allows parameterized data from a SQL database to be displayed in an ASP.NET GridView.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Practical-05 Theory: Step 1

    Uploaded by

    sey
    18 views2 pages
    The document describes steps to display parameterized data from a SQL database in an ASP.NET GridView control using a SQLDataReader. Step 1 involves creating an empty ASP.NET project and adding a WebForm with a GridView. Step 2 adds code behind to: 1) get a connection string, 2) execute a SQL query to retrieve data, 3) populate a DataTable from the SQLDataReader, and 4) bind the DataTable to the GridView. This allows parameterized data from a SQL database to be displayed in an ASP.NET GridView.

    Original Description:

    Display parameterized data using SQLDataReader and GridView in ASP.NET.

    Original Title

    Practical-05 itl

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes steps to display parameterized data from a SQL database in an ASP.NET GridView control using a SQLDataReader. Step 1 involves creating an empty ASP.NET project and adding a WebForm with a GridView. Step 2 adds code behind to: 1) get a connection string, 2) execute a SQL query to retrieve data, 3) populate a DataTable from the SQLDataReader, and 4) bind the DataTable to the GridView. This allows parameterized data from a SQL database to be displayed in an ASP.NET GridView.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    18 views2 pages

    Practical-05 Theory: Step 1

    Uploaded by

    sey
    The document describes steps to display parameterized data from a SQL database in an ASP.NET GridView control using a SQLDataReader. Step 1 involves creating an empty ASP.NET project and adding a WebForm with a GridView. Step 2 adds code behind to: 1) get a connection string, 2) execute a SQL query to retrieve data, 3) populate a DataTable from the SQLDataReader, and 4) bind the DataTable to the GridView. This allows parameterized data from a SQL database to be displayed in an ASP.NET GridView.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    Practical-05

    Aim: Display parameterized data using SQLDataReader and GridView in ASP.NET.

    Theory:

    Step 1:

    Create the project as:


    1. "Start" - "All Programs" - "Microsoft Visual Studio 2013".
    2. "File" - "New Project" - "C#" - "Empty Project" (to avoid adding a master page).
    3. Give the project a name such as "BindGridfromxml" or another as you wish and specify the
    location.
    4. Then right-click on Solution Explorer - "Add New Item" - "WebForm1.aspx" page.
    5. Drag and Drop one grid view to the WebForm1.aspx page. Then the page will look such as
    follows.
    WebForm1.aspx
    1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inhe
    rits="WebApplication1.WebForm1" %>
    2. <!DOCTYPE html>
    3. <html
    4. xmlns="http://www.w3.org/1999/xhtml">
    5. <head runat="server">
    6. <title></title>
    7. </head>
    8. <body>
    9. <form id="form1" runat="server">
    10. <div>
    11. <asp:GridView ID="GridView1" runat="server"></asp:GridView>
    12. </div>
    13. </form>
    14. </body>
    15. </html>

    Step 2:

    Write a Below Code In code behind file:


    1. using System;
    2. using System.Collections.Generic;
    3. using System.Linq;
    4. using System.Web;
    5. using System.Web.UI;
    6. using System.Web.UI.WebControls;
    7. using System.Data.SqlClient;
    8. using System.Data;
    9. using System.Configuration;
    10. namespace WebApplication1 {
    11. public partial class WebForm1: System.Web.UI.Page {
    12. string constr = ConfigurationManager.ConnectionStrings["MyDbConn1"].ToString();
    13. protected void Page_Load(object sender, EventArgs e) {
    14. GetDataForReader();
    15. }
    16. private void GetDataForReader() {
    17. SqlConnection con = new SqlConnection(constr);
    18. con.Open();
    19. string str = "Select * from Students";
    20. SqlCommand cmd = new SqlCommand(str, con);
    21. SqlDataReader reader = cmd.ExecuteReader();
    22. DataTable dt = new DataTable();
    23. dt.Columns.Add("Id");
    24. dt.Columns.Add("Name");
    25. dt.Columns.Add("Gender");
    26. dt.Columns.Add("Subjects");
    27. while (reader.Read()) {
    28. DataRow row = dt.NewRow();
    29. row["Id"] = reader["Id"];
    30. row["Name"] = reader["Name"];
    31. row["Gender"] = reader["Gender"];
    32. row["Subjects"] = reader["Subjects"];
    33. dt.Rows.Add(row);
    34. }
    35. GridView1.DataSource = dt;
    36. GridView1.DataBind();
    37. reader.Close();
    38. con.Close();
    39. }
    40. }
    41. }

    You might also like