saving data from datagriedviewtextboxcolumn into sql

Question

hello i have problem for creating an windows base application in c# & in my that form 3 textbox and 1 griedview & in that griedview 1 datagriedviewtextboxcolumn  and 1 datagriedviewcomboboxcolumn now how to store all data in sql from datagriedviewtextboxcolumn & datagriedviewcomboboxcolumn  and also from that 3 textbox into sql in windows applicaion

Nitin Sontakke · Answer

Hello Anurag Don't think like DataGridView -> SQL Server in a Windows Forms Application. And please DO NOT connect to the database and perform db operations in the Button_Click event method. Please try to implement some level of abstraction in the applications right from the beginning. With values from DataGridView create an appropriate class (technically that is called Model) and fill it's properties. Because you have DataGridView control you will need one sub-class and it's List as one of the properties to the main class. Pass the instance of that class to the Business layer yet another class. From there pass on that model to Data Access Layer yet another class where you will connect to the db and save the data from the model. Believe me this much level abstraction IS A MUST in any size of application in today's world.