urgent help needed - input string not in correct format

[ZZZ]

this code :
try

{

DataSet dsDeurprijs = new DataSet();

SqlDataAdapter sqlDeurprijs = new SqlDataAdapter( "Select
isnull(convert( varchar,promopr ijsKK),'')as promoprijsKK from DEURPRIJZEN
where DEUR_KODE=" + sKode_deur,sqlC onnection3);

sqlDeurprijs.Fi ll(dsDeurprijs) ;

int prijs =
Convert.ToInt32 (dsDeurprijs.Ta bles[0].Rows[0].ItemArray[0].ToString());

MessageBox.Show (prijs.ToString ());

}

catch(Exception ex)

{ MessageBox.Show (ex.Message.ToS tring());}

gives me : input string not in correct format

info :

promoprijsKK field = money

sKode_deur=stri ng

[MA]

"ZZZ" <[e-mail]> wrote in message
news:uT******** *****@TK2MSFTNG P11.phx.gbl...

this code :
try

{

DataSet dsDeurprijs = new DataSet();

SqlDataAdapter sqlDeurprijs = new SqlDataAdapter( "Select
isnull(convert( varchar,promopr ijsKK),'')as promoprijsKK from DEURPRIJZEN
where DEUR_KODE=" + sKode_deur,sqlC onnection3);

sqlDeurprijs.Fi ll(dsDeurprijs) ;

int prijs =
Convert.ToInt32 (dsDeurprijs.Ta bles[0].Rows[0].ItemArray[0].ToString());

MessageBox.Show (prijs.ToString ());

}

catch(Exception ex)

{ MessageBox.Show (ex.Message.ToS tring());}

gives me : input string not in correct format

info :

promoprijsKK field = money

sKode_deur=stri ng

How doés the string looks like and how do you want it to look like?

/Marre

[ZZZ]

select statement showed in messagebox is OK (tested in sql query analyzer)
dont know why this error is generated

"MA" <ne**@supremeli nk.se> wrote in message
news:2p******** ****@uni-berlin.de...

"ZZZ" <[e-mail]> wrote in message
news:uT******** *****@TK2MSFTNG P11.phx.gbl...

this code :
try

{

DataSet dsDeurprijs = new DataSet();

SqlDataAdapter sqlDeurprijs = new SqlDataAdapter( "Select
isnull(convert( varchar,promopr ijsKK),'')as promoprijsKK from DEURPRIJZEN
where DEUR_KODE=" + sKode_deur,sqlC onnection3);

sqlDeurprijs.Fi ll(dsDeurprijs) ;

int prijs =
Convert.ToInt32 (dsDeurprijs.Ta bles[0].Rows[0].ItemArray[0].ToString());

MessageBox.Show (prijs.ToString ());

}

catch(Exception ex)

{ MessageBox.Show (ex.Message.ToS tring());}

gives me : input string not in correct format

info :

promoprijsKK field = money

sKode_deur=stri ng

How doés the string looks like and how do you want it to look like?

/Marre

[Zürcher See]

I don't understand why you, in your slect, convert the promoprijsKK field to
varchar, and then in Int32 in your code?

try
{
DataSet dsDeurprijs = new DataSet();
SqlDataAdapter sqlDeurprijs = new SqlDataAdapter( "Select promoprijsKK
from DEURPRIJZEN where DEUR_KODE=" + sKode_deur,sqlC onnection3);

sqlDeurprijs.Fi ll(dsDeurprijs) ;

if (dsDeurprijs.Ta bles[0].Rows[0][0]!=System.DbNull .Value)
{
int prijs =(int)dsDeurpri js.Tables[0].Rows[0][0];
MessageBox("pri js="+prijs);
}
else MessageBox("DbN ullValue");
}
catch(System.Ex ception e)
{
MessageBox(e.Me ssage);
}

"ZZZ" <[e-mail]> schrieb im Newsbeitrag
news:uT******** *****@TK2MSFTNG P11.phx.gbl...

this code :
try

{

SqlDataAdapter sqlDeurprijs = new SqlDataAdapter( "Select
isnull(convert( varchar,promopr ijsKK),'')as promoprijsKK from DEURPRIJZEN
where DEUR_KODE=" + sKode_deur,sqlC onnection3);

sqlDeurprijs.Fi ll(dsDeurprijs) ;

int prijs =
Convert.ToInt32 (dsDeurprijs.Ta bles[0].Rows[0].ItemArray[0].ToString());

MessageBox.Show (prijs.ToString ());

}

catch(Exception ex)

{ MessageBox.Show (ex.Message.ToS tring());}

gives me : input string not in correct format

info :

promoprijsKK field = money

sKode_deur=stri ng

[ZZZ]

thx

this did it

string prijs = dsDeurprijs.Tab les[0].Rows[0].ItemArray[0].ToString();

thx a lot!!!!!!!


"Zürcher See" <aq****@cannabi smail.com> wrote in message
news:Oa******** ******@TK2MSFTN GP10.phx.gbl...

I don't understand why you, in your slect, convert the promoprijsKK field to varchar, and then in Int32 in your code?

try
{
DataSet dsDeurprijs = new DataSet();
SqlDataAdapter sqlDeurprijs = new SqlDataAdapter( "Select promoprijsKK
from DEURPRIJZEN where DEUR_KODE=" + sKode_deur,sqlC onnection3);

sqlDeurprijs.Fi ll(dsDeurprijs) ;

if (dsDeurprijs.Ta bles[0].Rows[0][0]!=System.DbNull .Value)
{
int prijs =(int)dsDeurpri js.Tables[0].Rows[0][0];
MessageBox("pri js="+prijs);
}
else MessageBox("DbN ullValue");
}
catch(System.Ex ception e)
{
MessageBox(e.Me ssage);
}

"ZZZ" <[e-mail]> schrieb im Newsbeitrag
news:uT******** *****@TK2MSFTNG P11.phx.gbl...

this code :
try

{

SqlDataAdapter sqlDeurprijs = new SqlDataAdapter( "Select
isnull(convert( varchar,promopr ijsKK),'')as promoprijsKK from DEURPRIJZEN
where DEUR_KODE=" + sKode_deur,sqlC onnection3);

sqlDeurprijs.Fi ll(dsDeurprijs) ;

int prijs =
Convert.ToInt32 (dsDeurprijs.Ta bles[0].Rows[0].ItemArray[0].ToString());

MessageBox.Show (prijs.ToString ());

}

catch(Exception ex)

{ MessageBox.Show (ex.Message.ToS tring());}

gives me : input string not in correct format

info :

promoprijsKK field = money

sKode_deur=stri ng