Search : in
By :

How to Store Data In Sql Server

Last answer on Aug 4, 2009 10:47:21 am BST Sarosh, on Jun 18, 2009 12:59:03 pm BST 
 Report this message to moderators

Hello Sir or Mam,

I am making a SignUp Page in ASP.Net 2.0 and i am facing a problem that How to store Signup Data in SQL Server 2005 like User Name,User Id or Password.Please Help to resolve this situation.Thankyou

Configuration: Windows XP
Firefox 3.0.11

Best answers for « How to Store Data In Sql Server » in :
Download Copy Database For SQL Server Show Description The application is designed by Ombelt Solutions. Copy Database for SQL Server is a tool that enables you to create copy of selected tables to various different servers or databases. Simple and easy to use, the application has been awarded...
Visual FoxPro and SQL Server Show Visual FoxPro and SQL Server Visual Foxpro 9 and SQL Server 2005 Is there a better alternative than using Visual FoxPro to manage efficiently a SQL Server? Here's an interesting issue. For more information see the article:...
Automatic backup of a Database in SQL EXPRESS 2005 ShowAutomatic backup of a Database in SQL EXPRESS 2005 If you want to automate a backup of a database in SQL Server Express, there is a simple solution using a .bat. file. Create a new text file. This file should contain the following...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Choosing the right kind of storage media or services ShowChoosing the right kind of storage media Constraints depending on frequency of use of the documents Costs of archiving Depending on the length of archiving documents, the choice of storage media is also depends on the type of...
Download EMS Data Export for SQL Server ShowDo you need to analyze your data in your SQL Server database? Would you like to print them? EMS Data Export for SQL Server offers to export them into MS Access, MS Excel, MS Word, RTF, HTML, XML, PDF, TXT, CSV, DBF or ODF only in a few steps. This...
Computer - Introduction to Memory ShowThe Role of Memory The term "memory" applies to any electronic component capable of temporarily storing data. There are two main categories of memories: internal memory that temporarily memorises data while programs are running. Internal memory...
Read-only memory (ROM) ShowRead-only memory (ROM) There is a type of memory that stores data without electrical current; it is the ROM (Read Only Memory) or is sometimes called non-volatile memory as it is not erased when the system is switched off. This type of memory...
Hard drive ShowThe role of the hard drive The hard drive is the component which is used to permanently store data, as opposed to RAM, which is erased whenever the computer is restarted, which is why the term mass storage device is sometimes used to refer to hard...

1

tommo2785, on Jun 18, 2009 1:13:37 pm BST

What exactly are you refering to? question about taking information off the form or question relating to the input of data into the DB/
If it is the former i cannot help as i have not learned that yet, however SQL language is Easy

INSERT INTO table_name
VALUES (value1, value2, value3,...);

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...);

both those examples were plagiarized from w3schools. Really good information on here and easy to follow this was one of the sites i studied whilst doing Modules on Databases, helped me receive a 7 or high distinction.

they also have tutorials on ASP PHP CSS HTML etc. study that,and you will work out your own answer it is very easy working on database.
If your database is already functional with tables and relations correctly assigned and constrained with DDL the rest is easy, Designing a good EER DB is a fair bit mor challenging, hence why those guys are some of the best paid in the industry

Reply to tommo2785

2

tommo2785, on Jun 18, 2009 2:47:04 pm BST

Here is a link that shows examples on PHP
will give you the general format
http://www.webmasterworld.com/databases_sql_mysql/3011940.ht­m
still though check out w3schools they have good information easily explained covering all the basics. another place to look for questions others have already answered is SQLteam.com I also regularly go through there reading threads and learning more.

Reply to tommo2785

3

 NITIN, on Aug 4, 2009 10:47:21 am BST
  • +2

Hi Dude,This is simply a easy method to store the values of sign up page data to sql server 2000.

Well if u design asp page than for insrting data in sql server 2000 . u recquired to import namespaces sql.data and sq.data.client

after that u define object for sqlconnection.sqlcommand and sqldatareader

make a connection on page load.
and open that connection.

After making connection with server u have to fire sql query for insert values and pas the textbox values .
finally execute ommand executenonquery.

Reply to NITIN