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

11-14-2004

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

11-14-2004

Pratik Gupte wrote:
> 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).

--

Jos

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples	jayeshsorathia@gmail.com	ASP .Net	0	08-28-2012 07:53 AM
INSERT DATA OF MY DATATABLE INTO TABLE OF A SQL DATABASE	Rod	ASP .Net	0	10-27-2006 11:41 AM
How to Insert into new table, then delete from old table	D	ASP .Net	3	09-03-2006 07:58 AM
Tools to extract data from SQL database and convert it into XML & insert XML data into SQL databases	Harry Zoroc	XML	1	07-12-2004 10:10 PM
Changing a html table when new data is entered into SQL table.	Renie83	ASP General	1	07-09-2003 03:30 PM