---
title: "How to use Dataset in asp.net"
description: "How to use Dataset in asp.net"
author: "Anonymous User"
published: 2016-01-12
updated: 2016-01-12
canonical: https://www.mindstick.com/forum/33857/how-to-use-dataset-in-asp-dot-net
category: "c#"
tags: ["c#", "ado.net"]
reading_time: 2 minutes
---
# How to use Dataset in asp.net
I want to use detaset in asp.net.how to use this.
## Replies
### Reply by Anonymous User
DataSet is a ado.net components.it is a collection of DataTables. you can use the DataSet type to store many DataTables in a single collection.
```
usig System;using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace Forumasp{ public partial class DataSetDemo : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataSet ds = CreateDataSet();
GridView1.DataSource = ds.Tables["Customer"];
GridView1.DataBind(); } } private DataSet CreateDataSet()
{ DataSet dataset = new DataSet();
DataTable Customer = CreateStudentTable();
dataset.Tables.Add(Customer); return dataset;
} private DataTable CreateStudentTable() { DataTable Customer = new DataTable("Customer");
AddNewColumn(Customer, "System.Int32", "CustomerID");
AddNewColumn(Customer, "System.String", "CustomerName");
AddNewColumn(Customer, "System.String", "CustomerEmailid"); AddNewRow(Customer, 1, "Surendra", "surendra@yahoo.com");
AddNewRow(Customer, 2, "Mahesh Sharma", "mahesh@gmail.com");
AddNewRow(Customer, 3, "Mayank Singh", "mayank@gmail.com");
AddNewRow(Customer, 4, "Sohel", "sohel@gmail.com");
AddNewRow(Customer,5, "Vikram", "vikram@gmail.com");
return Customer;
} private void AddNewColumn(DataTable table, string columnType, string columnName)
{ DataColumn column = table.Columns.Add(columnName, Type.GetType(columnType));
} private void AddNewRow(DataTable table, int id, string name, string city) { DataRow newrow = table.NewRow();
newrow["CustomerID"] = id;
newrow["CustomerName"] = name;
newrow["CustomerEmailid"] = city; table.Rows.Add(newrow); } }} <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DataSet.aspx.cs" Inherits="Forumasp.DataSetDemo" %>
```
---
Original Source: https://www.mindstick.com/forum/33857/how-to-use-dataset-in-asp-dot-net
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.