VS 2005 Can not open DataSet Schema in Designer mode

Question

Hi I cannot view DataSet file in designer mode in VS 2005. When I try to it another solution it is ok but in one of my project solution I cant. The projects are c# class library projects in a solution file. Is there any suggestion? Thanks for your help.

Answer 1

Try traversing it for errors along the line of..

System.Data.DataSet ds = new {your dataset}

if (ds.HasErrors)
{
    foreach (DataTable dt in ds.Tables)
    {
        if (dt.HasErrors)
        {
            DataRow[] drErr =  dt.GetErrors();
            foreach (DataRow dr in drErr)
            {
                DataColumn[] dca = dr.GetColumnsInError();
                foreach(DataColumn dc in dca)
                {
                    System.Diagnostics.Debug.Print(dr.GetColumnError(dc)); 
                }
            }
         }
    }
}

Answer 2

If you are not getting any error then I guess its a setting problem. For resolving that go to View menu in Dot.NEt and click on Non-viual Controls or Ctrl+Alt+Q to enable the same.

Now u'll be able to view the Dataset in design view.

Regards, Ravi Prakash