Hi,

I am experiencing an error when I call a SP that requires a string parameter.

I am using mmToolStripComboBox to select among a couple of filtering criteria for rows in my DataGridView.

I can run the SP from SQL Management Studio with no problmes but if I call the SP from my Biz Object I get the following error:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

I am enclosing the stack Trace just in case.

A second question is: How can I bind the mmToolStripComboBox to a Biz object?

Thanks in advance for you advice.


Stack Trace
====================================================================================
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at System.ThrowHelper.ThrowArgumentOutOfRangeException()
at System.Collections.Generic.List`1.get_Item(Int32 index)
at OakLeaf.MM.Main.Windows.Forms.mmBindingStrategyBase.RemoveBindingSourceDataTable(Control control, DataTable dt)
at OakLeaf.MM.Main.Windows.Forms.mmBindingStrategyDataGrid.BindData(ImmBindingDataGrid mmGrid, DataSet ds, String tableName, mmBusinessObject bizObj)
at OakLeaf.MM.Main.Windows.Forms.mmBindingStrategyDataGrid.BindData(ImmBindingDataGrid mmGrid, mmBusinessObject bizObj, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Windows.Forms.mmBindingStrategyDataGrid.BindData(ImmBindingDataGrid mmGrid, mmBaseBusinessObject bizObj, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Windows.Forms.mmDataGridView.OnBindData(mmBaseBusinessObject bindingSource, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Windows.Forms.mmUIHelper.StateChangeHandlerGrid(Control control, mmBaseBusinessObject bizObj, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Windows.Forms.mmDataGridView.StateChangeHandler(mmBaseBusinessObject bizObj, mmBusinessStateChangeEventArgs e)
at OakLeaf.MM.Main.Business.mmBusinessObject.OnStateChange(mmBusinessState bizState, String tableName, Object primaryKeyValue, Object[] primaryKeyValues)
at OakLeaf.MM.Main.Business.mmBusinessObject.CallStateChange(mmBusinessState bizState, String tableName, DataRow dr)
at OakLeaf.MM.Main.Business.mmBusinessObject.CallStateChange(mmBusinessState bizState, String tableName)
at OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.GetEntityList(String command, String databaseKey, CommandType cmdType, IDbDataParameter[] cmdParams)
at OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.GetEntityList(String command, String databaseKey, IDbDataParameter[] cmdParams)
at OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.GetEntityList(String command, IDbDataParameter[] cmdParams)
at Target.ProTrack.Business.CellDevice.GetCellDevicesByTypeName(String CellDeviceTypeName) in D:\Data\DevProjects08\ProTrack Business Objects\CellDevice\CellDevice.Partial.cs:line 28
at Target.ProTrack.WinApp.CellDevicesListForm.tscTCellDeviceTypeName_SelectedIndexChanged(Object sender, EventArgs e) in D:\Data\DevProjects08\ProTrack\ProTrackWinApp\CellDevicesListForm.cs:line 63
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ToolStripComboBox.HandleSelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.SendMessage(HandleRef hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at System.Windows.Forms.Control.SendMessage(Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.Control.ReflectMessageInternal(IntPtr hWnd, Message& m)
at System.Windows.Forms.Control.WmCommand(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at System.Windows.Forms.NativeWindow.DefWndProc(Message& m)
at System.Windows.Forms.Control.DefWndProc(Message& m)
at System.Windows.Forms.Control.WmCommand(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at Target.ProTrack.WinApp.AppMainEntry.Main() in D:\Data\DevProjects08\ProTrack\ProTrackWinApp\Main.cs:line 43
=====================================================================================