Member Avatar for ak2ktech

Dear Friends,
i host a website and use visual web developer for aspx ...
i want to create a form , in which users will aftre logging to my page enter 10-12 fields and that will be appended in a backend database on my server eg MS Access... please suggest..

  • 3 Contributors
  • 2 Replies
  • 116 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mail2saion
Member Avatar for ericstenson

Dear Friends,
i host a website and use visual web developer for aspx ...
i want to create a form , in which users will aftre logging to my page enter 10-12 fields and that will be appended in a backend database on my server eg MS Access... please suggest..

Hire a web developer.

Member Avatar for mail2saion 
using System.Data.ADO;
// setting up the onnection strng
public const string DB_CONN_STRING = 
        "Driver={Microsoft Access Driver (*.mdb)}; "+
        "DBQ=D:\\CS\\TestDbReadWrite\\SimpleTest.mdb";

After that

ADOConnection conn = new ADOConnection(DB_CONN_STRING);
 conn.Open();

//NOW INSERT
String sSQLCommand = "INSERT INTO Person (Age, FirstName, 
                             Description, Updated)  " +
                         "VALUES( 55, 'Bob', 'Is a Penguin', 
                             '2001/12/25 20:30:15' );";
    // Create the command object by using your text input

    ADOCommand cmdAdder = new ADOCommand(
        sSQLCommand,
        DB_CONN_STRING);
    cmdAdder.ActiveConnection.Open();
    // Execute the SQL command

    int nNoAdded = cmdAdder.ExecuteNonQuery();

HOPE NOW YOU CAN INSERT DATA.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.