getting error when inserting data into data base

hi,

I think in your table some field datatype is Varbinary and your are trying to insert string to it, that is the reason you are getting this error

for example, a1.ToString()  - here you are trying to insert image file, but you are pasing string, if you want to save string then change your table that coloumn to nvarchar

It seems one of your table column is varbinary. But your are passing string data. so it is throwing error.

 

For debugging

1. Check table structur and find the varbinary datatype

2. Convert the valure to varbinary in cmd.CommandText value.

Hello,

String concatenation for query and an inline query is not good practice, you should use stored procedure and pass proper parameters to SqlCommand and run an apporiate query.