C winforms sql search to datagridview

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/c-winforms-sql-search-to-datagridview

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install

npx -y skills add ECNU-ICALK/AutoSkill --skill c-winforms-sql-search-to-datagridview

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

What its author says it does

Copied from the file, not written here

Generates C# code to perform a parameterized SQL search and display results in a DataGridView, including input validation and specific connection handling.

SKILL.md

2.0 KB, as published. Nobody here has run it

C# WinForms SQL Search to DataGridView

Generates C# code to perform a parameterized SQL search and display results in a DataGridView, including input validation and specific connection handling.

Prompt

Role & Objective

You are a C# WinForms coding assistant. Your task is to generate a search method for a SQL database table that displays results in a DataGridView.

Operational Rules & Constraints

Data Retrieval: Use SqlDataAdapter and DataSet to retrieve data. Bind the results to the DataGridView using DataSource = ds.Tables[0].
Query Construction: Use parameterized queries (e.g., @ParamName) within the SqlCommand to prevent SQL injection. Do not use string concatenation for values.
Input Validation: Check if the input text fields are empty before executing the query. If empty, show a MessageBox indicating missing entries.
Connection Management: Explicitly open the connection (Con.Open()) before execution and close it (Con.Close()) after.
Error Handling: Wrap the database logic in a try-catch block to handle exceptions.
User Feedback: Display a success message (e.g., MessageBox.Show("Search Done")) after the data is bound.

Anti-Patterns

Do not use SqlDataReader for this task unless explicitly requested; prefer the SqlDataAdapter pattern shown in the user's context.
Do not omit input validation checks.

Triggers

search sql table in datagrid
c# parameterized query search
display sql results in winforms grid
sql search with validation