how to INSERT data into a table in SQL express2005 using ASP.Net2.0

[Pratik Gupte]

I have created a database in .mdf format, but I am unable to insert data
into its tables. Can anybody help how to insert data using ASP.Net 2.0 using
SQL Server 2005 Express edition in windows integrated security mode.
thx

 

[Jos]

I have created a database in .mdf format, but I am unable to insert
data into its tables. Can anybody help how to insert data using
ASP.Net 2.0 using SQL Server 2005 Express edition in windows
integrated security mode.
thx

1) Add the ASPNET user as a login to SQL Server
2) Add the login as a database user to your database
3) Give the database user the INSERT permission to the table(s).