Insert into sql database c#

Insert into sql database c#

Save data/records from web application. 

1. Create Table In SQL Server Database

Create Table ItemDetails
(
ItemCode Varchar(10)NOT NULL,
ItemName Varchar(30)NOT NULL,
Category Varchar(10)NOT NULL,
Quantity Int NOT NULL,
Price Float NOT NULL,
Country VarChar(30)NOT NULL,
Description VarChar(200)NOT NULL
)

2. Create a C#/Asp.net form as below image.
 TextBox Name as below or any your choice.

[Note: 
  ItemCode to txtItemCode
  ItemName to txtName
  Category to txtCategory
  Quantity to txtQty Price to txtPrice
  Country to txtCountry
  Desc to txtDesc
]

3. Type the following code inside btnSave event

using System;

using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace MyProject
{
    public partial class ItemEntry : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                SqlConnection con;
                con = new SqlConnection("Server=Kool-PC;Database=CenterDB;user=sa;password=a;trusted_connection=yes");
                con.Open();
                SqlCommand cmd;
                cmd = new SqlCommand("Insert Into ItemDetails Values(@ItemCode,@ItemName,@Category,@Quantity,@Price,@Country,@Desc)", con);
                cmd.Parameters.Add("@ItemCode", SqlDbType.VarChar, 10).Value = txtItemCode.Text.Trim();
                cmd.Parameters.Add("@ItemName", SqlDbType.VarChar, 50).Value = txtName.Text.Trim();
                cmd.Parameters.Add("@Category", SqlDbType.VarChar, 20).Value = txtCategory.Text.Trim();
                cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = txtQty.Text.Trim();
                cmd.Parameters.Add("@Price", SqlDbType.Float).Value = txtPrice.Text.Trim();
                cmd.Parameters.Add("@Country", SqlDbType.VarChar, 30).Value = txtCountry.Text.Trim();
                cmd.Parameters.Add("@Desc", SqlDbType.VarChar, 200).Value = txtDesc.Text.Trim();
                cmd.ExecuteNonQuery();
                Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language="javascript">alert('Saved')</script>");

            }
            catch(Exception ex)
            {
                lblerror.Text = ex.Message;
               // Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language="javascript">alert('" + ex.Message + "')</script>");

            }
              
        }

    }
}

Insert into Sql database form asp.net in Video