public int Delete() { string strDeleteQuery = string.Empty; strDeleteQuery = "DELETE FROM [dbo].[EmployeeDetails] WHERE UserName = '******'"; objSQL = new SQL(); return objSQL.ExecutiveNonQuery(strDeleteQuery); }
public int Insert() { string strInsertyQuery = "INSERT INTO [dbo].[EmployeeDetails] ("; string strColumns = string.Empty; string strValues = string.Empty; strColumns = "UserName,"; strValues = "'" + strUserName + "',"; strColumns = strColumns + "FirstName,"; strValues = strValues + "'" + strfirstname + "',"; strColumns = strColumns + "LastName,"; strValues = strValues + "'" + strlastname + "',"; strColumns = strColumns + "Pass_word,"; strValues = strValues + "'" + strPass_word + "',"; strColumns = strColumns + "Gender,"; strValues = strValues + "'" + strGender + "',"; strColumns = strColumns + "DateOfBirth,"; strValues = strValues + "'" + strDateOfBirth + "',"; strColumns = strColumns + "Email,"; strValues = strValues + "'" + strEmail + "',"; strColumns = strColumns + "Mobile"; strValues = strValues + "'" + strMobile + "'"; strInsertyQuery = strInsertyQuery + strColumns + ") VALUES (" + strValues + ")"; objSQL = new SQL(); return objSQL.ExecutiveNonQuery(strInsertyQuery); }