check wehther name exists in database

Vivek Joy11y ago

Anyway thanks

0

Vivek Joy11y ago

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;

}

0

Ravi Kumar11y ago

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

0