C# Syntax Error in INSERT INTO statement C#

Question

if (txtUsername.Text != "")
        {
            string q = "insert into info(Username) values ('" + txtUsername.Text.ToString() + "')";
            dosomething(q);
            txtUsername.Text = "";
        }
        else
        {
            MessageBox.Show("Please Complete the neccessary information");
        }
        if (txtPassword.Text != "")
        {
            string a = "insert into info(Password) values ('" + txtPassword.Text.ToString() + "')";
            dosomething(a);
            txtUsername.Text = "";

        }
        else
        {
            MessageBox.Show("Please Complete the neccessary information");
        }

private void dosomething(String q)
{
    try
    {
        cn.Open();
        cmd.CommandText = q;
        cmd.ExecuteNonQuery();
        cn.Close();

    }
    catch (Exception e)
    {
        cn.Close();
        MessageBox.Show(e.Message.ToString());
    }
}

Every time I run this it always show that error. I dont know how to fix it. The code should record the data i put in a textbox to ms access database. plz helpp

where have you define cn & how did you pass the connectionstring to it? — Nikita Shrivastava
– Nikita Shrivastava, Commented Sep 30, 2015 at 8:01
please include the code of the connection string in your post — dlght
– dlght, Commented Sep 30, 2015 at 8:04
cn = connection object, which you would pass the connectionstring to... read up codeproject.com/Articles/4416/… — BLoB
– BLoB, Commented Sep 30, 2015 at 8:04
I know that this is a beginner's code, but there are just so many things wrong with that... — SWeko
– SWeko, Commented Sep 30, 2015 at 8:04

Bas · Accepted Answer · 2015-09-30 08:06:54Z

2

Presumably, you've initialized cn somewhere by doing something like

cn = new SqlConnection();

You need to pass the connection string for the database to the constructor:

cn = new SqlConnection("your connection string here");

or set it sometime later, before you connect:

cn.ConnectionString = "your connection string here";

answered Sep 30, 2015 at 8:06

Bas

2,0381 gold badge22 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# Syntax Error in INSERT INTO statement C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related