I have a gridview that I have bound to a DataSet that displays a customer's address information. (Select FNAME, LNAME, STREET, CITY, STATE, ZIP FROM CUSTOMERS)
I have a textbox that a user will type a search criteria into and click a button. What I am trying to do is run the sql again with that criteria applied and return the results to the user by updating this GridView.
This should be simple and I have done it before in Access. But, I am stumped right now and could use some help.
Table adapter is named CUSTOMERSTableAdapter
Binding source is named CUSTOMERSBindingSource
Data set is named ECOMLIVEDataSet
If my button was named btnCustomerSearch, what code should execute on the _click event to revise the SQL?
Thanks in advance. Maybe somebody can point to a tutorial online somewhere or help explain this.
Hi,
i have got System.OutOfMemoryException while assigning dataset with 3+ milllion records to PivotGrid. I understand that this is sql driver memory limitation, but how do you suggest to solve it besides using analysis services?
Thanks
Alex
Hi,
looks like a bug:
if i set
this.radPivotGrid1.AutoExpandColumnHeaders = false;
this.radPivotGrid1.AutoExpandRowHeaders = false;
then add 3rd field to Sum values and change it to Average - PivotGrid still show "Sum of ...", plus you can't change column width, etc
I tried on this sample project:
http://feedback.telerik.com/Project/154/Feedback/Details/196043-improve-radpivotgrid-extend-the-save-load-api-to-always-serialize-the-filterde
Alex
Need a way of disabling a checkbox cell in a unbound grid based data obtained elsewhere.
Basically, I have a Combobox Column displaying Employee Name. When I select a Employee, I have a 'Bonus' checkbox column that I "may" need to disable based on the Employee selected.
Something like, I select Employee A from the 'Employee Name' column and determine if this employee is eligible to receive a bonus. If Employee is NOT eligible, I want to disable the 'Bonus' checkbox column for this row, unselect the checkbox if it is selected, and visually show that it is disabled. If Employee is eligible the 'Bonus' column for the row should be enabled and visually show that it is enabled.
Not exactly sure how to accomplish this and would appreciate any help anyone can provide.
Thank you.
James
Posted 3 hours ago
I am attempting to add validation to my grid which has 3 columns: ID, NAME, STATUS
My data is not bounded to an adaptor (requirement).
I am trying to validate for the existence of name in my database on the RowsChanging event.
On NotifyCollectionChangedAction.Add , I pass the value of NAME to my stored procedure and determine if the NAME value exists; no problems.
On NotifyCollectionChangedAction.ItemChanging, I pass the values of ID and NAME to my stored procedure and determine if the NAME value exists.
Problem is, the NAME value passed on ItemChanging is what is currently in the cell, not what is in the editor. How can I get the editor value at this time?
The maximized form misses the the outer border (a few millimeters). The behavior appeared with Release 2016.2.608.20 from 2015.3.930.20.
I could reproduce the behavior with an empty form. The executable seem to have this behavior only on my computer.
See the attached images. Do you have any idea?
Starting from scratch, the SystemButton's minimize, maximize, and close are incredibly small.. Is this a glitch, or is this the starting theme for a RadTitleBar?
I feel this is a glitch. If this is not, can someone provide detailed instructions on how to get the ContextMenu items to show properly?
Hello,
I would like to know if it is possible to center the text (I have set the radtextboxitem's textalign to center but this had no effect)
Also I would like the popup to popup or close when i click on the text (I tried to do this in the click event but it didn't behave the way i was expecting).
Thank you
Hello,
I have standard control drag and drop in my app, so I have .net DragEnter, DragDrop, DragOver, etc. handlers for the RadGridView in my form. Of course, grid doesn't react properly on mouse activity over it. In my DragOver handler I want to set row under the cursor to hovered state. I found GridTableElement.HoveredRow property, but it is internal. Is there a way to programmatically make grid to set a row into howered state?