How to Display two rows of SQL Table into two different textboxes?

Question

0.00/5 (No votes)

See more:

Hi All,
I have two Tables Named Output and Activities. The Output table contains Output_ID (Int) as a primary key and Output (Varchar(Max)), The Activities table contains Activity_ID (Int) as a primary key, Output_ID (Int) as foreign key and Activity (Varchar) it self. I used one to many relation ship between these tables where an output can have multiple activities but an activity can only have only one output.

The thing i want your help with is How can i retrieve the all activities in different textboxes of an output based on Output_ID? as far i am quite new to SQL Server i will be glad if you help me.

Note : I tried this code, it works with SQL Server Query but not with visual studio c#.

SQL

SELECT * FROM ActivitesTBL

Thanks in advance

Here is what i have done.

C#

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Joining ;Persist Security Info=True;User ID=sa;Password=*********");
            string Query = "SELECT * FROM ActivityTBL WHERE Output_ID = '"+Outputcmbx.Text+"';".ToString();



            SqlCommand cmd = new SqlCommand(Query, conn);
            SqlDataReader dr;
            try
            {
                conn.Open();
                dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    string sActivity = dr.GetString(2);

                    FirstActivitytxt.Text = sActivity;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

Posted 6-Nov-13 22:39pm

NaserDostdar

Updated 6-Nov-13 23:04pm

Sampath Lokuge

v5

Add a Solution

Comments

CodeBlack 7-Nov-13 4:44am

I think first of all you should learn 'How to retrieve data from SQL'. Below link will be helpful for that :

http://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C

[no name] 7-Nov-13 4:51am

Thank You.

Rak_Avasthy. 7-Nov-13 4:49am

you need c# code or sql query for that??.... and this is a query.. it does not run in visual studio, you have to meke an sql connection and sql command to execute this command

[no name] 7-Nov-13 4:51am

I did that i need to load the activities in two text boxes that is it!

Sampath Lokuge 7-Nov-13 4:50am

Is this asp.net webform,MVC or win App ?

[no name] 7-Nov-13 4:52am

It is winform application, all i need i want to display 2 records in to two
different textboxes.

[no name] 7-Nov-13 4:59am

Can you see FirstActivitytxt.text Text box? I have another Textbox for Second, third and fourth... activities to be shown when Output id is selected how can i do that?

♥…ЯҠ…♥ 7-Nov-13 4:58am

According to the output you need to put it in different text boxes.... am I right?

[no name] 7-Nov-13 5:02am

See i have one Output called "Best Output" i have two activities for this out put so called "Best Activity" and "Poor activity". The code that i have written it only displays the poor activity in the first text box but the second activity is not shown in the second text box called SecondActivity.txt. you know what i mean?

♥…ЯҠ…♥ 7-Nov-13 5:06am

I do not know what you mean, anyone explain his requirement if you understand.....

[no name] 7-Nov-13 5:07am

Sir do you have skype ? Please if you can i need your urgent help please.

Sergey Alexandrovich Kryukov 20-Feb-14 9:11am

Still need a site replica? Really want someone to help you? :-)
—SA

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)

♥…ЯҠ…♥ · Answer 1 · 2013-11-06T23:21:00

Hi Naser,

From your updated question, you retrieved only one string and moved to FirstActivityTxt.text,
you missed to read second string... so try this

C#

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Joining ;Persist Security Info=True;User ID=sa;Password=*********");
            string Query = "SELECT * FROM ActivityTBL WHERE Output_ID = '"+Outputcmbx.Text+"';".ToString();
 

 
            SqlCommand cmd = new SqlCommand(Query, conn);
            SqlDataReader dr;
            try
            {
                conn.Open();
                dr = cmd.ExecuteReader();
 
                while (dr.Read())
                {
                    string sActivity = dr.GetString(2);
		    string poorActivity = dr.GetString(1); //Column ordinal number comes here
                    FirstActivitytxt.Text = sActivity;
	            PoorActivitytxt.Text = poorActivity; //Replace PoorActivitytxt name with your textbox name
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

I think now it would work....

Regards,
RK