String qryChkExist = "SELECT isnull(column_name,'') as Article_alias from Table_Name where column_name='" + txtalias.text.tostring().trim()+ "'";
 String ChkRecord = (String)SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, qryChkExist);
        if (ChkRecord != null)
        {
            if (ChkRecord != "")
            {
                lblMsg.Text = "Another Alias with this Name already exists. Please choose another Alias.";
                return;
            }
        }
Give me the complete Example of source code
ReplyDeleteGive me Example In a table Email,Username Are unique
Enter Username(oR)Email Already exist in DB Tell me Already Exits
Plz send me complete source code
My mail Id:mandla.anilbabu@gmail.com