Gridview coading problem

Question

Dear sir,

I am inserting data through gridview. and again click on submit button with same data it display inserted successfully.

I want to display error message record already existed. Please help me and send code.

Dorababu Meka · Answer

Try this and change as per your requirement create a stroed procedure as follows createPROCEDURE insertData ( @ID int, @Name varchar(50), @Address varchar(50) ) as begin iF NOT EXISTS ( select * from Employee where EmployeeName = @Name AND Address = @Address) // here compare with your desired column insert into Employee(EmpID,EmployeeName,Address)values(@ID,@Name,@Address) END from your code string constring = ConfigurationManager.ConnectionStrings["vendorConn"].ConnectionString; SqlConnection sqlCon = new SqlConnection(constring); SqlCommand cmd = new SqlCommand("insertData",sqlCon); cmd.Parameters.AddWithValue("@ID", 2000); cmd.Parameters.AddWithValue("@Name", "Dorababu"); cmd.Parameters.AddWithValue("@Address", "Hyderabad"); cmd.CommandType = CommandType.StoredProcedure; sqlCon.Open(); if (cmd.ExecuteNonQuery() > 0) { } else { }

murali athmuri · Answer

yes,and second thing is when i assign particular subject for particular lecturer timings will be different.Don't assign same timings for two lecturer. I am sending by designing page.

Dorababu Meka · Answer

So If one field is different field you would like to insert the whole data if not you don't want to insert

murali athmuri · Answer

based on class and checking all fields.If any one field is different that record only inserted remaing fields are not inserted

Dorababu Meka · Answer

On what basis you would like to check, all fields or any particular one like User name or ID?