SQL/C#

[Harry2000]

Hi I have used this for the slq statem SELCT FirtName, LastName, ID,From Coustomer WHERE FirstName LIKE '[A-Z]' C# private void button1_Click(object sender, System.EventArgs e) { oleDbConnection1.Open(); oleDbDataAdapter2.SelectCommand.Parameters["LastName"].Value = textBox1.Text; dataSet11.Clear(); oleDbDataAdapter2.Fill(dataSet11) oleDbConnection1.Close(); } But when I run it gave a and error can u help me anyone Harrison Brock

[Mike Dimmick]

You're not going to get anywhere with SQL unless you spell statements correctly. When posting questions, you really need to copy and paste code accurately (ideally formatting with the <pre> tag), and report error messages exactly. I can currently see at least four errors with your SELECT statement, which (assuming that the data schema is spelled correctly) should look more like

SELECT FirstName, LastName, ID
FROM Customer
WHERE FirstName LIKE '[A-Z]'

Note spelling of SELECT, FirstName, Customer, and the removal of the comma before FROM.