I keep getting Unhandled Exception Error-System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'FROM'

I keep getting Unhandled Exception Error-System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'FROM'

namespace WindowsFormsApp2
{
    public partial class Form1 : Form
    {

        public Form1()
        {
            InitializeComponent();

        }

        private void Form1_Load(object sender, EventArgs e)
        {
            Load += new EventHandler(button1_Click);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=xxx.xxx.xxx.xxx; Database=ddddd; User ID=uuuuuu; Password=pppppppp");
            SqlDataAdapter sda = new SqlDataAdapter("SELECT COUNT * FROM [Log_Users] WHERE [UserName] = '"+textBox1.Text+"' AND PASSWORD = '"+textBox2.Text+"'",con);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            if (dt.Rows[0][0].ToString() == "1")
            {
                this.Hide();
                Main ss = new Main();
                ss.Show();
            }

        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}