Question on Asp.Net DataTable

Aniket Narvankar

10y1.1kLearn iOS Programming

I have a DataTable which contains 3 columns

id name val

1 a 2

2 b 3

3 c 4

4 d 12

5 e 14

there are five variables string a,string b,string c,string d,string e.I want to assign a value,from name column a value which is 2 to variable a,similary b value to variable b.I have done it this way

a = dt.Rows[0]["val"]

b = dt.Rows[1]["val"]

c = dt.Rows[2]["val"]

d = dt.Rows[3]["val"]

e = dt.Rows[4]["val"]

this is assigning values,but the way is going wrong.Please do let me know the other way i am stuck on this.

Regards,

Aniket Narvankar

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
@Aniket,If you need anyother solution like yours then we can include using if..else statement instead of switch..case inside for loop. Wecan try with while..loop too.In my perspectiveI don't think, howthese options are considered as alternatives.
Since your ultimate result needs get thevalues from the each row and assign to the separate "string"variables. :)
0
Aniket Narvankar10y ago
string message = string.empty;
foreach(DataRow dr in dt.Rows)
{
switch(dr["name"].ToString())
{
case 'a':
a = dr["val"].ToString();
break;

case 'b':
b= dr["val"].ToString();
break;

case 'c':
c= dr["val"].ToString();
break;
case 'd':
d= dr["val"].ToString();
break;
case 'e':
e= dr["val"].ToString();
break;
default:
message = "No Records Found";
break;
}
}
Found this temporary way,if there is any other way please do let me know about it.by storing the variables in a list and by iterating through it,and checking wether it is present in datatable then only assign it,but not getting how to do this
0
Vinay Singh10y ago
Hi
I got the requirement. But just check ones you are getting value in datatable not. if you are still getting value in datatable the what the error you are getting.
0
Rajesh Sahoo10y ago
What is the error you are facing?
0
Francis Susaimichael10y ago
Since you want to get thevalues from the each row and assign to the separate "string"variables, this is thepossibleway AFAIK. I think, you feel that the code is repeated multiple times. But this is how you need to achieve this one.
If any other way, is exist I'm glad to know. :)
0
Aniket Narvankar10y ago
I have DataTable which has 3 columns
id name val
1 a 2
2 b 3
3 c 4
4 d 12
5 e 14

there are five variables string a,string b,string c,string d,string e.I want to assign a value,from name column a value which is 2 to variable a,similary b value to variable b.I have done it this way

a = dt.Rows[0]["val"].ToString()
b = dt.Rows[1]["val"].ToString()
c = dt.Rows[2]["val"].ToString()
d = dt.Rows[3]["val"].ToString()
e = dt.Rows[4]["val"].ToString()

this is assigning values,but the way is going wrong.Please do let me know the other way i am stuck on this.is there any other way,please let me know about it.
Regards,
Aniket Narvankar
0
Vinay Singh10y ago
Hi
What exactly the problem you are facing
0
Rajesh Sahoo10y ago
hi,
actually problem is you are assigning a object value to string so it gives you error.
just change your line to....
a = dt.Rows[0]["val"].ToString();
mark as answar if it helps.
0