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

  • Thread starter Thread starter Pratik Gupte
  • Start date Start date
P

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
 
Pratik said:
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
Click to expand...

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).
 
Back
Top