Progress Monitor for IdealProgrammer.com

Take Swift, Intelligent, Massive, Planned, Loving, Effective (S.I.M.P.L.E.) Action to Transform Self into Ideal

Skip Repetitive Navigational Links

Home

News

Presenters

Contact

Please login

C# ASP.NET Sql Command Insert Statement Source Code Example

Description: Illustrates using Sql Command Insert Statement in C-Sharp ASP.NET.

Example Webform Code:

<%@ Page Language="C#" AutoEventWireup="false" CodeFile="SqlCommandInsert.aspx.cs" Inherits="Database_ADONET_SqlCommandInsert" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table>
        <tr>
        <td>First Name: </td><td>
        <asp:TextBox ID="txtFirstName" runat="server"></asp:TextBox>
        </td>
        </tr>
        <tr>
        <td>Last Name: </td><td>
        <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox>
        </td>
        </tr>
        </table><br />
        <asp:Button ID="btnInsert" runat="server" Text="Insert" 
            onclick="btnInsert_Click" /><br />
        <asp:Label ID="lblErrMsg" runat="server" Text="lblErrMsg" ForeColor="#FF3300" 
            Visible="False"></asp:Label><br />
        <asp:GridView ID="GridView1" runat="server" DataSourceID="sdsEmployees">
        </asp:GridView>
        <asp:SqlDataSource ID="sdsEmployees" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Northwind_ConnectionString %>" 
            SelectCommand="SELECT [FirstName], [LastName] FROM [Employees]">
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

Example Code Behind:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
 
partial class Database_ADONET_SqlCommandInsert : System.Web.UI.Page
{
 
    protected void btnInsert_Click(object sender, System.EventArgs e)
    {
        SqlConnection thisConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Northwind_ConnectionString"].ConnectionString);
 
        //Create Command object
        SqlCommand nonqueryCommand = thisConnection.CreateCommand();
 
        try
        {
            // Open Connection
            thisConnection.Open();
 
            // Create INSERT statement with named parameters
            nonqueryCommand.CommandText = "INSERT  INTO Employees (FirstName, LastName) VALUES (@FirstName, @LastName)";
 
            // Add Parameters to Command Parameters collection
            nonqueryCommand.Parameters.Add("@FirstName", SqlDbType.VarChar, 10);
            nonqueryCommand.Parameters.Add("@LastName", SqlDbType.VarChar, 20);
 
 
            nonqueryCommand.Parameters["@FirstName"].Value = txtFirstName.Text;
            nonqueryCommand.Parameters["@LastName"].Value = txtLastName.Text;
 
            nonqueryCommand.ExecuteNonQuery();
        }
 
        catch (SqlException ex)
        {
            // Display error
            lblErrMsg.Text = ex.ToString();
            lblErrMsg.Visible = true;
        }
 
        finally
        {
            // Close Connection
            thisConnection.Close();
 
        }
        GridView1.DataBind();
    }
 
    protected void  
Page_Load(object sender, System.EventArgs e)
    {
        lblErrMsg.Visible = false;
 
    }
 
}

Example Connection String:

<connectionStrings>
    <add name="Northwind_ConnectionString"
      connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI" />
    <add name="Pubs_ConnectionString"
      connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI" />
  </connectionStrings>