how to get datagrid particular cell value in wpf ?

Question

3.00/5 (5 votes)

See more:

Hi Friends,

In my project I put one DataGrid for viewing database data. Now I want the cell value which I selected in the DataGrid.

for that I code

 private void dataGrid1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
 textBox1.Text = dataGrid1.SelectedItem.ToString();// TextSelection;
               
}

I want the code name only. :-\ that is 'cs11'. but I got

{ name = tuutusdydfh, code = cs11 }

.,

so I try these code also.

C#

// textBox1.Text = dataGrid1.SelectedCells[1].ToString();
  //textBox1.Text = dataGrid1.CurrentCell.Item.ToString();
  // textBox1.Text = dataGrid1.ItemsSource.ToString();
  //textBox1.Text = dataGrid1.Items.ToString();

but I cant get. I want the code name only, help me friends.

My Data Grid (xaml):-

<datagrid name="dataGrid1" itemssource="{Binding }" borderbrush="Gray" borderthickness="5" margin="45,91,30,116">
                 Background="LightGray"
                 RowBackground="SeaShell"
                 RowHeight="30"
                 ColumnWidth="150"
                 AlternatingRowremoved="Lavender"
                 HorizontalScrollBarVisibility="Visible"
                 VerticalScrollBarVisibility="Visible"
                 MouseDoubleClick="dataGrid1_MouseDoubleClick"
                 SelectionChanged="dataGrid1_SelectionChanged" /></datagrid>

Code :-

if (paramType == "Hall")
           {
               //var dbList = from recs in MainWindow.mcsEntity.mcs_hall orderby recs.mcs_Hall_Name
                    //        select recs;
               //dataGrid1.DataContext = dbList;
               dataGrid1.DataContext = from re in MainWindow.mcsEntity.mcs_hall
                                       orderby re.mcs_Hall_Code
                                       select new
                                       {
                                           name = re.mcs_Hall_Name,
                                           code = re.mcs_Hall_Code
                                       };


           }

Posted 27-Feb-11 19:16pm

Sagotharan Jagadeeswaran

Updated 23-Mar-16 5:22am

Henry Minute

v6

Add a Solution

Comments

Vineeth P Joseph 28-Feb-11 1:49am

Hi Jagadees,
Please provide some more details.How do you set the itemsSource in the datagrid?

Sagotharan Jagadeeswaran 28-Feb-11 3:47am

Hi Vineeth,
i add some code. Its enough or not?.

3 solutions

Solution 2

I think that this[^] thread on MSDN has the solution you are looking for.

Posted 2-Mar-11 5:45am

Henry Minute

Comments

Sagotharan Jagadeeswaran 4-Mar-11 2:06am

thanks

Solution 3

C#

for (int j = 0; j < dataGrid1.Columns.Count; j++)
            {
                for (int i = 0; i < dataGrid1.Items.Count - 1; i++)
                {
                    string s=(dataGrid1.Items[i] as DataRowView).Row.ItemArray[j].ToString();
                }
}

Posted 4-Jun-12 0:35am

sureshkumar.y

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

DrNimnull · Accepted Answer · 2011-03-02T05:11:00

Hi,

you can use a class

C#

public class MyClass
{
    public string Name {get;set;}
    public int Code { get; set; }
}

and create in the Linqstatement no var. You create new objects from your class:

C#

dataGrid1.DataContext = from re in MainWindow.mcsEntity.mcs_hall
                                       orderby re.mcs_Hall_Code
                                       select new MyClass
                                       {
                                           Name = re.mcs_Hall_Name,
                                           Code = re.mcs_Hall_Code
                                       };

in your SelectionChanged event you convert the selectedItem to your class:

C#

private void DataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (e.AddedItems.Count > 0)
            {
               textBox1.Text = (e.AddedItems[0] as MyClass).Name;
            }
        }

Hope that helps