如何从grideview获取单元格值 [英] how to take cells value from grideview

问题描述

我有一个gridview1控件
我想通过gridview1更新数据库中的数据
当我单击添加按钮时，所选行将转换为编辑模式
但是当我以
查询时

I have one gridview1 control
I want to update data in database through gridview1
when i click on add button the selected row get converted into edit mode
but when i fire query as

cmd = new SqlCommand("update " + Label7.Text + " set " + ds1.Tables[0].Columns[i].ColumnName + "='" + GridView1.Rows[0].Cells[i].Text + "' where " + ds1.Tables[0].Columns[0].ColumnName + "='" + GridView1.Rows[0].Cells[0].Text + "'", con);

实际值未插入数据库中，仅在数据库中添加了空值
如何在gridview1中添加值

请给我任何解决方案

the actual value is not inserted in database ,only null value get added i database
how can i add values in gridview1

Plz suggest me any solution

推荐答案

我认为您可以使用类型化的数据集来简化此操作.

1:将数据库添加到ur Project
2:然后从数据源"中拖动ur表以赢得表格(在Datagridview表格中).
3:然后以goto Form1.cs(F7)的形式加载删除

hi i think u can use typed Dataset that will make it easy.

1 : add database to ur Project
2 : then from Data Sources drag ur table to win form (in Datagridview form).
3 : then in goto Form1.cs (F7) form load delete

private void Form1_Load(object sender, EventArgs e)
        {           
     delete this line>>>>>>>>  this.datos_de_estudiantesTableAdapter.Fill
(this.control_de_EstudiantesDataSet.Datos_de_estudiantes);

}

4:然后在您的保存按钮点击功能中使用自动生成的代码

4 : then use automatic generated code in ur save button click function

private void datos_de_estudiantesBindingNavigatorSaveItem_Click(object sender, EventArgs e)
       { 
Use this code>>>>>>>>>>>>> 
 this.Validate();
 this.datos_de_estudiantesBindingSource.EndEdit();                 this.tableAdapterManager.UpdateAll(this.control_de_EstudiantesDataSet);
 this.datos_de_estudiantesTableAdapter.Fill(this.control_de_EstudiantesDataSet.Datos_de_estudiantes);

       }

5:希望能帮助您

5 : hope helping u

这篇关于如何从grideview获取单元格值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！