saving data from datagriedviewtextboxcolumn into sql

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
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.