.Net 多表查询 @参数怎么处理

[SmailSwallow]

select C.ClothesTypeCode,C.ClothesTypeName,C.ClothesTypePicture,L.LaundryTypeCode,C.TS,C.DR
from LR_ClothesType C left join LR_LaundryType L on C.LaundryTypeCode=L.LaundryTypeCode

---我要使用参数 这么处理？where LaundryTypeCode=@LaundryTypeCode;
高手帮忙，谢谢！

[whb147]

存储过程吗？

[huangwenquan123]

sqlparameter[] para = {new sqlparameter("@LaundryTypeCode",sqldbtype.int,4)};
para[0].value="你的参数";
sqldatareader dr = cmd.executereader(sql,para);

[ds252743641]

 SqlCommand command = new SqlCommand();
        command.Parameters.Add(new SqlParameter("@LaundryTypeCode", "你的值"));
        SqlDataReader reader = command.ExecuteReader();

[天下在我心]

参数一样可以用啊
where LaundryTypeCode=@LaundryTypeCode
要指定表名，这样
where C.LaundryTypeCode=@LaundryTypeCode;
然后参数赋值一样用法

[种草德鲁伊]

和多少个表没关系的，表和参数名没联系。

[kongdelu2008]

按3楼的办法就可以了，祝楼主早日搞定！呵呵

[若-相惜]

一个表和多个表一样的

[哥子谭]

SqlConnection conn = new SqlConnection("server=.;database=test;uid=sa;pwd=pwd");
SqlCommand cmd= new SqlCommand("select * from userinfo",conn);
cmd.Parameters.Add(new SqlParameter("@LaundryTypeCode", "你的值"));
SqlDataAdapter sda = new SqlDataAdapter();
sda.selectedCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dtTable = ds.Tables[0];

[panchunlong]

建立视图不行吗

[guyoujing]

例：
SqlCommand cm = new SqlCommand();
cm.Connection = cn;
cm.CommandType = CommandType.Text;
cm.CommandText = "select Password,Role from Login where uID=@uID";
cm.Parameters.AddWithValue("uID", "你的值"); SqlDataReader dr = cm.ExecuteReader();

[SmailSwallow]

"select C.ClothesTypeCode,C.ClothesTypeName,C.ClothesTypePicture,L.LaundryTypeCode,C.TS,C.DR "+
" from LR_ClothesType C left join LR_LaundryType L on C.LaundryTypeCode=@LaundryTypeCode";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@LaundryTypeCode",laundrycode)
};
---谢谢大家\(^o^)/~ 调试通过了...

[SmailSwallow]

为什么我前台绑定不上数据信息呢，空白~ 汗...
帮帮忙... 谢谢~！
-----------------------------
public void GridViewBind()
{


indexcode = this.ddlLaundryType.SelectedValue; // 得到洗衣类型


LR_MiddlePrice lr_middlepric = LR_MiddlePriceManager.findLR_MiddlePriceByLanudryTypecode(indexcode);//得到衣服价格信息
lr_clothestypelist = LR_ClothesTypeManager.findLR_ClothesTypeByLaundryCode(indexcode); // 根据 洗衣 类型 code 得到衣服类型---list
LR_ClothesType lr_clothesType = LR_ClothesTypeManager.findLR_ClothesTypeByClothesTypeCode(lr_middlepric.ClothesTypeCode);// 根据 衣服类型 code 得到衣服类型信息

DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new DataColumn("图片", typeof(string)));
dt.Columns.Add(new DataColumn("类型名称", typeof(string)));
dt.Columns.Add(new DataColumn("价格", typeof(float)));
dt.Columns.Add(new DataColumn("选择", typeof(CheckBox)));
for (int i = 0; i < lr_clothestypelist.Count; i++)
{
dr = dt.NewRow();
dr[0] = lr_clothesType.ClothesTypePicture;
dr[1] = lr_clothesType.ClothesTypeName;
dr[2] = lr_middlepric.LaundryPrice;
dr[3] = new CheckBox();
dt.Rows.Add(dr);
}
gvwLanudyr.DataSource = dt;
gvwLanudyr.DataBind();

}

protected void ddlLaundryType_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewBind();
}

[sunzhi523]

以后多多交流 哦。。。