Editing and updating data in gridview using sqldatasource control - Part 17

[@GreggDunn]

Really needed this. So many of these videos are out there with incorrect steps. Yours is perfect. Thank you!

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you kzbin.infoplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat

[@hasans7370]

I really appreciate your tutorials! I've been saved lots of times because of them! Tons of love

[@Pablissimo85]

Thank you! Your tutorial helped me a lot.

[@angelfrance007]

thankyu so much!!! you really helped me!! Praise God

[@Csharp-video-tutorialsBlogspot]

Hi Sure, I will do it.

[@nadiayusof93]

thanks for the tutorial! really helpful

[@srinu143nivas]

Hey bro really cool and clear...thnks..:)

[@mohanrajendiran6902]

if i run this above program i am getting error...how to solve this Incorrect syntax near 'nvarchar'. Must declare the scalar variable "@ID".

[@termsaknud403]

thank you so much. give you a big hug. ^^

[@vindhawan]

My generate update,delete and insert in advanced option is not active.

[@sagarmaniar4713]

Surinder Dhawan If your Advanced SQL Generation Options are grayed out - your table probably has no Primary Key defined..

[@greatsea]

my 'advanced' page grayed out

[@kashifansari96]

can i edit the position of these edit and cancel link buttons ? also can i use other buttons instead of link buttons??

[@swaminathanp7161]

Nice and clear..

[@pushpakgosavi9697]

thank you so much sir for this "great" Video

[@nyashachamunokara9787]

SqlDataSource "Specify columns from a table or view" option is grayed out in the "Configure the Select Statement" page. What do I do, help please, I'm new to VS.

[@chucksihebuzor8941]

Thanks for all your tutorials. They have helped me in my recent developer role. I have a question ( there does not seem to be any answers anywhere on the web ) How do you create a search box where after getting a result from searching and click the edit button on the Gridview next to the result? it doesn't do a postback and refresh the whole Gridview again - making the edit to jump to the wrong search record. I hope that makes sense.

[@abhaymohite159]

I encountered exact issue today. I searched many sites but didn't find the solution and then came across ur comment. Do u have workaround for this. Thank you in advance.

[@pinky9734]

Thank you So much ...its working fine

[@dotnetfullstackrktutorials]

sir could you please tell me how to update data in my registration form when i click edit button in my gridview control...please its urgent

[@9729rahul]

sir when i clicked in edit button gridview column is resized.. can u tell me how to fix the size of column in gridview..

[@shreyanshrathi6051]

How can I reorder my columns in grid view if I select a grid view from data and in that grid view i add a column of update but I want that column to present at the last of my table not first how should I do that?

[@AMITCHAUDHARI1389]

The edit link button is the first column in the gridview control. What if I want that to be the last coloum. How to achieve that?

[@hasans7370]

You can simply do so, by clicking on the small arrow of the grid view, and then click on edit columns. Pick the link/button or whatever in the selected fields, and u can freely manipulate its position using the upward/downward arrows.

[@Ayubajbnabi]

Thanks for this video. I will appreciate if you could also do the GridView Editing using ObjectDataSource like you did in your previous videos about select and delete. Thanks allot.

[@CloudDba35]

dear sir when I Am editing data and clik on update button I am Getting this error

[@michaeldemaeyer8567]

when i used the update in my browser it updated all the items to the one that was updated.. What's wrong ?

[@BhushanPrasad]

Thank You

[@mohanrajendiran6902]

Incorrect syntax near 'nvarchar'. Must declare the scalar variable "@ID". I am getting this type of error.how to solve this

[@zahidtariq8198]

same error

[@yancur]

If your Advanced SQL Generation Options are grayed out - your table probably has no Primary Key defined..

[@rashasalim1259]

you probably forgot to add "WHERE " in the update command, it happened to me once