Getting data from listview in WPF

Question

I have created listview in C# and filled it with data from SQL server. But when I assign mouse double click, I don't know how to get clicked data. Please help:

My XAML:

<ListView Name="ListViewEmployeeDetails" ItemsSource="{Binding Path=Table}" Margin="0,0,0,67" MouseDoubleClick="ListViewEmployeeDetails_MouseDoubleClick">
    <ListView.Background>
        <LinearGradientBrush>
            <GradientStop Color="white" Offset="0"/>
        </LinearGradientBrush>
    </ListView.Background>
    <ListView.View>
        <GridView>
            <GridViewColumn Width="70" Header="Číslo bytu" DisplayMemberBinding="{Binding Path=cislo_Bytu}"/>
            <GridViewColumn Width="70" Header="Podlaží" DisplayMemberBinding="{Binding Path=podlazi}"/>
            <GridViewColumn Width="70" Header="Účel" DisplayMemberBinding="{Binding Path=ucel}"/>
            <GridViewColumn  Width="70" Header="Plocha" DisplayMemberBinding="{Binding Path=plocha}"/>
            <GridViewColumn Width="70" Header="Stav" DisplayMemberBinding="{Binding Path=stav}"/>
            <GridViewColumn Width="70" Header="Country" DisplayMemberBinding="{Binding Path=Country}"/>
        </GridView>
    </ListView.View>
</ListView>

And my code:

SqlDataAdapter ad = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand();

String str = "SELECT cislo_Bytu, podlazi, ucel, plocha, stav, poznamky FROM prostory";
cmd.CommandText = str;
ad.SelectCommand = cmd;
cmd.Connection = datovéPřipojení;
DataSet ds = new DataSet();
ad.Fill(ds);

ListViewEmployeeDetails.DataContext = ds.Tables[0].DefaultView;
datovéPřipojení.Close();

So my question is, what I should write into the

private void ListViewEmployeeDetails_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
    // Here
}

To get the data (cislo_Bytu) from the row which was clicked on?

Thanks,

Kevin Aenmey · Accepted Answer · 2012-06-27 14:02:06Z

4

The sender will be the ListView.

((ListView)sender).SelectedItem

Since you are binding to a DataView, the SelectedItem will be of type DataRowView. You can then reference the relevant value using the column name. For example, to assign the value of the cislo_bytu column to the textBox1.Text property, do the following:

textBox1.Text = ((DataRowView)((ListView)sender).SelectedItem)["cislo_bytu"].ToString();

edited Jun 27, 2012 at 14:02

answered Jun 27, 2012 at 13:12

Kevin Aenmey

13.4k5 gold badges48 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Petr Cizek Over a year ago

And if I would like to put that data into textbox? the point is that someone will click on the row and text from one cell (for example cislo_bytu) is going to be shown in a textbox... ? Thanks a lot...

Justin Pihony · Accepted Answer · 2012-06-27 13:08:49Z

1

I believe what you want is OriginalSource MSDN

e.OriginalSource

answered Jun 27, 2012 at 13:08

Justin Pihony

67.2k20 gold badges154 silver badges185 bronze badges

Comments

user1399377 · Accepted Answer · 2012-06-27 18:09:10Z

0

Use following code to get the each item by changing the index value in the ItemArray in your double click event

((System.Data.DataRowView)(ListViewEmployeeDetails.SelectedItem)).Row.ItemArray[0]

`

answered Jun 27, 2012 at 18:09

user1399377

4892 gold badges8 silver badges19 bronze badges

Comments

user1985143 · Accepted Answer · 2013-01-16 20:53:01Z

0

You have to cast the object that is selected to access each proprety..

Example:

((Class)listView1.SelectedItem).cislo_bytu

just change Class to your original class that has proprety cislo_bytu

answered Jan 16, 2013 at 20:53

user1985143

1

Collectives™ on Stack Overflow

Getting data from listview in WPF

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related