datagridview动态绑定以及显示行号转载

//动态绑定

OleDbConnection conn;

conn.Open();
string strSelect = string.Format(@"select productname ,supplier ,typename ,number  from materials ");
OleDbDataAdapter dap = new OleDbDataAdapter(strSelect, conn);
DataSet ds = new DataSet();
dap.Fill(ds, "materials");

if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow aRow = ds.Tables[0].Rows[i];
int rwindex = dataGridView1.Rows.Add();
dataGridView1.Rows[rwindex].Cells[0].Value = aRow["productname"].ToString();
dataGridView1.Rows[rwindex].Cells[1].Value = aRow["typename"].ToString();
dataGridView1.Rows[rwindex].Cells[2].Value = aRow["supplier"].ToString();
dataGridView1.Rows[rwindex].Cells[3].Value = aRow["number"].ToString();
}
}
conn.Close();

//显示行号

private void dataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
{
using (SolidBrush b = new SolidBrush(dataGridView1.RowHeadersDefaultCellStyle.ForeColor))
{
int linen = 0;
linen = e.RowIndex + 1;
string line = linen.ToString();
e.Graphics.DrawString(line, e.InheritedRowStyle.Font, b, e.RowBounds.Location.X, e.RowBounds.Location.Y + 5);
SolidBrush B = new SolidBrush(Color.Red);
}
}