Insert (SQL) won't work! Yet, I have no error message

DaveRook

Hi

I am trying to do a basic insert into an Access database (I have done this via MSSQL before and it was fine). I have done this with asp.old and no problems.

I am now using Access 2007 and C#.

Expand|Select|Wrap|Line Numbers

 
string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Domains\xxx.com\App_Data\customers.accdb; Persist Security Info=False;";
 
string strInsert = "INSERT INTO Customers ([FirstName], [LastName], [EmailAddress]) VALUES ('FN', 'LN', 'Email@email.com')";
 
        OleDbConnection oleConn = new OleDbConnection();

        OleDbCommand oleCmd = new OleDbCommand();

        OleDbDataAdapter oleDA = new OleDbDataAdapter();
 
        oleCmd.CommandText = strInsert;

        oleCmd.CommandType = CommandType.Text;

        oleCmd.Connection = oleConn;

        oleConn.ConnectionString = strConn;
 
        oleDA.SelectCommand = oleCmd;
 
        oleConn.Open();
 
         Response.Redirect("website.aspx");

I run the page and click the button which runs the code above! I know it's getting to the end as the redirect works!! My database does not alter!

It's almost as if it's ignored everything! What have I done wrong! I know I must have missed something!

Teme64

I'm not a C# programmer but

Expand|Select|Wrap|Line Numbers

oleDA.SelectCommand = oleCmd;

seems a bit suspicious if you try to do insert. Shouldn't you use:

Expand|Select|Wrap|Line Numbers

oleDA.InsertCommand = oleCmd;

Teme64 @ windevblog.blogspot.com

DaveRook

Hi

Thank you for the suggestion, but sadly this did not solve it!

Thank you again though

MrMancunian

Quote:

Originally Posted by Teme64

I'm not a C# programmer but

Expand|Select|Wrap|Line Numbers

oleDA.SelectCommand = oleCmd;

seems a bit suspicious if you try to do insert. Shouldn't you use:

Expand|Select|Wrap|Line Numbers

oleDA.InsertCommand = oleCmd;

Teme64 @ windevblog.blogspot.com

I agree with Teme64 :-)

Furthermore, you will have to execute the query. All you did now was telling oleDA what his command was. Open the database, execute the query (oleDA.InsertCommand.ExecuteNonQuery(); or something) and close the database again.

That should do the trick :-)

DaveRook

Thank you everyone

The code I was missing was

oleDA.InsertCommand = oleCmd;
oleCmd.ExecuteNonQuery();

Thank you everyone for helping! Beers on me :)

Insert (SQL) won't work! Yet, I have no error message

re: Insert (SQL) won't work! Yet, I have no error message

re: Insert (SQL) won't work! Yet, I have no error message

re: Insert (SQL) won't work! Yet, I have no error message

re: Insert (SQL) won't work! Yet, I have no error message

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about