To display data from sql server into a label name

Question

5.00/5 (1 vote)

See more:

Can I display data from from sql server table into a label.text?
I am making a registration form followed by a login form.
The registration form takes values from textboxes and for a security question I have a combo box. So in registration and login I have succeeded in that but I want to change the user password so I first want to display the security question into a label's text. Can I do that?

[edit]SHOUTING removed - OriginalGriff[/edit]

Posted 25-Aug-12 23:09pm

sariqkhan

Updated 25-Aug-12 23:48pm

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 26-Aug-12 5:48am

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.

To chose both wrong styles in the same question just makes you look like a rude child.

sariqkhan 26-Aug-12 5:57am

oops sorry I dont know the rules
: )

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)

nitin bhoyate · Accepted Answer · 2012-08-25T23:51:00

Solution 1

sure you can do that.
Steps:
1)Create connection object
2) open connection
3) create sqlcommand to read the data by passing the select query
4)execure reader
5) then labelname.text=Reader["Columnname"].ToString();

C#

try
{
    SqlDataReader myReader = null;
    SqlCommand    myCommand = new SqlCommand("select * from table", 
                                             myConnection);
    myReader = myCommand.ExecuteReader();
    while(myReader.Read())
    {
        label.text=myReader["Column1"].ToString();

    }
}
catch (Exception e)
{
    messagebox.show(e.ToString());
}

you can find more at
Beginners guide to accessing SQL Server through C#[^]

Posted 25-Aug-12 23:51pm

nitin bhoyate

Updated 25-Aug-12 23:52pm

v2

Comments

Mohamed Mitwalli 26-Aug-12 6:06am

5+

nitin bhoyate 26-Aug-12 6:08am

thanks go ahead....do more coding....

sariqkhan 26-Aug-12 6:43am

+5:)

sariqkhan 26-Aug-12 6:33am

bro you have given column1 name. So it is not dynamically change when the user gets change. Sorry i have not specified before. But if i have a username column too. Then inserting a username the specified column beside that will come as label's text. Can we do that?

nitin bhoyate 26-Aug-12 6:44am

if your table contains the column username then you can pass this instead of column1. and label will get content of that column.
Just try it. After trying you can understand more

sariqkhan 26-Aug-12 7:19am

bro there is no error in my program but the label text is still label1
i dont know why it is not changing
take a look my code is this one

namespace login
{
public partial class form1 : Form
{
public form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\aquib\My Documents\Visual Studio 2010\Projects\insert\login\Database1.mdf;Integrated Security=True;User Instance=True";
string s = "";
if (comboBox1.SelectedIndex >= 0)
s = comboBox1.Items[comboBox1.SelectedIndex].ToString();
string q = "insert into Table1 values('" + textBox1.Text + "','" + textBox2.Text + "','" + s + "')";
con.Open();
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("SUCCEED");

try
{
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select * from Table1",con);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
aquib.Text = myReader["USERNAME"].ToString();

}
}
catch (Exception d)
{
MessageBox.Show(d.ToString());
}

}

}
}

nitin bhoyate 26-Aug-12 7:22am

what is the name of table?

nitin bhoyate 26-Aug-12 7:23am

i think you should give where condition in select command

sariqkhan 26-Aug-12 7:28am

table name is table1
and where command?
can you show me an example
rewrite the code please if you can
copy paste it

nitin bhoyate 26-Aug-12 7:33am

if (con.State == ConnectionState.Open)
{ con.Close(); }
try
{

con.Open();
cmd = new SqlCommand("select * from table1 where username='passrequrednamehere'", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
labelName.text= dr["UserName"].ToString();
}
dr.Close();
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
con.Close();
}

sariqkhan 26-Aug-12 9:05am

hey bro can you help me out more?making this?
and sorry for my bad english ,my english is not good i am weak in it

sariqkhan 26-Aug-12 7:57am

awsome bro it worked.
thanks a lot.
you have selected a column username and given the value one value here in 'passrequirednamehere'
which is shown in the label's text?
right
is this the whole concept???
:)

nitin bhoyate 26-Aug-12 9:30am

I problem is solved then plz mark this question as solved

sariqkhan 26-Aug-12 9:39am

bro my real problem us not solved actually.
my actual code is this one
can you help me out

private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\aquib\My Documents\Visual Studio 2010\Projects\Copy of insert with combo with labelname+\login\Database1.mdf;Integrated Security=True;User Instance=True";
string q = ("select SEC_QUESTION from Table1 where USERNAME='" + textBox1.Text + "'");
con.Open();
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();

MessageBox.Show("SUCCEED");

is this code correct.? i want to display a column sec_question where the username is given by the text box?
i have this type of database

USERNAME PASSWORD SEC_QUESTION
aquib XYZ WHATS YOUR PET NAME
nitin PQR WHATS YOUR HOBBY
etc GHJ WHATS YOUR TELEPHONENO.
I WANT to get the security question "whats your hobby" if i will type in the inbox nitin username?
is my code correct?

nitin bhoyate 26-Aug-12 9:45am

SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\aquib\My Documents\Visual Studio 2010\Projects\Copy of insert with combo with labelname+\login\Database1.mdf;Integrated Security=True;User Instance=True";
string q = ("select SEC_QUESTION from Table1 where USERNAME='" + textBox1.Text + "'");
con.Open();
SqlCommand cmd = new SqlCommand(q, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
labelName.text= dr["SEC_QUESTION"].ToString();
}
dr.Close();
con.Close();
}

Member 8064216 5-Feb-13 18:49pm

I have 5 labels in my vb form. The project is I hav to display an exam timetable based on the order of the course id's. I have retreived the course id's from the database(sql server) and sorted them using the ".sort" method by putting all the values into an array. Now these sorted values have to be inserted into a set of labels in the same order. For example, first course id from the sorted array has to go to label1, second one into the second label(say label2) and so on.. Now, this is wer am stuck... So, I hope my question is clear... Is there anyone who can help me out.? Please....