想把datatable綁定到dataviewgrid中
DataSet ds = kdcmpy.GetList(wherestr); DataTable dt = new DataTable(); retunPage page = new retunPage(); //每頁顯示50;
page.PAGESIZE = 50;
page.PAGEDS = ds;
page.topage(); //分页信息开始设置 //当前页面处理 if (nowpage<1)
{
nowpage = 1; }
pagesize = 50; //每页显示 allsize = ds.Tables[0].Rows.Count; //所有记录 allpage = (int)Math.Ceiling((double)((double)allsize / (double)pagesize)); //总页数 if (allpage < nowpage)
{
nowpage = allpage;
} //添加page列
// MessageBox.Show(allpage.ToString()); txt_nowpage.Items.Clear();
for (int i = 1; i <= allpage; i++)
{
txt_nowpage.Items.Add(i); //添加页的值 } txt_nowpage.SelectedIndex = nowpage-1; //设第一页 dt.Columns.Add("是否列印"); dt.Columns.Add("列印", typeof(System.Windows.Forms.CheckBox)); //這個值列地址無法實現
dt.Columns.Add("公司名");
dt.Columns.Add("統編號");
dt.Columns.Add("地址"); //从ds开始的记录for_start,到for_start结束的记录 for (int i = for_start; i < for_end; i++)
{ dr = dt.NewRow();
dr[0] = "否";
CheckBox chebox = new CheckBox();
chebox.Name = "print"; chebox.Checked = true;
chebox.CheckState = CheckState.Checked;
dr[1] = chebox; //這裡寫了好幾天,都無法寫成
dr[2] = ds.Tables[0].Rows[i]["compchinesename"].ToString();
dr[3] = ds.Tables[0].Rows[i]["compno"].ToString();
dr[4] = ds.Tables[0].Rows[i]["compCity"].ToString() + ds.Tables[0].Rows[i]["comparea"].ToString() + ds.Tables[0].Rows[i]["compadd"].ToString(); dt.Rows.Add(dr);
}
DataSet ds = kdcmpy.GetList(wherestr); DataTable dt = new DataTable(); retunPage page = new retunPage(); //每頁顯示50;
page.PAGESIZE = 50;
page.PAGEDS = ds;
page.topage(); //分页信息开始设置 //当前页面处理 if (nowpage<1)
{
nowpage = 1; }
pagesize = 50; //每页显示 allsize = ds.Tables[0].Rows.Count; //所有记录 allpage = (int)Math.Ceiling((double)((double)allsize / (double)pagesize)); //总页数 if (allpage < nowpage)
{
nowpage = allpage;
} //添加page列
// MessageBox.Show(allpage.ToString()); txt_nowpage.Items.Clear();
for (int i = 1; i <= allpage; i++)
{
txt_nowpage.Items.Add(i); //添加页的值 } txt_nowpage.SelectedIndex = nowpage-1; //设第一页 dt.Columns.Add("是否列印"); dt.Columns.Add("列印", typeof(System.Windows.Forms.CheckBox)); //這個值列地址無法實現
dt.Columns.Add("公司名");
dt.Columns.Add("統編號");
dt.Columns.Add("地址"); //从ds开始的记录for_start,到for_start结束的记录 for (int i = for_start; i < for_end; i++)
{ dr = dt.NewRow();
dr[0] = "否";
CheckBox chebox = new CheckBox();
chebox.Name = "print"; chebox.Checked = true;
chebox.CheckState = CheckState.Checked;
dr[1] = chebox; //這裡寫了好幾天,都無法寫成
dr[2] = ds.Tables[0].Rows[i]["compchinesename"].ToString();
dr[3] = ds.Tables[0].Rows[i]["compno"].ToString();
dr[4] = ds.Tables[0].Rows[i]["compCity"].ToString() + ds.Tables[0].Rows[i]["comparea"].ToString() + ds.Tables[0].Rows[i]["compadd"].ToString(); dt.Rows.Add(dr);
}
this.dataGridView1.DataSource = dt;
//调整宽度
this.dataGridView1.Columns[0].Width = 80;
this.dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dataGridView1.Columns[1].Width = 60; // this.dataGridView1.Columns[1]. this.dataGridView1.Columns[2].Width = 165;
this.dataGridView1.Columns[4].Width = 300; txt_pageinfo.Text = "總共有" + page.ALLCOUNT + "條記錄,當前第1/" + page.ALLPAGE.ToString() + "頁";