Convert listview data into datatable

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

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

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)

{

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
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 Kumar11y ago
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



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



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

}
}
}