Convert a datarow to int

Question

Hi,

I have a little project i am working on. This project is build by the 3 layer concept. But i have a small problem.
First let me tell you i have stored procedure: select movie_id from tbl_movie . Here i get all the id's from the movies.

Also i use a webservice to call all my methods. I have the following method:
Public Function updateMovie(ByVal Movie_id As Integer, ByVal Movie_naam As String, ByVal Movie_status As Integer, ByVal Movie_hoofdrol As String) As Boolean

In this method my movie_id is an integer.
Now when i want to use this method in my presentation layer, i first call the getMovieID function, where i get a dataset with all the id's. But then i want to convert the first datarow into an integer so that i can use it in my updatemovie funtion.

I tried this, dsMovie = (DataSet)wsMovie.getKlantId();
tabel = dsMovie.Tables["tbl_klanten"];
eersteRij = tabel.Rows[0];
Boolean bresult;
bresult = wsMovie.updateKlant((Int32.Parse(eersteRij.ToString()))

But it doesn't work...

Suthish Nair · Answer

You are not passing the column index... bresult = wsMovie.updateKlant( Convert.ToInt64 (eersteRij[0].ToString()) , txt_naam.Text, txt_voornaam.Text, txt_adres.Text, txt_postcode.Text, txt_telefoon.Text);

Suthish Nair · Answer

yes you can handle this also.. Like txt_naam.Text create another control make it visible false and bind eersteRij[0] the value to it . Then point this textbox value to your method. private void btn_first_Click(object sender, RoutedEventArgs e) { try{ index = 0; eersteRij = tabel.Rows[index]; txt_hide.Text = eersteRij[0].ToString(); } catch (Exception ex) { objLoggingApplication.WriteLine(strApplicationName, ex.Message); } }

Geelen Stef · Answer

Sorry, but i have still one problem. I need the current Id not the first...

Vulpes · Answer

For the record, DBNull.Value is what you get if there's no value at all for that row/column in the underlying database, but it doesn't matter now that Suthish has figured out what the problem was :)

Geelen Stef · Answer

Oh stupid ! Many thanks Nair ! You rock ! xD

Geelen Stef · Answer

Oh stupid ! Many thanks Nair ! You rock ! xD

Geelen Stef · Answer

what do you mean by DBNull.Value ??

Vulpes · Answer

Is it possible that tabel.Rows[0] could contain DBNull.Value? If it did, then that would explain the error you're seeing.

Geelen Stef · Answer

I uploaded the whole project!, the problem is situated in klant_overzicht.xaml.cs

Suthish Nair · Answer

can you upload the sample project page as attachmnent.

Geelen Stef · Answer

He doesn't want to do the count. Operator > cannot be applied to operands of type 'method group' and 'int'

Suthish Nair · Answer

if(dsMovie.Tables[0].Count > 0) { if(dsMovie.Tables[0].Rows[0][0].ToString() != "") //put a breakpoint on this line and check the value you getting { bresult = wsMovie.updateKlant(Convert.ToInt64(dsMovie.Tables[0].Rows[0][0])); } }

Geelen Stef · Answer

this is my error, Input string was not in a correct format. And your code doesn't work either .

Suthish Nair · Answer

what error you getting? try like this... if(dsMovie.Tables[0].Count > 0) { Convert.ToInt64(dsMovie.Tables[0].Rows[0][0]); }