在DataTable中怎么才能获取Column的宽度呢?急!!
说明一下:假如DataTable 的有一列:name
                                  张三
                                 zhangsan
想获得最长字符串的长度“zhangsan”怎么办?

解决方案 »

  1.   

    int numberOfRows = mySqlDataAdapter.Fill(myDataSet, "yourTableName");             DataTable tbl = myDataSet.Tables["yourTableName"];            int MaxStrLen= 0 ;
                int CurStrLen = 0 ;            for (int i = 0; i < numberOfRows; i++)
                {
                    try
                    {
      if (tbl.Rows[i]["name"]!=null)
                        CurStrLen = tbl.Rows[i]["name"].ToString().Trim().Lenght);
                      else 
                        continue ;                  if (MaxStrLen<CurStrLen)
                            MaxStrLen=CurStrLen;
                    }
                    catch
                    {
                        MessageBox.Show("数据转换出错");
                        break ;
                    }
                 }