sql查询问题,在线急

Question

select top 10 * from [Sheet1$] 
可以取到指定的excel表中Sheet1的前10条数据,那么我想取10-20这10条数据怎么取啊
sql和C#的写法都可
在线等,急!!!!!!!!!!!!!!
那位大虾解决一下,小弟不胜感激!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Answer 1

select top 10 * from [Sheet1$] where id not in (select top 9 id from [Sheet1$] )最简单的，不过效率不高

Answer 2

select top 20 * from [Sheet1$]
放到一个table里.再从里面取 10-20条的数据.哇哈哈~~!!!

Answer 3

你那种方法我已经用过了,他需要一个id,可我对excel操作的时候,虽然我取出了id 但是运行的时候报错啊

Answer 4

select top 10 * from (select top 20 * from table1 order by id desc) order by id

Answer 5

to Qim(莫名-从星做起......)
那样要行的话我就不来问了

Answer 6

sqlcommand.CommandText="select  * from [Sheet1$] ";
System.Data.SqlClient.SqlDataAdapter adp = new System.Data.SqlClient.SqlDataAdapter(sqlcommand);
.....
            adp.Fill(myDataSet,10, 10, "TableName");

Answer 7

办法1
select top 10 * from [Sheet1$] where id not in (select top 9 id from [Sheet1$] )办法2在代码里面控制.

Answer 8

strExcel = "select top 20 * from [Sheet1$] where " + ss + "　not in (select top 10 " + ss + " from [Sheet1$])";
这个方法不好用,我用过了,提示from语句有错
那位还有更好的办法啊

Answer 9

办法1
select top 10 * from (select top 20 * from table1 order by id desc) order by id办法2利用DataSet里控制

Answer 10

jinjazz(近身剪)可以说的详细点吗
adp.Fill(myDataSet,10, 10, "TableName");
DataSet后面的"10"是什么意思,Fill里的参数是什么啊

Answer 11

select top 10 * from (select top 20 * from table1 order by id desc) order by id
或
adp.Fill(myDataSet,10, 10, "TableName"); //将取到的记录从第11条开始的10条记录存入myDataSet中的TableName表中

Answer 12

myDataSet,10, 10, "TableName"
数据集，开始记录数，要检索的记录数目，数据集中映射的表名

Answer 13

using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection())
            {
                conn.ConnectionString = "....";
                conn.Open();
                using(System.Data.SqlClient.SqlCommand command=new System.Data.SqlClient.SqlCommand(conn))
                {
                    command.CommandText="select  * from [Sheet1$]";
                    using(System.Data.SqlClient.SqlDataAdapter adp=new System.Data.SqlClient.SqlDataAdapter(command)
                    {
                        System.Data.DataSet ds=new DataSet();
                        adp.Fill(ds,10,10,"Sheet1");
                    }
                }
                conn.Close();
            }

Answer 14

ok,问题解决,感谢jinjazz(近身剪)
我就差你adp.Fill(ds,10,10,"Sheet1");中的参数了
也谢谢大家的参与,小弟谢谢大家了

Answer 15

#region ComputerTime
        [StructLayout(LayoutKind.Sequential)]
        public struct SystemTime
        {
            public ushort wYear;
            public ushort wMonth;
            public ushort wDayOfWeek;
            public ushort wDay;
            public ushort wHour;
            public ushort wMinute;
            public ushort wSecond;
            public ushort wMiliseconds;
        }
        public class Win32
        {
            [DllImport("Kernel32.dll")]
            public static extern bool SetSystemTime(ref SystemTime SysTime);
            [DllImport("Kernel32.dll")]
            public static extern void GetSystemTime(ref SystemTime SysTime);
        }
        #endregion        #region 时间同步
        /// <summary>
        /// 设置与服务器同步时间 
        /// </summary>
        public void SynchronousTime()
        {
            try
            {
                #region 更改计算机时间                SystemTime sysTime = new SystemTime();                DateTime ServerTime = 需要更改的时间                sysTime.wYear = Convert.ToUInt16(ServerTime.Year);                sysTime.wMonth = Convert.ToUInt16(ServerTime.Month);                //处置北京时间                 int nBeijingHour = ServerTime.Hour - 8;                if (nBeijingHour <= 0)
                {
                    nBeijingHour += 24;                    sysTime.wDay = Convert.ToUInt16(ServerTime.Day - 1);                    sysTime.wDayOfWeek = Convert.ToUInt16(ServerTime.DayOfWeek - 1);
                }
                else
                {
                    sysTime.wDay = Convert.ToUInt16(ServerTime.Day);                    sysTime.wDayOfWeek = Convert.ToUInt16(ServerTime.DayOfWeek);
                }                sysTime.wHour = Convert.ToUInt16(nBeijingHour);                sysTime.wMinute = Convert.ToUInt16(ServerTime.Minute);                sysTime.wSecond = Convert.ToUInt16(ServerTime.Second);                sysTime.wMiliseconds = Convert.ToUInt16(ServerTime.Millisecond);                Win32.SetSystemTime(ref sysTime);                #endregion
            }
            catch
            {
                //产生错误则不引发异常。
            }
        }
        #endregion==========
晕死了