实体框架在WinForms中运行的小代码 [英] Entity Framework small code to run within WinForms

问题描述

您好

无法使用此功能，当我运行项目时，没有显示控制台

Could not get this to work, When I Run project no console is displayed

也是因为我是新手使用C＃winforms的实体框架，我想问一下如何使用上下文项填充TextBox。

also as I am new to Entity Framework with C# winforms, I would like to ask how to fill a TextBox with a context item.

我使用的是Visual Studio 2010版本和MS SQL 2008 Express。

I am using Visual studio 2010 version and MS SQL 2008 Express.

谢谢

代码：

使用System;

使用System.Data.Objects;

使用System.Linq;

使用System.Windows.Forms;



$
命名空间MyNameSpace

{

   公共部分类Form1：表格

    {

        public Form1（）

        {

            InitializeComponent（）;

        }
        private void BtnOk_Click（object sender，EventArgs e）

        {
$


           使用（LINQtoEntitiesEntities MyEntities =新LINQtoEntitiesEntities（））

            {

               的ObjectQuery<员工> Employee = MyEntities.Employee;

                VAR查询=从对在雇员

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;其中p.Nom =="珍"

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;选择新{p.ID，p.LastName，p.FirstName，p.Birth};

            &NBSP;&NBSP;&NBSP;&NBSP;的foreach（在查询VAR LIGNE）

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP; Console.WriteLine（ligne.ID + QUOT;" + ligne.LastName + QUOT;" + ligne.FirstName）;

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP; }
            Console.Read（）;

        }
    } b $ b}

using System;
using System.Data.Objects;
using System.Linq;
using System.Windows.Forms;


namespace MyNameSpace
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void BtnOk_Click(object sender, EventArgs e)
        {

            using (LINQtoEntitiesEntities MyEntities = new LINQtoEntitiesEntities())
            {
                ObjectQuery<Employee> Employee = MyEntities.Employee;
                var query = from p in Employee
                              where p.Nom == "JANE"
                              select new { p.ID, p.LastName, p.FirstName, p.Birth };
                foreach (var ligne in query)
                    Console.WriteLine(ligne.ID + " " + ligne.LastName + " " + ligne.FirstName);
            }
            Console.Read();
        }
    }
}

推荐答案

你写的是输出到控制台并期望它在TextBox中？这怎么可能？

you are writing the output to console and expecting it in TextBox ? How is that possible ?

这样做：

foreach（查询中的var ligne）

foreach (var ligne in query)

{

TextBox.Text = ligne.ID +" " + ligne.LastName +" " + ligne.FirstName;

TextBox.Text = ligne.ID + " " + ligne.LastName + " " + ligne.FirstName;

}

或var data = query.FirstOrDefault（）;

or var data = query.FirstOrDefault();

TextBox .Text = data .ID +" " + data .LastName +" " + data.firstName

TextBox.Text = data .ID + " " + data .LastName + " " + data .FirstName

这篇关于实体框架在WinForms中运行的小代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！