read only sql database in c#

Question

hi
i have program in windows application c# with sql server and i can read and write on database but when i make my program setup
my database change to read only and i cannot insert any data

Answer 1

It may depend on your setup. Database access can be controlled by permissions so I'd check user and login permissions as well as role membership. Read only would suggest permissions are only granted for SELECT

Also for localdb check the file attribute, if it's not set to read only once deployed.

Answer 2

INSERT INTO database_table_name(field1,field2...) VALUES(value1,value2...), make sure that you entered a good database name on connection.

Answer 3

i do that but nothing happend

Answer 4

can you screenshot your program or just write some lines

Answer 5

my program in c# well running with no error but when i make it setup my database change to read-only and i use ado to connect my pro with sql

Answer 6

i thing the error can be in data source and my code data source =(localdb)\v11.0 and try data source=(localdb)\mssqllocaldb