Gridview with textbox and search button in winforms

Question

0.00/5 (No votes)

See more:

I have a register form for students and I need to have a gridview with a textbox and a button above the gridview to search students by studentID. I am beginner in C# and I don`t know what should I do and which codes I need for gridview and searchbox.please help me

Posted 31-Oct-15 7:43am

Member 12103175

Add a Solution

Comments

Maciej Los 31-Oct-15 16:01pm

And..
What have you tried?

BillWoodruff 31-Oct-15 16:14pm

Time to start studying, then. Start by reading the documentation and examples for DataGridView. Search CodeProject for articles that will help you understand how to use the DataGridView.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2015-10-31T12:15:00

There's at least few ways to achieve that:
1) using stored procedure
How to: Execute a Stored Procedure that Returns Rows[^]
How to: Execute a Query Using a Stored Procedure with In and Out Parameters[^]

2) using Filter[^] for binding source
DataGridView BindingSource.Filter Windows Forms Sample[^]

3) adding Dropdown to DataGridView's Headers
Building a Drop-Down Filter List for a DataGridView Column Header Cell [^]

4) using Linq To Dataset[^]
Querying DataSets (LINQ to DataSet)[^]

5) etc.

Try something and get back here when you get stuck to ask detailed question.

provi 777 · Answer 2 · 2015-11-01T04:53:00

Solution 3

con.Open();
da = new OleDbDataAdapter(" select *from tablename where studentID ='" + textbox1.Text + "'", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "tablename");
            dataGridView1.DataSource = ds.Tables[0];
            ds.Tables.Clear();
            con.close();

Posted 1-Nov-15 4:53am

provi 777

Comments

Maciej Los 1-Nov-15 12:09pm

Wrong approach! Never, ever use such of queries! Use parametrzed queries.