ASP.NET

John C Rayan wrote:

Is this forum for MVC too? or is there any separate forum for MVC?

<%@ 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.