Last Statement
, BiosStatus='" + BiosStatus + "Where UserName=" + UserName;
should be like
, BiosStatus='" + BiosStatus + "' Where UserName='" + UserName+"'";
Added space and single quote before where keyword.
Please test yor query properly as it contain lot of variables involved.
Its always nice to use Parameters instead.