Clicked row id in syncfusion asp.net

[Hüseyin Cenk Özmutlu]

Hi, I have a question about syncfusion grid. I hava sycfusion grid. I want to delete a row from this grid and SQL Database. How can I focus that I clicked row's ID? Thanks for your replies.

[Mani Sankar Durai]

Hi Hüseyin, 

Thanks for contacting Syncfusion support. 

Based on your query we have already documented a Syncfusion knowledge base of about how to perform CRUD operations in grid with SqlDataSource. 

Link: https://www.syncfusion.com/kb/7423/how-to-perform-crud-operations-with-asp-sqldatasource 

Refer the code example. 

<asp:SqlDataSource ID="SqlData" runat="server" ConnectionString="<%$ ConnectionStrings:NORTHWNDConnectionString %>" 

            SelectCommand="SELECT * FROM [Orders]"  

        ... 

        DeleteCommand= 

        "DELETE FROM [Orders] WHERE [OrderID] = @OrderID" 

       ... 

</asp:SqlDataSource> 

 

From the above code example we can delete the record in grid based on primary key column (OrderID). 

Please let us know if you need further assistance. 

Regards, 

Manisankar Durai.