如何用SqlCommand执行连接查询。

[严志]

string constr = @"data source=.\sqlexpress;initial catalog = HR;user id =sa;password=123456";
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = constr;
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
string query = "select b.cEmployeeCode,b.vFirstName,b.vAddress, a.vDepartmentName";
query += " from dbo.Department a join dbo.Employee b";
query += " on a.cDepartmentCode = b.cDepartmentCode ";
query += "where a.vDepartmentName ='@Sales'";
cmd.CommandText = query; SqlParameter sql = new SqlParameter("@Sales", SqlDbType.VarChar,25); ///
sql.Value = this.textBox1.Text.Trim();
cmd.Parameters.Add(sql);
cmd.CommandType = CommandType.Text; ////
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
string address = dr.GetString(dr.GetOrdinal("a.vDepartmentName"));
MessageBox.Show("地址是：" + address);
this.textBox2.Text = address;
}
dr.Close();
}
}
}

可以提供代码参考吗：有请发送至：[e-mail]

[严志]

谢谢光临。顶

[Andy__Huang]

string constr = @"data source=.\sqlexpress;initial catalog = HR;user id =sa;password=123456";
using (SqlConnection conn = new SqlConnection())
{
    conn.ConnectionString = constr;
    conn.Open();
    using (SqlCommand cmd = conn.CreateCommand())
    {
        string query = "select b.cEmployeeCode,b.vFirstName,b.vAddress, a.vDepartmentName";
        query += " from dbo.Department a join dbo.Employee b";
        query += " on a.cDepartmentCode = b.cDepartmentCode ";
        query += "where a.vDepartmentName ='@Sales'";
        cmd.CommandText = query;   
        cmd.Parameters.Add("@Sales", SqlDbType.VarChar,25).Value = this.textBox1.Text.Trim();   --->改为这一行就可以了     
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            string address = dr.GetString(dr.GetOrdinal("a.vDepartmentName"));
            MessageBox.Show("地址是：" + address);
            this.textBox2.Text = address;
        }
        dr.Close();
    }
}

[是_这样吗]

[严志]

谢谢。