for (int i = 0; i < dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].HeaderCell.Value = (i + 1).ToString(); }
for (int i = 0; i < dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].HeaderCell.Value = (i + 1).ToString(); //第一个问题 sum=sum + convert.todecimal( datatable.rows[i]["car_fee"]); //第二个问题 }//最后 dataGridView1.Rows.Add();DataGridViewRow row = dataGridView1.Rows[dataGridView1.Rows.Count];row.datatable.rows[i]["car_fee"] = sum;
最后一句应为row.Cells[n].Value = sum;
string ConStr = @"provider=microsoft.jet.oledb.4.0; Data Source=.\1.mdb"; OleDbConnection con = new OleDbConnection(ConStr); con.Open(); string sqlstr = "select * from tb_RenYuan"; OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, con); DataSet ds = new DataSet(); da.Fill(ds); ds.Tables[0].Columns.Add("编号"); for (int i = 0; i < ds.Tables[0] .Rows .Count ; i++) { ds.Tables[0].Rows[i]["编号"] = i + 1; }我这样能实现加入一列,并从第一行到最后N行显示编号1-N
string ConStr = @"provider=microsoft.jet.oledb.4.0; Data Source=.\1.mdb"; OleDbConnection con = new OleDbConnection(ConStr); con.Open(); string sqlstr = "select * from tb_RenYuan"; OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, con); DataSet ds = new DataSet(); da.Fill(ds); ds.Tables[0].Columns.Add("编号"); for (int i = 0; i < ds.Tables[0] .Rows .Count ; i++) { ds.Tables[0].Rows[i]["编号"] = i + 1; } ds.Tables[0].Columns["编号"].SetOrdinal(0); dataGridView1.DataSource = ds.Tables[0];加了一段:ds.Tables[0].Columns["编号"].SetOrdinal(0); 让它在第一列
直接操作datatable
datatable.cols.add("num");
decimal sum=0;
for(int i=0;i<datatable.rows.count;i++)
{
datatable.rows[i]["num"]=i+1;
sum=sum+convert.todecimal( datatable.rows[i]["car_fee"]);
}
datarow row=datatable.newrow();
row["car_fee"]=sum;
datatable.rows.add(row);
大概就是这样
{
dataGridView1.Rows[i].HeaderCell.Value = (i + 1).ToString();
}
{
dataGridView1.Rows[i].HeaderCell.Value = (i + 1).ToString(); //第一个问题 sum=sum + convert.todecimal( datatable.rows[i]["car_fee"]); //第二个问题
}//最后
dataGridView1.Rows.Add();DataGridViewRow row = dataGridView1.Rows[dataGridView1.Rows.Count];row.datatable.rows[i]["car_fee"] = sum;
OleDbConnection con = new OleDbConnection(ConStr);
con.Open(); string sqlstr = "select * from tb_RenYuan";
OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, con);
DataSet ds = new DataSet();
da.Fill(ds);
ds.Tables[0].Columns.Add("编号"); for (int i = 0; i < ds.Tables[0] .Rows .Count ; i++)
{
ds.Tables[0].Rows[i]["编号"] = i + 1;
}我这样能实现加入一列,并从第一行到最后N行显示编号1-N
OleDbConnection con = new OleDbConnection(ConStr);
con.Open(); string sqlstr = "select * from tb_RenYuan";
OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, con);
DataSet ds = new DataSet();
da.Fill(ds);
ds.Tables[0].Columns.Add("编号"); for (int i = 0; i < ds.Tables[0] .Rows .Count ; i++)
{
ds.Tables[0].Rows[i]["编号"] = i + 1;
}
ds.Tables[0].Columns["编号"].SetOrdinal(0); dataGridView1.DataSource = ds.Tables[0];加了一段:ds.Tables[0].Columns["编号"].SetOrdinal(0); 让它在第一列