GridView insert update delete in asp.net - Part 23

[@mcfawknuts]

Thank you soooo much for this!

[@Csharp-video-tutorialsBlogspot]

+mcfawknuts Thanks a lot for stopping by to provide your feedback. This means a lot to me. I am really glad you found the video tuorials useful. All the Pragim Tech video tutorials are organised in to playlists, which help you find the videos you are looking for easily kzbin.infoplaylists?view=1&sort=dd You can also order DVDs or download all the videos and slides for offline viewing using the link below www.pragimtech.com/kudvenkat_dvd.aspx Image version of the slides and text Version of the videos are on my blog csharp-video-tutorials.blogspot.com Tips to effectively use our free channel. kzbin.info/www/bejne/r2ibYYCtnb5qZtU To receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info If you like these videos, please click the THUMBS UP button below the video. We like to see these free video tutorials helping others as well. Please share the link with your friends and family who you think would also benefit from them. Thanks Venkat

[@somanapallilokkeshwararav7043]

Worsted

[@stephanieezat-panah7750]

I had some problems with the Insert function not working. I believe that it had to do with not using a "protected" access modifier. it works now. And, thank you, Professor Venkat. You are the best, simply the best. I have watched all your videos: C#, asp.net, ado.net and SQL Server. My career has been enhanced & enabled. I cannot thank you, enough.

[@nikhillala1451]

This was literally the easiest and the most efficient method anyone could have ever implemented. Thank you for sharing this with us. Helped Alot!

[@WolfgangLettko]

Your videos are very helpful ! Most i know from ASP.NET i have learned in your videos. Great work ! Thank you.

[@mryoso22]

this is so useful man! you've just upgraded humanity in a whole new different level.. hope i could see you in person.. (im serious, im your number 1 fan)

[@arunaravind571]

Thank you so much sir.....Best asp.net video I had ever seen...Hats of your effort..thank you so much.

[@kalin1993]

You are a hero. My course project was finished because of your guide.Thank you very much.

[@Csharp-video-tutorialsBlogspot]

Hearty congratulations on successful completion of your course project. Very glad the videos helped. Thank you very much for taking the time to give feedback. All the very best with everything you do.

[@lopintipriya3510]

hello venkat, Thank you very much.i understood and i could implement according my requirement .without ignoring it as a silly question, you answered so well, i truly admire your help.Thank you once again

[@Csharp-video-tutorialsBlogspot]

Hi Vivek, are you talking about doing everything in code using RowCommand, without using datasource controls. If that's the case we will be discussing about it very soon. Please stay tuned.

[@JoeG2324]

amazing video. best asp .net tutorial series on youtube.

[@Tlgte]

Even though this video came out in 2013, it still came in very useful for finishing my assignment. Thank you.

[@johnsongeorge5906]

Best tutorial on KZbin Ever Million time Thanks Sir GOD BLESS you.....!

[@charlesrabelloable]

This videos was great, very helpful to my projects. Sharing knowlodge turn the world better. So, I will do the same sharing what I learned with brazilian folks in portuguese. Thanks, and keep sharing.

[@pqmg]

Absolutely great stuff! Thank you Kudvenkat for sharing this! :)

[@TheSplifydadz]

Keep up the good work kudvenkat, we really appreciate it. Thanks.

[@Csharp-video-tutorialsBlogspot]

Hi Priya, Here the ID column is an identity column. When we insert a row, we don't have to provide a value for this column. It will be auto-incremented and inserted by sql server automatically. In reality, it is unusual to provide a value for ID field. But if your, project requirement is to provide the value for ID, then we can very easily achieve by including a TextBox next to the insert link button in footer template of ID column. Hope this answers your question.

[@Ayubajbnabi]

Excellent. Thank you very much Kudvenkat.

[@MoathResume]

Thank you for your reply Kudvenkat, I actually just redid it and worked, thanks a lot :)

[@Csharp-video-tutorialsBlogspot]

"SelectedIndexChanged" is the default event of GridView control. It is very easy to identify default events of controls in asp.net. Drag and drop a control on the webform, double click on the control, and an event handler method will be generated in the code-behind file automatically for the default event. Hope, you will find this useful. If you like these videos, please click on the THUMBS UP button below the video. Good Luck.

[@entemolu1]

No doubt, You are a Master of Master

[@amroosman9934]

Thank you Man you are simply Stunning.

[@shreya5235]

Thank you. Your tutorials are very helpful.

[@IrishReGGie]

LEGEND FOR DOING THIS

[@hakeraz]

Congratulations, this is a good tutorial

[@sharvaryrane1702]

best video for beginners... thank you so much... really useful👍

[@madihasabihkhan5841]

Very clearly elaborate each steps.

[@MissNumnum]

its really help me a lots! Much love and thank u!!!!!!!!!!

[@husamhabbal1419]

a very big Thank you, you deserve more

[@stefanskoda6841]

amazing as usual :) Thanks Kudvenkat

[@mittalpatel4990]

Can you please help to just submit record into database using ASP.net. You are really life saver. I am working almost 5 day to do connection string but your video are simply best. many many thanks

[@Csharp-video-tutorialsBlogspot]

Hi, Aniruddha, this is easy to fix. The issue is that, validation controls are performing validations on the client, and are not allowing the page to be posted back to the server, so the code in Image Button click can be executed. To fix this, set CausesValidation property of the Image Button to true. Hope this answers your question. If you like these videos, please click on the THUMBS UP button below the video. Please share these videos with your friends on Google pluas and facebook. Good Luck.

[@SanjeevSriramoju]

best video....usefull for beginersss

[@davester32]

Thank you for all your videos !

[@saialuri9370]

Thanks a lot for your video,I got some knowledge on Insert,Update and Delete in Gridview.

[@Jimpeeterske]

You helped me a lot ! awesome video !

[@karenwilson1558]

Thanks! Glad it's still on line!

[@黄桂兰-o7k]

Thank you very much for this good teaching. I have learned a lot from this video.

[@archanashet5]

Very nice and helpful video. Thank You so much :)

[@mandardesai3841]

I saw many video the way you explain is very good I saw many other .net video such as lynda.com pluralsight or other but your video is simply great.I have one request for you plz record video on windows database deployment application.in short how can create software with product key and adding .net framework with that windows application which is easily installed another computer.

[@Csharp-video-tutorialsBlogspot]

Hi Moath, RequiredFieldValidator should support ControlToVaildate attribute, irrespective of VS2010 or VS2012. I am not sure what's wrong at the moment. Can you please include the complete declaration of RequiredFieldValidator. Since angular brackets, cannot be pasted in the comment, use square brackets [ ] instead of angular brackets.

[@Csharp-video-tutorialsBlogspot]

Hi Priya, you are very welcome. May I ask you for a favour. I am receiving lot of questions everyday from our youtube users, and finding it extremely difficult to answer all the questions in time. I hope, you can help me answer a few questions for which you know the answer. This will help boost your confidence, and also help build your network on youtube.

[@vidhyambalan7750]

Can we use the same with otacle database

[@lopintipriya3510]

hi venkat , i'm very thankful for the support you are providing for your fellow developers, Iam extremely thanful to you , and here is my silly question , after seeing the video, ok , here you are giving a demo on insertion, i see that insert button is sitting in the id field , so do we insert the value for that , and if it is a primary key field , it gives an error, is it'nt ,may be its a very stupid question, i dont know,but please tellme how can i give thevalue for the first field

[@Unearthed13]

EXCELLENT video ... thank you so much :D

[@sawlehapathan249]

Thank you for this tutorial...really helpful

[@Qazafi4u]

Hi There Thanks for this wonderful project. Would that be possibility the insert row will appear at the top of the grid instead at the bottom of the grid. Can you please reply it is really urgent. Thanks Qazafi

[@gandolfiniL]

Thanks, very good, all work perfect!!!

[@markharris2944]

I love the videos. I am new to all this stuff and it is great to see videos that step you through step by step. How would I show the footer of a gridview when there is no data in the gridview? I have a dropdown list box that will show the records of the selected item but when there are no records associated with the listed item, I cannot insert a record because there is no footer.

[@eieichitsu9722]

Thanks you so much, I like the way u teach, this video is very helpful for my assignments. Thanks....^_^

[@duynm]

Thank you, i love your videos

[@vidhikansara7103]

So helpful video tutorial thank you so much it really helped

[@abdelhadiessaifi7339]

Thank you very much bro, you re my best mentor

[@Csharp-video-tutorialsBlogspot]

I think this is already covered in gridview tutorial. Please check and let me know if you have found it.

[@ArsalHussain]

I Want A Really Fast Video Implementation For CRUD In ASP GridView For Quick Revision And This Helps Me. Very Nice Work. And Also Thank You!

[@mohamedjaffir9097]

thank a lot..very very useful and works fine..briefly describe

[@priya354783]

Very usefull !! Thanks :)

[@Z3rY]

hey kud, thank you 4 ur vids, they are very helpful, i gotta question and, i was trying 2 edit the template for my gridveiw, i added a drop down list on 1 of the fields, but the drop down list uses an SQLDataSource cuz i need some values from another table, but instead of editing it deletes the record when i pess update

[@csandhya5289]

Hi sir, your videos are really helping me a lot for preparing interviews.Thanku so much.and one of the interviewer asked ,what is the default event for a gridview control?can you please share me the anser.

[@SteeveBalla2006]

great video

[@sajadadal4276]

شكرا لك اخي على هاذا الشرح

[@junadashraf7936]

are you using DataReader or DataAdapter to connect to your DataBase?

[@DarkCebolix]

Great video! tranks:)

[@scarlettflitzpatrick8501]

Thanks..nice videos!

[@SuperMillone]

Very interesting Thank you for such good work. Actually I have replaced the dropdown with a checkbox and I cannot make it working. I would appreciate some hint about how to change the code in the lblInsert to use a checkbox.

[@61Ritz]

thanx awsome tutorial

[@ww1flyingace263]

I was able to put the insert link in the first column (same column as edit/update). I think it looks nicer there. In case anyone was wondering if it could be done.

[@renjithgmathew]

How did you do that?

[@indikamakawitage]

Good Tutorial,Thank you so much

[@petersbase]

Hi Kudvenkat, thanks for the amazing video! It provides a perfect GridView template for use in my project. Is it possible for you to demonstrate the "OnClick-Insert record" event in "VB.NET"? I was left puzzling how to do this after many hours of "Google" searching. As a beginner, I know some VB.NET, and I do not want to learn C# as well. If I use the C# you provide in the video, it will be like a "black box" solution that I do not understand. Thanks again for your excellent video! Cheers, Pete

[@HonzaMatejicek]

I have to say really good and useful videos. But I would like to ask you about DropDownList used in EditItemTemplate. I'm using VS2012 .Net Framework 4.5 and the SelectedValue is missing... Do you have some video about handling DropDownList with code behind?

[@win66K]

Hi Venkat, I want to know how to insert records using first row of the gridview not with using footer.

[@jitendrasharma757]

good try for understand to other peoples.

[@robertomancino5517]

Thank you so much for the helpful video. Just a simple question. I would like to edit a row after a filtered GridView, is that possible?

[@mhasimioglu8410]

Thank you very much :)

[@waynesmith4336]

what a man move fast, me rahtid!

[@NicePaki]

Hi Venkat, Thanks for these amazing videos, which are very helpful for us. I would like to bind Drop Down List with a DataSource but when I click edit I get error similar to "indurnuguri1" mentioned in his post.

[@pixelbeans]

Thank you very much. Excellent.

[@sachinkaushik4657]

first of all thanks but i known thank is a little word for you job sir i have a question for you suppose i have no data in my table in that case the footer rows is not visible where i have a add button as you already told in your videos you can use emptdatatemplate i used that it it show col and there is no row in table but in footer template i use command="addcol" for insert a row i use rowcommand event if a have a row then i access the textbox which is in footer using cont.........

[@jac94]

Hi Kudvenkat, thanks for the video. I just want to know how to show the gridview footer when the dataSource is empty, I mean, inserting the first row, becuase the gridview i this case doesn't show any row.

[@dungcnpmb02]

thank you sooooo much !!!!!!

[@briansims3023]

Hi venkat, I am having trouble with the dropdownlist on the edit column. When I bind it with Bind("Gender") and run, I receive an error that says SelectedValue is invalid because it does not exist in the list of items. If I remove that and edit the row with the pull down it inserts a null value no matter what I choose. I am thinking it is an property for the Dropdown list but can not seem to find it. Can you offer any suggestions please?

[@piyasidey2117]

you are like God..

[@indurnuguri1]

Hi Venkat, Thanks for the amazing videos. I wanted to do the practical follow-up to this video but I'm getting the below error when I try to open the webform for edit. I tried the exact same thing as you mentioned, could you please let me know what is going on here? 'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value Thanks,

[@kunaldedhia5502]

If I use the way you have showed then is there a way to show the insert linkbutton in the same column as of the Edit/Delete column?

[@fula5]

Excellent (y)

[@NicePaki]

Hi Venkat, how can we add first data row, if there is no data in table?

[@haniabidi7305]

Sir could you please tell me how to achieve validation group in mvc as you did in this video. I did not find any appropriate article on web.

[@stutitehri993]

good tutorial

[@ashishpasi1524]

thanks very help full

[@hampushauffman7084]

You are a fkn legend dude!

[@sathyak6254]

I hav a requirement to do crud using webfirm as front end and excel as back end??..I have gone through some articles.can someone help me

[@iamsanjaygautam]

Thanx bro for help

[@Csharp-video-tutorialsBlogspot]

Hi Vivek, please convert EmployeeId to identity column. This should automatically compute and insert the new value for EmployeeId column when a new row is inserted.

[@fooyl6299]

HI venkat, for the first part of drop down list,its shows this error "'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value" ,bt the drop down list beside insert row works fine..what is the problem behind this

[@manaldawood7413]

hi Vinkat, thanks a lot these lessons are very helpfull, i am trying to do all the examples you are explaining with, i tried this lesson with some deference i added a parameter to this example (int32) and the value comes from a dropdown list SqlDataSource1.InsertParameters["screenId"].DefaultValue = ((DropDownList)FindControl("DropDownList1")).SelectedValue; but it didn't work. some help please

[@kremius12]

kudvenkat Is is possible to dinamically disable updating some columns? For example I want to disable to update some columns for specified user. Can I do that ?

[@MrSuryasj]

good one thanks

[@PradeepthaObeysekara]

If the footer items does not appear... check whether you have put ShowFooter="True" in the gridview control.

[@bryannrecolosado7809]

why add,edit delete statements are not enable in my advanced configuration in SQl datasource?

[@jubinsingh931]

just set your column name called "Id" or whatever you have given a name in your database as "primary key"

[@MANISH2634]

jubin singh did not work

[@minakshisingh1314]

Manish Gupta write query like this Create table Employee(Id int primary key identity(1,1),Name varchar(32))

[@stephanieezat-panah7750]

I always enjoy your videos, Professor, but not for anything could I get this to work. After many internet searches, the following did work; setting the properties AppendDataBoundItems="true" and AutoPostBack="True" in the DDL. thoughts?

[@commsoft2923]

I would like to use a second sqlconnection with datavalues to be used in the drop downlist How can i do that? btw. thanks for great videos!

[@maryemchaaba8082]

thank you very much