how to pass the data to lablel control data is in SP?

Question

0.00/5 (No votes)

See more:

How to pass data to label and display in UI? That data is in SP

I used 3 tier architecture. In Data access layer

Set @meassage="Record Inserted SucessFully";

C#

cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500);
cmd.Parameters["@Message"].Direction = ParameterDirection.Output;

int result=  cmd.ExecuteNonQuery();
string outputValue = cmd.Parameters["@Message"].Value.ToString();
if (result == 1)
{
    lbloutputdata.text = outputValue;
}

This is not in .aspx.cs page . that code is in data acess layer

Any one help me ...

Posted 10-Oct-14 23:47pm

Sai Prasad anumolu

Add a Solution

2 solutions

Solution 2

create a class file for message box
as example
message.cs in bll

C#

public void ShowAlertMessage(string error)
    {

        Page page = HttpContext.Current.Handler as Page;

        if (page != null)
        {

            error = error.Replace("'", "\'");

            ScriptManager.RegisterStartupScript(page, page.GetType(), "err_msg", "alert('" + error + "');", true);

        }
    }

and place the code.

now you add your serverside

C#

message msg = new message();

cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500);
cmd.Parameters["@Message"].Direction = ParameterDirection.Output;
 
int result=  cmd.ExecuteNonQuery();
if (result >= 1)
{
    msg.Showalertmessage("Your Message!..");
}

Posted 11-Oct-14 3:22am

Maddy selva

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-10-11T00:34:00

Solution 1

You have to return that from the method in data access layer. Then just assign the returned string to the Label.

Posted 11-Oct-14 0:34am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Sai Prasad anumolu 11-Oct-14 7:38am

I already returned friend

cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500);
cmd.Parameters["@Message"].Direction = ParameterDirection.Output
string outputValue = cmd.Parameters["@Message"].Value.ToString();
This is class DAL .

This is .aspx.cs i want output value is call in label.text How ?
lbloutputData.Text = ObjectRepresentDL.outputValue;

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Oct-14 8:03am

That code should be inside a method, right? Add a return type to that method, which will be string, like...

string MethodInDAL()
{
//......., other codes....
cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500);
cmd.Parameters["@Message"].Direction = ParameterDirection.Output
string outputValue = cmd.Parameters["@Message"].Value.ToString();

return outputValue;
}

Now in aspx.cs...

lbloutputData.Text = MethodInDAL();

Got me?

Sai Prasad anumolu 11-Oct-14 8:07am

i already i return return ObjectRepresentDL; This one DAl

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Oct-14 8:13am

So, what is the issue. Have you not assigned the message to this object?

Sai Prasad anumolu 11-Oct-14 8:18am

Issue means .. how to store the value in Class ?(This is class) + That stored value will call to label.text

label.text= Stored value. I used 3 tier architecture

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Oct-14 8:22am

As you said you are returning ObjectRepresentDL, so you should put that message in this object like...

ObjectRepresentDL.ReturnMessage = "anything you want";

ReturnMessage should be one property of that object's class.

Sai Prasad anumolu 11-Oct-14 8:26am

already data is Stored procedure

set @Message='Your Record Inserted Successfully'
SELECT @Message;

This data is in stored procedure

+ My Dataacesslayyer Code is this one ....
cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500);
cmd.Parameters["@Message"].Direction = ParameterDirection.Output;
string outputValue = cmd.Parameters["@Message"].Value.ToString();
int result= cmd.ExecuteNonQuery();

My webpage Code is L this one

lbloutputData.Text = DataAccessDAL();

That @meassage value will display in Labal

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Oct-14 8:34am

Please post the whole method DataAccessDAL() code here.

Sai Prasad anumolu 11-Oct-14 8:38am

SqlCommand cmd = new SqlCommand("InsertEmployeeBioData_SP", con); //This is Insert the All Values From the Tables
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", ObjectRepresentDL.FirstName);
cmd.Parameters.AddWithValue("@LastName", ObjectRepresentDL.LastName);
cmd.Parameters.AddWithValue("@Gender", ObjectRepresentDL.Gender);
cmd.Parameters.AddWithValue("@Experience", ObjectRepresentDL.Experience);
cmd.Parameters.AddWithValue("@Designation", ObjectRepresentDL.Designation);
cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500);
cmd.Parameters["@Message"].Direction = ParameterDirection.Output;
string outputValue = cmd.Parameters["@Message"].Value.ToString();
int result= cmd.ExecuteNonQuery();

cmd.Dispose();
con.Close();
return ObjectRepresentDL;

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Oct-14 8:44am

Now as I already said, please add another property to the class, whose object is ObjectRepresentDL.

So, you can write like...

ObjectRepresentDL.Message = outputValue;

Then in aspx.cs page, you can write...

ObjectRepresentDL = DataAccessDAL();

lbloutputData.Text = ObjectRepresentDL.Message;

Sai Prasad anumolu 11-Oct-14 9:05am

null is comming brother

ObjectRepresentDL = DataAccessDAL();
lbloutputData.Text = ObjectRepresentDL._Message;

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Oct-14 9:09am

How? Don't you get any value from database? Please debug and see. If you are getting values for other properties, then you can also get for this.

Sai Prasad anumolu 11-Oct-14 9:59am

Thank you it is working

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Oct-14 10:29am

Glad to know. Please accept the answer.

Thanks,
Tadit