GridView insert update delete in asp.net - Part 23

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

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

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

    Thank you soooo much for this!

    • @Csharp-video-tutorialsBlogspot
      @Csharp-video-tutorialsBlogspot  9 лет назад +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!

  • @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.

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

    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.

  • @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.

  • @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.

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

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

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

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

  • @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.

  • @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.

  • @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

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

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

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

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

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

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

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

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

  • @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.

  • @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.

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

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

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

    Thank you. Your tutorials are very helpful.

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

    Excellent. Thank you very much Kudvenkat.

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

    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.

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

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

  • @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.

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

    Thank you Man you are simply Stunning.

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

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

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

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

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

    No doubt, You are a Master of Master

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

    Very clearly elaborate each steps.

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

    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?

  • @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

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

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

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

    LEGEND FOR DOING THIS

  • @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

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

    Great Video! However, I have problems:
    1. ASP.net will not accept 'SelectedValue='' property as the DropDownList property (as shown in video 4:20 ). It will rather allow to declare as 'AppenDataBoundItems...'
    2. Cannot edit the Gender. Upon clicking the 'update' it will not display the gender status (male or female) or it will erase from the database while other data like "name" and "City' can be edited normally. I followed the video exactly as described. I used varchar(20) as Gender type in my database. I am wondering if that is the problem.
    Any help will really be appreciated! Anybody.

  • @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!

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

    Congratulations, this is a good tutorial

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

    how do you enable the little arrow that gives you the grid view task properties

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

    a very big Thank you, you deserve more

  • @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

  • @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.

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

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

  • @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.

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

    Thank you for all your videos !

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

    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.

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

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

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

    So helpful video tutorial thank you so much it really helped

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

    You helped me a lot ! awesome video !

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

    Thanks. I want to add drop-down list containing another table data. How can I do that. Please help

  • @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.

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

    amazing as usual :) Thanks Kudvenkat

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

    Thank you for this tutorial...really helpful

  • @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 ?

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

    Thanks! Glad it's still on line!

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

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

  • @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

  • @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?

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

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

  • @bryannrecolosado7809
    @bryannrecolosado7809 11 лет назад +2

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

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

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

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

      jubin singh did not work

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

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

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

    Someone please help me out,for some reason edit/update is not working in gridview table, how to solve this?

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

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

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

    Thanks, very good, all work perfect!!!

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

    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?

  • @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.

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

    on 1:22, why is the Generate INSERT, DELETE And UPDATE statements is greyed out on me?? Anyone knows please help

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

      Thank you :D

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

      Hi, do you have a primary key in your table? I heard about some having that problem and they had no primary key.

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

      thanks, worked for me, too

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

      yes primary key and identity column as well increment 1 and seed is 1 set that as well

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

    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

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

    best video....usefull for beginersss

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

    hi i m looking for video where insert button is in other way. it is just button and wen i click on it then it will make blank row in witch i can insert data. you have video for that kind of insert button?

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

    Do you know how to persist GridView state after closing or restarting windows?. Because, when I close windows, its state is gone.

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

    Thank you very much bro, you re my best mentor

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

    Hi, i used visual studio 2015 but it doesn't have Enable Editing and Enable Delete checkbox. So, how to used this function? Thank you.

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

      same :( please help Using Community 2015

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

      same problem

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

      Have you define a Primary Key. I used this table
      CREATE TABLE DBO.WAP5 ( CODIGO INTEGER NOT NULL PRIMARY KEY, NOMBRE NCHAR(71), GENERO NCHAR(20), CIUDAD NCHAR(20) )
      INSERT INTO WAP5 VALUES (1,'MIKE', 'Male', 'LONDON')
      INSERT INTO WAP5 VALUES (2,'JHON', 'Male', 'CHENNAI')
      INSERT INTO WAP5 VALUES (3,'MARY', 'Male', 'NY')
      INSERT INTO WAP5 VALUES (4,'MIKE', 'Male', 'SIDNEY')
      INSERT INTO WAP5 VALUES (5,'PAM', 'Female', 'TORONTO')
      INSERT INTO WAP5 VALUES (6,'DAVID', 'Male', 'SIDNEY')
      and work with this.

  • @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.

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

    Sir how did you automatically insert a value to the primary key? is it in auto increment?

    •  9 лет назад

      +Gerald Cudia One would assume so.

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

      It's an identity primary key column, so yes auto increment.

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

    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.

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

    EXCELLENT video ... thank you so much :D

  • @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?

  • @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.

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

    why gridview is not displayed in browser when I run the web form?plz help me.

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

    Hello Venkat Sir,
    When i try configure with insertion and deletion. While Clicking on the advance options those two options are disabled and i m not able to select it

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

      For people with this problm.. primary key constraint is a must in ur table

  • @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?

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

    Hello i have completed the code by taking your reference but the problem is my "user_id cannot be allowed as null " error gets generated on insert command pls help what should i do.

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

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

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

    Hello,Thank you so much,but if there are a lot of rows and I don't want all rows appeared in one page , what should I do?

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

      You can active paging option on your gridview

  • @Pyro_the-animatior
    @Pyro_the-animatior 7 лет назад

    the footer is invincible if the datasource has no records , how can i make it visible.

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

    Am unable to fired lbinsert_Client event dynamically .can you please help me out?

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

    hi can i ask, you this? the default value of checkbox, this is my example
    SqlDataSource2.InsertParameters["is_active"].DefaultValue =
    ((CheckBox)GridView1.FooterRow.FindControl("checkActive")).Text;

  • @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)

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

    hi kudvenkat !
    I am unable to insert data don't know why,as i have done exactly you did. but its not working.please help me

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

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

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

    Fo r mine the enable edit and delete part is not functional. I can't click it

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

    Please I have a problem, once I've implemented the Insert, I've got an error saying that data cannot be inserted cause it's not allowing null values, but it should display the error of validation control first, how can I fix this error please ?

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

    It won't insert it for me while applying even though there aren't any errors.
    I didn't put validations though, could that be the problem?

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

    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

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

    Thank you, i love your videos

  • @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.

  • @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 :)

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

    I am to update a template of the gridview with image uploaded through FileUpload Control. I am saving the path of the uploaded image to the database. How can I do that? Thank you.