C#执行带参数sql问题
System.Collections.Hashtable paramsHashTable = new System.Collections.Hashtable();
paramsHashTable.add("AA",DataTime.Now);
OleDbCommand command = this.getCommand(procedureName, this.connection);
command.CommandType = CommandType.StoredProcedure;
IDictionaryEnumerator enumerator = paramsHashTable.GetEnumerator();
while (enumerator.MoveNext()) {
OleDbParameter parameter = new OleDbParameter(enumerator.Key.ToString(), enumerator.Value);
command.Parameters.Add(parameter);
}
为什么上面那样写不行?