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);
        }

    }
   



    }

where you want to display?
Can You be little bit Clearer in your question??

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

what do you mean i last post, have you solved it??

no haha sorry. i would like your help

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.