473,325 Members | 2,792 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Set TextBox MaxLength to match SQL varchar(nnn) length?

I have a database with text string fields defined by varchar(nnn). When I
request from the user the text from a textbox, I'd like to set the maximum
number of characters in the textbox to the "nnn" that was used in the
varchar(...) statement in the field definition. i.e.

Field1 varchar(25) NOT NULL

and in the .aspx file:

<asp.textbox id=Field1 runat="server" />

I load a dataset and put data in the text box via the following:

DataSet dsInfo = new DataSet();
SqlDataAdapter daRecord
= new SqlDataAdapter("SELECT * FROM Records WHERE RecordID ='"
+ RecordID + "'", SqlConnect);
daRecord.Fill(dsInfo, "Table");

DataTable dtRecord = dsInfo.Tables["Table"];
DataRow drRecord = dtRecord.Rows[0];

textBox1.Text = drRecord["Field1"]
textBox1.MaxLength = ???

My question is how can I set the MaxLength property of the text box?
Somewhere in the depths of the DataSet must be some description of the
schema defining the field in the table. Could someone offer guidance as to
extracting this? Presumably, I should also be able to extract other details
of the schema such as type or nullability.

I could have an array of sizes for each one of the text boxes but it seems
bad programming practice to have the field sizes defined in two completely
different places.

Ed
--
Edward E.L. Mitchell
Phone: (239)415-7039
6707 Daniel Court
Fort Myers, FL 33908

Jul 21 '05 #1
5 7399
Hi Edward,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to get the MaxLength of a
certain column from SQL database. If there is any misunderstanding, please
feel free to let me know.

I think we can do the following to achieve this.

1. Before filling the DataSet, we first fill the schema.

daRecord.FillSchema(ds, SchemaType.Source);
daRecord.Fill(dsInfo, "Table");

2. Then we use the DataColumn.MaxLength to get the maximum length. If the
column has no maximum length, the value is -1.

textBox1.Text = drRecord["Field1"]
int len = dsInfo.Tables["Table"].Columns["Field1"].MaxLength
if(len != -1)
textBox1.MaxLength = len;

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Jul 21 '05 #2
It's the FillSchema(...) that was the routine that I was looking for so that
I could interrogate the table definition.

However, I seem to get only the -1 that says that it has no maximum length!

I define the test table with:

CREATE TABLE Records
(
RecordID int NOT NULL IDENTITY PRIMARY KEY,
Field1 varchar(15) NOT NULL
)
INSERT Records (Field1) VALUES ("abc")
GO

and in the page load event do the following:

private void Page_Load(object sender, System.EventArgs e)
{
// database connection string
String SqlConnect = "workstation id=DELL340;packet size=4096;"
+ "integrated security=SSPI;data source=DELL340;"
+ "persist security info=False;initial catalog=Test";

DataSet dsInfo = new DataSet();

// read all the stuff from the table
SqlDataAdapter daRecord
= new SqlDataAdapter("SELECT * FROM Records", SqlConnect);
daRecord.FillSchema(dsInfo, SchemaType.Source);
daRecord.Fill(dsInfo, "Records");
DataTable dtRecord = dsInfo.Tables["Records"];
DataColumn dc1 = dtRecord.Columns["Field1"];
int iLen1 = dc1.MaxLength;
}

When I single step through this code, the iLen1 shows as -1 rather than the
15 that I had put into the varchar(...) field definition that was used when
the table was created.

I looked (with the Debugger) into the DataSet dsInfo and found that there
was a list of {System.Data.DataColumns} of length 2 and the second column
had the right name Field1 and a length of 15.

When I look into the DataTable dtRecord (the QuickWatch window expression
is:
((System.Collections.ArrayList)(((System.Data.Data ColumnCollection)(dtRecord.Columns)).List))._items[1])
then the field name is still "Field1" but the MaxLength has been changed
to -1. I tried both SchemaType of Source or Mapped with the same results.

Why doesn't the 15 length carry over into the DataColumn?

Ed


"Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
news:$B**************@cpmsftngxa10.phx.gbl...
Hi Edward,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to get the MaxLength of a
certain column from SQL database. If there is any misunderstanding, please
feel free to let me know.

I think we can do the following to achieve this.

1. Before filling the DataSet, we first fill the schema.

daRecord.FillSchema(ds, SchemaType.Source);
daRecord.Fill(dsInfo, "Table");

2. Then we use the DataColumn.MaxLength to get the maximum length. If the
column has no maximum length, the value is -1.

textBox1.Text = drRecord["Field1"]
int len = dsInfo.Tables["Table"].Columns["Field1"].MaxLength
if(len != -1)
textBox1.MaxLength = len;

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Jul 21 '05 #3
Hi Edward,

You are getting -1 as the MaxLength of the DataColumn because when you
fillschema, the DataAdapter created a table named "Table". But when you
call Fill, the data was filled to another table named Records. So actually
the schema information was not put to the Record table. Thus, we have to
add a table name for FillSchema as the third argument. Please replace
FillSchema with the following line, which will resolved this issue.

daRecord.FillSchema(dsInfo, SchemaType.Source, "Records");

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Jul 21 '05 #4
Kevin,

That fix worked. I appreciate the help.

The documentation (MSDN Oct2004) for the .NET Framework Class Library
doesn't mention the availability of a third argument to FillSchema(...)! It
does say that FillSchema adds a DataTable named "Table" to the specified
DataSet so I could have extracted the lengths from this.

Ed

"Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
news:0g**************@cpmsftngxa10.phx.gbl...
Hi Edward,

You are getting -1 as the MaxLength of the DataColumn because when you
fillschema, the DataAdapter created a table named "Table". But when you
call Fill, the data was filled to another table named Records. So actually
the schema information was not put to the Record table. Thus, we have to
add a table name for FillSchema as the third argument. Please replace
FillSchema with the following line, which will resolved this issue.

daRecord.FillSchema(dsInfo, SchemaType.Source, "Records");

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Jul 21 '05 #5
Hi Ed,

It was nice to hear that the problem is resolved.

Actually, you can find this overload for FillSchema from the following link.

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdatacommondbdataadapterclassfillschemat opic3.asp

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Jul 21 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Gil | last post by:
I am trying to advance to the next textbox when input for the current textbox has reached its maximum length. In a different newsgroup I found this code snipit, but I have not been able to use it....
0
by: Edward Mitchell | last post by:
I have a database with text string fields defined by varchar(nnn). When I request from the user the text from a textbox, I'd like to set the maximum number of characters in the textbox to the...
3
by: Agnes | last post by:
How Can I set the max length in the datagrid ? Thanks
3
by: N! Xau | last post by:
Hi, I am using a textbox to display, row by row, results of Database-related operation. One, is this a valid method or not? Two, I see textbox.maxlength defaulted to 32767. What problems do...
0
by: Christian Enklaar | last post by:
We are using a table with a primary key of type varchar. If we try to find entries with select * from <table> where <table.key> = '<text>'; entries with a key length of more than 32 characters are...
3
by: Christian Enklaar | last post by:
Hello, we are using a table with a primary key of type varchar. If we try to find entries with select * from <table> where <table.key> = '<text>'; entries with a key length of more than 32...
0
by: ABC | last post by:
When set textbox's datasource and datamember to dataset, Is it auto set textbox maxlength properties with dataset's field length?
9
by: The Confessor | last post by:
I declare the following variable in one of my structures... <VBFixedString(17)> Dim Name As String Fixed to 17 because it's written to a random-access file. Is there any way to tie the...
0
by: Gilgamesh | last post by:
I'm retrieving a data column from SQL Server 2000 which has the type Varchar with length set to 10. The MaxLength method of DataColumn object returns -1 instead of the correct size which is 10....
1
by: =?Utf-8?B?SC5CLg==?= | last post by:
Hi, How can I force TextBox to have more than 32767 in length. Max Length is not respected over 32767. I build a log window and need to display a lot of data. Thanks, Hugo
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.