三种表格题

表格打分题:

 protected void Page_Load(object sender, EventArgs e)
    {
        //行值数组
        string[] RowData ={ "选项描述1", "选项描述2", "选项描述3" };
        //选项数组
        string[] ColumnData ={ "选项1", "选项2", "选项3" };

        //使用例子
        ShowTablePQ(RowData, ColumnData);
    }

    //显示表格打分题
    public void ShowTablePQ(string[] RowData, string[] ColumnData)
    {
        //动态添加GridView控件
        Panel1.Controls.Clear();

        //添加选项描述列
        GridView GridView1 = new GridView();
        BoundField bf = new BoundField();
        //bf.HeaderText="SD";
        bf.DataField = "SD";
        GridView1.AutoGenerateColumns = false;
        GridView1.Columns.Add(bf);

        //添加模板列
        for (int l = 0; l < ColumnData.Length; l++)
        {
            TemplateField customField1 = new TemplateField();
            customField1.ShowHeader = true;
            customField1.HeaderTemplate = new GridViewTemplate(DataControlRowType.Header, ColumnData[l].ToString());
            customField1.ItemTemplate = new GridViewTemplate(DataControlRowType.DataRow, "");
            GridView1.Columns.Add(customField1);
        }
        //绑定数据源
        GridView1.DataSource = CreateDataSource(RowData);
        GridView1.DataBind();

        Panel1.Controls.Add(GridView1);

    }
    //创建表格视图
    public DataView CreateDataSource(string[] RowData)
    {
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add("SD");

        for (int i = 0; i < RowData.Length; i++)
        {
            dr = dt.NewRow();
            dr[0] = RowData[i].ToString();
            dt.Rows.Add(dr);
        }
        DataView dv = new DataView(dt);
        return dv;

    }

    public class GridViewTemplate : ITemplate
    {
        private DataControlRowType templateType;
        private string columnName;

        public GridViewTemplate(DataControlRowType type, string colname)
        {
            templateType = type;
            columnName = colname;
        }
        //模板列
        public void InstantiateIn(System.Web.UI.Control container)
        {
            switch (templateType)
            {
                case DataControlRowType.Header:
                    Literal lc = new Literal();
                    lc.Text = columnName;
                    container.Controls.Add(lc);
                    break;
                case DataControlRowType.DataRow:
                 
                        DropDownList drr = new DropDownList();
                        //drr.ID = "dropdown";
                        drr.AppendDataBoundItems = true;
                        drr.Items.Add(new ListItem("--请打分--", "0"));
                        drr.Items.Add(new ListItem("1", "1"));
                        drr.Items.Add(new ListItem("2", "2"));
                        drr.Items.Add(new ListItem("3", "3"));
                        drr.Items.Add(new ListItem("4", "4"));
                        drr.Items.Add(new ListItem("5", "5"));
                        drr.Items.Add(new ListItem("6", "6"));
                        drr.Items.Add(new ListItem("7", "7"));
                        drr.Items.Add(new ListItem("8", "8"));
                        drr.Items.Add(new ListItem("9", "9"));
                        drr.Items.Add(new ListItem("10", "10"));
                        container.Controls.Add(drr);
               
                    break;
                default:
                    break;
            }
        }
    }
 --------------------------------
 表格单选题:
 
   protected void Page_Load(object sender, EventArgs e)
    {
        //行值数组
        string[] RowData ={ "选项描述1", "选项描述2", "选项描述3" };
        //选项数组
        string[] Selection ={ "有", "没有", "不知道" };

        //使用例子
        ShowTableSQ(RowData, Selection);

    }


    //显示表格多选题
    public void ShowTableSQ(string[] RowData, string[] Selection)
    {
        //动态添加GridView控件
        Panel1.Controls.Clear();

        GridView GridView1 = new GridView();
       
        //添加选项描述列

        BoundField bf = new BoundField();
        //bf.HeaderText="SD";
        bf.DataField = "SD";
        GridView1.AutoGenerateColumns = false;
        GridView1.Columns.Add(bf);


  
        //添加模板列
        for (int l =0;l<Selection.Length; l++)
        {
            TemplateField customField1 = new TemplateField();
            customField1.ShowHeader = true;
            customField1.HeaderTemplate = new GridViewTemplate(DataControlRowType.Header, Selection[l].ToString());
            customField1.ItemTemplate = new GridViewTemplate(DataControlRowType.DataRow, "");
            GridView1.Columns.Add(customField1);
        
        }

        //绑定数据源
        GridView1.DataSource = CreateDataSource(RowData);
    
        GridView1.DataBind();
   
        Panel1.Controls.Add(GridView1);

    }
    //创建表格视图
   
    public DataView CreateDataSource(string[] RowData)
    {
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add("SD");

        for (int i = 0; i < RowData.Length; i++)
        {
            dr = dt.NewRow();
            dr[0] = RowData[i].ToString();
            dt.Rows.Add(dr);
        }
        DataView dv = new DataView(dt);
        return dv;
    }

    public class GridViewTemplate : ITemplate
    {
        private DataControlRowType templateType;
        private string columnName;

        public GridViewTemplate(DataControlRowType type, string colname)
        {
            templateType = type;
            columnName = colname;
        }
        //模板列
        public void InstantiateIn(System.Web.UI.Control container)
        {
            switch (templateType)
            {
                case DataControlRowType.Header:
                    Literal lc = new Literal();
                    lc.Text = columnName;
                    container.Controls.Add(lc);
                    break;
                case DataControlRowType.DataRow:
                
                        RadioButton rb = new RadioButton();
                        rb.ID = "rb";
                        rb.Checked = false;
                        container.Controls.Add(rb);
           
                    break;
                default:
                    break;
            }
        }
    }
   
 --------------------------
 表格多选题:
 
   protected void Page_Load(object sender, EventArgs e)
    {
        //行值数组
        string[] RowData ={ "选项描述1", "选项描述2", "选项描述3" };
        //选项数组
        string[] Selection ={ "选项1", "选项2", "选项3" };

        //使用例子
        ShowTableMQ(RowData, Selection);

    }


    //显示表格多选题
    public void ShowTableMQ(string[] RowData, string[] Selection)
    {
        //动态添加GridView控件
        Panel1.Controls.Clear();

        GridView GridView1 = new GridView();


        //添加选项描述列

        BoundField bf = new BoundField();
        //bf.HeaderText="SD";
        bf.DataField = "SD";
        GridView1.AutoGenerateColumns = false;
        GridView1.Columns.Add(bf);

        //添加模板列
        for (int l = 0; l < Selection.Length; l++)
        {
            TemplateField customField1 = new TemplateField();
            customField1.ShowHeader = true;
            customField1.HeaderTemplate = new GridViewTemplate(DataControlRowType.Header, Selection[l].ToString());
            customField1.ItemTemplate = new GridViewTemplate(DataControlRowType.DataRow, "");
            GridView1.Columns.Add(customField1);
        }
        //绑定数据源
        GridView1.DataSource = CreateDataSource(RowData);
        GridView1.DataBind();

        Panel1.Controls.Add(GridView1);

    }
    //创建表格视图
    public DataView CreateDataSource(string[] RowData)
    {
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add("SD");

        for (int i = 0; i < RowData.Length; i++)
        {
            dr = dt.NewRow();
            dr[0] = RowData[i].ToString();
            dt.Rows.Add(dr);
        }
        DataView dv = new DataView(dt);
        return dv;
    }

    public class GridViewTemplate : ITemplate
    {
        private DataControlRowType templateType;
        private string columnName;

        public GridViewTemplate(DataControlRowType type, string colname)
        {
            templateType = type;
            columnName = colname;
        }
        //模板列
        public void InstantiateIn(System.Web.UI.Control container)
        {
            switch (templateType)
            {
                case DataControlRowType.Header:
                    Literal lc = new Literal();
                    lc.Text = columnName;
                    container.Controls.Add(lc);
                    break;
                case DataControlRowType.DataRow:
                 
                        CheckBox cb = new CheckBox();
                        //cb.ID = "checkbox";
                        cb.Checked = false;
                        container.Controls.Add(cb);
                    
                   

                    break;
         
                default:
                    break;
            }
        }
    } 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
1.将工作表Sheet1复制到Sheet2,并将Sheet2更名为“职工工资表”; 2.在“职工工资表”中用公式求出每人的应发数和实发数(应发数=固定工资+浮动工资+各种津贴,实发数=应发数-扣除); 3.将“职工工资表”中各职工姓名“加粗,居中”,并以“实发数”降序排列表格内容; 4.根据“职工工资表”的“姓名”和“实发数”创建一“簇状柱形图”,显示在区域A13:H22,要求以“实发数示意图”为图表标。 帮助: 1.选择Sheet1中A1:G8间的全部内容,再单击“编辑”→“复制”,再将光标移到Sheet2的A1单元格,单击“编辑”→“粘贴”,再用鼠标双击工作表标签Sheet2,并在上面输入“职工工资表”,然后按回车键即可。 2.选择“职工工资表”中的E3单元格,并输入“=B3+C3+D3”并按回车键,再将光标移到E3单元格右下角的“句柄”,然后按住鼠标左键拖到E8,再在G3单元格中输入“=E3-F3”并按回车键,再将光标移到G3单元格右下角的“句柄”,然后按住鼠标左键拖到G8即可。 3.选择“职工工资表”中A3:A8单元格,单击“格式”→“单元格”,在“字体”选项卡的“字形”栏中选择“加粗”,在“对齐”选项卡的“水平对齐”栏中选择“居中”,再将光标移到其他数据区域内,单击“数据”→“排序”,在弹出窗口的“主要关键字”中选择“实发数”,并选择排列顺序为“递减”,单击“确定”。 4.在“职工工资表”中选择“姓名”和“实发数”数据,即A2:A8及G2:G8,单击“插入”→“图表”,在“图表类型”中选择“柱形图”,在“子图表类型”中选择“簇状柱形图”,单击“完成”,并在选中图表的情况下单击“图表”→“图表选项”,在“标”选项卡的“图表标”栏中输入“实发数示意图”,单击“确定”,再将图表通过拖动和缩放,显示在区域A13:H22。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值