Sql insert values

[suruchi120294 (Suruchi Kangutkar)]

getting this error while inserting the values into database

[Manjuts90]

@suruchi120294 can u share database connection string and sql statement

[suruchi120294 (Suruchi Kangutkar)]

@Manjuts90
this is the connectio string:- “Data Source=LAPTOP-SDNQHKA1;Initial Catalog=user;Integrated Security=True”

[Manjuts90]

@suruchi120294 is connection string is correct? since i am not sure about ur connection string.

[suruchi120294 (Suruchi Kangutkar)]

@Manjuts90 yes it is correct . The select query is working properly but only insert query is giving this error.

[Manjuts90]

@suruchi120294 can u share insert query?

[PrankurJoshi]

See this -

Exception while inserting datatable into database using execute non query

Hello, I am getting exception as “cannot create and populate list type System.data.sqlclient.sqlerrorcollection” while inserting datatable into database using execute non query activity.

Issue while using Database Insert Activity

Hi, I am using Database Insert activity to insert the datatable values to database table, but it is throwing an error like “cannot create and populate list type System.data.sqlclient.sqlerrorcollection” [image] Please help to solve this issue. Thanks.

[suruchi120294 (Suruchi Kangutkar)]

got the output tysm @Manjuts90

[suruchi120294 (Suruchi Kangutkar)]

@PrankurJoshi tysm got the output