how to get the value using datareader
Posted By: sheeba Posted Date: April 26, 2011
Points:5 Category :ASP.Net
cmd = new OleDbCommand("SELECT PARTNO FROM PARTMACHINE WHERE PARTNO NOT IN(SELECT PARTNO FROM HEADER WHERE BATCH_CODE = '" + Batch_Code + "') AND BATCH_CODE = '" + Batch_Code + "'", oitem.con);
Dr = cmd.ExecuteReader();
parts = Dr["PARTNO"].ToString();
in this loop i can get the 3 values 001,002,003 like that.now i want to separate using ','..
my o/p should be like this
and then i need to store this value to one variable bcz i need to use this variable for future purpose.
How to do?
You must Sign In To post reply