I have a C # method in my datatier that I am trying to convert to VB.Net. I converted it to VB.Net, but when I raise the data class, the method is not displayed. It has been a long time since I used VB.Net and forgot a lot of things.
Here is my C # method:
public static useraccount UserActInfo(string empnumber) { SQLConnectivity db = new SQLConnectivity(); SqlParameter[] param = new SqlParameter[1]; DataTable dt = new DataTable(); useraccount user = new useraccount(); param[0] = db.MakeInputParameter("@UserEmpNumber", empnumber); db.RunExecuteProcedure("dc_SELECT_UserActInfo_By_EmpNumber", param, ref dt); if (dt != null && dt.Rows.Count > 0) { user.ID = Convert.ToInt32(dt.Rows[0]["UserID"].ToString()); user.FirstName = dt.Rows[0]["FName"].ToString(); user.LastName = dt.Rows[0]["LName"].ToString(); user.MiddleName = dt.Rows[0]["MName"].ToString(); user.Title = dt.Rows[0]["Title"].ToString(); user.PhoneNo1 = dt.Rows[0]["PhoneNumber1"].ToString(); user.PhoneNo2 = dt.Rows[0]["PhoneNumber2"].ToString(); user.Fax = dt.Rows[0]["FaxNumber"].ToString(); user.Email = dt.Rows[0]["Email"].ToString(); user.StreetAddress = dt.Rows[0]["StreetAddress"].ToString(); user.Locality = dt.Rows[0]["Locality"].ToString(); user.Province = Convert.ToInt32(dt.Rows[0]["Province"].ToString()); user.PostalCode = dt.Rows[0]["PostalCode"].ToString(); user.EmpNumberID = Convert.ToInt32(dt.Rows[0]["EmployeeNumberID"].ToString()); user.EmpNumber = dt.Rows[0]["EmployeeNumber"].ToString(); } if (user.ID != 0) { return user; } else { return null; } }
I believe this is due to the ad, which I have as:
Public Static Function UserActInfo(ByVal _eno As String) As useraccount
Why I do not see the method
source share