Insert Data in Database (mssql)

How TO Insert Data In MSsql DataBase with ASP.NET (C#).

So let's Start Now... 


 You must do 5 steps for insert, update, and delete (DML)Operations.

 Step 1: Add " using System.Data.SqlClient ; ".
Step 2: Create Object of SqlConnection...  like this..  ( SqlConnection Objname = new SqlConnection(); )
Step 3: Crate Object of SqlCommand.... like this... ( SqlCommand  cmd = new SqlCommannd(); ).
Step 4: After create Objects of sqlconnection and sqlcommand You Open the Connection. Like this (Objname.Open() ;)
Step 5: Execute your Query...

 Here Example::::......
-------------------------------------------------------------------------------------------
                                                                  Code Start
-------------------------------------------------------------------------------------------

 using System;
using System.Windows.Forms;
using System.Data.SqlClient;            // Step 1
namespace Managment
{
    public partial class Form1 : Form
    {
        public Form1() // Constructor of this class
        {
            InitializeComponent();
        }

         private void btnsave_Click(object sender, EventArgs e)
        {
            SqlConnection objSqlConnection = new SqlConnection("Data Source = SUMITSHEKHAWAT; Initial Catalog = Company; Integrated Security = True");   // Step 2
            SqlCommand objSqlCommand = new SqlCommand("Insert into Users values('"+Convert.ToString(txtname.Text.Trim())+"')",objSqlConnection);    // Step 3
            objSqlConnection.Open();        // Step4
            int resultstorer = objSqlCommand.ExecuteNonQuery();         // Step5
            if (resultstorer > 0)
            {
                lblmessage.Text = "Data Save Succesfully";
            }
            else
            {
                lblmessage.Text = "Data Not Save Please check your code";
            }
        }
    }
}

-------------------------------------------------------------------------------------------
                                                                  Code End
-------------------------------------------------------------------------------------------
Result :

Comments

Post a Comment

Popular posts from this blog

Tree view in winforms using c#

Image
Tree view in c# ms sqlserver 2008(database) __________________________ step 1 _________ CREATE TABLE [dbo].[myTable]( [ID] [int] IDENTITY(1,1) NOT NULL, [title] [varchar](255) NOT NULL, [parentID] [int] NULL,  CONSTRAINT [PK_myTable] PRIMARY KEY CLUSTERED  ( [ID] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] ) ON [PRIMARY] step 2 _________ INSERT INTO myTable(title, parentID) VALUES('Microsoft', NULL) INSERT INTO myTable( title, parentID) VALUES('C#', 1) INSERT INTO myTable( title, parentID) VALUES('VB.net', 1) INSERT INTO myTable( title, parentID) VALUES('Open Source', NULL) INSERT INTO myTable( title, parentID) VALUES('Python', 4) INSERT INTO myTable( title, parentID) VALUES('Ruby', 4) INSERT INTO myTable( title, parentID) VALUES('PHP', 4) INSERT INTO myTable( title, parentID) VALUES('Perl...
Read more

how to Replace null value with 0 Using C#

how to Replace null value with 0 Using C# //here we suppose that objDataTable have data collection as table now access this //datatable object. decimal  j = 0;  j = objDataTable.Rows[0]["Qty"] ==  DBNull .Value ? 0 :  Convert .ToDecimal(objDataTable.Rows[0]["Qty"]); NOTE :- //if   DBNull.value is null  then   "0 " else  "your code here")  // ? = then // : = else Thank You [Sumit Singh Shekhawat]
Read more

how to fetch all HTML Table Records and modify all records accordingly using jquery and Javascript

In my example, I have fetch HTML Table Records and Convert to Class List Object for C# Result: Click Here < script src = "https://ajax.googleapis.com/ajax/libs/jquery/3.6.3/jquery.min.js" ></ script > < script >   $ ( document ). ready ( function () {     // Get the table element     const table = document . getElementsByTagName ( "table" )[ 0 ];     // Get all the table rows     const rows = table . rows ;     // Create an empty array to store the table data     const data = [];     // Loop through each row and get the cell data     for ( let i = 0 ; i < rows . length ; i ++) {       const cells = rows [ i ]. cells ;       const rowData = {};       //new Columns { CharacterName = "", Char = "", Code = "", Decimal = "", Binary = "", Hex = "" },       var stringCon = "new Columns {" ;       /...
Read more