ASP.NET

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Insert.aspx.cs" Inherits="DBManagerWebForm.Insert" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <asp:DetailsView ID="DetailsView1" runat="server" DefaultMode="Insert" Height="50px" Width="125px" AutoGenerateInsertButton="True" OnItemInserting="DetailsView1_ItemInserting" OnItemUpdating="DetailsView1_ItemUpdating">
    </asp:DetailsView>
    <%--<asp:Button ID="btnOk" runat="server" OnClick="btnOk_Click" Text="Ok" />
    <asp:Button ID="btnReset" runat="server" OnClick="btnReset_Click" Text="Reset" />--%>
    <asp:Button ID="btnCancel" runat="server" OnClick="btnCancel_Click" Text="Go Back" />
    <br />
    <asp:TextBox ID="txtError" runat="server" ReadOnly="True" TextMode="MultiLine" Width="411px"></asp:TextBox>
</asp:Content>

protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
       {
           int i;
           SqlDbType T;
           try
           {
                string Cmd = "INSERT INTO " + TABLE + " (";
               IEnumerator En =  e.Values.Keys.GetEnumerator();
               En.Reset();
               for (i = 0; i < e.Values.Count - 1; i++)
               {
                   En.MoveNext();
                   Cmd += En.Current.ToString() + ",";
               }
               En.MoveNext();
               Cmd += En.Current.ToString() + ") VALUES (";
               string val;


               En.Reset();
               for (i = 0; i < e.Values.Count - 1; i++)
               {
                   En.MoveNext();
                   T = Util.GetSqlType(DT.Columns[i].DataType);
                   val = e.Values[En.Current] == null ? "" : e.Values[En.Current].ToString();
                   if (T == SqlDbType.NVarChar)
                       Cmd += "'" + val + "',";
                   else
                       Cmd += val + ",";
               }
               En.MoveNext();
               T = Util.GetSqlType(DT.Columns[i].DataType);
               val = e.Values[En.Current] == null ? "" : e.Values[En.Current].ToString();
               if (T == SqlDbType.NVarChar)
                   Cmd += "'" + val + "')";
               else
                   Cmd += val + ")";


 string ConnStr = WebConfigurationManager.ConnectionStrings[CONNECTION].ConnectionString;

               SqlConnection Conn = new SqlConnection(ConnStr);
               Conn.Open();
               SqlCommand Comm = new SqlCommand(Cmd, Conn);
               int r = Comm.ExecuteNonQuery();
               Conn.Close();

               // Response.Redirect("~/modifica.aspx");
               Server.Transfer("~/modifica.aspx");
           }
           catch (Exception ex)
           {
               txtError.Text = "Errore :" + ex.Message;
           }
       }

protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
    string ConnStr = WebConfigurationManager.ConnectionStrings[CONNECTION].ConnectionString;

    using (SqlConnection connection = new SqlConnection(ConnStr))
    using (SqlCommand command = new SqlCommand("", connection))
    {
        string[] columns = new string[e.Values.Count];
        int index = 0;

        foreach (string key in e.Values.Keys)
        {
            command.Parameters.AddWithValue("@" + key, e.Values[key]);
            columns[index] = key;
            index++;
        }

        command.CommandText = string.Format("INSERT INTO [{0}] ({1}) VALUES (@{2})",
            TABLE, string.Join(", ", columns), string.Join(", @", columns));

        connection.Open();
        command.ExecuteNonQuery();
    }

    Server.Transfer("~/modifica.aspx");
}

<asp:GridView ID="gvItems" 
              runat="server"
              AutoGenerateColumns="False" onrowdatabound="gvItems_RowDataBound">

<add name="SecurityConnectionString" connectionString="Password=...;Persist Security Info=True;User ID=impact_app;Initial Catalog=cc_3100_CC_20_20_sec;Data Source=CCDBER\CCDB_ERPS"/>

Nathan Minier wrote:

If you have a static method on a non-static object, an instance WILL be created by the ASP.NET host in order to process the request, therefore any constructor logic will fire. The static signifies that the method (or field, or object) will only be created once, and all calls made by the application for that static element will point to the same memory address space.

Nathan Minier wrote:

By leveraging statics, you introduce state to an object.

ganesh.dks wrote:

These static web methods cannot access the page's controls or their view state hence the danger of multiple requests and concurrency does not arise.

ganesh.dks wrote:

You call a static web method which means it does not have an associated object making it stateless(why do they use the term stateless?), which there by makes it work like a service which takes data, processes it, and returns something but does not keep anything to itself.

ganesh.dks wrote:

Also you can choose to change the state of the controls present on the webpage by getting data in this manner and using JavaScript