private void button4_Click(object sender, EventArgs e) { dgv2.DataSource = DBMaker.GetCity(); //禁止列排序 for (int i = 0; i < dgv2.Columns.Count; i++) { dgv2.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } //锁定列头高 dgv2.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //锁定行头宽 dgv2.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; //设定行头宽 dgv2.RowHeadersWidth = 30; //禁止调整行高 dgv2.AllowUserToResizeRows = false; //禁止调整列高 dgv2.AllowUserToResizeColumns = false; }
private void button1_Click(object sender, EventArgs e) { #region 生成DataGridView列 并设置 { DataGridViewComboBoxColumn col = new DataGridViewComboBoxColumn(); col.HeaderText = "城市名称"; col.Name = "城市名称"; col.DataSource = DBMaker.GetCity(); col.DisplayMember = "txtName"; col.ValueMember = "Id"; dgv1.Columns.Add(col); } #endregion #region 填充DataGridViewComboBoxColumn { DataGridViewComboBoxColumn col = dgv1.Columns[0] as DataGridViewComboBoxColumn; col.HeaderText = "城市名称"; col.Name = "城市名称"; col.DataSource = DBMaker.GetCity(); col.DisplayMember = "txtName"; col.ValueMember = "Id"; } #endregion }
private void btnGroup_Click(object sender, EventArgs e) { rptGroup doc = new rptGroup(); DataTable dt = DBMaker.学生成绩表(); doc.SetDataSource(dt); crystalReportViewer1.ReportSource = doc; }
private void btnList_Click(object sender, EventArgs e) { rptList doc = new rptList(); DataTable dt = DBMaker.人员表(); doc.SetDataSource(dt); crystalReportViewer1.ReportSource = doc; }
private void btnGroup_Click(object sender, EventArgs e) { DataTable dt = DBMaker.学生成绩表(); reportViewer1.Reset(); reportViewer1.LocalReport.DataSources.Clear(); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetScore_学生成绩", dt)); reportViewer1.LocalReport.ReportEmbeddedResource = "AboutReport.RDLC.rptGroup.rdlc"; reportViewer1.RefreshReport(); }
private void btnList_Click(object sender, EventArgs e) { DataTable dt = DBMaker.人员表(); reportViewer1.Reset(); reportViewer1.LocalReport.DataSources.Clear(); reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetOffice_人员表", dt)); reportViewer1.LocalReport.ReportEmbeddedResource = "AboutReport.RDLC.rptList.rdlc"; reportViewer1.RefreshReport(); }
private void btnByDataSet_Click(object sender, EventArgs e) { DataTable dt = DBMaker.文章表(); reportViewer1.Reset(); reportViewer1.LocalReport.DataSources.Clear(); //DataSet名_表名 reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetArticles_Articles", dt)); reportViewer1.LocalReport.ReportEmbeddedResource = "AboutReport.RDLC.rptDataSet.rdlc"; reportViewer1.RefreshReport(); }
private void Form1_Load(object sender, EventArgs e) { dataGridView1.DataSource = DBMaker.GetListMyClass(); dataGridView1.DataSource = DBMaker.GetDataTable(); dataGridView1.DataSource = DBMaker.GetDataTable().DefaultView; BindingSource bs = new BindingSource(); bs.DataSource = DBMaker.GetDictionary(); dataGridView1.DataSource = bs; dataGridView1.DataSource = DBMaker.GetList().Select(p => (new { 内容 = p })).ToList(); dataGridView1.DataSource = DBMaker.GetDictionary().Select(p => (new { 编号 = p.Key, 内容 = p.Value })).ToList(); }
private void btnParentChild_Click(object sender, EventArgs e) { rptParent doc = new rptParent(); DataSet ds = new DataSet(); ds.Tables.Add(DBMaker.班级表()); ds.Tables.Add(DBMaker.学生表()); ds.Tables[0].TableName = "班级"; ds.Tables[1].TableName = "学生"; doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; }
void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e) { e.DataSources.Add(new ReportDataSource("DataSetStudent_学生", DBMaker.学生表())); }
private void btnParentChild_Click(object sender, EventArgs e) { reportViewer1.Reset(); reportViewer1.LocalReport.ReportEmbeddedResource = "AboutReport.RDLC.rptParent.rdlc"; reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSetStudent_班级", DBMaker.班级表())); reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing); this.reportViewer1.RefreshReport(); }