check wehther name exists in database

Question

Hi Everyone I need to check whether the name entered while entering data that to be stored is exists in database or not and if it exists it doesnot allow to store or else it should store. How can i do it?

Vivek Joy · Answer

i get the code if (!TxtName()) { } else { } public bool TxtName() { Program.StrSql = select from Where = '+ .Text+'; SqlCommand cmd = new SqlCommand(); cmd.Connection = Program.QbSysDbCon; cmd.CommandText = Program.StrSql; SqlDataReader dr=null; dr = cmd.ExecuteReader(); while(dr.Read()) { if( .Text==dr[ ].ToString()) { MessageBox.Show(Exists); return false; } dr.Close(); } return true; }

Vivek Joy · Answer

Anyway thanks

Ravi Kumar · Answer

try the fallowing ALTER PROCEDURE [dbo].[USP_SaveCategoryMaster] ( @CategoryName VARCHAR(50) ) AS BEGIN IF EXISTS(SELECT Category_Name FROM CategoryMaster WHERE Category_Name=@CategoryName) BEGIN SELECT 0 END ELSE BEGIN INSERT INTO CategoryMaster ( Category_Name ) VALUES ( @CategoryName ) END SELECT @@IDENTITY END