Update Datagridview using textbox in VB.net

Question

Dear All,

I want to update all records in one column in Datagridview to the same value in textbox.

Example:

Textbox value: xxx

But in datagridview:

Column1:

xx01

xx02

xx03

so, i want to change it to be like this if i click on Button:

Column1

xxx

xxx

xxx

How to write code in VB.net?

Regards,

Ratana, Cambodia

Answer 1

Hi Ratana,

You can iterate through all DataGridView.Rows and assign the column value.

        For Each row As DataGridViewRow In DataGridView1.Rows
            row.Cells.Item("ColumName").Value = TextBox1.Text
        Next

Best Regards,

---

Bob Wu
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Thank Bob Wu-MT....my problem is sloved.

Answer 3

dear all,

Update Datagridview using textbox in VB.net

  For Each row As DataGridViewRow In DataGridView1.Rows
            row.Cells.Item("ColumName").Value = TextBox1.Text
        Next

this is my code:

    Private Sub update_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click

        For Each row As DataGridViewRow In DataGridView1.Rows
            row.Cells.Item("ArtifactCodeDataGridViewTextBoxColumn").Value = TextBox1.Text
            row.Cells.Item("NamaDataGridViewTextBoxColumn").Value = TextBox2.Text
            row.Cells.Item("NopendaftaranDataGridViewTextBoxColumn").Value = txtno.Text
            row.Cells.Item("ButiranDataGridViewTextBoxColumn").Value = txtbutiran.Text
            row.Cells.Item("DimensiLDataGridViewTextBoxColumn").Value = txtL.Text
            row.Cells.Item("DimensiPDataGridViewTextBoxColumn").Value = txtP.Text
            row.Cells.Item("KeadaanDataGridViewTextBoxColumn").Value = txtkeadaan.Text
            row.Cells.Item("DiperolehidaripadaDataGridViewTextBoxColumn").Value = txtdiperolehi.Text
            row.Cells.Item("TarikhdiperolehiDataGridViewTextBoxColumn").Value = dtpdate.Text
            row.Cells.Item("NofailberdaftarDataGridViewTextBoxColumn").Value = txtnofail.Text
            row.Cells.Item("TempatsimpanDataGridViewTextBoxColumn").Value = cbotempat.Text
            row.Cells.Item("RujukanDataGridViewTextBoxColumn").Value = txtrujukan.Text
            row.Cells.Item("TempatasalDataGridViewTextBoxColumn").Value = txtasal.Text

   Next

    End Sub

don't have error but when i update one data from textbox then when i view in datagridview
the data which is I update before this , that change to all row no 1 data that  i want to update

hope can help me...urgentt,,please..