c# - Cannot Edit Cells in RadGridView Telerik WPF -


i using telerik's radgridview display data database. data want load gridview , added 3 columns users type in additional information.

the problem i'm having when type in information 1 of empty cells , click out of row/column, information i've typed in disappears. i've scoured every forum relating , think have code right using gridview.items.commitedit, information i've inputted empty cells still disappears. here code creates columns:

private void window_loaded(object sender, routedeventargs e)     {         //loads queries each of designated data tables in bsi_test         var customerquery =             (from customer in testentity.customers              join job in testentity.jobs              on customer.cid equals job.cid              join claim in testentity.claims              on job.jid equals claim.jid              select new              {                  customer_name = customer.cname,                  customer_id = customer.cid,                  job_id = job.jid,                  claim_id = claim.claimid,                  did = deductid,                  check_no = checkno,                  check_date = checkdate              })             .orderby(c => c.customer_name);           //populates telerik data grid data.         gridview.itemssource = customerquery.tolist();           gridviewdatacolumn deductid = new gridviewdatacolumn();         deductid.uniquename = "deductid";         deductid.header = "did";         deductid.datamemberbinding = new binding("deductid");         gridview.columns.add(deductid);          gridviewdatacolumn checkno = new gridviewdatacolumn();         checkno.uniquename = "checkno";         checkno.header = "check no";         checkno.datamemberbinding = new binding("checkno");         gridview.columns.add(checkno);          gridviewdatacolumn checkdate = new gridviewdatacolumn();         checkdate.uniquename = "checkdate";         checkdate.header = "check date";         checkdate.datamemberbinding = new binding("checkdate");         gridview.columns.add(checkdate);     }

and here gridview_celleditended event attempts commit edits made columns. note: did test event out using breakpoints , make way through if statement when type information cell , click out of it. however, data have inputted still disappears, commitedit doesn't seem work properly.

bool handle = true; private void gridview_celleditended(object sender, gridviewcelleditendedeventargs e) {     if (e.editaction == gridvieweditaction.commit && handle)     {         handle = false;         gridview.items.edititem(this.gridview.currentitem);         gridview.items.commitedit();         handle = true;     } }

if able me out this, appreciated. i'm confused wrong code.

edit: have updated code window_loaded event show linq query queries information database datagrid. itemssource set query list. below before mainwindow() method set properties deductid, checkno, , checkdate.

public string deductid { get; set; } public int checkno { get; set; } public string checkdate { get; set; }  public mainwindow() {     initializecomponent(); }

edit: i've added in deductid, checkno, , checkdate properties linq query.

edit: here dataproperties class:

public partial class dataproperties {     public string cname { get; set; }     public int cid { get; set; }     public int jid { get; set; }     public int claimid { get; set; }     public string deductid { get; set; }     public string checkno { get; set; }     public string checkdate { get; set; } }

you should set datamemberbinding property of each column binding object:

private void window_loaded(object sender, routedeventargs e) {     gridviewdatacolumn deductid = new gridviewdatacolumn();     deductid.uniquename = "deductid";     deductid.header = "did";     deductid.datamemberbinding = new system.windows.data.binding("deductid");     gridview.columns.add(deductid);      gridviewdatacolumn checkno = new gridviewdatacolumn();     checkno.uniquename = "checkno";     checkno.header = "check no";     deductid.datamemberbinding = new system.windows.data.binding("checkno");     gridview.columns.add(checkno);      gridviewdatacolumn checkdate = new gridviewdatacolumn();     checkdate.uniquename = "checkdate";     checkdate.header = "check date";     deductid.datamemberbinding = new system.windows.data.binding("checkdate");     gridview.columns.add(checkdate); }

you need make sure type t of ienumerable<t> have set itemssource radgridview contains deductid, checkno , checkdate properties , each of these have public setter.

binding collection of objects of anonymous type won't work. need create class contains properties (customer_name, customer_id, job_id, claim_id, deductid, checkno , checkdate) , have public setters want able edit in radgridview:

var customerquery =            (from customer in testentity.customers             join job in testentity.jobs             on customer.cid equals job.cid             join claim in testentity.claims             on job.jid equals claim.jid             select new yourclass //<--             {                 customer_name = customer.cname,                 customer_id = customer.cid,                 job_id = job.jid,                 claim_id = claim.claimid,                 did = deductid,                 check_no = checkno,                 check_date = checkdate             })            .orderby(c => c.customer_name);

Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more