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(EmpIDEmployeeNameAddress)values(@ID@Name@Address) END from your code string constring = ConfigurationManager.ConnectionStrings[vendorConn].ConnectionString; SqlConnection sqlCon = new SqlConnection(constring); SqlCommand cmd = new SqlCommand(insertDatasqlCon); 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

yesand 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?