asp.net2.0中尝试读取无效值的错误

要判断一条纪录是否存在然后执行插入/更新的方法

            sqlDataSource.SelectCommand = "select WageID,IsAgree from TBWages where EmployeeName='" + myDBReader[0].ToString() + "' and WageDate='" + Datestr + "'";
            SqlConnection myCon = new SqlConnection(sqlDataSource.ConnectionString);
            SqlCommand myComt = new SqlCommand(sqlDataSource.SelectCommand, myCon);
            myCon.Open();
            SqlDataReader myRd = myComt.ExecuteReader();
            myRd.Read();
            try
            {
                strID = myRd["WageID"].ToString();
                strAgree = myRd["IsAgree"].ToString();
            }
            //
            catch
            {
                strID = "";
                strAgree = "0";
            }
            //else 

 

如果你用if (myRd["WageID"] == null)来判断查询结果会报错:尝试读取无效值

那就可以巧妙的运用try{}catch{}了啊