如何使用Linq To Sql将数据调用到文本框 [英] How Can I Call A Data To Textbox Using Linq To Sql

问题描述

我有这个，没有错误但它不起作用



POSDataContext pos = new POSDataContext（）;

Credential c = new Credential（）;



var q =来自pos.Credentials中的m，其中c.UserName == usernamelabel.Text选择m;



fnamelabel.Text = c.FirstName;

lnamelabel.Text = c.LastName;

pnumberlabel.Text = c.PhoneNumber;

dateofcreationlabel.Text = c.DateCreated.ToString（）;

privilegelabel.Text = c.Privilege;

i have this, no error but it doesn't work

POSDataContext pos = new POSDataContext();
Credential c = new Credential();

var q = from m in pos.Credentials where c.UserName == usernamelabel.Text select m;

fnamelabel.Text = c.FirstName;
lnamelabel.Text = c.LastName;
pnumberlabel.Text = c.PhoneNumber;
dateofcreationlabel.Text = c.DateCreated.ToString();
privilegelabel.Text = c.Privilege;

推荐答案

可能你的代码应该像

Probably your code should be like

POSDataContext pos = new POSDataContext();
var q = (from m in pos.Credentials where c.UserName == usernamelabel.Text select new Credential{
FirstName = m.FirstName,
LastName = m.LastName,
PhoneNumber = m.PhoneNumber,
DateCreated = m.DateCreated,
Privilege = m.Privilege
}).Single() ;
fnamelabel.Text = q.FirstName;
lnamelabel.Text = q.LastName;
pnumberlabel.Text = q.PhoneNumber;
dateofcreationlabel.Text = q.DateCreated.ToString();
privilegelabel.Text = q.Privilege;

这篇关于如何使用Linq To Sql将数据调用到文本框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！