sql database reading

Question

1.00/5 (1 vote)

See more:

how to select entir data of a specific column in sql server database into a form components like lables? my code look like this---here i am not geting the value for lable2.

C#

private void timer1_Tick(object sender, EventArgs e)
        {
            try
            {
                SqlConnection con = new SqlConnection(@"Server=192.168.1.4;Database=DIGIQUEUE;User Id=digiq;Password=digiq123;");
                con.Open();
                string sql1 = "Select callpad_status from callpad ";
                SqlCommand cmd = new SqlCommand(sql1, con);
                SqlDataReader sqlReader = cmd.ExecuteReader();
                while (sqlReader.Read())
                {
                    label1.Text = sqlReader.GetValue(0).ToString();
                    label2.Text = sqlReader.GetValue(1).ToString();
                }
                sqlReader.Close();
            }
            catch (System.Exception ex)
            {
            }
       }

Posted 28-May-13 20:15pm

harishhn

Updated 28-May-13 20:40pm

Sushil Mate

v2

Add a Solution

Comments

Himanshu__Bisht 29-May-13 2:31am

Are you getting any error or a undesired result. Pls Share. Thanks!!

Sushil Mate 29-May-13 2:44am

which data column you want to add in label2? you need to put in select query. the problem lies in the select query.

renish patel 29-May-13 3:12am

May be you get solution using this...

while(sqlReader.Read())
{
label1.Items.Add(sqlReader["callpad_status"].ToString());
}

Thanks

4 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 · 2013-05-28T21:06:00

I would suggest you to start here: ASP.NET Overview[^] and read all related articles.

Next, have a look at examples:
Beginners guide to accessing SQL Server through C#[^]
A Beginner's Tutorial - Understanding ControlState in ASP.NET[^]
Beginner's Tutorial on Master Pages in ASP.NET[^]
A Beginner's Tutorial on ASP.NET Web Parts[^]
Understanding ASP.NET Application and Page Life Cycle - A Beginner's Tutorial[^]
Understanding ASP.NET Roles and Membership - A Beginner's Tutorial[^]
ASP.NET Code Sample Downloads[^]
ASP.NET Code Examples from MSDN and the ASP.NET[^]

I think it's enough for start...

Basmeh Awad · Answer 2 · 2013-05-28T21:07:00

check this

C#

private void timer1_Tick(object sender, EventArgs e)
        {
            try
            {
                SqlConnection con = new SqlConnection(@"Server=192.168.1.4;Database=DIGIQUEUE;User Id=digiq;Password=digiq123;");
                con.Open();
                string sql1 = "Select callpad_status from callpad ";
                SqlCommand cmd = new SqlCommand(sql1, con);
                SqlDataReader sqlReader = cmd.ExecuteReader();
                label1.Text="";
                while (sqlReader.Read())
                {
                    label1.Text =label1.Text + sqlReader.GetValue(0).ToString(); //you  are selecting only one column in your select query. when you will add one more column in your query then you can use label2 same as label1
                    label2.Text = sqlReader.GetValue(1).ToString();
                }
                sqlReader.Close();
            }
            catch (System.Exception ex)
            {
            }
       }

Hitesh Gohel · Answer 3 · 2013-05-28T21:12:00

Solution 4

Hi,
Please change the select query like this ..

SQL

Select columnname1 , columnname2 from tablename

then you can get the value of lable2

Posted 28-May-13 21:12pm

Hitesh Gohel

renish patel · Answer 4 · 2013-05-28T21:10:00

Solution 3

C#

while(sqlReader.Read())
               {
                   label1.Items.Add(sqlReader["callpad_status"].ToString());
               }

Posted 28-May-13 21:10pm

renish patel

sql database reading

4 solutions

Solution 1

Solution 2

Solution 4

Solution 3

Add your solution here

Preview 0