iaroslav Posted October 9, 2003 Posted October 9, 2003 I'm trying to detect if a column is allowed to contain NULL values. I use ADO .NET in VB to connect to SQL server, retrieve table data and store it in a dataset. Everything seems to work fine, apart from the AllowDBNull value, which is always True for all columns, while for some columns in the database the 'Allow Nulls' property is set to False. For example, if I execute the following statement For I=0 to dsDataSet.Tables(0).Columns.Count - 1 console.WriteLine(dsDataSet.Tables(0).Columns(I).AllowDBNull.ToString) Next the result is always True. Am I doing something wrong? Thanks in advance Quote
*Experts* Nerseus Posted October 11, 2003 *Experts* Posted October 11, 2003 How are you filling your DataSet? You might need to call FillSchema first. If you load from a predefined dataset, such as an XSD, it usually contains that info as well (of course, it depends on how you create your XSD, if you do it that way). -Nerseus Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.