how I can create a Database in SQL Express, then add tables and columns .. etc to the Database.
On PHP & MySQL I use to go into PhpMyAdmin and do that all there ! However with SQL Server Express and Visual Studio 2010. how to do it.
I've put my site online and I'm looking to add/change user membership. From Visual Studio, I can access the Website Administration Tool WSAT and it's great if you just want to add users manually. Is there a similar way to change users once the site is hosted on a remote server?For the moment, I change the user information through the WSAT and re-FTP the mdf file; it's pretty painful.
View 1 RepliesI wanted to use the "create database query" from my ASP.Net page, say "install.aspx". So that when the page is run, it works as an automated tool to create database and tables required for the application.
1. What should be the connection string (if any)?
2. What functions are to be used?
if there is any easier way to synchronize the TypedDataSets with the chages made to backend Table / Stored Procedure schema. I use Typed DataSets in my project extensively and I found them very useful and easier to code, but difficult to maintain
The difficuly I have always faced is whenever there is a change in a backend database table structure or stored procedure that is linked to any of the Typed DataSet in our project requires to recreate whole DataSet again by scrapping the old one. The backend changes will not be reflected unless and untill you recreate the whole stuff again.
Is there any easier way to synchronize those typed datasets with the changes made to backend database schema or any other workaround that will not required to recreate the whole DataSet again.
When developing large application using ASP.NET (MVC or classic, doesn't matter), especially in large team, it is easy to produce a lot of messy, non-traceable CSS definitions. After some time we can end up not knowing why particular definition exists and what is its real effect considering style inheritance and cross-browser differences. Needless to say, changing anything in that mess is a risk and there are hundreds of ways how small change could affect the system.
I know some solutions to organize CSS stylesheets better, like predefined CSS "frameworks" or DotLessCss engine, but I still find it quite hard to cope with CSS as there is no such relationship between HTML markup and CSS styles like i.e. between interface and concrete class in C# code. I know this is by design to make presentation separate from the structure, but I believe it might be useful to have such a correspondence at development level.
Ideally, I need something that can enforce the team not to make messy CSS or be able to clean that mess up automatically. Do you know any resources that may help me, or any guidance how to manage my CSS definitions easily? Let me ask for something a bit different:Despite of my several years of web experience, I believe I would feel much more confident if some of my CSS could be moved into C# code, the same way as some of HTML generation is done by MVC HTML Helpers. It saves me writing a lot of unnecessary markup, still allowing to do so if needed. And it is more unit testable, easier to refactor using tools like ReSharper etc. I don't need mergers and compressors of my CSS, I would like to be able to manage my CSS at declaration level. Maybe there are some tools like that I'm not aware of, or maybe that idea is just wrong and wouldn't be useful?
I am having problem when i was trying to attach .mdf file while create a new connection of SQL server, create a new connection of SQL database file and open the database in Server Explorer. I am using VS 2010 Ultimate and SQL Express 2008 R2.
Here are the error message.
1. Attach .mdf in SQL database file and open the database in Server Explorer
2. Create a new SQL server and attach .mdf
If I have a DataTable (in-memory) read by my C# program from a flat file, and I want to create it as a new table in a SQL Server database... what is the simplest way to do that?
It seems like something like SqlBulkCopy with an option to create a new destination SQL server table would be on my line of thinking, but I dont see a way.
Before my time at the company they paid for a very expensive website written in asp.net and dotnetnuke. Absolutely terrible but there's very little that can be done about that now. They won't give us access to the SQL Server for some bizarre reason but they've given us FTP access.
Is there some way I can install a database manager (like phpMyAdmin) using FTP? I think I've found the username and password but I'm not familiar with asp so it's quite a confusing system.
I restored a database from another server, and everything looks good except the users.
I'm managing all this from SQL Server 2008 Management Studio as SA.
The users are present in the [u]databaseName > security > users[/u] section, and they exist in [u]databaseServer > Security > Logins[/u]. However I can't change anything in the [u]databaseName > security > users[/u] section, because when I try and make a change, and then I hit OK to apply, it says "[i]login name must be specified[b][/b][/i]". But the login name field is grayed out and I can't modify it(even though I'm logged into the machine as Administrator and SQL as SA).
Also, in the user mapping section, when I try to map one of the users to a database, it says '[i]create failed user already exists[b][/b][/i]'...but I don't want to create the user, I just want to map that user to the appropriate databases...
We had a website deployed on IIS server remotely say www.liveserver.com.
We recently decided to make a copy of the website internal to the organisation so we brought a server and copied all the code from live server and configured it and say it is http//archives-testserver.com
Everything seems to work fine but while navigating and clicking on certain module links within http//archives-testserver.com......the domain name is getting rewritten to www.liveserver.com and user is made to navigate on the live site. I wonder where this
configuration is with in IIS...
I looked under properties under website identification and everything is referring it as http://arhives-testserver.com. also thr is a file called securityRedirect.inc and ifor handling errors and all the references have been changed and couldn't find anything in web.config. where else to look for probable reference to live site?
Is it possible to get the sql script for creating the database, when using Entity Framework 4.0 code first, without using the designer? When i use the designer it creates an .....edmx.sql file with the script. But i don't want to use the designer.
View 3 RepliesThis is a simplified example of what I need. Imagine a person table with several different club tables. Every person can belong to any number of clubs, but must belong to at least one club. The association would be a 1 to zero or one between the person table and each of the club tables.I've created the databases, then the entity model. The associations are all 1 to many, which isn't what I want.
Is there a way to modify the database so that the model is created correctly? I'm still building the project, making lots of changes, and I've had problems with updating the model, so I keep recreating it. Setting up the database correctly would be preferable.I'm trying to follow the quickstart here: [URL]but I'm using the SQL Management Studio designer, and I can't find how to fix the associations I add.
I've been reading about using or not using foreign keys in the model, but it's only confused me more. Can someone help me understand this? I'm starting to write code with what I have, and I'm running into problems. I'm about to start using joins, which means I'm trying to use a hammer instead of a saw because I don't know how to use my saw. I'd rather understand my tools and use them the right way!
I have been reading the below article and I have got it to work.
[URL]
The problem is when I use my database script file it throws an error 1001 saying error next to keyword 'GO'. But if i take the exact same script and run it in SQL Management Studio it works fine.
Try this small script, this is what I am using and its giving me an error, An above is a lovely article to creating a database from microsoft.
[Code]....
i got an requirement where in the user submits the database scripts,stored procedures ,triggers ,functions or packages.i have create those in the database .if it throws an error it must be roll backed.how can i achieve this.
View 7 RepliesI know how to create an rss feed using xml, but not sure how to with my access database. Can anyone tell me how?
View 1 RepliesI have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
i'm using visual studio 2005. now i've to create a insert form which shud be connected to database(mssql). can any one tell me how to do dat. as i'm new to visual studio i dnt knw it.
View 8 RepliesI am currently using datasets for my data access layer. I currently store the connection string in the web.config file. I need the ability to change the connection to another database before any queries are processed. Is there an event that is triggered or a base class that can be modified that intercepts the process of retrieving the connection string from the web.config file? Is there any way to handle multiple database connections using the same code base and also take advantage of the connection pooling? I understand the best method is to get rid of datasets and use custom data objects.
View 2 RepliesI want to create web application. I use SqlServer 2008 and asp.net (framework 3.5 sp1).
In my task, user can create database arbitrary structure. and i must write system that generate web site by template. is it possible?
I want to start creating sites with simple backends! I don't know much about databases though and I don't want to jump straight into creating sites with databases anyway. So I want to find out what the best way of creating a simple backend without using a database is.
I have an asp.net webpage which is a prices page detailing the prices of services at a hair salon. The prices change every 6 months so I want to give the client a simple backend so he can update the prices himself. The backend will just be a table of inputs populated with the current prices which can be changed and then click 'save changes' to update the site.
Now what is the best way of implementing this?
A) In the prices page, hard code an html table, within each cell code a <span> tag with an id for the price that will go within the span tag like id="menscut" and within the span tag hard code the price of the service. Then wirte a C# class called 'edit' that is used when the 'save changes' button is clicked on the backend page. When 'save changes' is clicked the 'edit' class parses the prices.aspx page and finds <span id="menscut">£20</span> and then changes it to <span id="menscut">£22</span> (or what ever new price has been entered in the backend) and then saves the new edited prices.aspx page over the old one on the server.
or
B) Don't hard code prices into the prices.aspx but instead store the prices in a seperate .txt or .xml file. Every time the prices.aspx page loads it runs a class called 'populate' which extracts the prices from the .txt file or .xml file and inserts them into the table in the prices.aspx page. And now the edit class instead of editing the prices.aspx page it edits the .txt or .xml file.
So which of those ways is better, or if they are fairly even pegged what are the pros and cons of each?
Or are there any other options I haven't thought of?
I am planning to develop around 4 product catalogue websites. The functionality of all the websites would be same. however the design, images and css would be different.
All the 4 websites will use the same admin panel, forums and database(MS Access) also.
How should I create such a system.
I dont understand what kind of folder structure should I create.
I would like to create following kind of folder structure.
(Root Folder)Admin Website ----> Website 1 (subfolder)
----> Website 2 (subfolder)
----> Website 3 (subfolder)
----> Website 4 (subfolder)
Root folder will have the database and all the common files.
Unfortunately, when I tried to create such structure, Dot Net Didnt allow me to create one website inside another
what kind of system should I use for maximum reusability.
I am a small time freelancer and cannot afford to build seperate websites for each of my client.
I've created a web application that's using Windows Authentication using roles authorization.
In VS2008 everything's runs fine by running the app or browsing using the VS web server.
I create a new virtual App in IIS6 and then try to browse the page. The app hangs, and has a very mysterious habit of creating a new SQL Server Express database in our appdata directory called TimeTracker.MDF.
So I was thinking somewhere along the line we installed a TimeTracker Starter Kit and it updated a configuration file somewhere.
My initial reaction was to search all of the config files under the framework directories. So i did that using Windows GREP, only to find one entry here:
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
oot26676eb792c7e946App_Code.hcjj1nuh.dll
I have created a database in Access 2007 for a university. Now, a new functionallity is required. What I need to do is a search function where students can search the database online. Now, they can only search using a front-end which is read-only, but they need to use a computer with Microsoft Access (or Runtime) and they need to be connected to the back-end which is located on a server.
make the database to work online? I am a novice to web programming. Which is the easiest way and how do I start?
The database has fields with Attachments. The students can search the database and open Attachments connected to the found posts, this part needs to be online. The personnel can edit and add data using a more complex front-end. This does not need to be online, they can still use Access.
I have created class in C# i need to use objects from this class to add them to a databse table.
the information come from textbox go into the object of the class than from this object i want to preform databse function.
i want to make a table to look like this..Â
------------------------------------------------
| Size | 6.0 | Â 6.5 | 7.0| 7.5| 8.0 | 8.5 |
-----------------------------------------------
| Qty  | 8   |  2   | 0  | 9  | 0   | 9   |
----------------------------------------------
| All.Q| 2 Â Â | Â 3 Â Â | 0 Â | 5 Â | 0 Â Â | 2 Â Â |
----------------------------------------------
where all.q is allocated quantity for that size
while the sizes & qty r called from a size table in the database.