I want to set the value for Label1 dynamically.

Question

0.00/5 (No votes)

See more:

Hi dear,

I am making a small program in ASP.NET in C# but am not able to set the label names from a Database table.

Table Name: Columns

col_id col_name
======= ==========================
Label1 City ID
Label2 City Name
Label3 City Addrs

i want to set all the lables from the table "Columns".

This function will be called at the time of Page Load()

More Details of My code "I am not Sure It is True"

In Class file Main.cs

 public static string GetColum_Des(string p_opt_id)
{
    string str = System.Configuration.ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
  
    SqlCommand cmd;
    SqlDataReader rd;
    SqlConnection con = new SqlConnection(str);
                     
    unsafe
    {
        string str1, str2;
              
        con.Open();
        cmd = new SqlCommand("select col_id,col_name from LOCATIN_DETAIL where opt_ID=@p_opt_id ", con);
        cmd.Parameters.AddWithValue("@p_opt_id", p_opt_id);
         rd = cmd.ExecuteReader();
        while (rd.Read())
        {
            str1 = rd["col_id"].ToString() + ".Text";//I want to get Label Id from here +.Text Means "Label1.Text" in str
            str2=rd["col_name"].ToString();//I want to get Label value from here  which had stored in database fied col_name
            str1 = str2; //Means Label1.Text=str2 is it possible
        }
    }
 
    return "";
}

This Function is calling on Page_Load of Default.aspx

C#

protected void Page_Load(object sender, EventArgs e)
    {
      //Passing value of p_opt_id
      Main.GetColum_Des("001001001")
    }

Expecting Your Help

[edit] edited for more readability[/edit]

Posted 3-Aug-10 23:58pm

saifulhaque

Updated 4-Aug-10 0:23am

raju melveetilpurayil

v2

Add a Solution

Comments

koool.kabeer 4-Aug-10 9:49am

are your Labels defined in AspPage?...
or you want to create new Labels?...

3 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)

raju melveetilpurayil · Answer 1 · 2010-08-04T00:34:00

Solution 2

I don't know the use of unsafe here in your code. anyway this will help you

C#

public static string GetColum_Des(string p_opt_id,Label label1,Label label2)
   {
       //do your DB opertation
       //this value from your code
       label1.Text = "str";
       //this value from your code
       label2.Text = "str2";
       return "";
   }

C#

protected void Page_Load(object sender, EventArgs e)
   {
       //labels in your page.
       GetColum_Des("your p_opt_id", Label1, Label2);
   }

Posted 4-Aug-10 0:34am

raju melveetilpurayil

Comments

raju melveetilpurayil 4-Aug-10 6:55am

where you need to show this Labels? you need a PlaceHolder to display this labels.

saifulhaque 4-Aug-10 6:56am

I think you are not understant my questain ,I want to pass only value of

p_opt_id . Label1,Label2 are generated from database field col_id through

while loop,Then appened .Text with Labels,This will create

Label1.Text,Label2.Text etc.. .After that i want to read value from database

field col_name to Label1.text,Label2.Text etc in while loop ,You can see in my code which had given.

koool.kabeer · Answer 2 · 2010-08-04T10:25:00

may be this will help you..
i am considering that you have a Database table named as
"Columns" whose data and structure is

col_id ----- col_name ---- opt_ID
______ _________ ________

lbl1 --------- Asp ---------- 1
lbl2 ------ --- C# ---------- 2
lbl3 --------- VB ---------- 22
lbl4 --------- Ado --------- 13

and as you said you have the Labels in on you web Page...
suppose you have assigned that Labels in a Container Control say Panel as
'panel1' as id....
and you have set your Labels ids as in the Database table
"Columns" column "col_id"...

now here is the Code..

/*for getting the Collection of Label Controls from your Container Control say Panel whose id is "panel1" into Collection "labels"*/
var labels = from Control c in panel1.Controls where c.GetType().Equals(typeof(Label)) select c;

 con.Open();
 cmd = new SqlCommand("select col_id,col_name from Columns where opt_ID=@p_opt_id ", con);
 cmd.Parameters.AddWithValue("@p_opt_id", p_opt_id);
  rd = cmd.ExecuteReader();
 while (rd.Read())
 {
    foreach(Control c in labels)/*looping only the Labels
                                Collection of "panel1"*/
    {

       Label l = (Label)c;
       if(l!=null)
       {
           if(l.id==rd["col_id"].ToString())
                l.Text=rd["col_name"].ToString();/*you can set
                                                 various
                                                 Properties of
                                             Label Control here*/
       }
    }
 }

and to set the ID's of your Labels in Your Panel "panel1"..
use the "ID" Property of Label Control that can be set and get....
as... Label1.ID="lbl1";

and i dont know what is "unsafe" in your code....
hope this will help you
may be i am answering quite irrelevant....
if so, sorry friends......

Sandesh M Patil · Answer 3 · 2010-08-04T00:23:00

Solution 1

do u have Label Control Label1 on your page. If not create a control

protected void Page_Load(object sender, EventArgs e)
{
Label Label1=new Label();
Main.GetColum_Des("001001001")//Passing value of p_opt_id
}

I think it help u.... :)

Posted 4-Aug-10 0:23am

Sandesh M Patil

Comments

raju melveetilpurayil 4-Aug-10 6:42am

Reason for my vote of 1
Label Label1=new Label(); this will not add a control in page.

saifulhaque 4-Aug-10 6:57am

I had Label in my Default.aspx page I want to pass only value of

p_opt_id . Label1,Label2 are generated from database field col_id through

while loop,Then appened .Text with Labels,This will create

Label1.Text,Label2.Text etc.. .After that i want to read value from database

field col_name to Label1.text,Label2.Text etc in while loop ,You can see in my code which had given.

koool.kabeer 4-Aug-10 9:52am

can you define.. how to generate the Labels from database?

koool.kabeer 4-Aug-10 9:56am

i got you in your previous question....
i asked you about where are you adding your labels?,
sorry i just lost for some days...
i think you are asking this...
Label l = new Label();
and you want this 'l' not as 'l' but the string "col_id" of database..
so that you can change Text of Database referenced Label;

saifulhaque 4-Aug-10 10:36am

I have Label id like Label1,Label2..etc in my Default.aspx.

I want to get automatically label id from database field col_id

(Label1,Label2 ..etc) and appened ".Text" with each Label.Then it will come

Label1.Text,Label.Text2 etc.. .I want read col_name this

Label1.text,Label2.Text etc.. from database field col_name through while

loop.Is it possible through some other way.I am thinking my code is

incorrect.Think another way. Share with your friends also.

Try to Help.

I want to set the value for Label1 dynamically.

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us