hi all:

My c# code like this , and just like here on Microsoft web site :
http://support.microsoft.com/default...;en-us;q317175


DataSet ds = new DataSet();
//myDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
myDataAdapter.Fill(ds, "Categories");
myDataAdapter.FillSchema(ds, SchemaType.Mapped);

DataTable mytable = ds.Tables["Categories"];
for (int i = 0; i < mytable.Columns.Count; i ++)
Console.WriteLine(mytable.Columns[i].MaxLength);


but DataColumn.MaxLength() does not work at all,
how can i do?
thanks!

Why did you comment out the MissingSchemaAction line? It is necessary to get
certain SQL information.

Kathleen


"wjg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi all:
>
> My c# code like this , and just like here on Microsoft web site :
> http://support.microsoft.com/default...;en-us;q317175
>
>
> DataSet ds = new DataSet();
> //myDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
> myDataAdapter.Fill(ds, "Categories");
> myDataAdapter.FillSchema(ds, SchemaType.Mapped);
>
> DataTable mytable = ds.Tables["Categories"];
> for (int i = 0; i < mytable.Columns.Count; i ++)
> Console.WriteLine(mytable.Columns[i].MaxLength);
>
>
> but DataColumn.MaxLength() does not work at all,
> how can i do?
> thanks!
>
>
>
>
>

[Pradono]

Try to call FillSchema first before calling Fill method such as:

myDataAdapter.FillSchema(ds, SchemaType.Mapped);
myDataAdapter.Fill(ds, "Categories");