Question on Asp.Net DataTable

Question

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 astring bstring cstring dstring e.I want to assign a valuefrom name column a value which is 2 to variable asimilary 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 valuesbut the way is going wrong.Please do let me know the other way i am stuck on this. Regards Aniket Narvankar

Francis · Answer

@AniketIf 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 stringvariables. :)

Aniket Narvankar · Answer

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 wayif there is any other way please do let me know about it.by storing the variables in a list and by iterating through itand checking wether it is present in datatable then only assign itbut not getting how to do this

Vinay Singh · Answer

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.

Rajesh Sahoo · Answer

What is the error you are facing?

Francis · Answer

Since you want to get thevalues from the each row and assign to the separate stringvariables 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. :)

Aniket Narvankar · Answer

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 astring bstring cstring dstring e.I want to assign a valuefrom name column a value which is 2 to variable asimilary 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 valuesbut the way is going wrong.Please do let me know the other way i am stuck on this.is there any other wayplease let me know about it. Regards Aniket Narvankar

Vinay Singh · Answer

Hi What exactly the problem you are facing

Rajesh Sahoo · Answer

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.