Silverlight / WPF - insert data into a atable using listview

Hi ,

I have a listview with multiple columns, I want to insert all  data in that listview to a table using c# in WPF application.

Can anybody help me to do this.

Thanks.

private void BindDetails(string sortExpression)
{
sortExpression = sortExpression.Replace("Ascending", "ASC");
using (SqlConnection conn = new SqlConnection(_connStr))
{
conn.Open();
using (SqlDataAdapter dAd = new SqlDataAdapter("select * from Details order by Name", conn))
{
DataTable dTable = new DataTable();
dAd.Fill(dTable);
// Sort now
dTable.DefaultView.Sort = sortExpression;
// Bind data now
ListView1.DataSource = dTable;
ListView1.DataBind();
}
conn.Close();
}
}


protected void InsertListViewItem(object sender, ListViewInsertEventArgs e)
{
ListViewItem item = e.Item;
TextBox tName = (TextBox) item.FindControl("txtName");
TextBox tAddress = (TextBox)item.FindControl("txtAddress");
TextBox tPhone = (TextBox)item.FindControl("txtPhone");
// insert records into database
using (SqlConnection conn = new SqlConnection(_connStr))
{
string Sql = "insert into Details (Name, Address, Phone) values " +
" (@Name, @Address, @Phone)";
conn.Open();
using (SqlCommand dCmd = new SqlCommand(Sql, conn))
{
dCmd.Parameters.AddWithValue("@Name", tName.Text.Trim());
dCmd.Parameters.AddWithValue("@Address", tAddress.Text.Trim());
dCmd.Parameters.AddWithValue("@Phone", tPhone.Text.Trim());
dCmd.ExecuteNonQuery();
}
conn.Close();
}
lblMessage.Text = "Records Inserted Successfully.";
// Rebind the details
BindDetails("Name ASC");
}





//Using This Way You Can Insert Your Data in The ListView........

You can insert data into a dataset from the listview control and upate to the databse.

Check this article:

http://www.codeguru.com/vb/controls/vbnet_controls/listview/article.php/c3979/How-to-Fill-a-ListView-with-any-ADONet-Dataset.htm

Thanks