#region  论文专著及教材
            WritingAndDissertation wad = new WritingAndDissertation();//论文
            DataSet dat = wad.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "WDID");            ScienceProduction spd = new ScienceProduction();//专著
            DataSet dst = spd.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "ProductionID");            TeachingBook tb = new TeachingBook();//教材
            DataSet det = tb.GetAllDynamicFromView("ReportID='" + strReportID.ToString() + "'", "ID");
            int count = dat.Tables[0].Rows.Count + dst.Tables[0].Rows.Count + det.Tables[0].Rows.Count;
            wh.GoToBookMark("论文专著");//获取论文的书签
            if (count <= 5)
            {
                //论文
                if (dat != null && dat.Tables.Count > 0 && dat.Tables[0].Rows.Count > 0)
                {
                    int i = 0;
                    foreach (DataRow dr in dat.Tables[0].Rows)
                    {
                        i++;
                        wh.InsertText(i.ToString());//插入数据
                        wh.MoveNextCell();//移动到下一单元格
                        wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["WDTitle"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["Publisher"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["AuthorOrder"].ToString());
                        wh.MoveNextRow();//移动到下一行                    }                }
                //著作                if (dst != null && dst.Tables.Count > 0 && dst.Tables[0].Rows.Count > 0)
                {
                    int i = dat.Tables[0].Rows.Count;
                    foreach (DataRow dr in dst.Tables[0].Rows)
                    {                        i++;
                        wh.InsertText(i.ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["ProductionName"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["Organization"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["AuthorOrder"].ToString());
                        wh.MoveNextRow();                    }
                }
                //教材                if (det != null && det.Tables.Count > 0 && det.Tables[0].Rows.Count > 0)
                {
                    int i = dat.Tables[0].Rows.Count + dst.Tables[0].Rows.Count;
                    foreach (DataRow dr in det.Tables[0].Rows)
                    {
                        i++;
                        wh.InsertText(i.ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["Name"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["Organization"].ToString());
                        wh.MoveNextCell();
                        wh.InsertText(dr["AuthorOrder"].ToString());
                        wh.MoveNextRow();
                    }
                }
            }
            #endregion
这段代码是王Word文档书签里插入数据,Word文档里有一个表格
比如说 
序号   论文专著教材   完成人顺序
论文,专著,教材分别属于三个表
现在的问题是,这三个表的数据总条数不确定啊,我只想去前五条,怎么弄啊,帮帮忙,各位大侠!最好写几句代码

解决方案 »

  1.   

                    if (dat != null && dat.Tables.Count > 0 && dat.Tables[0].Rows.Count > 0)
                    {
                        int i = 0;
                        foreach (DataRow dr in dat.Tables[0].Rows)
                        {
                            i++;
                            wh.InsertText(i.ToString());//插入数据
                            wh.MoveNextCell();//移动到下一单元格
                            wh.InsertText(dr["PublishYear"].ToString() + "." + dr["PublishMonth"].ToString());
                            wh.MoveNextCell();
                            wh.InsertText(dr["WDTitle"].ToString());
                            wh.MoveNextCell();
                            wh.InsertText(dr["Publisher"].ToString());
                            wh.MoveNextCell();
                            wh.InsertText(dr["AuthorOrder"].ToString());
                            wh.MoveNextRow();//移动到下一行
                               if (i > 5) break;
                        }                }
      

  2.   

    select top 5 from biao取前5条