How Could I Achive get dgv cells data And store to database

Question

I need to save data from datagridview to table , as table contains more columns but i showed only few columns in datagridview. The dgv fill by sending text from another device with sendkeys event . I just want that when i click "send data" button , it will get all textfileds values of dgv and store to database table and dgv needs to be clear(as i delete its contains after moving data from this table to another table). currently i get text from cells but after calling RowLeave event , i want to get text on "send data" button .

how to achive this? please help.

Sujeet Suman · Answer

Please once try below steps: Step-(01.) Bind your datagridview on form load event. Spet-(02.) On btnSendData click event follow below process: private void btnSendData _Click(object sender EventArgs e) { // Pass datagridview data to your table through command objects. // Clear your datagridview dataGridView1.Rows.Clear(); // You can also use this- dataGridView1.DataSource = null; } If this is helpful for you then please accept my Answer .