Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Don't take this the wrong way, but judging by what you've said about your lack of coding abilities, it may work out cheaper for you to get someone else to do the work for you. A competent coder should be able to knock something out for you in about an hour, probably less if he doesn't stop for coffee.</p> <p>If you do really really want to do it yourself, then first off, you're going to have to find out if the hosting packing for the website includes a database or not.</p> <p>Assuming you don't host the website on your local machine, then having a version of SQL Express on your machine will help you develop the code, but you won't be able to deploy it.</p> <p>Completely ignoring that though, steps you want to go through are:</p> <ol> <li>Create the database in SQL, then create the relevant database table</li> <li>Create a connection from the website to the database using ADO.Net</li> <li>Create the code to insert the contact form data into the database table</li> </ol> <p>You then need to think about how you're going to view the data once it's been collected, so you're either going to have to write something or learn SQL.</p> <p>If you want some code samples to help you get going, then we need to know what language you're using (it should be C# or VB.Net) and posting the code for the contact form would help as well (obviously deleting any sensitive details, such as usernames and passwords).</p> <p><strong>EDIT:</strong></p> <p>Once you've created the database, this script should give you a basic table structure in SQL Express:</p> <pre><code>CREATE TABLE [dbo].[tblEmails]( [EmailID] [int] IDENTITY(1,1) NOT NULL, [EmailAddress] [nvarchar](200) NOT NULL, [Subject] [nvarchar](200) NOT NULL, [Message] [nvarchar](max) NOT NULL, [FirstName] [nvarchar](50) NOT NULL, [LastName] [nvarchar](50) NOT NULL, [PhoneNumber] [nvarchar](20) NOT NULL, [City] [nvarchar](50) NOT NULL, [State] [nvarchar](50) NOT NULL, CONSTRAINT [PK_tblEmails2] PRIMARY KEY CLUSTERED ( [EmailID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO </code></pre> <p>To use it, right click on the database in SQL Express, click New Query, paste the above into the window, then hit the Execute button, refresh the database and you shouldn't see the table.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I make this asp.net email go to a database?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDark Hippo
    1. USDark Hippo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I make this asp.net email go to a database?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COOh, I'm definitely lacking coding abilities, Hippo. I'm a robotics engineer. But this is a start-up company and we don't have the money to hire a programmer -- but I doubt it'd be that cheap. I use discountasp.net as my web host .... they allow 1 SQL database for 10 bucks a month ... but thank you for taking the time to read my issue, and respond. Thank you very much for laying out the steps I'd have to take, recognizing I'm not too adept at programming. I do appreciate your help!
      singulars
      1. PO
      1. USJason Weber
    2. COI tend to agree with @Kronass that an MS Access database may be better for you, but it depends on whether your hosting provider will allow you to have one or not.
      singulars
      1. PO
      1. USDark Hippo
    3. COYes, they allow for an MS Access DB.
      singulars
      1. PO
      1. USJason Weber
 

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