一个SQL问题!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Question

String StrQDepartmentId = "select departmentid from department where 部门名称='" +myDDNewDepartment.SelectedValue.ToString() + "'" and  unitid=NewUnit;这句的正确语法应该怎么写?!!!

Answer 1

String StrQDepartmentId = "select departmentid from department where 部门名称='" +myDDNewDepartment.SelectedValue.ToString() + "' and  unitid=NewUnit";如果NewUnit是列名的话...

Answer 2

NewUnit是已经赋值的变量.unitid是列名

Answer 3

以下是全部代码:DropDownList myDDNewUnit = DetailsViewMove.FindControl("DropDownListNewUnit") as DropDownList;
        string connectionString = ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString;
        SqlConnection myConnection = new SqlConnection(connectionString);
        myConnection.Open();
        String StrQ= "select unitid from unit where 单位名称='" + myDDNewUnit.SelectedValue.ToString()+"'";
        SqlCommand myCommand = new SqlCommand(StrQ, myConnection);
        SqlDataReader myReader = myCommand.ExecuteReader();
        string NewUnit = myReader[0].ToString();                
        DropDownList myDDNewDepartment = DetailsViewMove.FindControl("DropDownListNewDepartment") as DropDownList;
        SqlCommand myCommand1 = new SqlCommand(SQLconn, myConnection);
        SqlDataReader myReader1 = myCommand.ExecuteReader();
        String StrQDepartmentId = "select departmentid from department where 部门名称='" +myDDNewDepartment.SelectedValue.ToString() + "'" and  unitid=NewUnit;

Answer 4

String StrQDepartmentId = "select departmentid from department where 部门名称='" +myDDNewDepartment.SelectedValue.ToString() + "' and  unitid='" + NewUnit "'";

Answer 5

具体错误代码贴出来string NewUnit = myReader.ToString();

Answer 6

应该是这个样子的
String StrQDepartmentId = "select departmentid from department where 部门名称='" +myDDNewDepartment.SelectedValue.ToString() + "' and  unitid='" + NewUnit.ToString()  + "'";