Guest User

Untitled

a guest
Jan 22nd, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.39 KB | None | 0 0
  1. "select F1,F3,F6 from [" + worksheetName + "$]", con);
  2.  
  3. cmd.Fill(excelDataSet);
  4.  
  5.  
  6. System.Data.OleDb.OleDbException was unhandled
  7. Message=No value given for one or more required parameters.
  8. Source=Microsoft Access Database Engine
  9. ErrorCode=-2147217904
  10. StackTrace:
  11. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
  12. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
  13. at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
  14. at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
  15. at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
  16. at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  17. at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  18. at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  19. at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  20. at ExcelReader.mainForm.GetWorksheet(String worksheetName) in D:PLNExcelReaderExcelReaderMain.cs:line 112
  21. at ExcelReader.mainForm.sheetsToolStripComboBox_SelectedIndexChanged(Object sender, EventArgs e) in D:PLNExcelReaderExcelReaderMain.cs:line 125
  22. at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
  23. at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
  24. at ExcelReader.mainForm.openToolStripButton_Click(Object sender, EventArgs e) in D:PLNExcelReaderExcelReaderMain.cs:line 51
  25. at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
  26. at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
  27. at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
  28. at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  29. at System.Windows.Forms.Control.WndProc(Message& m)
  30. at System.Windows.Forms.ToolStrip.WndProc(Message& m)
  31. at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
  32. at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
  33. at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
  34. at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
  35. at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
  36. at ExcelReader.Program.Main() in D:PLNExcelReaderExcelReaderProgram.cs:line 17
  37. at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
  38. at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
  39. at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
  40. at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
  41. at System.Threading.ThreadHelper.ThreadStart()
  42. InnerException:
Add Comment
Please, Sign In to add comment