WPF Discussion Boards

Fetching DataGrid Columns Data [modified]

18-Oct-08 22:14

Hello,

It is available in Silverlight 2 RC0.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

fasih198111-Aug-08 1:36

fasih1981

11-Aug-08 1:36

Hi!

My question is:
How to get the columns data(values) of selected row in a datagrid of silverlight in C# code?
My grid has multiple columns.I want to get the data of each column.

Plz also guide me if my grid columns has controls (like "TextBlock" etc)
then how to fetch data from such columns.

Please help me with code and some description.

Thanks in advance.
M.Fasih

fasih_is_my_signature

modified on Monday, August 11, 2008 7:44 AM

Re: Fetching DataGrid Columns Data

Syed Mehroz Alam12-Aug-08 1:31

Syed Mehroz Alam

12-Aug-08 1:31

fasih1981 wrote:
How to get the columns data(values) of selected row in a datagrid of silverlight in C# code?
My grid has multiple columns.I want to get the data of each column.

You can get use the DataGrid.SelectedItem property in a way like:

(dataGrid.SelectedItem as YourObject).AnyProperty

I hope this[^] article that I posted today may help you as it presents a master-detail UI using DataGrids and ListBox.

Regards,
Syed Mehroz Alam

My Articles

Different backgound on different theme selection

Darmi10-Aug-08 23:59

Darmi

10-Aug-08 23:59

Am working on a WPF application having a combobox. I have set the background of combobox to dimgray color.Currently i am using Windows Classic Theme.While working in this theme, if i disable combobox , the background will be dimgrey itself. However, if i change to Windows XP style and disable combobx, the disabled combobox is having a white background. Can we set the backcolor or the style of combobox independent of the themes. If we use Vista operating system, the same scenario can be noted.

How i navigate on local Host

wasimsharp10-Aug-08 23:11

wasimsharp

10-Aug-08 23:11

i Asp.Net when i want to navigate to other page i use Responce.Redirect("abc.aspx") what should i do when i use silver light button for the same navigation on my local Host.

wasim khan

Re: How i navigate on local Host

Syed Mehroz Alam12-Aug-08 1:45

Syed Mehroz Alam

12-Aug-08 1:45

You can simply use:

<br />
System.Windows.Browser.HtmlPage.Window.Navigate( uri here )

Regards,
Syed Mehroz Alam

My Articles

Silverlight Beta 2 | VB | Linq to XML confusion

crystal915410-Aug-08 9:42

crystal9154

10-Aug-08 9:42

OK, I cannot find any VB samples, (different issue if I was doing things in C#). Any way, I am using WebClient class and am successfully reading the XML file of business videos in my xaml.vb file asynchronously. But I am having a problem populating the datagrid properly:

My XML has these nodes:

<videos>
<profession name="lawyer">
<video id="1" title="Lawyer Title 1" />
<video id="2" title="Lawyer Title 2" />
</profession>
<profession name="doctor">
<video id="1" title="Doctor Title 1" />
<video id="2" title="Doctor Title 2" />
</profession>
</videos>

Here's my query

Dim BizVideos = _
From videos In xmlVideos.DescendantsAndSelf("profession") _
Where videos.Attribute("name") = "doctor" _
Select videos

dgridVideoList.ItemsSource = BizVideos

Here's the problem I am experiencing:

1. I am only getting one row in the datadrid with everything included in that one row, as opposed to what I want, i.e. one row for Video ID 1, and one for Video ID 2.

2. I am getting more fields in the datagrid than I want, i.e. "Has Elements", "Has Attributes", "Parent Node", etc.

Can anyone offer me (a.) the correct syntax for the query where I can break out the video child nodes under profession doctor and diplay them one video per row (b.) avoid showing superflulous fields like "Has Attributes", "Parent Node", etc., as well as (c.) what I am doing wrong in the binding of my datagrid?

Thank you all for your help.

Any recommendation for WPF Datagrid??

Michael Sync10-Aug-08 4:53

10-Aug-08 4:53

I've been evaluating around 5 third-party WPF datagrids for my project.. Each Datagrid has some issues.. (Ref[^])

The following are my requirement for buying WPF datagrid..

* Controls inside the Datagrid Column: I wanna display one or more WPF controls (e.g. Checkedbox or Combobox, Textbox or etc) inside the column of Datagrid. Plus, I should be able to set/get the value to/from those controls at runtime.
* Excel-Like Filtering: Should we call it as the row filtering? In Microsoft Excel, we are able to filter by the rows.For example: There are ten student records showing in Datagrid and those students are from Math Major and Physic Major. So, I should be able to filter those students by Major. Yes. it’s like grouping but if I say “grouping”, you might get confused with grouping features of Datagrid.
* Sorting, Grouping: Of course!
* Hierarchical display: Same as Grouping featuer? (Importantly, It would be better if we can specify the appearance of hierarchical in XAML)
* SelectedItem Binding (two ways): I believe that this feature should be included in every datagrid but surprisely, I found a few datagrids that don’t provide this feature. Weird.
* Less work from Code-behind file: What does it mean? It means, I should be able to do the most of works in XAML. In my current project, we are using MVVM (Model-View-ViewModel) pattern with CompositeWPF (Codename: Prism) framework so we do the most of jobs in either XAML or ViewModel (which is not a code-behind file) and we try not to write as much as possible in code-behind file.

It would be great if anyone can recommend some cool WPF datagrid control.. Thanks in advance...

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Jammer10-Aug-08 11:05

10-Aug-08 11:05

I've only used two of note, both of which I'm sure you'll have already tested.

Xceed WPF Grid & Infragistics XamDataGrid.

I'm working on a project for my own company and I'm also working on a large LOB WPF app for my employer, both are using the XamDataGrid. We too are using MVVM (Dan's flavour) in the LOB app. So far we are really pleased with the XamDataGrid. Before opting for the XamDataGrid I test run a few myself and wasn't overly impressed. The Component One stuff just looks terrible in my opinion. The Xceed looks good but due to us wanting to buy a complete suite we ended up opting for the Infragistics stuff (we wanted a good chart as well). In my opinion the Infragistics stuff is still the WPF suite of controls to measure things by.

That said I had an interested reply from one of the sales guys as Nevron. He basically said that for their WPF offering (not available yet) they were going to be implementing their own framework which will be merely hosted by WPF citing performance as their reasoning. I'll be looking out for that as I'm intrigued to find out exactly what he was on about. I've been using the XamDataGrid with datasets of 100,000+ records and i've not had any problems ...

There are a few other small component houses that are making things but they really don't compare to Infragistics yet. Not to mention that the support and developer interaction that I've had with the Infragistics folks has been exemplary. That's worth the price of admission. Don't forget that you can get a full blown copy of the XamDataGrid for FREE!!!! Look for their Express suite ... you get the grid, checkbox and an editor for zilcho ... nada ... nothing ... wooo!

Just out of interest, what have you found that you have liked??

Jammer

Going where everyone here has gone before! Smile | :)

Michael Sync10-Aug-08 18:14

10-Aug-08 18:14

I have tested 5 third-party controls and updated my post yesterday..

Based on my experience, Infragistics/C1 are so unstable for now even though they are big companies.

I like Xceed Datagrid and I think their doc and samples are really great.... I got one reply from Xceed in their forum.. http://xceed.com/CS/forums/thread/13984.aspx[^]

Hopefully, they can solve the problem that Im having now.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Jammer10-Aug-08 22:44

10-Aug-08 22:44

Infragistics?? Unstable???

Are you sure we're talking about the same things??? I have an app out at Beta testing stage using that grid and no-one is reporting problems with the grid ...

What exactly do you mean by unstable?

Jammer

Going where everyone here has gone before! Smile | :)

Michael Sync10-Aug-08 22:46

10-Aug-08 22:46

Please take a look at my post[^]?

I have four problems. It would be great if you can help me to solve those problems..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Michael Sync10-Aug-08 22:47

10-Aug-08 22:47

okay. If you don't want to go to my blog, I will post those issues here. Hope, you may suggest something...

* No SelectedItem: There is no dependency property called SelectedItem or equalivalient in xamlDatagrid. But they do have SelectedItems (with s). I wonder what wrong with SelectedItem. I don’t allow the user to select more than one row at a time so why do I need to loop through the SelectionItem list to get that selected item. Weird.
* Can’t get the reference of controls inside the Datagird: Maybe, I don’t know the correct way of doing this. And also, there is no documentation or sample for that. I tried to use VisualTreeHelper class to walk throught each and every element of Datagird but I just can’t find the controls which are inside DataTemplate. (It’s so easy to do with Xceed Datagrid.). Okay. Never mind.
* Showing the incorrect record if the datasource has some filters: I was using ListCollectionView as a datasource to bind the datagrid. There are some records that need to be excluded so I used the filter predicate for excluding those unnessary records. Then, I binded that ListCollectionView with Datagird. It works for the first time. So, I added new record to ListCollectionView and make it refresh. Opps! it shows the exclued record. crazy! then, I put WPF listview to find out whether this is a ListCollectionView problem or datagrid problem. And I found that it’s working fine with ListView. This issue is really crazy..
* Showing wrong checkedstate when scrolling: Here is another crazy issue. I created three columns for Datagrid in XAML. One of three columns has the checkbox inside. I showed around 30 records on the datagrid but only 10 rows are viewable within datagrid since I specify the height of datagrid explicitly. Then, I run the problem and checked a couple of checkbox. After that, I scrolled up and down a bit then the checkbox that I haven’t checked are automatially checked after scrolling.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Jammer10-Aug-08 22:55

10-Aug-08 22:55

Just reading the bit you did on XamDataGrid (since this is what I have most experience with) ...

1. Their "SelectedItem" is called "ActiveRecord" ...

2. I have loads of embedded controls in our grids with no problems. All easily controlable, I have some dynamically animated based on the grids contents as well.

3. In the app I'm doing for my company I used filters extensively to sort the results in the grid, not sure why you'd see problems here.

4. Not sure what is going wrong here, they did have an issue with the checkboxes that was fixed in a hotfix some months ago now.

Anyway, seems like you decicded on Xceed now. Although I'm not sure you have given them all a good thorough testing however.

Jammer

Going where everyone here has gone before! Smile | :)

Michael Sync10-Aug-08 23:31

10-Aug-08 23:31

Jammer wrote:
1. Their "SelectedItem" is called "ActiveRecord" ..

Is this bindable? Let's say I bind this "ActiveRecord" with AA Get/Set property. If I select one row after another on datagrid, can i get the selected record from AA property?

Jammer wrote:
2. I have loads of embedded controls in our grids with no problems. All easily controlable, I have some dynamically animated based on the grids contents as well.

How can I get the reference of those embedded controls? I wanna use like DG.Row[1].Cell[1].FindControl("myextendedtextbox")

Jammer wrote:
3. In the app I'm doing for my company I used filters extensively to sort the results in the grid, not sure why you'd see problems here.

Are you using ListCollectionView.Filter? Did you bind it to Datagrid? Have you tried to add new item to that ListCollectionView? I'm not sure why I got that error, man.

>>seems like you decicded on Xceed now.

Not yet. I'm doing with Telerik Datagrid before I got the solution from Xceed. If Xcced can give me some solutions, I may use that grid. Otherwise, I hav to go with Telerik....

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Window Background Brush Change

Jacquers11-Aug-08 21:19

Jacquers

11-Aug-08 21:19

.NET 3.5 SP1 now includes a datagrid Smile | :)

Link[^]

BlitzPackage8-Aug-08 10:07

BlitzPackage

8-Aug-08 10:07

Good people,

I have assigned several items (including the background of my MainWindow) to a particular brush. My strategy is that instead of changing several different components (e.g. border background colors, border colors, control background colors, etc...), I can just change the color of the brush they all use via procedural code. The colors will change based on user preferences.

Unfortunately, when I try to do that, it doesn't work. The code is as follows:

public void SetClassicThemeBrushes()
{
// WindowMainBackground

Brush WindowMainBackgroundBrush = (Brush)TryFindResource("BrushWindowMainBackground");
WindowMainBackgroundBrush = (Brush)TryFindResource("MyCoolBreezeGradientBrush");
}

In the first line of code, attempt to get a reference to the existing brush that the components are assigned to. In the second line of code, I try to assign another color brush to the WindowMainBackground brush hoping it changes its color. Now I am wondering if all I have done is change a reference and not the color. Any idea on how I change the colors?

Any thoughts?

Thanks,
BP

Insincere Dave8-Aug-08 13:58

Insincere Dave

8-Aug-08 13:58

You could either set a new value in the resource dictionary:
Resources["BrushWindowMainBackground"] = (Brush)TryFindResource("MyCoolBreezeGradientBrush");

Or change the brush itself, I don't know if this would work in all situations but it seemed to in this one.
SolidColorBrush b = (SolidColorBrush)TryFindResource("BrushWindowMainBackground");
b.Color = Colors.Green;

Also make sure your using DynamicResource in the xaml and not StaticResource.

BlitzPackage8-Aug-08 15:41

BlitzPackage

8-Aug-08 15:41

Thanks, I will try that and see what happens.

Also, what do you think about using styles?

BlitzPackage8-Aug-08 15:51

BlitzPackage

8-Aug-08 15:51

Actually, it worked. By the way, what do the Brackets "[]" mean? What do they do that parentheses would not?

Thanks,
BP

Jammer8-Aug-08 22:38

8-Aug-08 22:38

This is something you need to plan carefully imho.

At work I've spent about a month putting together/organising thousands of lines of styles into a style dll. We are planning on having a few 'skins' that users can choose from. Personally I prefer the idea of offering skins over allowing a user to change individual colours since that can wind up with an horrific mish mash of contrasting rubbish in the UI.

Have a look at this article on CP its where I started along this path and its a seriously cool CP article in general that covers this topic really well.

http://www.codeproject.com/KB/WPF/wpfskins.aspx[^]

Jammer

Going where everyone here has gone before! Smile | :)