Convert a datarow to int

Geelen Stef

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...

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Accepted 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 Nair15y ago
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 Stef15y ago
Sorry, but i have still one problem. I need the current Id not the first...
Vulpes15y ago
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 Stef15y ago
Oh stupid ! Many thanks Nair ! You rock ! xD
Geelen Stef15y ago
Oh stupid ! Many thanks Nair ! You rock ! xD
Geelen Stef15y ago
what do you mean by DBNull.Value ??
Vulpes15y ago
Is it possible that tabel.Rows[0] could contain DBNull.Value?

If it did, then that would explain the error you're seeing.
Geelen Stef15y ago
I uploaded the whole project!, the problem is situated in klant_overzicht.xaml.cs
Suthish Nair15y ago
can you upload the sample project page as attachmnent.
Geelen Stef15y ago
He doesn't want to do the count. Operator > cannot be applied to operands of type 'method group' and 'int'
Suthish Nair15y ago
  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 Stef15y ago
this is my error, Input string was not in a correct format. And your code doesn't work either .
Suthish Nair15y ago
what error you getting? try like this... if(dsMovie.Tables[0].Count > 0) { Convert.ToInt64(dsMovie.Tables[0].Rows[0][0]); }