Re: VARCHAR Length

[Chris Cline]

I'm not sure how you are excuting the DataReader but here is how I get the columnSize and other attributes.

MySqlConnection mCon = new MySqlConnection( this.ConnectionString );
mCon.Open();

MySqlCommand mCmd = new MySqlCommand("Select * from " + DatabaseName + "." + TableName , mCon );

MySqlDataReader mr = mCmd.ExecuteReader();

DataTable st = mr.GetSchemaTable();

I can then do a foreach datarow dr in st.Rows and look at the "ColumnSize", "ColumnName", etc.