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();
}
