creating a database, tables, records, and fields in a Sql server 2005 express

creating a database, tables, records, and fields in a Sql server 2005 express

• SQLDiva

  p3aul,
  
  your statement:
  INSERT INTO family VALUES ("Paul", "Handley");
  
  should be:
  INSERT INTO family (fieldname, fieldname) VALUES ("Paul", "Handley");
  
  where fieldname is the name of your field.
  
  

• AnupamKundu

  Thanks, Steve. That was the problem. However, I still can't add data or insert blank records in the database. I noticed when I used an Access database I was able to edit and delete the data. I would like to be able to do that with Sql server express database also and in addition to inserting a blank record. I am using a a gridview component.
  
  In Visual basic 6.0 I could drop a few buttons on the form and with next, previous delete and insert methods I could alter the database where the columns were bound to individule Textboxes.
  I have a lot to learn and there are very few books and tutorials written with info on what I want to learn.
  
  I guess the gridview tasks are limited because I have no data to edit or delete, and I don't know how to use the Management Studio to enter the data. :(
  
  

• Trond Smaavik

  Ok, that's it. If you are going to just leave me hanging here, I'm through. I'm going back to Linux and PHP and Mysql. I should have know better than to try this Microsoft garbage!
  Paul
  
  

• TheQuietShadow

  Well I think I spoke too soon. Now in VWD I drop a gridview and try to connect it to my database. When I am building a connection string, I get the dialog box, "Add Connection. When I try to browse and select my database I get this real long error, the essence of "Unable to open the phsical file c:\blah|blah\blah\prince.mdb. Operating system error 32(The process cannot access the file because it is being used by another process)" I know that it isn't being used because I closed the database and exited Management Studio.
  Thanks,
  Paul
  
  

• Rob Morrison

  Ok I found the where I could add the various links to Update Insert and edit my fields and when I click on New I get the blank fields to add new data but when I click on update I get this error msg:
  

  Inserting is not supported by data source 'SqlDataSource1' unless InsertCommand is specified.

  
  I feel sure If I could fix this I would be on my way, but the as I stated above the whe option are grayed out!
  

  Will someone pleeese answer this post!

  
  

• Jon_Hou

  Make sure the database is AutoClose=true. If the database is not set to automatically close, the SQL Server service will keep it open as long as the server is running.

  You can check this in the Options page of the database properties dialog in Management Studio.

  Hope this helps,

  Steve

  
  
  

• Ethan S

  Thanks, Jen! boy was that ever easy! I've got tables and columns now too! Tell me though, can I input some data in the management Studio Also
  Thanks,
  Paul
  
  

• SergeyDN

  I tried executing a query like this:
  INSERT INTO family VALUES ("Paul", "Handley"); family is my table and there are only two columns. I tried putting the column names but got an error. I also get this error when I try to run the above query:
  Msg 128, Level 15, State 1, Line 1
  The name "Paul" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
  
  Any suggestions
  Paul
  
  

• Rudi Groenewald

  Hi Paul,
  
  there is no need yelling in this group. As we are doing this all in our spare free time and on a voluntary basis, the poster of a question sometimes has to wait until he gets an answer. IMHO I would rather learn the basis things first, before comming to the groups and posting question which would have been solved if you just took a walkthough-easy-to-use-example.
  
  The question you are posting is related that you appearantly didn’t specifiy which command has to be executed in the case of an insert. YOu can either specify your own command or use a commanbuilder (But that are , as I told below some basic things which wouldn’t concern you if you have done some ADO.NET basics first)
  
  Fell free to come any time again in this group, but be aware that you sometime need to have a bit patience.
  
  HTH; jens Suessmeyer.

  
  

• Sebastiang

  Well I wasn't aware that I was shouting, I just c & p the error that appeared on the webpage. i figured it would just paste as normal 10 or 12 pt type. I enlarged the fon't and chose the color red in my plea for help because Time was going by and I was beginning to lose my train of thought.. I don't sit idley by and wait for someone to give me an idea that might help, I try to persue a solution on my on. If I leave the a file i am working on and load something else in and put my mind ont I am apt to forget what I was doing on the first file. I apologise for feeling frustrated but Microsoft tools are frustraing things to work with.
  
  tonic999 Thank you for the post. I don't remember where I was now. In working with MySQL , though, in the insert statement (fieldname, fieldname) are optional.
  
  My original question, If I can find the file I was working on, still stands, to wit:
  Ok I've got to the point where when I am configuring the datasource and I get to the "Configure the select statement and I choose "Specify columns from a table or view. I click on te advanced tab and I want to choose"Generate Insert, Update and Delete Statements" but the whole dialog box is grayed out! What do I do now I want the capabilities of editing, insertsing, deleteing and updating my records
  Thanks,
  Paul
  
  
  

• Neo77

  If you are using the managment studio, right click on the Databases node, --> New Database. If you are using a script tool for this, the fastest way to create a database is CREATE DATABASE <name>, which stores the data files in the defautl location, specified at setup time.

  HTH, Jens Suessmeyer.

  
  

• ross04

  Ok I've got to the point where when I am configuring the datasource and I get to the "Configure the select statement and I choose "Specify columns from a table or view. I click on te advanced tab and I want to choose"Generate Insert, Update and Delete Statements" but the whole dialog box is grayed out! What do I do now I want the capabilities of editing, insertsing, deleteing and updating my records
  Thanks,
  Paul
  
  
  
  

• Simon Dahlbacka

  Thanks, Jen. That did the trick. As far as the inserting and the editing of a database record within the web application I am developing, I still can't do that. Is it possible to attach a query to a button and just insert a blank record. Like this:
  Insert into family Values( '','') **Those are single quotes**
  Thanks,
  Paul
  
  

• Ambrose

  You can either set the following command:
  
  SET QUOTED_IDENTIFIER is OFF
  
  to use double quotation marks, or you use single quotation marks which wont cause the problem.
  
  HTH, jens Suessmeyer.

  
  
• creating a database, tables, records, and fields in a Sql server 2005 express