表"t_dict_hydm_xl"
Xlcode XlName
01 油料的种植
02 豆类的种植
03 棉花的种植
04 麻类的种植
05 烟草的种植
... ....
请问如何查到Xlcode为“04”的那条记录的实体?小弟初学,请给出完速的代码,谢谢
相关文件代码如下
XML code
C# code
using System;
using System.Collections.Generic;
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 System.Windows.Data;
using Test.Web;
namespace Test
{
public partial class ChildWindowDataGridEdit : ChildWindow
{
DomainServiceCustom custom;
public ChildWindowDataGridEdit()
{
InitializeComponent();
custom = new DomainServiceCustom();
WindowShow();
}
void WindowShow()
{
//这里面应该怎么写啊
t_dict_hydm_xl customHydmXl = new t_dict_hydm_xl();
txtXlCode.IsEnabled = false;
txtXlCode.Text = Temp.strTmp.ToString().Trim();
//这地方怎么写
txtXlName.Text =
}
private void OKButton_Click(object sender, RoutedEventArgs e)
{
this.DialogResult = true;
}
private void CancelButton_Click(object sender, RoutedEventArgs e)
{
this.DialogResult = false;
}
}
}
能否请管理员将你的代码改成我的样式,我是初学者,看这些有难度,许多都不懂的。谢谢。
http://funsl.com/node/46
请把它的留言也看完。答案就在其中.
看过了,但看不懂,请管理员指点一下
internal void loadUserInfo(string userid)
{
DomainService1 ds = new DomainService1();
var da = ds.Load(ds.getUserInfoQuery(userid));
da.Completed += new EventHandler(da_Completed);
}
void da_Completed(object sender, EventArgs e)
{
LoadOperation ut = (LoadOperation)sender;
if (ut.Entities.Count() == 1)
{}
}
这样你应该看得明白的了,原因是这些操作都是异步的。不是马上就有结果的,所以要通过completed事件去确保数据读取操作完成后再操作数据.
t_dict_hydm_xls customHydmXl = (from dep in custom.t_dict_hydm_xls where dep.XlCode == "04" select dep).AsQueryable().ToList();
txtXlName.Text = customHydmXl.XlName.ToString();
这样写抱错,请问应该怎么写
错误 1 无法将类型“System.Collections.Generic.List”隐式转换为“Test.Web.t_dict_hydm_xl” E:\PAGE\Silverlight\Test\Test\ChildWindowDataGridEdit.xaml.cs 49 43 Test
t_dict_hydm_xls是一个表的名称
t_dict_hydm_xls customHydmXl = (from dep in custom.t_dict_hydm_xls where dep.XlCode == "04" select dep).First();
t_dict_hydm_xl customHydmXl = (from dep in custom.t_dict_hydm_xls where dep.XlCode == "04" select dep).AsQueryable().First();
txtXlName.Text = customHydmXl.XlName.ToString().Trim();
出错,当前页面不出来啊
t_dict_hydm_xl customHydmXl = (from dep in custom.t_dict_hydm_xls where dep.XlCode == "04" select dep).First();
txtXlName.Text = customHydmXl.XlName.ToString().Trim();
写成这样同样报错,
Line:1
Char:1
Code:0
Error:Unhandled Error in Silverlight Application 序列不包含任何元素 位于 System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
位于 lambda_method(ExecutionScope )
位于 System.Linq.EnumerableExecutor`1.Execute()
位于 System.Linq.EnumerableQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
位于 System.Linq.Queryable.First[TSource](IQueryable`1 source)
位于 Test.ChildWindowDataGridEdit.WindowShow()
位于 Test.ChildWindowDataGridEdit..ctor()
位于 Test.ChildWindowDataGrid.btnEdit_Click(Object sender, RoutedEventArgs e)
位于 System.Windows.Controls.Primitives.ButtonBase.OnClick()
位于 System.Windows.Controls.Button.OnClick()
位于 System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
位于 System.Windows.Controls.Control.OnMouseLeftButtonUp(Control ctrl, EventArgs e)
位于 MS.Internal.JoltHelper.FireEvent(IntPtr unmanagedObj, IntPtr unmanagedObjArgs, Int32 argsTypeIndex, String eventName)
网址:http://127.0.0.1/testtestpage.aspx
很明显你没有按我以下代码为异步取得数据内容:
internal void loadUserInfo(string userid)
{
DomainService1 ds = new DomainService1();
var da = ds.Load(ds.getUserInfoQuery(userid));
da.Completed += new EventHandler(da_Completed);
}
void da_Completed(object sender, EventArgs e)
{
LoadOperation ut = (LoadOperation)sender;
if (ut.Entities.Count() == 1)
{}
}
sl中提取数据不像其他技术,它是异步提取数据的,不像win或asp.net那样只是实例化一下就可以读取数据的。