How to Save Data Using C# and SQL Server Database

[AccDispenser]

In this tutorial, I will teach you how to save data in the database using C#.net and SQL Server 2005 Express Edition. With this, you can access and save the data in the Server database with ease. This is the basic implementation for a newbie in programming who plans to build a system in the future.
break
Let's get started:

1. Create a database and name it "userdb".
2. Do this following query for creating a table in the database that you have created.

1. /****** Object: Table [dbo].[tbluser] Script Date: 06/23/2016 08:36:33 ******/
   
2. SET
   
   ANSI_NULLS ON
   
3. GO
   
4. SET
   
   QUOTED_IDENTIFIER ON
   
5. GO
   
6. CREATE
   
   TABLE
   
   [
   
   dbo]
   
   .
   
   [
   
   tbluser]
   
   (
   
7. [
   
   ID]
   
   [
   
   INT
   
   ]
   
   IDENTITY
   
   (
   
   1
   
   ,
   
   1
   
   )
   
   NOT
   
   NULL
   
   ,
   
8. [
   
   Name]
   
   [
   
   nvarchar]
   
   (
   
   50
   
   )
   
   NULL
   
   ,
   
9. [
   
   UNAME]
   
   [
   
   nvarchar]
   
   (
   
   50
   
   )
   
   NULL
   
   ,
   
10. [
    
    PASS]
    
    [
    
    nvarchar]
    
    (
    
    MAX
    
    )
    
    NULL
    
    ,
    
11. [
    
    UTYPE]
    
    [
    
    NCHAR
    
    ]
    
    (
    
    20
    
    )
    
    NULL
    
    ,
    
12. CONSTRAINT
    
    [
    
    PK_tbluser]
    
    PRIMARY
    
    KEY
    
    CLUSTERED
    
13. (
    
14. [
    
    ID]
    
    ASC
    
15. )
    
    WITH
    
    (
    
    PAD_INDEX =
    
    OFF,
    
    STATISTICS_NORECOMPUTE =
    
    OFF,
    
    IGNORE_DUP_KEY =
    
    OFF,
    
    ALLOW_ROW_LOCKS =
    
    ON
    
    ,
    
    ALLOW_PAGE_LOCKS =
    
    ON
    
    )
    
    ON
    
    [
    
    PRIMARY
    
    ]
    
16. )
    
    ON
    
    [
    
    PRIMARY
    
    ]
    

3. Open Microsoft Visual Studio 2008, create a new windows form application and do the form just like this.

4. Go to the Solution Explorer, click the “View Code” to fire the code editor.

5. Declare and initialize the classes that are needed.

1. //initialize all classes
   
2. SqlConnection string_con =
   
   new
   
   SqlConnection(
   
   )
   
   ;
   
3. SqlCommand sql_command =
   
   new
   
   SqlCommand(
   
   )
   
   ;
   

Note: Add "using System.Data.SqlClient;" above the namespace to access sql server library.

6. Establish a connection between SQL Server and C#.net on the first load of the form.

1. private
   
   void
   
   Form1_Load(
   
   object
   
   sender, EventArgs e)
   
2. {
   
3. //bridge between sql server to c#
   
4. string_con.
   
   ConnectionString
   
   =
   
   "Data Source=.\\
   
   SQLEXPRESS;Database=userdb;trusted_connection=true;"
   
   ;
   
5. }
   

7. Go back to the Design Views, Double click the "Save" button and create a method for saving the data in the SQL database.

1. private
   
   void
   
   btnSave_Click(
   
   object
   
   sender, EventArgs e)
   
2. {
   
3. try
   
4. {
   
5. //opening connection
   
6. string_con .
   
   Open
   
   (
   
   )
   
   ;
   
7. //create an insert query;
   
8. string
   
   sql=
   
   "INSERT INTO tbluser (NAME,UNAME,PASS,UTYPE) VALUES('"
   
   +
   
   txtName.
   
   Text
   
   +
   
   "','"
   
   +
   
   txtUsername.
   
   Text
   
   +
   
   "','"
   
   +
   
   txtPassword.
   
   Text
   
   +
   
   "','"
   
   +
   
   cboType.
   
   Text
   
   +
   
   "')"
   
   ;
   
9. //initialize a new instance of sqlcommand
   
10. sql_command =
    
    new
    
    SqlCommand(
    
    )
    
    ;
    
11. //set a connection used by this instance of sqlcommand
    
12. sql_command .
    
    Connection
    
    =
    
    string_con ;
    
13. //set the sql statement to execute at the data source
    
14. sql_command .
    
    CommandText
    
    =
    
    sql;
    
15. //execute the data.
    
16. int
    
    result =
    
    sql_command.
    
    ExecuteNonQuery
    
    (
    
    )
    
    ;
    
17. //validate the result of the executed query.
    
18. if
    
    (
    
    result >
    
    0
    
    )
    
19. {
    
20. MessageBox.
    
    Show
    
    (
    
    "Data has been saved in the SQL database"
    
    )
    
    ;
    
21. }
    
22. else
    
23. {
    
24. MessageBox.
    
    Show
    
    (
    
    "SQL QUERY ERROR"
    
    )
    
    ;
    
25. }
    
26. //closing connection
    
27. string_con .
    
    Close
    
    (
    
    )
    
    ;
    
28. 
    
29. }
    
30. catch
    
    (
    
    Exception ex)
    
    //catch exeption
    
31. {
    
32. //displaying errors message.
    
33. MessageBox.
    
    Show
    
    (
    
    ex.
    
    Message
    
    )
    
    ;
    
34. }
    
35. }
    

Output:

For all students who need a programmer for your thesis system or anyone who needs a source code in any programming languages. You can contact me @ :

Email – [email protected]
Mobile No. – 09305235027 – TNT