Get whether DataTable contains a specified DataColumn
ContainsMethodDataTable.aspx
<%@ Page Language="C#" AutoEventWireup="true" %>
<%@ Import Namespace="System.Data" %>
<!DOCTYPE html>
<script runat="server">
void Button1_Click(object sender, System.EventArgs e)
{
DataTable dt = new DataTable();
dt.TableName = "Books";
DataColumn dc = new DataColumn();
dc.ColumnName = "BookID";
dc.DataType = typeof(int);
DataColumn dc2 = new DataColumn();
dc2.ColumnName = "BookName";
dc2.DataType = typeof(string);
DataColumn dc3 = new DataColumn();
dc3.ColumnName = "Author";
dc3.DataType = typeof(string);
dt.Columns.AddRange(new DataColumn[] {dc,dc2,dc3});
dt.Rows.Add(new object[] { "1", "Network Your Computers & Devices Step by Step", "Ciprian Adrian Rusen" });
dt.Rows.Add(new object[] { "2", "Microsoft® Expression® Web 4 Step by Step", "Chris Leeds" });
dt.Rows.Add(new object[] { "3", "My New iPad, Second Edition", "Wallace Wang" });
GridView1.DataSource = dt;
GridView1.DataBind();
//this line check the 'BookName' DataColumn exists in DataTable or not
Boolean columnExists = dt.Columns.Contains("BookName");
Label1.Text = "'BookName' DataColumn exists in DataTable? = " + columnExists;
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>How to check the DataTable contains a DataColumn with the specified name in ado.net</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2 style="color:DarkBlue; font-style:italic;">
Using Contains() method - How to check the DataTable
<br /> contains a DataColumn with the specified name in ado.net
</h2>
<hr width="550" align="left" color="CornFlowerBlue" />
<asp:GridView
ID="GridView1"
runat="server"
BorderColor="Snow"
ForeColor="Snow"
Width="525"
HeaderStyle-BackColor="Maroon"
RowStyle-BackColor="OrangeRed"
AlternatingRowStyle-BackColor="Orchid"
>
</asp:GridView>
<br /><br />
<asp:Label
ID="Label1"
runat="server"
Font-Size="Large"
ForeColor="DarkSeaGreen"
>
</asp:Label>
<br /><br />
<asp:Button
ID="Button1"
runat="server"
OnClick="Button1_Click"
Text="Populate GridView"
Height="45"
Font-Bold="true"
ForeColor="DarkBlue"
/>
</div>
</form>
</body>
</html>
- How to add multiple columns at once to a DataTable
- How to create a DataColumn with default value
- How to set maximum size of a column in a DataTable
- How to get index of a column by name in a DataTable
- How to get a DataTable columns data type
- How to change DataTable columns order
- How to insert a new row into DataTable
- How to select data from a DataTable
- How to set all the values for a DataRow through an array
- How to update a row in a DataTable
