mercredi 26 août 2015

why doesn't this piece of code make a table?

i am new to using c# and sqlite. now i am using these two together and I try to figure out why this code isn't working.

    private void button1_Click(object sender, EventArgs e)
    {
        using (SQLiteConnection con = new SQLiteConnection(connectionString))
        {
            try
            {
                string createTableQuery = @"CREATE TABLE User (userName NOTNULL varchar(40), passWord NOTNULL varchar(40))";
                SQLiteCommand cmd = new SQLiteCommand();
                cmd.CommandText = createTableQuery;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }  
        }

    }

Aucun commentaire:

Enregistrer un commentaire