grid View with Sql server

Hi Kritika,
      From which table you are displaying data in gridview? i.e you are fetching data from master table or detail table.  If you are fetching data from master table i.e. from Category table and displaying it in grid with enable update and delete and trying to delete the data from Categry table then user usually face this type of error.

    The error itself is saying that if you are deleting data directly from master table then it will not allow you to do that. Because the data related to that C_ID key is present in detail table so you can not do that. 

The solution is that first delete the record from detail table an then try to delete from master table.

Hope this will clear your problem. If you need further help then reach to me  here.


=======================================================================
Kindly mark as answer if it solves your problem.
Thanks..... Nilesh