how to read data from sqlserver and show them in label?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

Hello.

I have created a web application that some one insert his personal information into the database.at the end he wants to see his inserted data. so i decided to make a printpage like below :

FirstName =========== FirstNameResultLabel
LastName =========== LastNameResultLabel
BirthDate =========== BirthDateResultLabel

infact i would like to read data from sqlserver and show them in these labels. so here is my code:

C#

    SqlCommand Command = DataProvider.GenerateCommand("[dbo].[Select_IranianGeneralInfoReport_SP]", CommandType.StoredProcedure);
    Command.Parameters.AddWithValue("@IdCode", GlobalVariables.IdCode);
    try
    {
        Command.Connection.Open();
        GlobalVariables.IdCode = int.Parse(Command.ExecuteScalar().ToString());
        SqlDataReader dr = DataProvider.ExecuteDataReader("[dbo].[Select_IranianGeneralInfoReport_SP]", CommandType.StoredProcedure);
        FamilyResultLabel.Text = dr["LastName"].ToString();
        NameResultLabel.Text = dr["FirstName"].ToString();
        dr.Read();

        dr.Close();
        Command.Connection.Close();
    }
    catch (Exception ex)
    {
        EventLogger.Log(ex.Message, LogType.Error);
    }
}

everything is in the PageLoad.
but when i start to debug , and exception occures .

how can i solve this problem ? or better to say how can i read data from database and show them in those above labels?

Posted 12-Feb-13 17:48pm

mohammad ehsan

Updated 12-Feb-13 17:50pm

v2

Add a Solution

Comments

Mithun P 12-Feb-13 23:55pm

pls post what is the exception u r getting

mohammad ehsan 13-Feb-13 0:10am

here is the exception:

Procedure or function 'Select_IranianGeneralInfoReport_SP' expects parameter '@IdCode', which was not supplied.

@IdCode either is a PK in my table and a session among my pages.

PIEBALDconsult 13-Feb-13 0:08am

"int.Parse(Command.ExecuteScalar().ToString());" Don't do that; if it's an int, just cast it!

You seem to copy the IdCode into the parameter before you set it.

And other questionable things.

2 solutions

Solution 2

Hi,

You can use something like below:

C#

DataSet ds = new DataSet();
DataTable dt = new DataTable();

da.SelectCommand = new SqlCommand(@"SELECT * FROM dbo.MyTable", connString);
da.Fill(ds, "dbo.MyTable");
dt = ds.Tables["dbo.MyTable"];

foreach (DataRow dr in dt.Rows)
{
    Label1.Text=dr["Column1"].ToString();
    Label2.Text=dr["Column1"].ToString();

}

The above is a method, but it will have performance issues when you have a large table in the database, coz the table will be queried everytime and it will add a overhead to your code.In that case you can pull the whole table in a datatable at once and use it.

Hope it helps.

Regards
Anurag

Posted 12-Feb-13 18:05pm

Anurag Sinha V

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)

*Karthik Harve* · Accepted Answer · 2013-02-12T17:56:00

Hi,

change these code lines.

C#

SqlCommand Command = DataProvider.GenerateCommand("[dbo].[Select_IranianGeneralInfoReport_SP]", CommandType.StoredProcedure);
            Command.Parameters.AddWithValue("@IdCode", GlobalVariables.IdCode);
try
{
    Command.Connection.Open();
    GlobalVariables.IdCode = int.Parse(Command.ExecuteScalar().ToString());
SqlDataReader dr = DataProvider.ExecuteDataReader("Select_IranianGeneralInfoReport_SP", CommandType.StoredProcedure);
FamilyResultLabel.Text = "";
NameResultLabel.Text = "";
while(dr.Read())
{
FamilyResultLabel.Text = dr["LastName"].ToString();
NameResultLabel.Text = dr["FirstName"].ToString();
}
dr.Close();
Command.Connection.Close(); 
}
catch (Exception ex)
{
    EventLogger.Log(ex.Message, LogType.Error);
}

dr.Read() should be excuted before reading the values. and putting that in while loop will avoid exception on zero rows.
refer this article for more information.
SqlDataReader Class[^]
SqlDataReader Class[^]

hope it helps.