Do CRUD on Gridview via WCF

Question

How can I do Populate, Create, Insert, Delete in gridview via WCF ?

I have the problem that it cannot find the fieldname, but I can get the data.

On my Service code:

[DataContract]
    public class Pers_Horraire
    {
        [DataMember]
        string _ClientId;
        public string ClientId
        {
            get { return _ClientId; }
            set { _ClientId = value; }
        }

        [DataMember]
        string _Horraire;
        public string Horraire
        {
            get { return _Horraire; }
            set { _Horraire = value; }
        }       
    }

[OperationContract]
public IList Get_Horraire(string CodeCL)
    {
        try
        {
            using (var connectionWrapper = new Connexion())
            {
                var connectedConnection = connectionWrapper.GetConnected();
                //string sql_SelectAll = Outils.LoadFileToString(HttpContext.Current.Server.MapPath("~/SQL/Ordre_Selt.sql"));
                string sql_SelectAll = "SELECT CLIENT_ID,HORRAIRE FROM LS_CLIENTHORRAIRE WHERE CLIENT_ID = @CLIENT_ID";
                SqlCommand comm_SelectAll = new SqlCommand(sql_SelectAll, connectionWrapper.conn);
                comm_SelectAll.Parameters.AddWithValue("@CLIENT_ID", CodeCL);
                SqlDataReader readerOne = comm_SelectAll.ExecuteReader();

                List oListOrdr = new List();
                Pers_Horraire obj_Horr = new Pers_Horraire();
                while (readerOne.Read())
                {
                    obj_Horr.ClientId = readerOne["CLIENT_ID"].ToString();
                    obj_Horr.Horraire = readerOne["HORRAIRE"].ToString();
                    oListOrdr.Add(obj_Horr);
                }
                readerOne.Close();
                readerOne.Dispose();
                return oListOrdr;
            }
        }
        catch (Exception excThrown)
        {
            throw new Exception(excThrown.Message);
        }
    }

And I consume with grid:

Code behind:

public void GetDataHorr()
{
    try
    {
        Service1Client client = new Service1Client();

        ASPxGridView_Horraire.DataSource = client.Get_Horraire(Id);  
        ASPxGridView_Horraire.DataBind();

        //just to show i get the data from WCF
        foreach (var oItem in client.Get_Horraire(Id))
        {
            ASPxLabel_err.Text += oItem + "_______";
        }
    }
    catch (Exception excThrown)
    {
        ASPxLabel_err.Text = excThrown.Message + "-->" + excThrown.InnerException;
    }
}

The problem it cannot find FieldName="HORRAIRE" so if I let FieldName="" it shows me empty column.

Neil Thompson · Accepted Answer

I think you are just returning a List of strings - so there is no concept of FieldNames in the client (the asp page).

eg:

oListOrdr.Add(readerOne["HORRAIRE"].ToString());

the named filed "Horraire" becomes just a string.

Could you amend the WCF Method to return a custom type perhaps?

public IList Get_Horraire(string CodeCL)

where you have

public class Horraire
{
   public int Client_Id {get;set;}
   public string Horraire {get;set;}
}

Do CRUD on Gridview via WCF

Answers (1)

Related Questions