DataColumn MaxLength Property
DataColumnMaxLengthProperty.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);
dt.Columns.Add(dc);
DataColumn dc2 = new DataColumn();
dc2.ColumnName = "BookName";
dc2.DataType = typeof(string);
//this line make DataColumn values maximum length 40 characters
dc2.MaxLength = 40;
dt.Columns.Add(dc2);
DataColumn dc3 = new DataColumn();
dc3.ColumnName = "BookAuthor";
dc3.DataType = typeof(string);
dt.Columns.Add(dc3);
dt.Rows.Add(new object[] { 1, "Programming Python, Fourth Edition", "Mark Lutz" });
dt.Rows.Add(new object[] { 2, "Head First Python", "Paul Barry" });
/*uncomment this line to get error message because
BookName column maximum length 40 characters*/
//dt.Rows.Add(new object[] { 3, "Hadoop: The Definitive Guide, Second Edition", "Tom White" });
dt.Rows.Add(new object[] { 4, "Real World Instrumentation with Python", "John M. Hughes" });
GridView1.DataSource = dt;
GridView1.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>How to use DataColumn MaxLength Property in ado.net</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2 style="color:DarkBlue; font-style:italic;">
How to use DataColumn MaxLength Property in ado.net
</h2>
<hr width="525" align="left" color="CornFlowerBlue" />
<asp:GridView
ID="GridView1"
runat="server"
BorderColor="Snow"
ForeColor="Snow"
Width="550"
>
<HeaderStyle BackColor="Crimson" ForeColor="Snow" Height="30" />
<RowStyle BackColor="SaddleBrown" ForeColor="Snow" />
<AlternatingRowStyle BackColor="Tan" ForeColor="Snow" />
</asp:GridView>
<br />
<asp:Button
ID="Button1"
runat="server"
OnClick="Button1_Click"
Text="Populate GridView"
Height="45"
Font-Bold="true"
ForeColor="DodgerBlue"
/>
</div>
</form>
</body>
</html>
- How to add multiple columns at once to a DataTable
- How to create a DataColumn with default value
- How to check if a column exists in a DataTable
- How to add a new row into DataTable
- 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
- How to create a DataTable from a DataView
