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

Discussion in 'ASP .Net' started by Pratik Gupte, Nov 14, 2004.

  1. Pratik Gupte

    Pratik Gupte Guest

    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 Gupte, Nov 14, 2004
    #1
    1. Advertising

  2. Pratik Gupte

    Jos Guest

    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
     
    Jos, Nov 14, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Harry Zoroc
    Replies:
    1
    Views:
    946
    Gregory Vaughan
    Jul 12, 2004
  2. fumade
    Replies:
    1
    Views:
    522
    alwin
    Jul 14, 2006
  3. Rod
    Replies:
    0
    Views:
    441
  4. Milsnips
    Replies:
    6
    Views:
    2,035
    Milsnips
    Nov 17, 2006
  5. Vijaya Lakshmi
    Replies:
    1
    Views:
    570
    Thomas Phaneuf
    Aug 9, 2007
Loading...

Share This Page