Forums » .NET » ASP.NET »

how to get value of cell of datatable in c#


Posted Date: 28 May 2008      Posted By:: Red Swan Profile photo    Member Level: Gold    Member Rank: 622     Points: 1   Responses: 5



how to get value of cell of datatable in c#:
I need to get the value from datatable from eachrow in single row...how it is?




Responses

#238583    Author: Ashok Kandasamy      Member Level: Gold      Member Rank: 236     Date: 28/May/2008   Rating: 2 out of 52 out of 5     Points: 2

hi,
Try this,

DataTable dt = new DataTable();
string rowValue = dt.Rows[0].ToString();
string coloumnValue = dt.Columns[0].ToString();


 
#238584    Author: Sujit Kumar      Member Level: Gold      Member Rank: 220     Date: 28/May/2008   Rating: 2 out of 52 out of 5     Points: 2

datatable.Rows[0][0]

//Rows[0][0], first[0] means rows and second [0] means column

Regards,
Sujit Kumar


 
#238588    Author: kavithiagu      Member Level: Silver      Member Rank: 0     Date: 28/May/2008   Rating: 2 out of 52 out of 5     Points: 2

try it

if (ds1.Tables.Count > 0)
{
for (int j = 0; j < ds1.Tables[0].Rows.Count; j++)
{
DataRow odr = ds1.Tables[0].Rows[j];

dataGridView1.Rows.Add();
dataGridView1.Rows[j].Cells[1].Value = odr["columnname"].ToString();
dataGridView1.Rows[j].Cells[2].Value = odr["columnname"].ToString();
dataGridView1.Rows[j].Cells[4].Value = odr["columnname"].ToString();
dataGridView1.Rows[j].Cells[2].ReadOnly = true;
dataGridView1.Rows[j].Cells[4].ReadOnly = true;

}





 
#238589    Author: Siva Prasad      Member Level: Gold      Member Rank: 1527     Date: 28/May/2008   Rating: 2 out of 52 out of 5     Points: 2

Hello Lalit,

string cellValue = dataTable.Rows[0][1].ToString();

Siva Prasad


 
#238752    Author: Parashu(Swathimutyam)      Member Level: Gold      Member Rank: 0     Date: 28/May/2008   Rating: 2 out of 52 out of 5     Points: 2

for (int i = 0; i < ds.Tables["reg_table"].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables["reg_table"].Columns.Count; j++)
{
items.Add(ds.Tables["reg_table"].Rows[i][j].ToString());
}
}

the above code will retrive a first row and all the columns,
based on this idea please implement your code

Regards,
Parshu(Swathimutyam)


 
Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.



Return to Discussion Forum
Start new thread

Subscribe to Subscribers
Active Members
TodayLast 7 Daysmore...

Awards & Gifts
Talk to Webmaster Tony John

Online Members

Ram Prasad
More...
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India