okay so i figured everything out for my project except how to get this simple select statement to work. i have a table named Car that i LINQ'd from a Microsoft Access File. please help. i want a button to display the Car database according to the SQL statement. thank you

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 NEWPROJECT
{
    public partial class Form2 : Form
    {
        string make;
        string model;
        string year;
        //string price;





        public Form2()
        {
            InitializeComponent();
        }

        private void Form2_Load(object sender, EventArgs e)
        {
            
            // TODO: This line of code loads data into the 'carDataSet.Car' table. You can move, or remove it, as needed.
            this.carTableAdapter.Fill(this.carDataSet.Car);

        }


        private void carBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {

            this.Validate();
            this.carBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.carDataSet);
        }
       

        private void pictureBox1_Click(object sender, EventArgs e)
        {

        }

        private void label4_Click(object sender, EventArgs e)
        {

        }

[B]        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            make = Console.ReadLine();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            make = (textBox1.Text);


            var query =
                from Make in Car
                where Make = make
                select Make, Model, Year, Price;
            
        }[/B]

        private void textBox2_TextChanged(object sender, EventArgs e)
        {
            model = Console.ReadLine();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            model = (textBox2.Text);
        }

        private void textBox3_TextChanged(object sender, EventArgs e)
        {
            year = Console.ReadLine();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            year = (textBox3.Text);
        }

    }
   



    }

Edited 5 Years Ago by vehpurple: n/a

In the above coding where you are displaying the values!!! Do you want to display in gridview??

yes yes that would be awesome. i would greatly appreciate your help. project due tonight

This article has been dead for over six months. Start a new discussion instead.