Insert form data with DataGridView rows to Database using C# and VB.Net in Windows Forms Application

Question

How to add form value and Datagrid value to be saved in database in C

Indresh · Accepted Answer

Hi  sujayanandI have created sample code which fullfill your requirement So please refer the below code and modify as per your requirementCprivate void BindProduct    DataTable dt  new DataTable    dtColumnsAdd34SrNo34    dtColumnsAdd34Product34    dtColumnsAdd34Rate34    dtColumnsAdd34Discount34    dtColumnsAdd34Price34    DataRow dr  dtNewRow    dataGridView1DataSource  dtprivate void button1Clickobject sender EventArgs e    object id    string constring  34Data SourceSQL2005Initial CatalogtestUser id  sapasswordpass12334    using SqlConnection con  new SqlConnectionconstring            using SqlCommand cmd  new SqlCommand34INSERT INTO Invoice ValuesDateInoviceEstimateNoName34  34SELECT SCOPEIDENTITY34 con                    cmdCommandType  CommandTypeText            cmdParametersAdd34Date34 SqlDbTypeDateTimeValue  txtDateText

Insert form data with DataGridView rows to Database using C# and VB.Net in Windows Forms Application

Company

Explore

Follow us

Contact Us