Convert listview data into datatable

Question

Hi  Dear All How to Convert listview data into datatable in wpf . If anybody know then me reply me fast.

Rajneesh Kumar · Answer

TRY THIS xmlns=http://schemas.microsoft.com/winfx/2006/xaml/presentation xmlns:x=http://schemas.microsoft.com/winfx/2006/xaml xmlns:tools=clr-namespace:Microsoft.CSharp;assembly=System Title=Page1> First Name Last Name Job Title Add Edit Delete Close here is the C# code please ignore the sql comments i am still trying to work on that but decided to forget about it and come back to it later on for now just the regular code i am trying to get working. Thanks again C# code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; using System.Data; using System.Collections; using System.Data.SqlClient; namespace webapptosql { /// /// Interaction logic for Page1.xaml /// public partial class Page1 : Page { public Page1() { try { group.Add(new usergroup(Steven Balderrama Software Developer)); InitializeComponent(); //queryit(); } catch (Exception) { throw; } } SqlConnection con = new SqlConnection(); SqlDataAdapter ad = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(); //string str = Select userID Firstname Lastname Jobtitle; HashSet group = new HashSet (); public void additin() { usergroup users = new usergroup(txtfirstname.Text txtlastname.Text txtjobtitle.Text); group.Add(users); Listview1.Items.Clear(); Listview1.ItemsSource = group; txtfirstname.Clear(); txtjobtitle.Clear(); txtlastname.Clear(); } /* public void queryit() { cmd.CommandText = str; ad.SelectCommand = cmd; con.ConnectionString = @Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Workers\MyWorkers.mdf; Integrated Security=True;Connect Timeout=30;User Instance=True; cmd.Connection = con; DataSet data = new DataSet(); ad.Fill(data); Listview1.DataContext = data.Tables[0].DefaultView; con.Close(); } */ private void btn_close_Click(object sender RoutedEventArgs e) { } private void btn_edit_Click(object sender RoutedEventArgs e) { } private void btn_addandSubmit_Click(object sender RoutedEventArgs e) { additin(); } } } IF NOT WORKING TRY THIS XAML code: xmlns=http://schemas.microsoft.com/winfx/2006/xaml/presentation xmlns:x=http://schemas.microsoft.com/winfx/2006/xaml xmlns:tools=clr-namespace:Microsoft.CSharp;assembly=System Title=Page1> First Name Last Name Job Title Add Edit Delete Close C# code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; using System.Data; using System.Collections; using System.Collections.ObjectModel; using System.Data.SqlClient; namespace webapptosql { /// /// Interaction logic for Page1.xaml /// public partial class Page1 : Page { public Page1() { try { InitializeComponent(); filltable(); } catch (Exception) { throw; } } SqlConnection con = new SqlConnection(@Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Workers\MyWorkers.mdf; Integrated Security=True;Connect Timeout=30;User Instance=True); SqlDataAdapter sqlda; DataSet sqlds; string sqlstring = SELECT * from tblWorkers; ObservableCollection group = new ObservableCollection (); public void filltable() { sqlds = new DataSet(); sqlda = new SqlDataAdapter(sqlstring con); con.Open(); sqlda.Fill(sqlds); } private void btn_close_Click(object sender RoutedEventArgs e) { } private void btn_edit_Click(object sender RoutedEventArgs e) { } private void btn_addandSubmit_Click(object sender RoutedEventArgs e) { } } }