DataGridView显示数据库数据的问题

[snying555]

在数据库中设定了一个字段用于是否显示在，valid=1显示在DataGridView数据表中，valid=0不显示
在DataGridView数据表中，右键改变valid值时，当有多条数据的时候，都能正常修改数据库，修改后也不显示在DataGridView数据表中，但就是当DataGridView数据表中数据只有一条时，操作能正常修改数据库，但datagridview却还显示它。

[snying555]

private void dgvData3_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e) {//右键选中dgvData3当前行当前项 if (e.Button == MouseButtons.Right) { dgvData3.ClearSelection(); dgvData3.Rows[e.RowIndex].Cells[e.ColumnIndex].Selected = true; dgvData3.CurrentCell = dgvData3.Rows[e.RowIndex].Cells[e.ColumnIndex]; } } private void contextMenuStrip3_Opening(object sender, CancelEventArgs e) { startPosition = Cursor.Position; } private void toolStripMenuItem6_Click(object sender, EventArgs e) { DataGridView.HitTestInfo ti; Point p = dgvData3.PointToClient(startPosition); //坐标转换 ti = dgvData3.HitTest(p.X, p.Y); try { if (dgvData3.Rows.Count <= 0) return; string descr = dgvData3.Rows[ti.RowIndex].Cells["Descr"].Value.ToString(); string alarmID = dgvData3.Rows[ti.RowIndex].Cells["ID"].Value.ToString(); string sql = "update DT_AlarmData "; sql += " set Valid = '0' "; sql += " where ID = '" + alarmID + "'"; Define.Database.ExecuteNonQuery(sql, null); LoadData(); } catch (Exception ex) { } } ************************************************** public void LoadData() { //装载数据 try { string sql = "select DT_Area.ID, DT_Area.AName"; sql += ",isnull((select SUM(MNP + ANP) from DT_Park where AID=DT_Area.ID),0) as SMNP"; sql += ",isnull((select SUM(CNP) from DT_Park where AID=DT_Area.ID),0) as SCNP from DT_Area"; DataTable table = Define.Database.ExecuteDataTable(sql, null); Define.AddGridRow(dgvData1, table, _Fields1, 0); sql = "select ID, AType, ATime, Descr from DT_AlarmData "; sql += " where Valid = '1' "; table = Define.Database.ExecuteDataTable(sql, null); pageControl2.SourceData = table; } catch (Exception ex) { Public.Dialog.Common.ShowDialog("装载数据时出错：" + ex.Message, "错误", MessageBoxIcon.Error); } }

[maige_2861038031]

DataGridView显示数据库数据示例 //DataGridView控件显示数据库数据 public DataTable GetDate() { string P_Connection = string.Format(//创建数据库连接字符串 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb;User Id=Admin"); OleDbDataAdapter P_DataAdapter = new OleDbDataAdapter(//创建数据适配器对象 @"select id as 编号,Name as 名称,Begin as 开始时间, Factory as 配件厂家名称,Phone as 电话,Address as 联系地址 from [tb_Ware] inner join [tb_Number] on [tb_Ware].Number=[tb_Number].Number", P_Connection); DataTable dt = new DataTable();//创建数据表 P_DataAdapter.Fill(dt);//填充数据表 return dt;//返回数据表 }//CodeGo.net/ //绑定显示数据信息事件 private void btn_Get_Click(object sender, EventArgs e) { dgv_Message.DataSource = new DataTier().GetDate();//绑定到数据表 }

[exception92]

修改 之后 让 datagridView 失去焦点，你没有结束它的编辑状态。