Forum Discussion

peter_zzz's avatar
peter_zzz
Copper Contributor
Apr 04, 2024

how to give my dataset the name i want in sql server management studio

hi

 

i want to pass from vb 2012 to vb 2022

everything goes fine except for the database

so i need to create the same database but for 2022

the problem is that in my project the dataset name is databaset1

how can i create a database in server management studio with the name of the dataset choosed by me

 

thanks a lot!

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 04, 2024
    Sorry, your post is very unclear and there is absolutely no relation between the Visual Studio version you are using and a somehow type of database.
    You have to describe the situation and problems more detailed.
    • peter_zzz's avatar
      peter_zzz
      Copper Contributor
      Apr 09, 2024

      olafhelper 

       

      so i will try to explain with more details what is very clear for me

      but i understand it was not for you

       

      i have a project made in 2012 visual studio

      in this project there was a internal database

       

      i converted to an external database for visual studio 2013

      in this conversion when i add a table, the new automatic dataset is called dataset11

      and the data are not saved after closing my project

       

      so i want to recrated the database from scratch but since my 2012 code was dataset1

      and the automatic conversion for external database for 2013 made a new dataset

       

      i absolutly need to recreate the database but keeping my 2012 code so the name of the dataset : dataset1 and tableadapter1

      here is the real code

      Me.ClientsTableAdapter1.Fill(Me.Database1DataSet1.Clients)

       

      so my initial question was :

      how to give my dataset the name i want in sql server management studio

       

      if the solution is not in server managment studio

      i will take the way it as to be to build a database with the name of the dataset i want to give to it

       

      thanks for your help

Resources