Hi,

I have an event and on that, I put Reader column values to the TextField but I do have the problem - 'Specified cast if not valid' when running it!

Here are part of my codes:

...

try

OleDbCommand comm = new OleDbCommand("SELECT * FROM bk_info where id in(select max(id) from bk_info)", conn);

OleDbDataReader reader = comm.ExecuteReader();

this.txtroom_no.Text = reader.GetString(1);

this.txtuser_nm.Text = reader.GetString(2);

this.txtchoose_dt.Text = reader.GetString(3);

...

Hi,

I think, there is some data mismatch when you retrieve data by using reader.GetString();

reader.GetString() can only be used if original data type in database is string related.

For other data types, you canuse GetBoolean(), GetChars(), etcor simply use GetValue().ToString()

Hope this may help.

try following codes

this.txtroom_no.Text = Convert.ToString(reader[1]) ;

this.txtuser_nm.Text = Convert.ToString(reader[2]) ;

this.txtchoose_dt.Text = Convert.ToString(reader[3]) ;

remember that return fields start from zero reader[0], reader[1], ...

Hi,

I think, there is some data mismatch when you retrieve data by using reader.GetString();

reader.GetString() can only be used if original data type in database is string related.

For other data types, you canuse GetBoolean(), GetChars(), etcor simply use GetValue().ToString()

Hope this may help.

try following codes

this.txtroom_no.Text = Convert.ToString(reader[1]) ;

this.txtuser_nm.Text = Convert.ToString(reader[2]) ;

this.txtchoose_dt.Text = Convert.ToString(reader[3]) ;

remember that return fields start from zero reader[0], reader[1], ...