insert into datagridview to sql dynamic column name using SQL Parameter

Asked Mar 22 '20 at 08:42

Active Mar 22 '20 at 08:56

Viewed 34 times

Is there a way to prevent sql from crashing using the answer in the link below Insert from datagridview to SQL with dynamic column names

wanted to prevent sql injection as per link SqlCommand Parameters vs. String.Format

edited Mar 22 '20 at 08:56

marc_s

asked Mar 22 '20 at 08:42

hussein0987654

Define "crashing"? What are you seeing? What code are you using? What is your scenario? – Marc Gravell Mar 22 '20 at 08:55
i am using the 1st link code error is as follows System.Data.SqlClient.SqlException: 'Incorrect syntax near 'ENTREPRISES'. – hussein0987654 Mar 22 '20 at 16:08

0 Answers0