LINQ到SQL的C＃-数量范围_未分类的问答_编程通用

你好。我刚开始学习C＃，我想了解如何使用LINQ to SQL查询。我曾在VB应用程序，使用2个文本框，一个DataGridView和一个提交按钮，并想知道代码是选择从一个数据库，由用户输入一个分钟数（可以是不低于0）到行一个文本框，并输入到另一个文本框的最大数量（可以是不高于5）。用户点击提交，它应该表现出有效的行包含列之间的2号他们在文本框输入一个值。这是我迄今为止

我有一个文本框和一个搜索按钮，搜索姓氏分贝。功能就好了。

我想能够进入2号和其他的搜索按钮，我有（btnAverage），得到的平均数。


using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace MasterDetailProject

{

    public partial class Details : Form

    {

        //ATTRIBUTES

        private BaseballDataContext database = new BaseballDataContext();

        private const double MIN_AVG = 0.000;

        private const double MAX_AVG = 1.000;

        //CONSTRUCTOR

        public Details()

        {

            InitializeComponent();

        }//end constrcutor

        private void Details_Load(object sender, EventArgs e)

        {

            txtLastName.Text = "Name";

          

        }//end Details_Load



        //METHODS

        private void RefreshContacts()

        {

            //show everything in db, sort by lastname, firstname - SHOWS EVERYONE IN AddressBook. just call whenever need be

            playerBindingSource.DataSource =

                from address in database.Players

                orderby address.LastName, address.FirstName

                select address;

            //go to the first result

            playerBindingSource.MoveFirst();

            //clear the find textbox

            txtLastName.Clear();

        }

 

        //EVENT HANDLER

        private void btnSearch_Click(object sender, EventArgs e)

        {

            playerBindingSource.DataSource =

                from PlayerID in database.Players

                where PlayerID.LastName.StartsWith(txtLastName.Text)

                orderby PlayerID.LastName, PlayerID.FirstName

                select PlayerID;

            playerBindingSource.MoveFirst();

        }//end btnSearch_Click

        private void btnAverage_Click(object sender, EventArgs e)

        {

            playerBindingSource.DataSource =

                from PlayerID in database.Players

                where PlayerID.BattingAverage.

           

        }//end btnAverage

    }//end class}//end namespace

任何想法？:8214406 |会员

LINQ到SQL的C＃-数量范围

回答