[arkatec]

I have a form that I'm trying to add to a database. It runs ok, but it's not inserting a row into my SQL server database. Where am I going wrong?

private void btnMemberAdd_Click(object sender, EventArgs e)
        {
            using (SqlConnection cs = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\CapitalCity107.mdf;Integrated Security=True;User Instance=True"))
            {
                using (SqlCommand insert = cs.CreateCommand())
                {

                    insert.CommandText = "INSERT INTO members (Salutation, FirstName, MInitial, LastName, Address1, Address2, City, State, Zip, HomePhone, MobilePhone, Email, DOB, DateRaised) VALUES (@Salutation, @FirstName, @MInitial, @LastName, @Address1, @Address2, @City, @State, @Zip, @HomePhone, @MobilePhone, @Email, @DOB, @DateRaised)";

                    insert.Parameters.AddWithValue("@Salutation",salutationBox.SelectedItem);
                    insert.Parameters.AddWithValue("@FirstName", txtBoxFName.Text);
                    insert.Parameters.AddWithValue("@MInitial", txtBoxInitial.Text);
                    insert.Parameters.AddWithValue("@LastName", txtBoxLName.Text);
                    insert.Parameters.AddWithValue("@Address1", txtBoxAddress1.Text);
                    insert.Parameters.AddWithValue("@Address2", txtBoxAddress2.Text);
                    insert.Parameters.AddWithValue("@City", txtBoxCity.Text);
                    insert.Parameters.AddWithValue("@State", stateBox.SelectedItem);
                    insert.Parameters.AddWithValue("@Zip", txtBoxZip.Text);
                    insert.Parameters.AddWithValue("@HomePhone", txtBoxHomePhone.Text);
                    insert.Parameters.AddWithValue("@MobilePhone", txtBoxMobilePhone.Text);
                    insert.Parameters.AddWithValue("@Email", txtBoxEmail.Text);
                    insert.Parameters.AddWithValue("@DOB", Convert.ToDateTime(txtBoxBirth.Text));
                    insert.Parameters.AddWithValue("@DateRaised",Convert.ToDateTime(txtBoxRaised.Text));

                    cs.Open();
                    insert.ExecuteNonQuery();
                    cs.Close();

                    MessageBox.Show("Entry Added");

             }
            }
        }

MOD EDIT: When posting code...USE CODE TAGS!!!

This post has been edited by JackOfAllTrades: 19 February 2011 - 09:02 AM

[CodingSup3rnatur@l-360]

Hi,

Where is your .mdf file located? If isn't in the bin/debug folder of your project, try moving it to that folder and run the code again. I had a bizarre problem with an update statement ages ago...

The problem in that instance was the 'Copy to Output Directory' of the database... If moving to the debug folder makes a difference, it is likely that it is the value of that property that is causing the problem, and you need to change it to something other than 'Copy Always'

This post has been edited by CodingSup3rnatur@l-360: 19 February 2011 - 08:32 AM

[arkatec]

It worked!!! Thanks alot. This issue had been driving me crazy.

[JackOfAllTrades]

If you post code again, please obey the rules and USE CODE TAGS!!!



If that's too complicated, see the first link in my signature.

[arkatec]

It has happened again. No matter what I set the Copy to Output Directory property to it, or if I move the .mdf file to the bin directory. It still won't show that I've inserted a row into the database.