User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 391,616 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,679 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Where is the table ????

Join Date: Jun 2006
Posts: 48
Reputation: Embeza is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
Embeza Embeza is offline Offline
Light Poster

Re: Where is the table ????

  #2  
Jun 22nd, 2006
Originally Posted by infinity4ever
hi... i create a new table with this code

Dim SQLCreate As New SqlCommand
Dim Conn As New SqlConnection
Dim DA As New SqlDataAdapter
Dim DS As New Data.DataSet

'Create DB

SQLCreate.CommandText = "CREATE TABLE test (ID integer NOT NULL)"
SQLCreate.Connection = Conn
Conn.ConnectionString = "Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RBD.mdf;Integrated
Security=True;Connect Timeout=30;User Instance=True"
DA.SelectCommand = SQLCreate
DA.Fill(DS)

the code works perfectly... but i dont know where the created table is??? when i open the sql server from Visual Studio.net 2005 it shows that the table test is there but when i close it and run microsoft sql 2005 i didn't find the table there!!!!!!!!! i restarted the pc and check again..the table is there in vs2005 but still not in microsoft sql 2005

even if i run the application and pess the button again it tells me that the table test is already there??!!!! so why it is not shown in microsoft sql server 2005??

what is the issue here? i want to save the table as a permenent table not temporary one
Hello, I am Embeza from Ethiopia.
This is my first time to this forum,

I am a begginer of database programming,

To your problem, I suggest that you add the conn.open()
conn.close() SQLCreate.dispose, DA.DataBind()(this is after the
code DA.Fill(DS)).
If i am not right please correct me
Thank you
Reply With Quote  
All times are GMT -4. The time now is 12:26 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC