insert data into database in asp.net c#

Here is the simple insert query to insert data into database using mssql server.

protected void Button1_Click(object sender, EventArgs e)
        {
            string constr = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
            SqlConnection con = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand("insert into tbl_view values(@Name,@EmailID,@view,@Activity,@DateTime)");
            cmd.CommandType = CommandType.Text;
  


           cmd.Parameters.AddWithValue("@Name",name.Value);
            cmd.Parameters.AddWithValue("@EmailID", email_id.Value);
            cmd.Parameters.AddWithValue("@view", message.Value);
            cmd.Parameters.AddWithValue("@Activity", "dolphin_safari");
            cmd.Parameters.AddWithValue("@DateTime", DateTime.Now);
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();


        }

Comments

Post a Comment

Popular posts from this blog

Disable right click, Inspect Element and page source using JavaScript in Html and asp.net

This is a code to hide right click on any web page and to hide inspect element and page source of page.  I have used JavaScript to hide a source code below is the code. It blocks Ctrl + U , Right click , F12 , and Ctrl+ Shift + J Step One :  copy JavaScript and paste under head tag. <script> document.onkeydown = function(e) { if(event.keyCode == 123) { return false; } if(e.ctrlKey && e.shiftKey && e.keyCode == 'I'.charCodeAt(0)){ return false; } if(e.ctrlKey && e.shiftKey && e.keyCode == 'J'.charCodeAt(0)){ return false; } if(e.ctrlKey && e.keyCode == 'U'.charCodeAt(0)){ return false; } } </script> Step Two :  Put this code  in the body tag. <body oncontextmenu="return false;"> Now you can run your page and check using all the short controls and right click all are disabled now… Happy Coding Day
Read more

Like Operator In Sql Server

Like operator used in where clause it’s use to search exact word from table. There are two wildcards in Like operator. _  - Underscore perform a single character % - Percent sign Perform for zero, multiple and for one character  Note: You can mix underscore and percent in query Like Operator Example Example 1 SELECT  *  FROM  Employee WHERE  Emp_Name  LIKE   'T%' ; [The following query returns all data where Emp_name starts with T] Example 2 SELECT  *  FROM  Employee WHERE  Emp_Name  LIKE   'a%i' ; [The following query selects al data and where Emp_Name starts with A and ends with I] Example 3 SELECT  *  FROM  Employee WHERE  Emp_Name  LIKE   '%T' ; [The following query returns all data with Emp_name where all Employee Name end with T] Example 4 SELECT  *  FROM  Employee WHERE  Emp_Name  LIKE   '%or%' ; [Following query returns all data where (or) will be situated in any Employee Name] Example 5
Read more