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?

Gridview coading problem

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)