-
Nov 28th, 2015, 09:48 AM
#1
The design surface is !Loading
Hey all,
I've decided to move some of my vb.net stuff to web app and am simply noodling around in ASP for the time.
In VS2013, I've created a VS web form application which created a number of files and default pages for a site. OK good, that's a great start.
I need a database so I right clicked the project and added one (Add New Item > Data > SQL Server Database). A prompt opened up telling me it should be placed in the App_Data folder; ok fine I clicked ok and now I have a database file in my project.
The database shows up in the server explorer as Dtabase1.mdf, and when I click on it, I can connect to it. When I try to add a table though, the IDE simple hangs with a message ("Loading... The design surface is loading.") It never loads (most of the time). In 2 days, I've had 2 attempts when I was actually able to modify or create a table. With both of those instances, VS ended up crashing and restarting. After that I can't add or modify any tables.
Does anyone have any insight to this problem?
I have read this but beyond that I haven't found much on google that relates.
thanks
Kevin
Process control doesn't give you good quality, it gives you consistent quality.
Good quality comes from consistently doing the right things.
Vague general questions have vague general answers. A $100 donation is required for me to help you if you PM me asking for help. Instructions for donating to one of our local charities will be provided.
______________________________ Last edited by kebo : Now. Reason: superfluous typo's
-
Nov 28th, 2015, 02:52 PM
#2
Re: The design surface is !Loading
Although I have vs2013 I never used that add database feature because till VS2008(at least that's when I stopped caring) this database is ACCESS!!!!!HELP!HELP!A DATABASE JUNK IS LOADING!HELP!
You see where I am getting to?
Just add a db to sql express or regular paid sql if you have it and reference the querystring through web.config.
ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·
-
Nov 29th, 2015, 08:54 AM
#3
Re: The design surface is !Loading
Originally Posted by sapator
Although I have vs2013 I never used that add database feature because till VS2008(at least that's when I stopped caring) this database is ACCESS!!!!!HELP!HELP!A DATABASE JUNK IS LOADING!HELP!
You see where I am getting to?
Um... that you don't like Access? OK, that's fine. But what's it got to do with the price of tea in China?
Originally Posted by sapator
Just add a db to sql express or regular paid sql if you have it and reference the querystring through web.config.
Or... get SSMS, and just use that to manage the database rather than VS. I've always thought VS made a poor substitute for a dedicated database management program.
-tg
-
Nov 30th, 2015, 10:23 AM
#4
Re: The design surface is !Loading
Originally Posted by sapator
Although I have vs2013 I never used that add database feature because till VS2008(at least that's when I stopped caring) this database is ACCESS!!!!!HELP!HELP!A DATABASE JUNK IS LOADING!HELP!
You see where I am getting to?
Just add a db to sql express or regular paid sql if you have it and reference the querystring through web.config.
Ok I'll give you that... Access is not the best choice. For what I'm doing now, it still should be ok. I have been working with this and the Loading problem seems to be either from within VS of with the connection to the DB file. It is work now, but it may crash out at any time.
One of the advantages I see to using an mdb file is portability. I should be able to configure the DB file, write the asp and upload the whole thing to my ISP and go live. I certainly could switch to a MSSQL or MySQL database, but I am not sure how I would then go from local designing and debugging to my ISP. I suppose I could export the local database as an sql file and run it on the server. Is that how it is normally done? And how do you deal with the changing connection string between developing with a local DB then switching to the remote DB?
I refer you to my first post...
Originally Posted by Me
noodling around in ASP for the time.
Originally Posted by tg
Or... get SSMS, and just use that to manage the database rather than VS.
I normally do all of my database management using HeidiSQL, but only with mySQL databases. If I can't get MSSQL working with it, I'll take a look at SSMS.
kevin
Process control doesn't give you good quality, it gives you consistent quality.
Good quality comes from consistently doing the right things.
Vague general questions have vague general answers. A $100 donation is required for me to help you if you PM me asking for help. Instructions for donating to one of our local charities will be provided.
______________________________ Last edited by kebo : Now. Reason: superfluous typo's
-
Nov 30th, 2015, 10:54 AM
#5
Re: The design surface is !Loading
Originally Posted by kebo
Ok I'll give you that... Access is not the best choice. For what I'm doing now, it still should be ok. I have been working with this and the Loading problem seems to be either from within VS of with the connection to the DB file. It is work now, but it may crash out at any time.
One of the advantages I see to using an mdb file is portability. I should be able to configure the DB file, write the asp and upload the whole thing to my ISP and go live. I certainly could switch to a MSSQL or MySQL database, but I am not sure how I would then go from local designing and debugging to my ISP. I suppose I could export the local database as an sql file and run it on the server. Is that how it is normally done? And how do you deal with the changing connection string between developing with a local DB then switching to the remote DB?
I refer you to my first post...
I normally do all of my database management using HeidiSQL, but only with mySQL databases. If I can't get MSSQL working with it, I'll take a look at SSMS.
kevin
Ummmm.... you ARE using MSSQL ... not Access... if you have an MDF file, that's SQL Server... if it's an MDB then that would be Access... soooo...... which is it?
as for the connection string... that's in the web.config file... you have a local version and a remote version... just be sure to not overwrite your remote with your local copy. Or vice versa.
-tg
-
Nov 30th, 2015, 12:04 PM
#6
Re: The design surface is !Loading
No you are right MDB is access. I have an MDF.
Ok, yea, there is the connection string. I was wondering where it was. As much as this is like making desktop forms, it's just different enough to make me scratch my head.
Thanks
kevin
Process control doesn't give you good quality, it gives you consistent quality.
Good quality comes from consistently doing the right things.
Vague general questions have vague general answers. A $100 donation is required for me to help you if you PM me asking for help. Instructions for donating to one of our local charities will be provided.
______________________________ Last edited by kebo : Now. Reason: superfluous typo's
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|