DataTable table = new DataTable("Customers"); 

table.Rows[0].Delete();

table.AcceptChanges();

DataTable workTable = new DataTable("Customers");


DataRow workRow = workTable.NewRow();

workRow["CustLName"] = "Smith";

workRow[1] = "Smith";

workTable.Rows.Add(workRow);


workTable.AcceptChanges(); 

        SQLiteConnection cn = new SQLiteConnection(Form1.dbQuery); 

        cn.Open();

        string SQL;

        SQL = "SELECT users_id, name, username, place FROM users";

        SQLiteCommand cmd = new SQLiteCommand(SQL, cn);

        SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);

        DataSet ds = new DataSet();

        da.Fill(ds);

        DataTable dt = ds.Tables[0];

        this.grid_userlist.DataSource = dt;

        cn.Close();