preview

Nt1330 Unit 3 Venn Diagrams

Decent Essays
Open Document

Let us see how to use dataset in ASP.NET web pages. A dataset will contain rows, columns, primary keys, constraints and the relations with the other objects of DataTable. The dataset is a memory-resident representation of data that will provide a consistent relational programming model without concern of the source of the data.
Dataset is a tabular representation of data i.e. it will represent data in the format of rows and columns. This class will be counted in a disconnected architecture in .NET framework i.e. it is found in System.data namespace. The dataset will hold records of more than one database tables.
Dataset can be used in combination with SqlDataAdapter class. Each DataTable in a DataSet is filled with data from the data source by making use of the DataAdapter. The SqlDataAdapter object will …show more content…

The above example SqlDataAdapter was used to fill the dataset with records.
The following code has to be written on the form load event. using System.Windows.Forms; using System.Data.SqlClient; namespace workingwithdataset
{
public partial class frmdataset : Form { public frmdataset() { InitializeComponent(); } private void frmdataset_Load(object sender, EventArgs e) { DataTable table1 = new DataTable(); DataTable table2 = new DataTable(); DataColumn dc11 = new DataColumn("ID", typeof(Int32)); DataColumn dc12 = new DataColumn("Name", typeof(string)); DataColumn dc13 = new DataColumn("City", typeof(string)); table1.Columns.Add(dc11); table1.Columns.Add(dc12); table1.Columns.Add(dc13); table1.Rows.Add(111,"Amit Kumar", "Jhansi"); table1.Rows.Add(222, "Rajesh Tripathi", "Delhi"); table1.Rows.Add(333, "Vineet Saini", "Patna"); table1.Rows.Add(444, "Deepak Dwij",

Get Access
Related
Get Access