none
SQL Database in VB 2015 RRS feed

  • Question

  • How to create SQL database and tables in VB 2015.(using server explorer).Please show step by step.Thanks.
    Friday, January 12, 2018 2:17 PM

Answers

  • Have not heard back from you, here is a step by step.

    With Server Explorer open.

    Right click on Data Connections, select Create new SQL Server database

    Select the server and provide a name for the database

    Press OK and we get

    Create a table by right clicking on tables

    Define the table and generate


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    • Marked as answer by sheelnath Tuesday, January 23, 2018 3:45 PM
    Saturday, January 13, 2018 2:00 AM
    Moderator

All replies

  • See the below link:

    How to: Create a SQL Server Database in Server Explorer


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Friday, January 12, 2018 2:44 PM
  • You can write T-SQL to do this 

    https://msdn.microsoft.com/en-us/library/z6sa01t4.aspx?f=255&MSPPError=-2147217396

    https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-sql-server-transact-sql

    https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites


    Friday, January 12, 2018 3:11 PM
    Moderator
  • Have not heard back from you, here is a step by step.

    With Server Explorer open.

    Right click on Data Connections, select Create new SQL Server database

    Select the server and provide a name for the database

    Press OK and we get

    Create a table by right clicking on tables

    Define the table and generate


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    • Marked as answer by sheelnath Tuesday, January 23, 2018 3:45 PM
    Saturday, January 13, 2018 2:00 AM
    Moderator
  • How to create SQL database and tables in VB 2015.(using server explorer).Please show step by step.Thanks.
    https://msdn.microsoft.com/ro-ro/library/ms233763(v=vs.120).aspx
    Saturday, January 13, 2018 3:10 AM
  • Have not heard back from you, here is a step by step.

    Karen, while I understand and appreciate your eagerness to answer all of these database questions, there are others who respond to these posts as well and I think you need to respect that. If you felt that my answer was somehow inadequate then you should have said so or complimented it with your own, as opposed to simply duplicating my answer with screenshots. :-(


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Saturday, January 13, 2018 3:35 AM
  • Have not heard back from you, here is a step by step.

    Karen, while I understand and appreciate your eagerness to answer all of these database questions, there are others who respond to these posts as well and I think you need to respect that. If you felt that my answer was somehow inadequate then you should have said so or complimented it with your own, as opposed to simply duplicating my answer with screenshots. :-(


    Paul ~~~~ Microsoft MVP (Visual Basic)

    My apologies, didn't mean to take away from your reply at all. 

    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Saturday, January 13, 2018 4:09 AM
    Moderator
  • Hi sheelnath,

    You can also take a look the following link, here are detailed steps.

    https://msdn.microsoft.com/ro-ro/library/ms233763(v=vs.120).aspx

    https://msdn.microsoft.com/en-us/library/ms239722.aspx

    Best Regards,

    Cherry


    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.

    • Proposed as answer by Stanly Fan Wednesday, January 17, 2018 7:07 AM
    Monday, January 15, 2018 5:55 AM
    Moderator