DataSet dt= SqlHelper.ExecuteDataset(SqlHelper.conn(), CommandType.Text, "SELECT id,fcode,fname,faddress,fpersons,fphone,fisbool FROM t_store").ToString();
SqlHelper.ExecuteDataset返回的一个DataSet类型,请问下各位大虾,为什么这里获取的dt是空的,数据库有两条记录,

解决方案 »

  1.   

    .ToString(),删了,你可以看看dataset.table的Count的值,如果为2说明是读出来的。没有就没读出来
      

  2.   

     private static OleDbConnection conn;
            public static OleDbConnection Conn
            {            get
                {
                    try
                    {                    string connstr = "";                    if (conn == null)
                            conn = new OleDbConnection(connstr);
                        if (conn.State == ConnectionState.Closed)
                            conn.Open();
                        if (conn.State == ConnectionState.Broken)
                        {
                            conn.Close();
                            conn.Open();
                        }
                        return conn;                }
                    catch (Exception ex)
                    {                    throw;
                    }
                }
            }
            //查询:DataTable
            public static DataTable GetTable(string SqlStr)
            {
                try
                {
                    OleDbDataAdapter dap = new OleDbDataAdapter(SqlStr, Conn);
                    DataSet ds = new DataSet();
                    dap.Fill(ds);
                    conn.Close();
                    return ds.Tables[0];
                }
                catch (Exception ex)
                {                throw;
                }
            }
      

  3.   

    上面的Xp,
    win7如下win7中Spy++才发现开始菜单就是窗口
     class Program
        {
            // 获得窗体句柄
            [DllImport("user32.dll")]
            public static extern IntPtr FindWindow(String className, String captionName);
            [DllImport("user32.dll")]
            public static extern bool ShowWindow(IntPtr hwnd, uint nCmdShow);
            static void Main(string[] args)
            {
                // 获得任务栏句柄
                var rwl = FindWindow("Shell_TrayWnd", null);
                //当nCmdShow=0:隐藏;=1:显示
                ShowWindow(rwl, 0);
                var rwl2 = FindWindow("Button", null);
                ShowWindow(rwl2, 0);
                Console.Read();
                ShowWindow(rwl2, 1);
                ShowWindow(rwl, 1);
            }
        }