How to check record is already exists means update or insert

Question

How to check record is already exists means update or insert in sqlite android?

Mani Kandan · Answer

Hello Anu Try this... SQLiteCommand check_User_Name = new SQLiteCommand( SELECT COUNT(*) FROM Tble_User WHERE (UserName = @user)  conn); check_User_Name.Parameters.AddWithValue( @user  username); int UserExist = ( int )check_User_Name.ExecuteScalar(); if (UserExist > 0) { //Username exist } else { //Username doesn't exist. }

Anu V · Answer

Thanks for your responses.. I need it for android studio java programming

Bikesh Srivastava · Answer

Hi http://www.c-sharpcorner.com/article/remote-validation-in-mvc-5-to-check-if-username-and-email-id-exists/