當(dāng)我傳遞列表的字符串版本時，我的代碼不會從測試數(shù)據(jù)庫表返回任何行，但如果我直接傳遞列表成員，它會返回行。當(dāng)我使用消息框顯示字符串 joinedSerialsList 時，它的格式似乎正確。// Create comma delimited list of serials:int currentSerial = beginning;List<string> serialsList = new List<string>();for (int i = 0; i < count; i++){ serialsList.Add(currentSerial.ToString()); currentSerial++;}string joinedSerialsList = string.Format("({0})", string.Join(", ", serialsList));OleDbConnection connection = BadgeDatabaseDB.GetConnection();string checkStatement = "SELECT SerialNumber, OrderNumber " + "FROM SerialNumbersMFG " + "WHERE SerialNumber IN (@List)";OleDbCommand command = new OleDbCommand(checkStatement, connection);command.Parameters.AddWithValue("@List", joinedSerialsList);string duplicateSerials = "";try{ connection.Open(); OleDbDataReader dataReader = command.ExecuteReader(); if (dataReader.Read()) { duplicateSerials += dataReader["OrderNumber"].ToString() + "\n"; }}catch (OleDbException ex) { throw ex; }finally { connection.Close(); }return duplicateSerials;
1 回答
瀟瀟雨雨
TA貢獻(xiàn)1833條經(jīng)驗(yàn) 獲得超4個贊
我重寫了你的樣本，這項(xiàng)工作：
private IEnumerable<string> getData()
{
// Create comma delimited list of serials:
int currentSerial = 4452; // your constant
var serialsList = new List<int>();
var count = 100;
for (int i = 0; i < count; i++)
serialsList.Add(currentSerial++);
var connString = getConnectionString();
var results = new List<string>();
string sqlSelect = $"SELECT SerialNumber, OrderNumber FROM SerialNumbersMFG WHERE SerialNumber IN ({string.Join(",", serialsList)})";
using (var connection = new SqlConnection(connString)) // BadgeDatabaseDB.GetConnection();
{
using (var command = new SqlCommand(sqlSelect, connection))
{
connection.Open();
var dataReader = command.ExecuteReader();
while (dataReader.Read())
results.Add(dataReader["OrderNumber"].ToString());
}
}
return results;
}
- 1 回答
- 0 關(guān)注
- 121 瀏覽
添加回答
舉報
0/150
提交
取消