Deleting data from gridview using sqldatasource control

[@Csharp-video-tutorialsBlogspot]

Hi, thank you very much for taking time to give feedback. Actually neither of these are being used in real world. More often people implement custom data access layer, using the standard ado.net classes like SqlConnection, SqlCommand etc. The data access layer will then be consumed by business or other layers depending on the architecture of the application. I have seen a few real time projects using objectdatasource, control, but definitely not sqldatasource control.

[@chibumbamohammed5006]

I will never forget you Sir

[@RahulAgarwal-ne5wg]

sir i am using this ((LinkButton)control).OnClientClick = "return confirm('Are you sure you want to delete? This cannot be undone.');"; but its not working , please give me solution ASAP, its urgent.

[@MrHooglaz]

A very insightful series. I appreciate your explanation of the ADO.Net code as well. What is more common in the working world: sqldatasource or objectdatasource?

[@ugotzenithful]

Great Explanation I just want to know, can the confirm box be implemented using onRowDeleting event ??

[@pracashmaster]

very nice explanation

[@prashantjain9876]

Hi sir need one help if you use GUID as primary key then what will be the parameter Type in Type field

[@hlams2]

what if i have 2 options in that row edit and delete than how to get than this works on delete

[@KochharAmandeep]

Try This Code! foreach (DataControlFieldCell cell in e.Row.Cells) { // check all cells in one row foreach (Control control in cell.Controls) { // Must use LinkButton here instead of ImageButton // if you are having Links (not images) as the command button. LinkButton button = control as LinkButton; if (button != null && button.CommandName == "Delete") // Add delete confirmation button.OnClientClick = "if (!confirm('Are you sure " + "you want to delete this record?')) return;"; } }

[@erdinc2727]

i tried what u showed in the video. but when i click the Advanced button botch checkboxes are seen Disabled what can be the reason ?

[@erdinc2727]

it was because i didnt have primary key in my table. i replied maybe someone else also has the same problem.

[@awaisrajpoot3160]

thank u so much :)

[@siddiquejaved5036]

Thanks you so much. It's take lots of time

[@1999mer]

How do you display image path locations from a sql database?

[@narayanakatika4231]

Hi, Javascript Validation is not working if I use Button control as Trivedi said. Could you plz tell us what is the reason for it?

[@hitarthtrivedi6267]

The javascript thing confirmation box is not working if I am using Button instead of LinkButton. ((Button)control).OnClientClick = "return confirm('Are You sure you want to delete? This change cannot be reverted')"; I am not sure what the reason is??

[@satyasandeep3699]

I appreciate your explanation and efforts u r putting.....i had a concern in this video .....i am not able to configure insert,update,delete through ADVANCED....they are disabled by default..i am not able to make a selection....i will appreciate if u would help me out.....plzzzzzzzzzzzzzzz

[@awaisrajpoot3160]

same problem.. did u get now ??

[@veluviorel]

@@awaisrajpoot3160 u need to put primary key in table.

[@michaelburns2273]

Did anyone get an answer to this question? I tried the same thing and the post back does not happen if user clicks yes. Thanks in advance! The javascript thing confirmation box is not working if I am using Button instead of LinkButton. ((Button)control).OnClientClick = "return confirm('Are You sure you want to delete? This change cannot be reverted')"; I am not sure what the reason is??

[@swastiknaik97]

+Michael Burns i think you are missing the javascript function

[@dzdeathray]

when i change the button type to = button the fields do not delete. Any Sugestions??

[@sulemanali4006]

i have an error please help: Must declare the scalar variable "@EmployeeID".

[@vichitraanand673]

on button type javascript not working

[@ww1flyingace263]

Same with me. I tried many things but could not make it work. The linkbutton worked fine though.

[@karangoyalkkp]

hello, i am getting compilation error- Server Error in '/' Application. Compiler Error Message: CS0583: Internal Compiler Error (0xc0000006 at address 658F166C): likely culprit is 'IMPORT'. plz guide me on this error how to resolve it.

[@bishnumishra3357]

sir ,plz help us to develop a real time project.

[@mustafaabbas2520]

supposed that javascript must be used in html file not in code file ?

[@MrHooglaz]

thank you

[@RahulAgarwal-ne5wg]

java script code not working.

[@rahultnna9198]

Java Script Code Is Not Properly Worked....

[@ashokreddyz]

java Script code is not working