Click here to Skip to main content
16,015,218 members
Search within:


Problem update methode in grid view ASP net
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
ASP
Gridview
Good morning I hav problem with asp net Grid View control in my web page. I can correctly get records by selected methode and populate Grid view. But I can configure correctly Update methode. It seems nothing happen when I press Update button.
I use Grid view and Object data source. I can correctly connect with database server that is MySql server db.
The Update methode is fired, but all its params seem not to be updated. Only if I make them read only the methode can get updated value.

What I have tried:

Asp net web page

<%@ Page Title="" Language="C#" AutoEventWireup="true" MasterPageFile="~/Site.Master" CodeBehind="gestioneLetture_G.aspx.cs" Inherits="clearbill.portale.gestioneLetture_G" %>



<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="server">

 
    <div>
        <div>
            POD:
            <div> <input type="text" id="Button1"  value="..." style="float: left;" /> </div>
        </div>        
        <div> <input type="button" id="btnRefresh"  value="Search" style="float: left;" /> </div>        
    </div>
    
   <asp:objectdatasource
          id="ObjectDataSource1"
          runat="server"         
          selectmethod="GetAllLetture99"
          UpdateMethod="UpdateLetture99"  
          DeleteMethod="DeleteLetture99"    
          DataObjectTypeName = "clearbill.portale.Lettura99"
          typename="clearbill.portale.Tabella99Leture" ConvertNullToDBNull="True" >
          <UpdateParameters>
               <asp:formparameter name="tb099_id" formfield="tb099_id" />
              <asp:formparameter name="tb099_pod_id_tb001" formfield="tb099_pod_id_tb001" />
           </UpdateParameters>  
    </asp:ObjectDataSource>
    <asp:gridview
          id="GridView1"
          runat="server"    
          DataKeyNames ="tb099_id"
        OnRowUpdating="TaskGridView_RowUpdating"
          AutoGenerateColumns ="true" 
          AllowPaging ="true"
          datasourceid="ObjectDataSource1" AllowSorting="True" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" AutoGenerateSelectButton="True" OnRowUpdated="GridView1_RowUpdated" ValidateRequestMode="Enabled" ViewStateMode="Enabled">
        <Columns>
            <asp:BoundField DataField="tb099_id" HeaderText="tb099_id" ReadOnly="true" SortExpression="tb099_id" />
            <asp:BoundField DataField="tb099_pod_id_tb001" HeaderText="tb099_pod_id_tb001" ReadOnly="false" SortExpression="tb099_pod_id_tb001" />
            <asp:BoundField DataField="tb099_fattura_id_tb027" HeaderText="tb099_fattura_id_tb027" ReadOnly="false" SortExpression="tb099_fattura_id_tb027" />
            
            <asp:BoundField DataField="tb099_potcontrimp" HeaderText="tb099_potcontrimp" ReadOnly="false" SortExpression="tb099_potcontrimp" />
            <asp:BoundField DataField="tb099_lettura_eaf1" HeaderText="tb099_lettura_eaf1" ReadOnly="false" SortExpression="tb099_lettura_eaf1" />
            <asp:BoundField DataField="tb099_lettura_eaf2" HeaderText="tb099_lettura_eaf2" ReadOnly="false" SortExpression="tb099_lettura_eaf2" />
            <asp:BoundField DataField="tb099_lettura_eaf3" HeaderText="tb099_lettura_eaf3" ReadOnly="false" SortExpression="tb099_lettura_eaf3" />
            <asp:BoundField DataField="tb099_lettura_erf1" HeaderText="tb099_lettura_erf1" ReadOnly="false" SortExpression="tb099_lettura_erf1" />
            <asp:BoundField DataField="tb099_lettura_erf2" HeaderText="tb099_lettura_erf2" ReadOnly="false" SortExpression="tb099_lettura_erf2" />
            <asp:BoundField DataField="tb099_lettura_erf3" HeaderText="tb099_lettura_erf3" ReadOnly="false" SortExpression="tb099_lettura_erf3" />
            <asp:BoundField DataField="tb099_lettura_potf1" HeaderText="tb099_lettura_potf1" ReadOnly="false" SortExpression="tb099_lettura_potf1" />
            <asp:BoundField DataField="tb099_lettura_potf2" HeaderText="tb099_lettura_potf2" ReadOnly="false" SortExpression="tb099_lettura_potf2" />
            <asp:BoundField DataField="tb099_lettura_potf3" HeaderText="tb099_lettura_potf3" ReadOnly="false" SortExpression="tb099_lettura_potf3" />
            <asp:BoundField DataField="tb099_tipo_misura" HeaderText="tb099_tipo_misura" ReadOnly="false" SortExpression="tb099_tipo_misura" />
            <asp:BoundField DataField="tb099_consumo_eaf1" HeaderText="tb099_consumo_eaf1" ReadOnly="false" SortExpression="tb099_consumo_eaf1" />
            <asp:BoundField DataField="tb099_consumo_eaf2" HeaderText="tb099_consumo_eaf2" ReadOnly="false" SortExpression="tb099_consumo_eaf2" />
            <asp:BoundField DataField="tb099_consumo_eaf3" HeaderText="tb099_consumo_eaf3" ReadOnly="false" SortExpression="tb099_consumo_eaf3" />
            <asp:BoundField DataField="tb099_consumo_erf1" HeaderText="tb099_consumo_erf1" ReadOnly="false" SortExpression="tb099_consumo_erf1" />
            <asp:BoundField DataField="tb099_consumo_erf2" HeaderText="tb099_consumo_erf2" ReadOnly="false" SortExpression="tb099_consumo_erf2" />
            <asp:BoundField DataField="tb099_consumo_erf3" HeaderText="tb099_consumo_erf3" ReadOnly="false" SortExpression="tb099_consumo_erf3" />
            <asp:BoundField DataField="tb099_consumo_progressivo_eaf1" HeaderText="tb099_consumo_progressivo_eaf1" ReadOnly="false" SortExpression="tb099_consumo_progressivo_eaf1" />
            <asp:BoundField DataField="tb099_consumo_progressivo_eaf2" HeaderText="tb099_consumo_progressivo_eaf2" ReadOnly="false" SortExpression="tb099_consumo_progressivo_eaf2" />
            <asp:BoundField DataField="tb099_consumo_progressivo_eaf3" HeaderText="tb099_consumo_progressivo_eaf3" ReadOnly="false" SortExpression="tb099_consumo_progressivo_eaf3" />
            <asp:BoundField DataField="tb099_codice_pod" HeaderText="tb099_codice_pod" ReadOnly="false" SortExpression="tb099_codice_pod" />
            <asp:BoundField DataField="tb099_is_iniziale" HeaderText="tb099_is_iniziale" ReadOnly="false" SortExpression="tb099_is_iniziale" />            
           <asp:CommandField ShowEditButton="True" />
        </Columns>
    </asp:gridview>

        
    

    <script>

        $(document).ready(function () {

            $("#btnRefresh").click(function click_allpod(cb) {
                var v = "";
            });

        });

    </script>

</asp:Content>


Behind code class in c#

using clearbill.Common;

using System;
using System.Collections.Generic;
using System.IO;
using System.IO.Compression;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Services;
using System.Collections.ObjectModel;
using System.Xml;
using System.Data;
using clearbill.common.ModelSubsonic;
using clearbill.core.bllSubsonic;
using clearbill.core.portale;
using clearbill.Common.DataAccess.Model;
using clearbill.core.bll;
using MySql.Data;
using System.Collections;
using MySql.Data.MySqlClient;
using System.Configuration;
using System.Web.Configuration;
using System.Windows.Forms;
using System.Threading;
using clearbill.core.bll.Import;
using System.Text;
using System.Reflection;
using System.Web.UI.HtmlControls;
using System.Xml.Schema;
using System.Data.SqlClient;
using SubSonic.SqlGeneration.Schema;
using System.ComponentModel;


namespace clearbill.portale
{
    public partial class gestioneLetture_G : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            int i = 0;
            
        }


        protected void TaskGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            //Retrieve the table from the session object.
            DataTable dt = (DataTable)Session["TaskTable"];
            
            //GridView1.DataBind();
        }

        protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
        {
            ((clearbill.portale.gestioneLetture_G)(HttpContext.Current.Handler)).GridView1.Rows[1].RowState = DataControlRowState.Normal;
            GridViewRow r = ((clearbill.portale.gestioneLetture_G)(HttpContext.Current.Handler)).GridView1.Rows[1];
        }
    }

    //----------------------------   DAL    -----------------------------------------------------------------------------

    public class Tabella99Leture
    {

        public int tb099_id;
        public int tb099_pod_id_tb001;
        public int tb099_fattura_id_tb027;
        public DateTime tb099_data_lettura;
        public decimal tb099_potcontrimp;
        public decimal tb099_lettura_eaf1;
        public decimal tb099_lettura_eaf2;
        public decimal tb099_lettura_eaf3;
        public decimal tb099_lettura_erf1;
        public decimal tb099_lettura_erf2;
        public decimal tb099_lettura_erf3;
        public decimal tb099_lettura_potf1;
        public decimal tb099_lettura_potf2;
        public decimal tb099_lettura_potf3;
        public string tb099_tipo_misura;
        public decimal tb099_consumo_eaf1;
        public decimal tb099_consumo_eaf2;
        public decimal tb099_consumo_eaf3;
        public decimal tb099_consumo_erf1;
        public decimal tb099_consumo_erf2;
        public decimal tb099_consumo_erf3;
        public decimal tb099_consumo_progressivo_eaf1;
        public decimal tb099_consumo_progressivo_eaf2;
        public decimal tb099_consumo_progressivo_eaf3;
        public string tb099_codice_pod;
        public bool tb099_is_iniziale;

         //DAL query Sql
        public static DataTable ExecuteDataTable(string SQL)
        {
            ConnectionStringSettings settings = WebConfigurationManager.ConnectionStrings["ClearBillMySqlConnection"];
            MySqlConnection con = new MySqlConnection(settings.ConnectionString);
            MySqlCommand cmd = new MySqlCommand();
            con.Open();
            try
            {
                DataTable dt = new DataTable();
                cmd = new MySqlCommand(SQL, con);
                MySqlDataAdapter DA = new MySqlDataAdapter(cmd);
                DA.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {                
                throw ex;
            }
            finally
            {
                if (con.State == ConnectionState.Open)
                    con.Close();

                con.Dispose();
                cmd.Dispose();
            }
        }

        // Returns a collection of NorthwindEmployee objects.
        public static ICollection GetAllLetture99()
        {
            ArrayList al = new ArrayList();
            string selectCommand = "SELECT * FROM tb099_riepilogo_letture_elettrico limit 100";
            DataTable resSelect = ExecuteDataTable(selectCommand);
            IEnumerable IDs = resSelect.DefaultView;
            // Iterate through the Enumeration and create a
            // NorthwindEmployee object for each ID.
            foreach (DataRowView row in IDs)
            {
                string id = row["tb099_id"].ToString();
                Lettura99 nwe = new Lettura99();               
                nwe.tb099_id                        = (int)row["tb099_id"];
                nwe.tb099_pod_id_tb001              = (int)row["tb099_pod_id_tb001"];
                nwe.tb099_fattura_id_tb027          = !DBNull.Value.Equals(row["tb099_fattura_id_tb027"])   ? (int)row["tb099_fattura_id_tb027"] : 0;
                nwe.tb099_data_lettura              = !DBNull.Value.Equals(row["tb099_data_lettura"])       ? (DateTime)row["tb099_data_lettura"] : new DateTime();
                nwe.tb099_potcontrimp               = !DBNull.Value.Equals(row["tb099_potcontrimp"])        ? (decimal?)row["tb099_potcontrimp"] : 0;
                nwe.tb099_lettura_eaf1              = !DBNull.Value.Equals(row["tb099_lettura_eaf1"])       ? (decimal?)row["tb099_lettura_eaf1"] :0;
                nwe.tb099_lettura_eaf2              = !DBNull.Value.Equals(row["tb099_lettura_eaf2"])       ? (decimal?)row["tb099_lettura_eaf2"] : 0;
                nwe.tb099_lettura_eaf3              = !DBNull.Value.Equals(row["tb099_lettura_eaf3"])       ? (decimal?)row["tb099_lettura_eaf3"] : 0;
                nwe.tb099_lettura_erf1              = !DBNull.Value.Equals(row["tb099_lettura_erf1"])       ? (decimal?)row["tb099_lettura_erf1"] : 0;
                nwe.tb099_lettura_erf2              = !DBNull.Value.Equals(row["tb099_lettura_erf2"])       ? (decimal?)row["tb099_lettura_erf2"] : 0;
                nwe.tb099_lettura_erf3              = !DBNull.Value.Equals(row["tb099_lettura_erf3"])       ? (decimal?)row["tb099_lettura_erf3"] : 0;
                nwe.tb099_lettura_potf1             = !DBNull.Value.Equals(row["tb099_lettura_potf1"])      ? (decimal?)row["tb099_lettura_potf1"] : 0;
                nwe.tb099_lettura_potf2             = !DBNull.Value.Equals(row["tb099_lettura_potf2"])      ? (decimal?)row["tb099_lettura_potf2"] : 0;
                nwe.tb099_lettura_potf3             = !DBNull.Value.Equals(row["tb099_lettura_potf3"])      ? (decimal?)row["tb099_lettura_potf3"] :0;
                nwe.tb099_tipo_misura               = !DBNull.Value.Equals(row["tb099_tipo_misura"])        ? (string)row["tb099_tipo_misura"] : "";
                nwe.tb099_consumo_eaf1              = !DBNull.Value.Equals(row["tb099_consumo_eaf1"])       ? (decimal?)row["tb099_consumo_eaf1"] : 0;
                nwe.tb099_consumo_eaf2              = !DBNull.Value.Equals(row["tb099_consumo_eaf2"])       ? (decimal?)row["tb099_consumo_eaf2"] : 0;
                nwe.tb099_consumo_eaf3              = !DBNull.Value.Equals(row["tb099_consumo_eaf3"])       ? (decimal?)row["tb099_consumo_eaf3"] : 0;
                nwe.tb099_consumo_erf1              = !DBNull.Value.Equals(row["tb099_consumo_erf1"])       ? (decimal?)row["tb099_consumo_erf1"] : 0;
                nwe.tb099_consumo_erf2              = !DBNull.Value.Equals(row["tb099_consumo_erf2"])       ? (decimal?)row["tb099_consumo_erf2"] : 0;
                nwe.tb099_consumo_erf3              = !DBNull.Value.Equals(row["tb099_consumo_erf3"])       ? (decimal?)row["tb099_consumo_erf3"] : 0;
                nwe.tb099_consumo_progressivo_eaf1  = !DBNull.Value.Equals(row["tb099_consumo_progressivo_eaf1"]) ? (decimal?)row["tb099_consumo_progressivo_eaf1"] : 0;
                nwe.tb099_consumo_progressivo_eaf2  = !DBNull.Value.Equals(row["tb099_consumo_progressivo_eaf2"]) ? (decimal?)row["tb099_consumo_progressivo_eaf2"] : 0;
                nwe.tb099_consumo_progressivo_eaf3  = !DBNull.Value.Equals(row["tb099_consumo_progressivo_eaf3"]) ? (decimal?)row["tb099_consumo_progressivo_eaf3"] : 0;
                nwe.tb099_codice_pod                = !DBNull.Value.Equals(row["tb099_codice_pod"])        ? (string)row["tb099_codice_pod"] : "";
                if(!DBNull.Value.Equals(row["tb099_is_iniziale"]) ){
                    if (DBNull.Value.Equals(row["tb099_is_iniziale"]) == true)
                    {
                        nwe.tb099_is_iniziale = true;
                    }else{
                        nwe.tb099_is_iniziale = false;
                    }
                }                                                                            
                // Add the NorthwindEmployee object to the collection.
                al.Add(nwe);
            }           
            
            return al;
        }

        public static Lettura99 GetLetture99(object anID)
        {
            return new Lettura99(anID);
        }

        public static void UpdateLetture99(
                int tb099_id,
                int tb099_pod_id_tb001,      
                int tb099_fattura_id_tb027,  
                DateTime tb099_data_lettura,      
                decimal tb099_potcontrimp,       
                decimal tb099_lettura_eaf1,      
                decimal tb099_lettura_eaf2,      
                decimal tb099_lettura_eaf3,      
                decimal tb099_lettura_erf1,     
                decimal tb099_lettura_erf2,      
                decimal tb099_lettura_erf3,      
                decimal tb099_lettura_potf1,     
                decimal tb099_lettura_potf2,     
                decimal tb099_lettura_potf3,     
                string tb099_tipo_misura,       
                decimal tb099_consumo_eaf1,      
                decimal tb099_consumo_eaf2,      
                decimal tb099_consumo_eaf3,      
                decimal tb099_consumo_erf1,      
                decimal tb099_consumo_erf2,      
                decimal tb099_consumo_erf3,      
                decimal tb099_consumo_progressivo_eaf1, 
                decimal tb099_consumo_progressivo_eaf2,
                decimal tb099_consumo_progressivo_eaf3,  
                string tb099_codice_pod,
                bool   tb099_is_iniziale
            )
        {
            bool retval = true;
            int i = 0;
            string cmdSQL = "UPDATE tb099_riepilogo_letture_elettrico SET " +
            "tb099_pod_id_tb001 =" + tb099_pod_id_tb001 + ", " +
            "tb099_fattura_id_tb027 =" + tb099_fattura_id_tb027 + "," +
            "tb099_data_lettura ='" + tb099_data_lettura + "', " +
            "tb099_potcontrimp =" + tb099_potcontrimp + ", " +
            "tb099_lettura_eaf1 =" + tb099_lettura_eaf1 + ", " +
            "tb099_lettura_eaf2 =" + tb099_lettura_eaf2 + ", " +
            "tb099_lettura_eaf3 =" + tb099_lettura_eaf3 + ", " +
            "tb099_lettura_erf1 =" + tb099_lettura_erf1 + ", " +
            "tb099_lettura_erf2 =" + tb099_lettura_erf2 + ", " +
            "tb099_lettura_erf3 =" + tb099_lettura_erf3 + ", " +
            "tb099_lettura_potf1 =" + tb099_lettura_potf1 + ", " +
            "tb099_lettura_potf2 =" + tb099_lettura_potf2 + ", " +
            "tb099_lettura_potf3 =" + tb099_lettura_potf3 + ", " +
            "tb099_tipo_misura ='" + tb099_tipo_misura + "', " +
            "tb099_consumo_eaf1 =" + tb099_consumo_eaf1 + ", " +
            "tb099_consumo_eaf2 =" + tb099_consumo_eaf2 + ", " +
            "tb099_consumo_eaf3 =" + tb099_consumo_eaf3 + ", " +
            "tb099_consumo_erf1 =" + tb099_consumo_erf1 + ", " +
            "tb099_consumo_erf2 =" + tb099_consumo_erf2 + ", " +
            "tb099_consumo_erf3 =" + tb099_consumo_erf3 + ", " +
            "tb099_consumo_progressivo_eaf1 =" + tb099_consumo_progressivo_eaf1 + ", " +
            "tb099_consumo_progressivo_eaf2 =" + tb099_consumo_progressivo_eaf2 + ", " +
            "tb099_consumo_progressivo_eaf3 =" + tb099_consumo_progressivo_eaf3 + ", " +
            "tb099_codice_pod ='" + tb099_codice_pod + "', " +
            "tb099_is_iniziale =" + tb099_is_iniziale  + " " +
            "WHERE tb099_id =" + tb099_id + ";";

            //ExecuteDataTable(cmdSQL);

            //bool retval = ne.Save();
            if (!retval) { throw new NorthwindDataException("UpdateEmployee failed."); }
        }

        public static void UpdateLetture99(Lettura99 entry)
        {
            
            int idSel = entry.tb099_id;
            //Riga selezionata
            GridViewRow r = ((clearbill.portale.gestioneLetture_G)(HttpContext.Current.Handler)).GridView1.Rows[idSel];
            //var v1 = ((clearbill.portale.gestioneLetture_G)(HttpContext.Current.Handler)).ObjectDataSource1.;
            var v = r.Cells[1].Text;
            bool retval = true;
            int i = 0;
            string cmdSQL = "UPDATE tb099_riepilogo_letture_elettrico SET " +
            "tb099_pod_id_tb001 =" + r.Cells[1].Text +", " +
            "tb099_fattura_id_tb027 =" + r.Cells[2].Text + "," +
            "tb099_data_lettura ='" + r.Cells[3].Text + "', " +
            "tb099_potcontrimp =" + r.Cells[4].Text + ", " +
            "tb099_lettura_eaf1 =" + r.Cells[5].Text + ", " +
            "tb099_lettura_eaf2 =" + r.Cells[6].Text + ", " +
            "tb099_lettura_eaf3 =" + r.Cells[7].Text + ", " +
            "tb099_lettura_erf1 =" + r.Cells[8].Text + ", " +
            "tb099_lettura_erf2 =" + r.Cells[9].Text + ", " +
            "tb099_lettura_erf3 =" + r.Cells[10].Text + ", " +
            "tb099_lettura_potf1 =" + r.Cells[11].Text + ", " +
            "tb099_lettura_potf2 =" + r.Cells[12].Text + ", " +
            "tb099_lettura_potf3 =" + r.Cells[13].Text + ", " +
            "tb099_tipo_misura ='" + r.Cells[14].Text + "', " +
            "tb099_consumo_eaf1 =" + r.Cells[15].Text + ", " +
            "tb099_consumo_eaf2 =" + r.Cells[16].Text + ", " +
            "tb099_consumo_eaf3 =" + r.Cells[17].Text + ", " +
            "tb099_consumo_erf1 =" + r.Cells[18].Text + ", " +
            "tb099_consumo_erf2 =" + r.Cells[19].Text + ", " +
            "tb099_consumo_erf3 =" + r.Cells[20].Text + ", " +
            "tb099_consumo_progressivo_eaf1 =" + r.Cells[21].Text + ", " +
            "tb099_consumo_progressivo_eaf2 =" + r.Cells[22].Text + ", " +
            "tb099_consumo_progressivo_eaf3 =" + r.Cells[23].Text + ", " +
            "tb099_codice_pod ='" + r.Cells[24].Text + "', " +
            "tb099_is_iniziale =" + r.Cells[25].Text + " " +
            "WHERE tb099_id =" + idSel + ";";

            //ExecuteDataTable(cmdSQL);

            //bool retval = ne.Save();
            if (!retval) { throw new NorthwindDataException("UpdateEmployee failed."); }
        }

        public static void DeleteLetture99(Lettura99 ne) {
            string cmdSQL =" DELETE FROM  tb099_riepilogo_letture_elettrico SET " + "";
        }

    }

    public class Lettura99 : INotifyPropertyChanged 
    {
        
        [SubSonicPrimaryKey]
        public int tb099_id { get; set; }

        public int tb099_pod_id_tb001 { get; set; }

        public int? tb099_fattura_id_tb027 { get; set; }

        public DateTime? tb099_data_lettura { get; set; }

        
        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_potcontrimp { get; set; }


        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_eaf1 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_eaf2 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_eaf3 { get; set; }


        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_erf1 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_erf2 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_erf3 { get; set; }


        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_potf1 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_potf2 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_lettura_potf3 { get; set; }

        [SubSonicNullString]
        public string tb099_tipo_misura { get; set; }


        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_eaf1 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_eaf2 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_eaf3 { get; set; }


        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_erf1 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_erf2 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_erf3 { get; set; }


        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_progressivo_eaf1 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_progressivo_eaf2 { get; set; }

        [SubSonicNumericPrecision(20, 6)]
        public decimal? tb099_consumo_progressivo_eaf3 { get; set; }


        [SubSonicNullString]
        public string tb099_codice_pod { get; set; }

        [SubSonicDefaultSetting(0)]
        public bool? tb099_is_iniziale { get; set; }

        public Lettura99(object anID)
        {
           
        }

        public Lettura99()
        {
            int i = 0;
           /* this.ID = anID;

            ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["NorthwindConnection"];

            SqlConnection conn = new SqlConnection(cts.ConnectionString);
            SqlCommand sc =
              new SqlCommand(" SELECT FirstName,LastName,Title,TitleOfCourtesy,ReportsTo " +
                             " FROM Employees " +
                             " WHERE EmployeeID = @empId",
                             conn);
            // Add the employee ID parameter and set its value.
            sc.Parameters.Add(new SqlParameter("@empId", SqlDbType.Int)).Value = Int32.Parse(anID.ToString());
            SqlDataReader sdr = null;

            try
            {
                conn.Open();
                sdr = sc.ExecuteReader();

                // This is not a while loop. It only loops once.
                if (sdr != null && sdr.Read())
                {
                    // The IEnumerable contains DataRowView objects.
                    this.firstName = sdr["FirstName"].ToString();
                    this.lastName = sdr["LastName"].ToString();
                    this.title = sdr["Title"].ToString();
                    this.titleOfCourtesy = sdr["TitleOfCourtesy"].ToString();
                    if (!sdr.IsDBNull(4))
                    {
                        this.reportsTo = sdr.GetInt32(4);
                    }
                }
                else
                {
                    throw new NorthwindDataException("Data not loaded for employee id.");
                }
            }
            finally
            {
                try
                {
                    if (sdr != null) sdr.Close();
                    conn.Close();
                }
                catch (SqlException)
                {
                    // Log an event in the Application Event Log.
                    throw;
                }
            }*/
        }

        // This method is called by the Set accessor of each property.
        // The CallerMemberName attribute that is applied to the optional propertyName
        // parameter causes the property name of the caller to be substituted as an argument.
        private void NotifyPropertyChanged([System.Runtime.CompilerServices.CallerMemberName] String propertyName = "")
        {
            if (PropertyChanged != null)
            {
                PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
            }
        }

        public bool Save()
        {
            return true;
        }

        public event PropertyChangedEventHandler PropertyChanged;
    }

    internal class NorthwindDataException : Exception
    {
        public NorthwindDataException(string msg) : base(msg) { }
    }

    //http://www.aspsnippets.com/Articles/Display-data-from-database-in-HTML-table-in-ASPNet.aspx
    //https://msdn.microsoft.com/en-us/library/ms972948.aspx
}
Posted
Add a Solution
Comments
Karthik_Mahalingam 6-Mar-17 4:23am    
post only relevant code, dont paste entire code.
Andy_Bell 6-Mar-17 4:52am    
Sorry, but I thought it be usefull to find the problem. I thought it depended by some Asp component or methode definition, so I was unable to select specific portions of code. In future I try to be more stringent.
Karthik_Mahalingam 6-Mar-17 5:01am    
hmm, but difficult to trace entire code..
Andy_Bell 6-Mar-17 5:37am    
I'm in your hands. Any sugestion will be appreciated
Karthik_Mahalingam 6-Mar-17 8:58am    
in which part you are getting stuck? simplify the issue.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Long Running Process in Asp,Net
Grid view and code behind on ASP NET
row updating problem in grid view
problem in grid view.
problem in grid view
grid view problem in asp 3.5
How to show hyperlinks in asp,net grid view.
Asp grid view in web method and jquery
grid view edit and update problem
grid view update problem

Advertise
Privacy
Cookies
Terms of Use
Last Updated 6 Mar 2017
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-07-22:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900