將數(shù)據(jù)庫(kù)中的內(nèi)容存到dataGridView的items中

string sqlCommandString = "select * from LvXin";
 //利用 Adapter 轉(zhuǎn)換結(jié)果到 datagrid
 // DataSet ds = new DataSet();
SQLiteCommand command = new SQLiteCommand(sqlCommandString, dbConnection);
 try
            {
                dbConnection.Open();
                DataTable dt = new DataTable();
              //使用adapter轉(zhuǎn)換結(jié)果到datagrid
                SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqlCommandString, dbConnection);
                adapter.Fill(dt);
                //將查詢結(jié)果綁定到combox控件
                for(int i =0; i<dt.Rows.Count;i++)
                {
                    comboBox_Type.Items.Add(dt.Rows[i]["TypeName"]);//將數(shù)據(jù)庫(kù)中字段為“TypeName的那一列讀出來(lái)”
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show("數(shù)據(jù)庫(kù)連接錯(cuò)誤");
            }        

使用遍歷方法可以將datagridView中的原始數(shù)據(jù)保存

//將dt中的所有元素存入對(duì)應(yīng)的gridbiew中
    dataGridView1.DataSource = dt;
    dataGridView1.Columns["類型"].DataPropertyName = dt.Columns["TypeName"].ToString();
    dataGridView1.Columns["高度"].DataPropertyName = dt.Columns["Height"].ToString();
    dataGridView1.Columns["寬度"].DataPropertyName = dt.Columns["Width"].ToString();//因?yàn)橹贿x了ID, NAME所以dt沒有相關(guān)數(shù)據(jù)
    dataGridView1.Columns["長(zhǎng)度"].DataPropertyName = dt.Columns["Lenth"].ToString();

從datagridview中刪除一個(gè)數(shù)據(jù)庫(kù)中的值

  //獲取datagridview控件中的值
            try
            {
                //選中要?jiǎng)h除的記錄
              string Name = dataGridView1.CurrentRow.Cells[1].Value.ToString();
                CSQLiteHelper.delete(Init_Class.tableName1, Name);
                MessageBox.Show("刪除成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show("請(qǐng)選中要?jiǎng)h除的記錄！");
            }

將dataGridView中第一列的值加上索引

  private void dataGridView2_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
        {
            using (SolidBrush b = new SolidBrush(
               dataGridView2.RowHeadersDefaultCellStyle.ForeColor))
            {
                e.Graphics.DrawString((e.RowIndex + 1).ToString(
                        System.Globalization.CultureInfo.CurrentCulture),
                        dataGridView2.DefaultCellStyle.Font
                        , b, e.RowBounds.Location.X + 20, e.RowBounds.Location.Y + 4);
            }