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: 0     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: 0     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: 0     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: 0     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

    Arun Skaria
    More...
     
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India

    
    
    
    

    Click the "Follow" button above to follow Tony John