Retrieve a single data

Question

0.00/5 (No votes)

See more:

I developed a Windows Form Application. There are many forms available for data manipulation. In a form namely Sales_Details I enter information of a doctor in database such as Doctor Name, Address, Mobile etc. In one another form I used a comboBox control for Doctor Name, I retrieve the Doctor Name to this comboBox from Sales_Details where the Doctor Name entered first time. I wrote this code for that

C#

DataTable dt2 = new DataTable();
SqlConnection cn1 = new SqlConnection(Class1.cs);
SqlDataAdapter da2 = new SqlDataAdapter("select Doctor_Name from Sales_Details", cn1);
da2.Fill(dt2);
comboBox2.DataSource = new BindingSource(dt2, null);
comboBox2.DisplayMember = "Doctor_Name";
comboBox2.Text = "Select One...";
cn1.Close();

while I run this code it's running properly but it retrieves and shows in the comboBox a particular Doctor Name 5 times if I entered that particular Doctor Name 5 times by using the first form viz; Sales_Details. I want to show that particular Doctor Name only one time whether I entered it 5 or 6 times no matter. Please someone help.
I used C# and SQL Server 2005 to develop this application.

Posted 25-Mar-13 17:11pm

Md M Ahmad

Updated 25-Mar-13 17:59pm

_Amy

v2

Add a Solution

3 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)

bbirajdar · Answer 1 · 2013-03-25T17:19:00

Solution 1

SQL

select DISTINCT Doctor_Name from Sales_Details

But not a perfect solutions since two doctors can have the same name.

Posted 25-Mar-13 17:19pm

bbirajdar

Updated 25-Mar-13 17:20pm

v2

Comments

_Amy 25-Mar-13 23:59pm

+5! Agree..

_Amy · Answer 2 · 2013-03-25T17:58:00

You should have a code for each doctors. I would suggest you to display code along with the doctor names in DropDown. Try this:

C#

DataTable dt2 = new DataTable();
SqlConnection cn1 = new SqlConnection(Class1.cs);
SqlDataAdapter da2 = new SqlDataAdapter("SELECT (Doctor_Name +' - '+ Doctor_Code) AS Doctor_Name, Doctor_Code  FROM Sales_Details", cn1);
da2.Fill(dt2);
comboBox2.DataSource = new BindingSource(dt2, null);
comboBox2.DisplayMember = "Doctor_Name";
comboBox2.Text = "Select One...";
cn1.Close();

Now, if the two doctors are having same name also then user can easily identify with their codes.

--Amit

Nasir M@hmood · Answer 3 · 2013-03-25T19:36:00

_Amy is right my solution is lite modified form

C#

DataTable dt2 = new DataTable();
SqlConnection cn1 = new SqlConnection(Class1.cs);
SqlDataAdapter da2 = new SqlDataAdapter("SELECT Doctor_Code, (Doctor_Name +' - '+ Doctor_Code) AS Doctor_Name, Doctor_Code  FROM Sales_Details", cn1);
da2.Fill(dt2);
comboBox2.DataSource = new BindingSource(dt2, null);
comboBox2.DisplayMember = "Doctor_Name";
comboBox2.ValueMember = "Doctor_Code";
comboBox2.Text = "Select One...";
cn1.Close();

now you can get the actual doctor code with comboBox.SelectedValue property.

Retrieve a single data

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0