The specified conversion is invalid !! Online etc ...

sunnyppp

depressed!

shenmue024

Wouldn't it be all written?

sunnyppp

Not good

Errors are the same

Where is the problem

Dude help me take a closer look!

shenmue024

Is this line wrong?

This error is an error when converting DBNull to a type. I just don't know where it is, so look carefully. I don't have a real environment.

sunnyppp

Pass the breakpoint test
strSql = "SELECT * FROM V_Bbs_PostDetails WHERE Post_Id =" + postid;
sdr = GetDataReader (strSql);
Smooth execution
I passed the ms sql query analyzer to execute strSql = "SELECT * FROM V_Bbs_PostDetails WHERE Post_Id =" + postid; sql statement, no problem!
sdr = GetDataReader (strSql); also executed!

shenmue024

You see which field values ​​are null in the results of the query analyzer, and then check these fields.

zhouyin1981

It must be caused by DBNULL. Find whether the related field converted to int is null

sunnyppp

No fields are empty!

shenmue024

Not empty?

That can only check the parameter type of new Bbs_PostDetailsInfo.

sunnyppp

I put
strSql = "SELECT * FROM V_Bbs_PostDetails WHERE Post_Id =" + postid;
Change to
strSql = "SELECT * FROM V_Bbs_PostDetails WHERE Post_Id = 391"
Both I determine in the sql query that there is a row of data
still the same