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..

Recommended Answers

All 2 Replies

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.

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.