Sql命令中的通陣列參數(shù)我試圖像下面這樣在C#中將數(shù)組參數(shù)傳遞給SQLCommnd，但它不起作用。以前有人見過嗎？string sqlCommand = "SELECT * from TableA WHERE Age IN (@Age)";SqlConnection sqlCon = new SqlConnection(connectString);SqlCommand sqlComm = new SqlCommand();sqlComm.Connection = sqlCon;sqlComm.CommandType = System.Data.CommandType.Text;sqlComm.CommandText = sqlCommand;sqlComm.CommandTimeout = 300;sqlComm.Parameters.Add("@Age", SqlDbType.NVarChar);StringBuilder sb = new StringBuilder();foreach (ListItem item in ddlAge.Items){ if (item.Selected) { sb.Append(item.Text + ","); }}sqlComm.Parameters["@Age"].Value = sb.ToString().TrimEnd(',');
3 回答
PIPIONE
TA貢獻1829條經(jīng)驗 獲得超9個贊
int[] ages = { 20, 21, 22 }; // could be any common list-like typevar rows = connection.Query<YourType>(
"SELECT * from TableA WHERE Age IN @ages",
new { ages }).ToList();- 3 回答
- 0 關(guān)注
- 396 瀏覽
添加回答
舉報
0/150
提交
取消