SiteMap  | About    

Dataset Column Definition

The SqlDataAdapter Object allows us to populate DataTable in a DataSet. We can use Fill method in the SqlDataAdapter for populating data in a Dataset. The Dataset can contains more than one Table at a time.

The data inside Table is in the form of Rows and Columns . The DataRow class represents the actual data contained in a table. You use the DataRow and its properties and methods to retrieve, evaluate, and manipulate the data in a table. In some situations we have to find the column headers in a DataTable. There is a ColumnsCollection Object in the Datatable hold the column Definitions. The following ASP.NET Source Code shows how to find Column Definitions from a Datatable.



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<head id="Head1" runat="server">
	<title>Untitled Page</title>
	<form id="form1" runat="server">
		<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
		<br />
		<asp:ListBox ID="ListBox1" runat="server"></asp:ListBox>
		<br />
		<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

Click the following links to see full source code

C# Source Code
VB.NET Source Code
default.aspx.vb (C) 2015    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.