我发现了一个关于DataGrid的问题:
如果一个数据库中的表中有100条记录,将它全部显示在DataGrid控件中只有99条,
具体显示方法采用:
this.sqlDataAdapter1.Fill(this.dataSet11,1,0,"bookinfo");
dataGrid1.SetDataBinding(this.dataSet11,"bookinfo");
依次类推,如果表中只有一条记录,DataGrid中将显示空!
但是如果你实现了查找功能,并在你的程序中查找仍能找到丢失的那一条记录,一般丢失的记录为表中的第一条!
不知道各位有没有遇到这样的问题?

解决方法:
不使用上面的方法,改用:
  Access acc1=new Access();
   DataSet ds1=new DataSet();
   acc1.GetDataSet(str1,ds1);//执行SQL语句str1，返回DataSet数据集,ds1
   this.dataGrid1.DataSource=ds1;
   this.dataGrid1.DataMember=ds1.Tables[0].ToString();
这样数据就会显示出来!

str1="select * from [yourtable]";

//
   // dataSet11
   //
   this.dataSet11.DataSetName = "DataSet1";
   this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
//
   // dataGrid1
   //
   this.dataGrid1.DataMember = "Customers";
   this.dataGrid1.DataSource = this.dataSet11;
   this.dataGrid1.Dock = System.Windows.Forms.DockStyle.Fill;
   this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
   this.dataGrid1.Location = new System.Drawing.Point(0, 0);
   this.dataGrid1.Name = "dataGrid1";
   this.dataGrid1.Size = new System.Drawing.Size(292, 233);
   this.dataGrid1.TabIndex = 0;
//
   // sqlSelectCommand1
   //
   this. = "SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region," +
    " PostalCode, Country, Phone, Fax FROM Customers";
   this.sqlSelectCommand1.Connection = this.sqlConnection1;