none
Using T-SQL commands in VB.net IDE with SQL Server Object Explorer RRS feed

  • Question

  • Hello again,

    In my previous thread, my response to creating tables on the fly in ADO.NET has been impossible; in other words, its library would not provide its functions.

    Instead, I am quickly learning T-SQL, not just to mention that I have learned Database Management fundamentals in community college in 2002.  Therefore I have gained prerequisites myself.

    Here are two screenshots below that demonstrates the SQL Server Object Explorer on its left pane, the Source Code Editor in the middle, and the properties window and solution explorer on the right.

    So far this is what exactly want to accomplish. Now I have place a command button on the form.

    Clearly and hopefully, this shall give more detail.  Any assistance from users will be helpful.

    Regards,

    JohnDBCTX

    Choosing which execution type in Transact-SQL in VB.net IDE


    jp

    Tuesday, January 21, 2020 1:23 AM

All replies

  • Hi,

    Can you describe in detail the problem you are currently experiencing? This makes it easier for us to find a solution to meet your current needs.

    Best Regards,

    Julie


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, January 22, 2020 9:40 AM
    Moderator
  • Take a look at ADOX..

    btw, what is your use-case for creating tables on the fly?

    Wednesday, January 22, 2020 9:52 AM
  • Hello,

    >has been impossible

    Possible. 

    User need to be permitted to use DDL. 

    The rest work as usual. 


    Sincerely, Highly skilled coding monkey.

    Wednesday, January 22, 2020 9:58 AM
  • Well, I have this current screenshot.

    See if anyone can solve this.

    Regards,

    JohnDBCTX


    jp

    Friday, January 24, 2020 4:11 AM
  • System.Runtime.InteropServices.COMException
      HResult=0x800A0BB9
      Message=Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
      Source=Table Creator Ver. 001
      StackTrace:
       at ADODB._Recordset.Open(Object Source, Object ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)
       at Table_Creator_Ver._001.TableCreator.CreateDataGridButton_Click(Object sender, EventArgs e) in C:\Users\johnd\source\repos\Table Creator Ver. 001\TableCreator.vb:line 76
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.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(IntPtr 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 Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
       at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
       at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
       at Table_Creator_Ver._001.My.MyApplication.Main(String[] Args) in :line 81

    The errors above demonstrate how I  may be programming wrong.

    Can anyone assist me in how to solve this?

    Regards,

    JohnDBCTX


    jp

    Friday, January 24, 2020 5:10 AM