C#-Create an application that connects to the Personnel.mdf database that you cr

Question

C#-Create an application that connects to the Personnel.mdf database that you created in Programming Problem 1. The application's form should display the Employee table in a DataGridView control. The application should let the user specify a name in a text box and then search for that name in the Employee table. The application should display any rows that contain full or a partial match of the specified name.

I am mainly having trouble with the SQL statement I need to write. I think it is along the lines of SELECT * From Employee Where Description Like '%' + @value + '%'

Explanation / Answer

SELECT * From Employee Where Name Like '%newname'%';

This will print the details after matching newname from the list of names and then display the result.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.