SQL Query to Restrict Entry of Same Data in a Table
Sir, I need your help in the following:-
I want SQL Query to restrict same data entry. Please take a look to the following Row:-
id Name Address Age Place Department Salary
1 Sam 3rd street, madgaon, Chennai 24 Chennai Sales 20000
2 Sam 3rd street, madgaon, Chennai 24 Chennai Sales 20000
This type of Entry does not allowed.
I need a different query than the Query I written below:-
if not exists(select Name, Address, Age, Place, Department, Salary from tbl_Employee where Name=@Name and Address=@Address and Age=@Age and Place=@Place and Department=@Department and Salary=@Salary)
begin
insert into tbl_Employee(Name, Address, Age, Place, Department, Salary)
values(@Name, @Address, @Age, @Place, @Department, @Salary)
end
Answers (1)
0
Conn = new SqlConnection(ConnString);
if (Conn.State == ConnectionState.Closed)
{
Conn.Open();
}
string query = "select * from student_master where name='" + txtname.Text + "'";
Cmd = new SqlCommand(query, Conn);
SqlDataReader dr = Cmd.ExecuteReader();
if (dr.Read() == true)
{
messegebox("Record allready exist");
return 1;
}
else
{
insert data();
}
Accepted