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.

Mageshwaran R · Answer

Hi, Try this code: // Create the `DataTable` structure according to your data source DataTable table = new DataTable(); table.Columns.Add( "FileNumber" , typeof ( int )); table.Columns.Add( "ShiftDate" , typeof (DateTime)); table.Columns.Add( "TimeCreated" , typeof (DateTime)); table.Columns.Add( "Remarks" , typeof ( string )); // Iterate through data source object and fill the table foreach (var item in CollectionUserData) { table.Rows.Add(item.FileNumber, item.ShiftDate, item.TimeCreated, item.Remarks); }

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) { } } }

Convert listview data into datatable

Answers (2)