Selecting a value from a Listview row/column populated by LINQ to SQL

Question

Through the double click event I need to pull a value from a row/column in a Listvview populated by LINQ to SQL.

For example, when the user needs to select a value from a row/column of this Listview, after the double click event, this information would feed a Textbox with the SQL database ID (not the Listview Index) corresponding to that row/column clicked.

Watch of can help me! Please!

Class that updates the List..

namespace TRSSystem.AcessoDados

public static List<tabProduto> Consultar_ALL()
        {
            TRSSystemDataClassesDataContext oDB = new TRSSystemDataClassesDataContext();
            List<tabProduto> oProdutos = (from Selecao in oDB.tabProdutos orderby Selecao.Descricao select Selecao).ToList<tabProduto>();
            return oProdutos;

    }

When I Start WPF Form...

listView_tabProduto.ItemsSource = TRSSystem.AcessoDados.tabProdutoAcesso.Consultar_ALL();

Event of the Double Click... (DOESN’T WORK)

private void Select_Item(object sender, MouseButtonEventArgs e)
        {


           txtDescricao.Text = listView_tabProduto.SelectedIndex.ToString(); -------> Não funciona

        }

Answer 1

Good night.

I found the solution:

    private void Select_Item(object sender, MouseButtonEventArgs e)
    {
        if (listView_tabProduto.SelectedItem != null)
        {

            tabProduto id = (tabProduto)listView_tabProduto.SelectedItem;

            txtDescricao.Text = id.Descricao.ToString();

        }

    }

Reference: http://www.linhadecodigo.com.br/artigo/2138/manipulando-dados-com-wpf-e-linq-to-sql.aspx

Answer 2

You have to take the column of the selected row:

DataRowView linha;
int linhaIndex;

linhaIndex=  listView_tabProduto.SelectedIndex;
linha= listView_tabProduto.Items.GetItemAt(linhaIndex) as DataRowView;
txtDescricao.Text = Convert.ToString(linha["Descricao"]);

. Reference:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/0e08f378-dc9d-42f9-b2a5-00414a37ec0e/how-to-get-value-of-selected-item-in-listview?forum=wpf