how to search a record from two differents windows form in c# and display it in datagridview

Question

1.00/5 (2 votes)

See more:

private void btnVwClient_Click(object sender, EventArgs e)
       {
           SqlDataAdapter da = new SqlDataAdapter("select * from client where clientId='" + txtNoCli.Text + "'", con);
           DataSet ds = new DataSet();
           da.Fill(ds, "client");
           DataView dv = new DataView(ds.Tables["client"]);
           dataGridView2.Visible = true;
           dataGridView2.DataSource = dv;
       }

Posted 9-Aug-12 21:12pm

Gilbertinino

Add a Solution

Comments

Santhosh Kumar Jayaraman 10-Aug-12 3:22am

Your question title and the description didnt match. can you please give us some more explantion?

[no name] 10-Aug-12 7:39am

This is just a code dump. No question. No description of a problem.

1 solution

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)

Christian Graus · Answer 1 · 2012-08-13T13:30:00

Solution 1

Your question is very unclear, but I will tell you this. Your code is not production quality. If I wanted to, I could erase your entire DB by doing a SQL Injection attack on this form. You need to read up on the right way to build SQl, using paramaterised queries. This looks like someone could be paying for it, and no-one should ever use this code in real life on a secure system.

Posted 13-Aug-12 13:30pm

Christian Graus

Comments

AspDotNetDev 13-Aug-12 19:38pm

I voted your answer a 2 because it is not an answer (however useful the advice may be). If you think the question is garbage, downvote, delete, edit, or comment on it. If you think there is something tangentially related to the code that is not an answer, post it as a comment.

Christian Graus 16-Aug-12 13:32pm

Fair enough. You'll notice I made my reply when this was days old. I am more careful about what I respond with, in the form of an answer, when a question looks active, and not abandoned.