C# ASP.NET Table SqlDataReader Example – SqlDataReader Table Example C# ASP.NET
Putting
the Pieces of .NET Together - 8 Part Video Series | ||||
| Introduction |  | |||
| Videos 1-4 | 1. Servers (3 minutes) | 2. .NET Framework (10 minutes) | 3. Security (8 minutes) | 4. Monitoring Tools (10 minutes) |
| Videos 5-8 | 5. Web Servers (6 minutes) | 6. SQL Server (6 minutes) | 7. Software Develop Tools (10 minutes) | 8. Languages (2 minutes) |
| Download PDF | Putting the Pieces of .NET Together - 48-page PDF | |||
C# ASP.NET Table SqlDataReader Example – SqlDataReader Table Example C# ASP.NET
Purpose: – Illustrates using DataTable load from SqlDataReader in C-Sharp ASP.NET.
Prerequistes:
- Install Visual Web Developer 2008
- Install SQL Server Express
- Download Northwind and Pubs Databases
- Attach Northwind Database to Databases in Sql Express
- Attach pubs Database to Databases in Sql Express
Notes:
- You can build your own library of syntax examples by using same web site over and over and just add new web forms to it.
Instructions:
- Use Visual Web Developer 2008
- Create new web site;
- Click File/New Web Site
- Select ASP.NET Website Template
- Select C-Sharp for Language
- name of Web Site could be CSharp_ASPNET_Syntax.
- Add New folder named "ADONET"
- Right-click project name in solution explorer;
- add new folder;
- name of folder could be: ADONET
- Add Web Form Named TableLoadFromSqlDataReader to ADONET folder
- Right-click ADONET folder;
- add new item;
- Select Web Form
- Check place code behind in separate file
- Web Form name could be TableLoadFromSqlDataReader
- Click on copy code in code below to copy code into web form TableLoadFromSqlDataReader.aspx
- Click on copy code in second set of code below to copy code into code-behind TableLoadFromSqlDataReader.aspx.cs
- Right-click on TableLoadFromSqlDataReader.aspx in solution explorer and select view in browser
Step 1: Click on Copy Code to Cut-n-paste code into TableLoadFromSqlDataReader.aspx
| XML | | copy code | | ? |
< %@ Page Language="C#" AutoEventWireup="true" CodeFile="TableLoadFromSqlDataReader.aspx.cs" Inherits="ADONET_TableLoadFromSqlDataReader" %> |
< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
<html xmlns="http://www.w3.org/1999/xhtml"> |
<head runat="server"> |
<title></title> |
</head> |
<body> |
<form id="form1" runat="server"> |
<div> |
<asp :GridView ID="GridView1" runat="server"> |
</asp> |
</div> |
</form> |
</body> |
</html> |
Step 2: Click on Copy Code to Cut-n-paste code into TableLoadFromSqlDataReader.aspx.cs
| C# | | copy code | | ? |
using System; |
using System.Data; |
using System.Data.SqlClient; |
using System.Collections; |
partial class ADONET_TableLoadFromSqlDataReader : System.Web.UI.Page |
{ |
protected void // ERROR: Handles clauses are not supported in C# |
Page_Load(object sender, System.EventArgs e) |
{ |
SqlConnection con = new SqlConnection("Server=(local)\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI"); |
SqlCommand cmd = new SqlCommand(); |
cmd.CommandText = "SELECT EmployeeID, FirstName + ' ' + LastName as FullName FROM Employees"; |
cmd.Connection = con; |
DataTable Table1; |
Table1 = new DataTable("Employees"); |
//creating a table named Employees |
DataRow Row1; |
//declaring row for the table |
DataColumn EmployeeID = new DataColumn("EmployeeID"); |
//declaring a column named EmployeeID |
EmployeeID.DataType = System.Type.GetType("System.Int32"); |
//setting the datatype for the column |
Table1.Columns.Add(EmployeeID); |
//adding the column to table |
DataColumn FullName = new DataColumn("FullName"); |
FullName.DataType = System.Type.GetType("System.String"); |
Table1.Columns.Add(FullName); |
try { |
con.Open(); |
SqlDataReader reader = cmd.ExecuteReader(); |
//(CommandBehavior.SingleRow) |
while (reader.Read()) { |
Row1 = Table1.NewRow(); |
//declaring a new row |
Row1["EmployeeID"] = reader.GetInt32(0); |
//filling the row with values. Item property is used to set the field value. |
Row1["FullName"] = reader.GetString(1); |
//filling the row with values. adding FullName |
Table1.Rows.Add(Row1); |
} |
reader.Close(); |
} |
finally { |
con.Close(); |
} |
GridView1.DataSource = Table1; |
GridView1.DataBind(); |
} |
} |
Step 3: Click on Copy Code to Cut-n-paste code into web.config right after the appSettings section
| XML | | copy code | | ? |
<connectiontableloadfromsqldatareaders> |
<add name="Northwind_ConnectionTableLoadFromSqlDataReader" |
connectionTableLoadFromSqlDataReader="Server=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI" /> |
<add name="Pubs_ConnectionTableLoadFromSqlDataReader" |
connectionTableLoadFromSqlDataReader="Server=(local)\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI" /> |
</connectiontableloadfromsqldatareaders> |
Related posts:
- VB.NET ASP.NET Table Load From SqlDataReader Source Code Example VB.NET ASP.NET Table Load From SqlDataReader Source Code Example...
- C# ASP.NET DropDownList Bind To Table Source Code Example C# ASP.NET DropDownList Bind To Table Source Code Example...
- VB.NET ASP.NET DropDownList Bind To Table Source Code Example VB.NET ASP.NET DropDownList Bind To Table Source Code Example...
- C# DataTable SqlDataReader Example – SqlDataReader Datatable Example C# C# DataTable SqlDataReader Example - SqlDataReader Datatable Example C#...
- VB.NET DataTable SqlDataReader Example – SqlDataReader DataTable Example VB.NET VB.NET DataTable SqlDataReader Example - SqlDataReader DataTable Example VB.NET...
Related posts brought to you by Yet Another Related Posts Plugin.