0

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
3
Views
8 Years
Discussion Span
Last Post by mail2saion
0

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.

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.