110,499
社区成员
发帖
与我相关
我的任务
分享
DataSet thisDataSet = new DataSet();
OleDbDataAdapter thisAdapter=new OleDbDataAdapter ("Select 收支,金额,支出原因,备注 from InOutCome",thisConnection);
thisAdapter.Fill(thisDataSet);
dataGridView_test.DataSource = thisDataSet.Tables[0];
DataGridViewComboBoxColumn col = new DataGridViewComboBoxColumn();
col.DataSource = dtClass;
col.DataPropertyName = "cid";
col.DisplayMember = "cname";
col.ValueMember = "cid";
this.dataGridView1.Columns.Add(col);
this.dataGridView1.DataSource = dtStudent;
this.dataGridView1.AutoGenerateColumns = false;
//数据源创建,这个要你自己的数据源。我是随便写的。
DataTable dt = new DataTable("t1");
dt.Columns.Add("InorOut");
dt.Columns.Add("Money");
for (int i = 0; i < 20; i++)
{
DataRow dr = dt.NewRow();
dr["InorOut"] = "0";
dr["Money"] = "10" + i;
dt.Rows.Add(dr);
}
//创建收入、支出列表
DataTable dtInorOut = new DataTable("dtInorOut");
dtInorOut.Columns.Add("Id");
dtInorOut.Columns.Add("InorOut");
DataRow dr0 = dtInorOut.NewRow();
dr0["Id"] = "0";
dr0["InorOut"] = "收入";
dtInorOut.Rows.Add(dr0);
DataRow dr1 = dtInorOut.NewRow();
dr1["Id"] = "1";
dr1["InorOut"] = "支出";
dtInorOut.Rows.Add(dr1);
//创建ComboBox列
DataGridViewComboBoxColumn colInorOut = new DataGridViewComboBoxColumn();
colInorOut.DataSource = dtInorOut;
colInorOut.DataPropertyName = "InorOut";
colInorOut.DisplayMember = "InorOut";
colInorOut.ValueMember = "Id";
this.dataGridView1.Columns.Add(colInorOut);
//创建Money列
DataGridViewTextBoxColumn colMoney = new DataGridViewTextBoxColumn();
colMoney.DataPropertyName = "Money";
this.dataGridView1.Columns.Add(colMoney);
this.dataGridView1.DataSource = dt;