Convert datarow to int

c# int datarow
Steaphann picture Steaphann · Mar 2, 2011 · Viewed 51.3k times · Source

I have a datarow, but how can i convert it to an int ?

I tried this, but it doesn't work.

dsMovie = (DataSet)wsMovie.getKlantId();
            tabel = dsMovie.Tables["tbl_klanten"];
            eersteRij = tabel.Rows[0];
(Int32.Parse(eersteRij.ToString())

Answer

user1228 picture user1228 · Mar 2, 2011

A DataRow is an object; it is not an integer. A DataRow contains one or more columns of data. You can index into the DataRow to access the values of these coulmns.

If table tbl_klanten contains one column, and that column is an integer, you can do the following:

var myInt = (int)eersteRij[0];

if the column is a string containing the value of an integer,

var myInt = int.Parse(eersteRij[0]);

If the column is named klant_id...

var myInt = (int)eersteRij["klant_id"];

if the column is a string containing the value of an integer,

var myInt = int.Parse(eersteRij["klant_id"]);

Related questions

Get int value from enum in C#

I have a class called Questions (plural). In this class there is an enum called Question (singular) which looks like this. public enum Question { Role = 2, ProjectFunding = 3, TotalEmployee = 4, NumberOfServers = 5, TopBusinessConcern = 6 } In the Questions class I have a get(int foo) function …

Read More
How can I convert String to Int?

I have a TextBoxD1.Text and I want to convert it to an int to store it in a database. How can I do this?

Read More
How can I cast int to enum?

How can an int be cast to an enum in C#?

Read More