将silverlight数据网格中的更改更新到数据库 [英] Updating Changes Made in silverlight datagrid to database
本文介绍了将silverlight数据网格中的更改更新到数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在Silverlight应用程序中使用数据网格。我已将该datagrid的列绑定到一个可观察的集合，该集合由来自Page Load的WCF服务的数据填充。我想要在运行时对datagrid做出的任何更改，即修改内容或添加新行，或删除行。它应该在单击保存按钮时永久更新到数据库。我怎样才能实现它。
我的Silverlight页面XAML。
I am using a datagrid in my Silverlight App. I have binded columns of that datagrid to an observable collection which is being filled by data from WCF service at Page Load. I want that whatever changes i make to datagrid at runtime, i.e modify something or add a new row, or delete a row. it should get updated permanently to the database on click of Save button. How can i achieve it.
My Silverlight Page XAML.
<controls:ChildWindow xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk" x:Class="slLHWProduct.PartsWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:controls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls"
xmlns:controlsToolkit="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Toolkit"
Width="581" Height="321" Loaded="PartsWindow_OnLoaded"
Title="Parts">
<Grid x:Name="LayoutRoot" Margin="2">
<StackPanel Orientation="Vertical">
<StackPanel Orientation="Horizontal">
<Button x:Name="btnAddBlankRow"
Width="Auto"
Height="22"
Margin="0,0,5,0"
HorizontalAlignment="Left"
VerticalAlignment="Bottom"
Click="btnAddBlankRow_Click"
FontSize="12">
<Button.Content>
<TextBlock Text="Add Blank Row" />
</Button.Content>
</Button>
<Button x:Name="btnCopySelectedRows"
Width="Auto"
Height="22"
Margin="0,0,5,0"
HorizontalAlignment="Left"
VerticalAlignment="Bottom"
Click="btnCopySelectedRows_Click"
FontSize="12">
<Button.Content>
<TextBlock Text="Copy Selected Rows" />
</Button.Content>
</Button>
<Button x:Name="btnDeleteSelectedRows"
Width="Auto"
Height="22"
Margin="0,0,5,0"
HorizontalAlignment="Left"
VerticalAlignment="Bottom"
Click="btnDeleteSelectedRows_Click"
FontSize="12">
<Button.Content>
<TextBlock Text="Delete Selected Rows" />
</Button.Content>
</Button>
<Button x:Name="btnSaveChanges"
Width="Auto"
Height="22"
Margin="0,0,5,0"
HorizontalAlignment="Left"
VerticalAlignment="Bottom"
Click="btnSaveChanges_Click"
FontSize="12">
<Button.Content>
<TextBlock Text="Save Changes" />
</Button.Content>
</Button>
<Button x:Name="btnExport"
Width="Auto"
Height="22"
Margin="0,0,5,0"
HorizontalAlignment="Left"
VerticalAlignment="Bottom"
Click="btnExport_Click"
FontSize="12">
<Button.Content>
<TextBlock Text="Export" />
</Button.Content>
</Button>
</StackPanel>
<StackPanel>
<ScrollViewer HorizontalScrollBarVisibility="Auto" VerticalScrollBarVisibility="Auto">
<sdk:DataGrid
x:Name="dgPartsData"
AutoGenerateColumns="False"
ScrollViewer.VerticalScrollBarVisibility="Visible"
ScrollViewer.HorizontalScrollBarVisibility="Visible"
RowHeaderWidth="30"
TabNavigation="Cycle"
FontSize="12"
SelectionMode="Single"
HeadersVisibility="All"
CanUserResizeColumns="True"
CanUserSortColumns="True"
CellEditEnded="DgPartsData_OnCellEditEnded"
CurrentCellChanged="DgPartsData_OnCurrentCellChanged"
HorizontalScrollBarVisibility="Auto"
VerticalScrollBarVisibility="Auto"
>
<sdk:DataGrid.Columns>
<sdk:DataGridTemplateColumn Header="Name" SortMemberPath="Name">
<sdk:DataGridTemplateColumn.CellTemplate>
<DataTemplate>
<TextBlock Text="{Binding Name}" FontSize="12" Margin="2" Tag="{Binding PartId}"></TextBlock>
</DataTemplate>
</sdk:DataGridTemplateColumn.CellTemplate>
<sdk:DataGridTemplateColumn.CellEditingTemplate>
<DataTemplate>
<TextBox Text="{Binding Name,Mode=TwoWay}" FontSize="12" Margin="2" GotFocus="TextBox_GotFocus" LostFocus="TextBox_OnLostFocus"></TextBox>
</DataTemplate>
</sdk:DataGridTemplateColumn.CellEditingTemplate>
</sdk:DataGridTemplateColumn>
<sdk:DataGridTemplateColumn Header="Description" SortMemberPath="Description">
<sdk:DataGridTemplateColumn.CellTemplate>
<DataTemplate>
<TextBlock Text="{Binding Description}" FontSize="12" Margin="2"></TextBlock>
</DataTemplate>
</sdk:DataGridTemplateColumn.CellTemplate>
<sdk:DataGridTemplateColumn.CellEditingTemplate>
<DataTemplate>
<TextBox Text="{Binding Description,Mode=TwoWay}" FontSize="12" Margin="2" GotFocus="TextBox_GotFocus"></TextBox>
</DataTemplate>
</sdk:DataGridTemplateColumn.CellEditingTemplate>
</sdk:DataGridTemplateColumn>
<sdk:DataGridTemplateColumn Header="InUse" SortMemberPath="InUse">
<sdk:DataGridTemplateColumn.CellTemplate>
<DataTemplate>
<TextBlock Text="{Binding InUse}" FontSize="12" Margin="2"></TextBlock>
</DataTemplate>
</sdk:DataGridTemplateColumn.CellTemplate>
</sdk:DataGridTemplateColumn>
</sdk:DataGrid.Columns>
</sdk:DataGrid>
</ScrollViewer>
</StackPanel>
</StackPanel>
<controlsToolkit:BusyIndicator x:Name="biGlobal" BusyContent="Retrieving/Updating data, please wait..." IsBusy="False" />
</Grid>
</controls:ChildWindow>
My C# Code.
My C# Code.
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Globalization;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using LinqToSqlClientHelper;
using slLHWProduct.LHWSLAdminServices;
namespace slLHWProduct
{
public partial class PartsWindow : ChildWindow
{
public PartsWindow()
{
InitializeComponent();
this._ProductId = 0;
biGlobal.IsBusy = true;
}
public class PartsData
{
public int PartId { get; set; }
public string Name { get; set; }
public string Description { get; set; }
public int InUse { get; set; }
}
#region variables
private int _ProductId = 0;
public int ProductId
{
get { return _ProductId; }
set { _ProductId = value; }
}
public LHWSLAdminServicesClient client;
public ObservableCollection<PartsData> oc_Original;
#endregion
private void PartsWindow_OnLoaded(object sender, RoutedEventArgs e)
{
client = new LHWSLAdminServicesClient();
oc_Original = new ObservableCollection<PartsData>();
if (_ProductId > 0)
{
client.GetProductPartsAsync(_ProductId);
client.GetProductPartsCompleted += new EventHandler<GetProductPartsCompletedEventArgs>(client_GetProductPartsCompleted);
}
}
void client_GetProductPartsCompleted(object sender, GetProductPartsCompletedEventArgs e)
{
if (e.Result != null)
{
foreach (var item in e.Result)
{
oc_Original.Add(new PartsData
{
PartId = item.PartID,
Name = item.Name,
Description = item.DESCRIPTION,
InUse = item.InUse.Value
});
}
dgPartsData.ItemsSource = oc_Original;
biGlobal.IsBusy = false;
}
}
private void OKButton_Click(object sender, RoutedEventArgs e)
{
GC.Collect();
this.DialogResult = true;
}
private void CancelButton_Click(object sender, RoutedEventArgs e)
{
GC.Collect();
this.DialogResult = false;
}
private void DgPartsData_OnCurrentCellChanged(object sender, EventArgs e)
{
dgPartsData.BeginEdit();
}
private void TextBox_GotFocus(object sender, RoutedEventArgs e)
{
((TextBox)sender).SelectAll();
}
private void DgPartsData_OnCellEditEnded(object sender, DataGridCellEditEndedEventArgs e)
{
dgPartsData.CommitEdit();
dgPartsData.ItemsSource = oc_Original;
}
private void TextBox_OnLostFocus(object sender, RoutedEventArgs e)
{
dgPartsData.CommitEdit();
dgPartsData.ItemsSource = oc_Original;
}
private void btnAddBlankRow_Click(object sender, RoutedEventArgs e)
{
var item = oc_Original.Last().PartId;
oc_Original.Add(new PartsData
{
PartId = item+1,
Name = "",
Description = "",
InUse = 0
});
dgPartsData.ItemsSource = oc_Original;
}
private void btnCopySelectedRows_Click(object sender, RoutedEventArgs e)
{
}
private void btnDeleteSelectedRows_Click(object sender, RoutedEventArgs e)
{
if (dgPartsData.SelectedItem != null)
{
dgPartsData.CommitEdit();
int PartID = Convert.ToInt32(((TextBlock)dgPartsData.Columns[0].GetCellContent(dgPartsData.SelectedItem)).Tag);
MessageBox.Show(PartID.ToString());
var item = oc_Original.FirstOrDefault(i => i.PartId == PartID);
oc_Original.Remove(item);
dgPartsData.ItemsSource = oc_Original;
}
else
{
MessageBox.Show("Please select a part to delete");
}
}
private void btnSaveChanges_Click(object sender, RoutedEventArgs e)
{
}
private void btnExport_Click(object sender, RoutedEventArgs e)
{
}
}
}
My WCF Service.
[OperationContract]
public List<lhwclasses.admin.sp_lhwadmin_getproductpartsresult> GetProductParts(int ProductID)
{
LHWClasses.Admin.LHWSLAdminDataContext db=new LHWSLAdminDataContext();
var res = db.sp_LhwAdmin_GetProductParts(ProductID);
return res.ToList();
}
Please Help me to sort out this problem in best way .
My WCF Service.
[OperationContract]
public List<lhwclasses.admin.sp_lhwadmin_getproductpartsresult> GetProductParts(int ProductID)
{
LHWClasses.Admin.LHWSLAdminDataContext db=new LHWSLAdminDataContext();
var res = db.sp_LhwAdmin_GetProductParts(ProductID);
return res.ToList();
}
Please Help me to sort out this problem in best way .
推荐答案
to me i have the same problem i tried to solved like this :
1- this is iTrans
[OperationContract]
bool Update(List<TransData> xlist)
2- this is TrnasService.svc which i implented the bool updata in
public bool Update(List<transdata> xlist)
{
TransDataLINQDataContext db = new TransDataLINQDataContext();
xlist = new List<transdata>();
foreach (var item in xlist)
{
var row = db.crrTrans.Single(p => p.id.Equals(item.ID));
{
row.ProjName = item.ProjName;
}
// ....
//and so on until you finish your table items
}
db.SubmitChanges();
return true;
}
this worked perfectly on my local address
hope it solve your problem
to me i have the same problem i tried to solved like this :
1- this is iTrans
[OperationContract]
bool Update(List<TransData> xlist)
2- this is TrnasService.svc which i implented the bool updata in
public bool Update(List<transdata> xlist)
{
TransDataLINQDataContext db = new TransDataLINQDataContext();
xlist = new List<transdata>();
foreach (var item in xlist)
{
var row = db.crrTrans.Single(p => p.id.Equals(item.ID));
{
row.ProjName = item.ProjName;
}
// ....
//and so on until you finish your table items
}
db.SubmitChanges();
return true;
}
this worked perfectly on my local address
hope it solve your problem
这篇关于将silverlight数据网格中的更改更新到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
