小白研究了登录页面~但提示System.Data.SqlClient.SqlException: '=' 附近有语法错误。

Question

问了度娘，说一般是SQL代码问题~但我的代码放在SQL里运行没毛病啊！求大神和大佬给看看是哪里出的问题！！！跪谢了~using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Configuration;public partial class Admin_AdminLogin : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {    }
    protected void AdminButton1_Click(object sender, EventArgs e)
    {
        string UserName = this.TextBox1.Text;                                             //获取账号
        string Password = this.TextBox2.Text;                                             //获取密码
        SqlConnection conn = new SqlConnection();                                         //创建数据库连接对象
        conn.ConnectionString = @"server=.;uid=sa;pwd=123456;database=ASP.NET_project;";  //SQL的连接字串
        conn.Open();                                                                      //打开数据库连接
        SqlCommand sqlComGet = new SqlCommand();                                                                             //创建SqlCommand对象
        sqlComGet.Connection = conn;                                                                                         //用sqlCon初始化SqlCommand对象
        sqlComGet.CommandText ="select username from AdminTable='"+UserName+ "'select password from AdminTable='"+Password+"'";         //说明查询内容
        SqlDataReader sqlDr = sqlComGet.ExecuteReader();                                                                     //创建SqlDataReader对象
        if (sqlDr.Read())                                                                                  //帐号和密码正确
        {
            Session["UserName"] = UserName;                                          //用Session记录帐号
            Session["UserPwd"] = Password;                                           //用Session记录密码
            Response.Redirect("Admin/AdminIndex.aspx");                              //跳转页面
        }
        else                                                                                               //帐号或密码错误
        {
            this.Response.Write("<script language='javascript'>alert('登录失败！！!');history.back();</script>");
        }
        conn.Close();//数据库关闭
    }
}

Answer 1

很明显SQL语法错了   重新查验下吧

Answer 2

sql =》  select username,password from admintable where username='"+username+"' and password ='"+password+"'

Answer 3

from admintable where username=

Answer 4

"select username from AdminTable='"+UserName+ "'select password from AdminTable='"+Password+"'"
这是什么sql……
"select * from AdminTable where userName = @UserName and password=@Password"
//拼接写法
"select * from AdminTable where userName = '"+UserName +"' and password='"+Password+"'"

Answer 5

sql语句错了  表名后面怎么能等于字段呢 少写了字段