Abdu Abdul

Abdu Abdul

  • 1.8k
  • 349
  • 4.3k

Insert data into column base on satisfying condition

Jan 20 2022 2:35 PM

I have a table structured below called time

name 1 2 3 4

and a datagridview structured below

name value
sani 1
sani 2
sani 3
sani 4
   

expected outcome

name 1 2 3 4
sani 1 2 3 4

i want an SQL command that save the data into MySQl table using DataGridview as the specifying column

when ever am saving it should loop through the DatGridView and save base on specifying column. i can save the data from DataGridview to Database. Let say what am saving is SANI with 3, then it should check for column 3 and save the data. 

Thank you in ADVANCE


Answers (1)