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