A category of information of a table is called a column. The string on top of each column allows the user to identify what that column is used for. That string is called the column header. To support the columns of a table, the .NET Framework provides the DataColumn class.
To create a column, you can first declare a variable of type DataColumn. The DataColumn class is equipped with five constructors. The default constructor allows you to create a column without giving details. Here is an example: using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace VideoCollection1
{
public partial class Exercise : Form
{
DataColumn colCategoryID;
public Exercise()
{
InitializeComponent();
}
private void btnDocument_Click(object sender, EventArgs e)
{
colCategoryID = new DataColumn();
}
}
}
To visually create a column, after displaying the Tables Collection Editor, under Members, click the name of the table. Then under Properties, click Columns and click its ellipsis button. This would open the Columns Collection Editor. To create a new column, click Add:
After clicking Add, the studio would declare a variable for the new column and a default variable name would be given to it. To change the name of the variable, under Properties, click (Name) and type the desired name.
In a database, as reviewed for a table, a column must have an object name. To distinguish them, each column must have a specific and unique object name. The object name of a column allows you to identify the column as a database object. The object name does not follow the rules of variables in C#. For example, a column's object name can be FullName, Date of Birth, First Name + Last Name, CD w/+ H2, $alary, or P@Hip!. As you can see, you can give any insane object name to a column. To make it easily identifiable, here are the rules and suggestions we will follow to name our columns:
To specify the object name of a column, when creating it, you can use the second constructor of the DataColumn class. Its syntax is: public DataColumn(string name); This constructor expects as argument the name of the column. Here is an example: using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace VideoCollection1
{
public partial class Exercise : Form
{
DataColumn colCategoryID;
public Exercise()
{
InitializeComponent();
}
private void btnDocument_Click(object sender, EventArgs e)
{
colCategoryID = new DataColumn("CategoryID");
}
}
}
To support the name of a column, the DataColumn class is equipped with a property named ColumnName. This property is of type string. If you have already declared a DataColumn variable, to specify or change its name, assign the desired string to the DataColumn.ColumnName property. Here is an example: using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace VideoCollection1
{
public partial class Exercise : Form
{
DataColumn colCategoryID;
DataColumn colCategory;
public Exercise()
{
InitializeComponent();
}
private void btnDocument_Click(object sender, EventArgs e)
{
colCategoryID = new DataColumn("CategoryID");
colCategory = new DataColumn();
colCategory.ColumnName = "Category";
}
}
}
Based on these descriptions, the minimum information needed to create a column is a name. If you do not specify a name, a default name is assigned to the new column. If you are visually creating your columns, after clicking Add a default name would be given to it. To specify or change the name of the column, under Members, click the column. Under Properties, click ColumnName and type the desired name.
To support, or to hold, the columns of a table, the DataTable class is equipped with a property named Columns. The Columns property is an object of type DataColumnCollection. Like DataTableCollection, the DataColumnCollection class is derived from the InternalDataCollectionBase class. The DataColumnCollection class provides everything that is necessary to create and manage the columns of a table.
To make a column part of a table, you must add it to the table's collection of columns. The DataColumnCollection class is equipped with a method named Add() that allows you to add a column to the table. The DataColumnCollection.Add() method is overloaded with 5 versions. One of the versions uses the following syntax: public virtual DataColumn Add(); When called, this method adds a new column and returns it. The compiler would assign a default name to the column. If this is the first column, it would be named Column1. If it is the second column, it would be named Column2, and so on. You can still specify or change the name of a column created with the above version of the Add() method. To do this, assign the desired string to the DataColumn.ColumnName. Here is an example: namespace VideoCollection1
{
public partial class Exercise : Form
{
DataColumn colDirectorID;
DataTable dtDirectors;
public Exercise()
{
InitializeComponent();
}
private void btnDocument_Click(object sender, EventArgs e)
{
dtDirectors = new DataTable();
colDirectorID = dtDirectors.Columns.Add();
}
}
}
If you want to specify the object name of the new column when calling the DataColumnCollection.Add() method, use the following version: public virtual DataColumn Add(string name); This method takes as argument the name of the new column and returns that new column. Here is an example: namespace VideoCollection1
{
public partial class Exercise : Form
{
DataColumn colDirectorID;
DataColumn colDirector;
DataTable dtDirectors;
public Exercise()
{
InitializeComponent();
}
private void btnDocument_Click(object sender, EventArgs e)
{
dtDirectors = new DataTable();
colDirectorID = dtDirectors.Columns.Add();
colDirector = dtDirectors.Columns.Add("Director");
}
}
}
If you have already formally created a DataColumn object, to add it to the collection of columns of a table, call the following version of the DataColumnCollection.Add() method: public void Add(DataColumn column); This method expects a DataColumn object as argument. You can either primarily create a DataColumn value or you can define one in the parentheses of the method. Here are two examples: namespace VideoCollection1
{
public partial class Exercise : Form
{
DataColumn colDirectorID;
DataColumn colDirector;
DataColumn colDateOfBirth;
DataTable dtDirectors;
public Exercise()
{
InitializeComponent();
}
private void btnDocument_Click(object sender, EventArgs e)
{
colDateOfBirth = new DataColumn("Date of Birth");
dtDirectors = new DataTable();
colDirectorID = dtDirectors.Columns.Add();
colDirector = dtDirectors.Columns.Add("Director");
dtDirectors.Columns.Add(colDateOfBirth);
}
}
}
Instead of adding one column (at a time) to a table, you can first create an array of columns and add that array to the collection of columns. To do this, you can call the DataColumnCollection.AddRange() method. Its syntax is: public void AddRange(DataColumn[] columns); This method takes as argument an array of predefined columns. Here is an example: namespace VideoCollection1
{
public partial class Exercise : Form
{
DataColumn colDirectorID;
DataColumn colDirector;
DataColumn colDateOfBirth;
DataTable dtDirectors;
DataColumn[] colVideos;
DataTable dtVideos;
public Exercise()
{
InitializeComponent();
}
private void btnDocument_Click(object sender, EventArgs e)
{
colDateOfBirth = new DataColumn("Date of Birth");
dtDirectors = new DataTable();
colDirectorID = dtDirectors.Columns.Add();
colDirector = dtDirectors.Columns.Add("Director");
dtDirectors.Columns.Add(colDateOfBirth);
colVideos = new DataColumn[7];
colVideos[0] = new DataColumn("Title");
colVideos[1] = new DataColumn("Director");
colVideos[2] = new DataColumn("YearReleased");
colVideos[3] = new DataColumn("Length");
colVideos[4] = new DataColumn("Rating");
colVideos[5] = new DataColumn("Format");
colVideos[6] = new DataColumn("Category");
dtVideos = new DataTable("Videos");
dtVideos.Columns.AddRange(colVideos);
}
}
}
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
