Inserting into database

ZiqXx · July 1st, 2004, 07:02 AM

Hi AGAIN,

I used this code in a another program I wrote and it worked, now it doesn't... Any ideas ?

Code:

try
{
    myConnection.Open();
    Adapter1.InsertCommand.Parameters["nafn"].Value = nafnaBox.Text;
    Adapter1.InsertCommand.Parameters["heimilisfang"].Value = heimilisfangaBox.Text;
    Adapter1.InsertCommand.Parameters["simi"].Value = simaBox.Text;
    Adapter1.InsertCommand.Connection = myConnection;
    Adapter1.InsertCommand.ExecuteNonQuery();
    myConnection.Close();
}
catch (Exception)
{
    MessageBox.Show("Some catch going on");
}

planoie · July 1st, 2004, 09:30 AM

How doesn't it work? Error messages? Can you provide more details?

ZiqXx · July 1st, 2004, 09:31 AM

It just went into the catch branch, so I took out the try & catch and saw the error message and realized I was missing the @ sign infront of the parameter names.... sry

planoie · July 1st, 2004, 09:43 AM

Aha! See my response was to help you trouble shoot the problem, using the old adage "if you give a man a fish...".

(Actually, I missed the @s myself!

)

ZiqXx · July 1st, 2004, 09:45 AM

yeah you got me thinking in the right direction, thanks alot for your time, I appriciate it alot, I am learning so much and so quickly, just started messing around with Visual programming a week ago, have quite a good experiance in the old C++ console programming....

melvik · July 3rd, 2004, 03:24 AM

I suggest to use catch part as

Code:

catch (Exception Ex)
{
    MessageBox.Show(Ex.Message);
}

to see what is the problem & solve it.

Keep in touch...

Always:),
Hovik Melkomian.

ZiqXx · July 5th, 2004, 04:13 AM

Will do, thanks for the tip