want to fetch a record from Database by making column name by concatenate column name with local variable value

Question

0.00/5 (No votes)

See more:

In attendance table thier are columns D1,D2,....D31.below i'm trying to fetch a column by Concatenate D& local variable j1 .here j1 is the last day of month(likeD30 or D31 or D28 or D29) if j1=30 then D"+j1+" consider as D30 and assign it's value to variable att but it assigns 30 not D30's value how can i fetch actual value by adding local variable with Column name (like D"+j1+")..hereif j1=30 the query should return D30's value and store it on att variable ..

string j1 = Convert.ToString(days1);
        att = "";
        ad = new SqlDataAdapter("select D"+j1+"  from Attendance where Emp_Code='" + TextBox1.Text + "',reg='" + regn1 + "'and Type='" + Label112.Text + "'", con);
        
        if (dt6.Rows.Count > 0)
        {
            att = Convert.ToString(dt6.Rows[0][0]);
        }

Posted 6-Dec-13 18:41pm

Ujjval Shukla

Updated 6-Dec-13 20:17pm

JoCodes

v2

Add a Solution

2 solutions

Solution 2

below code will help You

C#

string j1 = Convert.ToString(days1);
att = "";
ad = new SqlDataAdapter("select D + j1 + " from Attendance where Emp_Code='" + TextBox1.Text + "' and  reg='" + regn1 + "' and [Type]='" + Label112.Text + "'", con);

DataTable dt6 = new DataTable();

ad.Fill(dt6);

if (dt6.Rows.Count > 0)
{
 att = dt6.Rows[0][0].ToString()+"'s";
}

Posted 6-Dec-13 21:45pm

Salman622

Comments

OriginalGriff 7-Dec-13 4:17am

Reason for my vote of 1: Copying an existing solution and posting it as your own is not a good way to behave. It is the beginnings of "abuse" which can get you banned from the site.

Salman622 7-Dec-13 5:51am

do you have eyes

Salman622 7-Dec-13 5:53am

just read the Question above and see the solution below.
and plz don't interfere.

OriginalGriff 7-Dec-13 6:00am

I suggest you look at the "Solution 1" above your "Solution 2", and check out the time difference between them...
And "interfering" as you call it is part of why I am here: as a Protector I am expected to spot things like this, and take appropriate action. In this case, I felt that a polite comment asking you to desist would be sufficient. If you wish to be banned from the site, I can certainly help you with that, however.

Salman622 7-Dec-13 6:04am

for your kind information solution 1 is wrong according to the question asked
You should have a look to that also.

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)

Dineshshp · Accepted Answer · 2013-12-06T19:16:00

Try this...

string j1 = Convert.ToString(days1);
att = "";
ad = new SqlDataAdapter("select D" + j1 + " from Attendance where Emp_Code='" + TextBox1.Text + "' and  reg='" + regn1 + "' and [Type]='" + Label112.Text + "'", con);

DataTable dt6 = new DataTable();

ad.Fill(dt6);

if (dt6.Rows.Count > 0)
{
 att = Convert.ToString(dt6.Rows[0][0]);
}