Datagridview update rows with Dapper

Question

I have List . i have set it as a datasource of datagridview. now how can i update datagridview rows on runtime using dapper

Sohail Zafar · Answer

very great full for your solution. sir if u could create a mini app. it will help me alot

Gautam Parmar · Answer

if you use dapper as update tools it will update into database and refresh grid will changes automatically into grid and code is using (var connection = My.ConnectionFactory()) { connection.Open(); var list = new List () { new Invoice {InvoiceID = 1 Code = Update_Many_1 } new Invoice {InvoiceID = 2 Code = Update_Many_2 } new Invoice {InvoiceID = 3 Code = Update_Many_3 } }; var isSuccess = connection.Update(list); } And If you use datagrid it will update into ui only.