GridView insert update delete in asp.net - Part 23

Поделиться
HTML-код
  • Опубликовано: 26 окт 2024

Комментарии • 270

  • @mcfawknuts
    @mcfawknuts 8 лет назад +5

    Thank you soooo much for this!

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  8 лет назад +5

      +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
      ruclips.net/user/kudvenkatplaylists?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.
      ruclips.net/video/y780MwhY70s/видео.html
      To receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
      ruclips.net/user/kudvenkat
      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
      @somanapallilokkeshwararav7043 4 года назад

      Worsted

  • @stephanieezat-panah7750
    @stephanieezat-panah7750 6 лет назад +2

    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
    @nikhillala1451 7 лет назад

    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
    @WolfgangLettko 9 лет назад +5

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

  • @kalin1993
    @kalin1993 6 лет назад

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

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  6 лет назад

      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.

  • @Tlgte
    @Tlgte 4 года назад

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

  • @mryoso22
    @mryoso22 7 лет назад

    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)

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    Thank you very much for taking time to give feedback. For email alerts, when new videos are uploaded, please subscribe to my channel. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video.

  • @arunaravind571
    @arunaravind571 7 лет назад

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

  • @lopintipriya3510
    @lopintipriya3510 11 лет назад

    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

  • @charlesrabelloable
    @charlesrabelloable 9 лет назад +2

    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.

  • @johnsongeorge5906
    @johnsongeorge5906 7 лет назад

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

  • @JoeG2324
    @JoeG2324 10 лет назад +5

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

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    To receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. May I ask you for a favour. 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. If you like these videos, please click on the THUMBS UP button below the video.

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    Hi Sujatha, sure, will record and upload a video on this soon. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

  • @pqmg
    @pqmg 8 лет назад +1

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

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    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.

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    "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.

  • @TheSplifydadz
    @TheSplifydadz 10 лет назад

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

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    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.

  • @entemolu1
    @entemolu1 10 лет назад

    No doubt, You are a Master of Master

  • @mittalpatel4990
    @mittalpatel4990 11 лет назад

    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
    @Csharp-video-tutorialsBlogspot  11 лет назад

    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.

  • @shreya5235
    @shreya5235 3 года назад

    Thank you. Your tutorials are very helpful.

  • @Ayubajbnabi
    @Ayubajbnabi 11 лет назад

    Excellent. Thank you very much Kudvenkat.

  • @saialuri9370
    @saialuri9370 6 лет назад

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

  • @IrishReGGie
    @IrishReGGie 3 года назад +1

    LEGEND FOR DOING THIS

  • @sharvaryrane1702
    @sharvaryrane1702 7 лет назад

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

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    This is discussed in GridView tutorial. In the description of this video, I have included the link for ASP .NET, C#, and GridView playlists. Hope you will find these videos useful.

  • @madihasabihkhan5841
    @madihasabihkhan5841 9 лет назад +1

    Very clearly elaborate each steps.

  • @黄桂兰-o7k
    @黄桂兰-o7k 7 лет назад

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

  • @amroosman9934
    @amroosman9934 9 лет назад +1

    Thank you Man you are simply Stunning.

  • @lopintipriya3510
    @lopintipriya3510 11 лет назад

    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

  • @MoathResume
    @MoathResume 11 лет назад

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

  • @ArsalHussain
    @ArsalHussain 7 лет назад

    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!

  • @mandardesai3841
    @mandardesai3841 11 лет назад

    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.

  • @davester32
    @davester32 10 лет назад

    Thank you for all your videos !

  • @robertomancino5517
    @robertomancino5517 4 года назад

    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?

  • @husamhabbal1419
    @husamhabbal1419 5 лет назад

    a very big Thank you, you deserve more

  • @MissNumnum
    @MissNumnum 7 лет назад

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

  • @archanashet5
    @archanashet5 8 лет назад

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

  • @karenwilson1558
    @karenwilson1558 8 лет назад

    Thanks! Glad it's still on line!

  • @vidhikansara7103
    @vidhikansara7103 6 лет назад

    So helpful video tutorial thank you so much it really helped

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    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.

  • @Qazafi4u
    @Qazafi4u 11 лет назад

    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

  • @SanjeevSriramoju
    @SanjeevSriramoju 10 лет назад

    best video....usefull for beginersss

  • @csandhya5289
    @csandhya5289 11 лет назад

    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.

  • @sawlehapathan249
    @sawlehapathan249 6 лет назад

    Thank you for this tutorial...really helpful

  • @markharris2944
    @markharris2944 11 лет назад

    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.

  • @mohamedjaffir9097
    @mohamedjaffir9097 8 лет назад

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

  • @Jimpeeterske
    @Jimpeeterske 9 лет назад

    You helped me a lot ! awesome video !

  • @JackFurtarelly
    @JackFurtarelly 9 лет назад

    What should i do if i would have to put on the footer row a calendar ( for example for a datetime from database ); how can i write that on the insert_click event ?
    Thanks and thanks for ur lessons , its helpin me a lot :)

  • @hakeraz
    @hakeraz 10 лет назад +2

    Congratulations, this is a good tutorial

  • @jac94
    @jac94 10 лет назад +1

    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.

  • @stephanieezat-panah7750
    @stephanieezat-panah7750 6 лет назад

    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?

  • @lizravenwood5317
    @lizravenwood5317 8 лет назад

    I love your teaching, but unfortunately my employee has not given me access to an SQL server to develop. Can you show how to do this using Access database table back end?

  • @ww1flyingace263
    @ww1flyingace263 4 года назад +1

    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.

  • @haniabidi7305
    @haniabidi7305 9 лет назад +1

    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.

  • @gandolfiniL
    @gandolfiniL 6 лет назад

    Thanks, very good, all work perfect!!!

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

    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.

  • @SuperMillone
    @SuperMillone 11 лет назад

    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.

  • @abdelhadiessaifi7339
    @abdelhadiessaifi7339 9 лет назад +3

    Thank you very much bro, you re my best mentor

  • @SuperMillone
    @SuperMillone 11 лет назад

    I solved it. I changed the line relevant the checkbox in the eventhandler like this: SqlDataSource1.InsertParameters["is_admin"].DefaultValue =
    ((CheckBox)GridView1.FooterRow.FindControl("chkCredential")).Checked.ToString().ToLower();

  • @kunaldedhia5502
    @kunaldedhia5502 9 лет назад

    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?

  • @junadashraf7936
    @junadashraf7936 6 лет назад

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

  • @gautamkumaranil
    @gautamkumaranil 4 года назад

    Sir, Firstly, I will thank to you for such nice videos and presentations which are remarkable and memorable. I have stuck one place. I have copied the same codes (given in this video) except the table data in database . While using the insert command, the error showing on the web browser is "identity_insert is set to off". So, I have made the entry in the sql query SET IDENTITY_INSERT [TABLENAME] ON. But still same issue. Will you please help me out?

  • @SteeveBalla2006
    @SteeveBalla2006 7 лет назад

    great video

  • @commsoft2923
    @commsoft2923 9 лет назад +1

    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!

  • @muhammadaslam1798
    @muhammadaslam1798 7 лет назад

    And what if the query returns zero columns, in that case grid view control goes hidden.
    What should I do that the footer must be shown and works normal. ?
    (Looking forward to hear from you, soon)

  • @stefanskoda6841
    @stefanskoda6841 11 лет назад

    amazing as usual :) Thanks Kudvenkat

  • @yaredgirma2847
    @yaredgirma2847 11 лет назад

    I really like the way u teach very clear and very helpful thank you so much.
    can u help me on this
    I have tried to use a grid-view to edit update delete and insert to a database as u put in the tutorial but in my case i need to use a tow drop-dawn box inside the grid-view the first drop dawn list refers to the other as a pass parameter to display the filtered result based on the drop-dawn selection like continent and country in the insert template but when i tried to give a parameter value for the dropdawn box the only control available in the wizard is the Gridview1 not the drop-down box can u pls help me.

  • @duynm
    @duynm 11 лет назад

    Thank you, i love your videos

  • @sathyak6254
    @sathyak6254 4 года назад +1

    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

  • @Unearthed13
    @Unearthed13 10 лет назад +1

    EXCELLENT video ... thank you so much :D

  • @SanjeevKumar-cz3yi
    @SanjeevKumar-cz3yi 4 месяца назад

    SqlDataSource1.InsertParameters["Parametername"].DefaultValue accepts only string value. How it can store value of
    some other data type? like:-number,boolean and others. Wait for reply Sir...

  • @PradeepthaObeysekara
    @PradeepthaObeysekara 8 лет назад +1

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

  • @jitendrasharma757
    @jitendrasharma757 11 лет назад

    good try for understand to other peoples.

  • @kremius12
    @kremius12 9 лет назад

    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 ?

  • @NicePaki
    @NicePaki 11 лет назад

    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.

  • @vikashashok
    @vikashashok 9 лет назад

    Hi Venkat,, I am not able to view your 23 part of gridview...i.e. GridView insert update delete in asp.net - Part 23
    Please check if there is any issue with part 23

  • @jdverse2136
    @jdverse2136 2 года назад +1

    thank you venkat , but i called you yesterday why you didn't you receive my call, is this your friend ship

  • @piyasidey2117
    @piyasidey2117 8 лет назад

    you are like God..

  • @MJG_Vibes
    @MJG_Vibes 8 лет назад

    Venkat,
    I think I have watched all of your tutorial videos on gridviews, which are very helpful, but I still cannot find what I'm looking for. If you can help me please.
    I am using gridview controls so that users can edit, update and delete personal information like in a CV, and publish to sharepoint.
    The problem is, It will only let me use one sourcecontrol. . It updates all of the other gridviews to look like the first. They are all coming from the same source control. Should I use different source controls or place all of the grids in a different table. Not sql table. Table (column/row) on the form itself? Please help. I think I just answered my question. Use more source controls. I was using sourcecontrol1 for all of the gridviews but chosing different tables. They all pulled from the first table... Personal information.
    One GridView for Personal information
    Name
    Date of birth
    Rank
    National ID
    Assignment Date
    (edit, update, Delete)
    One for Experience
    Title
    Department
    Date
    (Edit, Update, Delete)
    One for Qualification.
    Specialization
    Place
    Date
    (Edit, Update, Delete)
    One for Training (edit, update, delete)
    Title
    Place
    Date
    Certifications (edit, update, delete)
    Accomplishments (edit, update, delete)
    Title
    By
    Date

  • @digifabit
    @digifabit 5 лет назад

    Thank you so much!

  • @indikamakawitage
    @indikamakawitage 10 лет назад

    Good Tutorial,Thank you so much

  • @sarawallace9643
    @sarawallace9643 7 лет назад +1

    Following this step by step, but I get this error: "The GridView 'GridView1' fired event RowEditing which wasn't handled."
    Not sure where I went wrong. Help?

  • @eieichitsu9722
    @eieichitsu9722 11 лет назад

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

  • @priya354783
    @priya354783 10 лет назад

    Very usefull !! Thanks :)

  • @loai79
    @loai79 4 года назад

    Thanks! How to edit gridview inside updatepanel? Can you please help?

  • @HonzaMatejicek
    @HonzaMatejicek 11 лет назад

    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?

  • @anjali1308
    @anjali1308 8 лет назад +2

    Hi Venkat,Thanks for a wonderful video!!!
    I am trying to do the same but when i am adding listitems to dropdown list i am getting error--'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.
    Parameter name: value Can u pls help!!

    • @fula5
      @fula5 8 лет назад

      Try 1) Table field Genre Char(6) 2) Elements male: Male no Male with 2 spaces. Its work.!

  • @eshaqquadri8737
    @eshaqquadri8737 6 лет назад

    Thanks for this video sir, sir I want to know how to make two table join in one gridview and have crud operations in it

  • @007iguan
    @007iguan 11 лет назад

    For those who had problems with the SelectedValue.. I fixed it by changing the value on my DB For example in my table "Empleados" the first record name is "Peter" but in the Dropdown list doesnt exist the name "Peter". In the dropdownlist there is "Jonh", "Marck",etc but not "Peter". You can fix it backwards, changing the name on the Dropdownlist not in the DB for matching the values. The important thing is that values must match.

  • @win66K
    @win66K 11 лет назад

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

  • @pixelbeans
    @pixelbeans 10 лет назад

    Thank you very much. Excellent.

  • @Z3rY
    @Z3rY 11 лет назад

    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

  • @Csharp-video-tutorialsBlogspot
    @Csharp-video-tutorialsBlogspot  11 лет назад

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

  • @sandeepkumarneelam9920
    @sandeepkumarneelam9920 10 лет назад

    Hai Venkat Sir. First i would like to say Thanks for your video Tutorials.
    Sir i have a Problem. (DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value)
    please help me out..

    • @csworld10
      @csworld10 9 лет назад

      Sandeep Kumar Neelam hi.
      did u get help for ur query? if yes please help me too

    • @sandeepkumarneelam9920
      @sandeepkumarneelam9920 9 лет назад

      Rizwana Abbasi No Buddy

    • @1gouravgg
      @1gouravgg 9 лет назад

      Sandeep Kumar Neelam refer here stackoverflow.com/questions/31919133/dropdownlist1-has-a-selectedvalue-which-is-invalid-because-it-does-not-exist-i

  • @sajadadal4276
    @sajadadal4276 7 лет назад

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

  • @waynesmith4336
    @waynesmith4336 10 лет назад

    what a man move fast, me rahtid!