Databases
StackOverflow2013
Usersdbo
USNick Fleetwood
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USNick Fleetwood
    primarykey
    data
    text
    <p>I don't know anything about programming. I had an idea for a website, but my brother, who does this for a living, wouldn't help me. At all. So, being bored, and incredibly cheap, I set out to give it a shot. And I thought I would share some things that helped me. I wrote this in an email to a friend.</p> <p>""</p> <p>3) She should consider [or you] doing it herself. It's free, except for time, and relatively simple. You can even host it on your home computer using a server program like IIS8 [which comes for free on all Windows computers] or Apache, which I hear is free and is also the most widely used server program. These are the tools you will need:</p> <p>-VISUAL STUDIO EXPRESS 2012 [2013] FOR WEB - <a href="http://www.microsoft.com/visualstudio/eng/products/visual-studio-express-products" rel="nofollow">http://www.microsoft.com/visualstudio/eng/products/visual-studio-express-products</a></p> <p>-SQL SERVER EXPRESS - <a href="http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx" rel="nofollow">http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx</a></p> <p>VS2012 is where you would write the code for the website. Free, and it helps you along.</p> <p>SQL SERVER is a database system. You'll need it, you always need a database. Just make sure you get the SQL Management Studio. I had trouble getting it.</p> <p>Now to write the code, you'll need some help :</p> <ul> <li><p>ASP.NET TUTORIALS - <a href="http://www.asp.net/mvc/tutorials/mvc-music-store" rel="nofollow">http://www.asp.net/mvc/tutorials/mvc-music-store</a></p></li> <li><p>ASP.NET TUTORIALS - <a href="http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/intro-to-aspnet-mvc-4" rel="nofollow">http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/intro-to-aspnet-mvc-4</a></p></li> <li><p>MSDN - <a href="http://msdn.microsoft.com/en-US/" rel="nofollow">http://msdn.microsoft.com/en-US/</a></p></li> <li><p>STACKOVERFLOW - <a href="http://stackoverflow.com/">http://stackoverflow.com/</a></p></li> </ul> <p>The tutorial walks you through building a music store website. The only problem I have is that it is in MVC3, and MVC4 while not that much different is better. BUT, it's relatively easy to update it.</p> <p>This tutorial is really short, I mean literally 1 hour tops, so I recommend it to get a feel for the system and how things fit together.</p> <p>ASP.NET and MSDN are reference guides for writing code in C# and VB. Stick to C#. VB is easier, but there is a lot more help out there with C#.</p> <p>STACKOVERFLOW is programmers forum. I swear, they have answers for everything. I posted something at 1AM and got a response within 6 hours. You also might find someone to write the program there, but not sure.</p> <p>GOOGLE is SOOOOOO necessary. I know it's not BING, but what can I say. You have a question, you search for it, you find it. Simple.</p> <p>""</p>
    plurals
    1. POTrouble with Code First DatabaseGenerated Composite Primary Key
      singulars
      1. PTQuestion
    2. POMVC 4 Sending Mail From Website to Client
      singulars
      1. PTQuestion
    1. POАltering database based on user id
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. POMVC 4 Sending Mail From Website to Client
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COOh, I was doing internet application development, not phone. But I actually want to do that a little later. Thanks for the answer; give me a few and I'll check it out in depth.
      singulars
      1. PO
      1. USNick Fleetwood
    2. COThis is really what I was looking for. Thank you! BUT, I'm still having trouble pulling this off. I'm not sure where to put this snippet. I edited question and added some of the controller code. For `mainone.DocketNumber = countID + 1;` "cannot implicitly convert type int to string"
      singulars
      1. PO
      1. USNick Fleetwood
    3. CO@MikeSmithDev That's a good thought and a possibility. I am worried about possible collisions using DATETIME, although unlikely at fractional seconds. As you point out, there can be a situation where there might be a collision, hence my thought for a type of autoincrement additional digit or something similar to eliminate the collision possibility.
      singulars
      1. POAuto-increment Using Dates
      1. USNick Fleetwood
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload