Part 4 of 5: Editing SQL data using the SqlDataAdapter UpdateCommand with C#

Поділитися
Вставка
  • Опубліковано 31 жов 2024

КОМЕНТАРІ • 44

  • @solvinia
    @solvinia 11 років тому

    Your tutorials are great, I can easily follow along. Your pace is good.

  • @claidlaw58
    @claidlaw58 8 років тому +1

    Been looking for a solution like this for a while, worked great with my application. Thanks a lot!

  • @shawnlesner
    @shawnlesner 11 років тому

    great videos for learning as well as for helping in projects.
    thank you so much Fabio

  • @gotdamnimin
    @gotdamnimin 11 років тому

    Your videos are so clear. I love them all from Part 1 to 5. You're a great tutor. Do you have any videos about XML data storage?
    If you don't it's OK. God bless you Sir for sharing such important information.

  • @barisal11
    @barisal11 13 років тому

    very good presentation. please add more

  • @domaine75atutube
    @domaine75atutube 13 років тому

    very good video
    I've just discovered your vids and I like it very much
    very usefull
    fred from Paris

  • @dankimle
    @dankimle 9 років тому

    Thank you so much for taking your time and making videos, Fabio Scopel.
    if you have sometimes, could you do tutorial which import data from Excel Spread sheet into SQL using C Sharp?

  • @amlzigh
    @amlzigh 12 років тому

    Sir, thank you very much, i appreciate your taking the time to explain this !

  • @mionel237
    @mionel237 12 років тому

    Great videos, helped me a lot. can you make videos about 3-layer architecture?

  • @lfendleygib
    @lfendleygib 11 років тому

    Hi, this is the 'Binding Source' that Fabio created in one of his previous videos :)

  • @maryamwahab
    @maryamwahab 12 років тому

    useful stuff u thought !! thanks

  • @johntrites3387
    @johntrites3387 11 років тому

    I really like these videos but have a question regarding an exception that was thrown after updating the 3rd row's last name and then clicking Next followed by the Display Records button. The debugger stopped on the "txtFirstName.DataBindings.Add(new Binding("Text", tblNamesBS, "FIRSTNAME"));" statement with exception: "This causes two bindings in the collection to bind to the same property.
    Parameter name: binding." Why did this happen? Thanks. JT

  • @joeryan9687
    @joeryan9687 9 років тому +1

    is it possible to make a new version of this short sweet tutoriasl using ADONET and Entity Model?

  • @JosueMaldonado1
    @JosueMaldonado1 13 років тому

    would it be the same if i need to use an INSERT command instead of UPDATE?

  • @ahmedinooo
    @ahmedinooo 12 років тому

    thank you very much

  • @JackBauerAgent24
    @JackBauerAgent24 13 років тому

    @yogeshkumarmahto1 I have the same problem , but I dont know what can I do.Did you find a key for teh problem???
    Thnx Your answer!

  • @Alfavazvlogz
    @Alfavazvlogz 4 роки тому +1

    Hi...can we use this ms sql in unity ?...i just want to call a player name jersy number dynamically....and it should display on game screeen ...can we do that?

    • @Coffeecupdev
      @Coffeecupdev  4 роки тому

      You can use any kind of storage with Unity, but I highly encourage you to look into Firebase, or Redis, or other very fast simple DBs if you are working with games.

  • @DimitrisKougioumtzis
    @DimitrisKougioumtzis 12 років тому

    nice videos , in the above example can you add in your database a date field and in the application a datepicker for example date of birth and then submit date of birth into the database

  • @MoxetKhan
    @MoxetKhan 12 років тому

    what is tablenames in the 3 line? after value table[0].rows[????????]

  • @vinu7866
    @vinu7866 12 років тому

    what is tablenamebs in that iam stuck in that position

  • @skamransajjad7
    @skamransajjad7 12 років тому

    Brother, I want to get max(id) from the same table where I am want to insert record, What should I do? I Tries following and got error:
    Int myrec = mydataset.Tables[0].Rows[0][0];
    Please Help

  • @yogeshkumarmahto1
    @yogeshkumarmahto1 13 років тому

    hi bablio br i have seen your video try to make it on the system every thing is doing right but when run it clicke next button then it updated but when i clicked update button then it give a problems and the problems is """"Failed to convert parameter value from a String to a Int32.""""""" give a error message how it is solved please help me display section is updated but

  • @NickFromIT
    @NickFromIT 12 років тому

    hi, sorry for my bad english.... just a question.
    what s "BS" where FABIO type (tblNamesBS.Position +1) i dont know .... someone can help me ? ... thank you all.

  • @anoopdeb
    @anoopdeb 14 років тому

    Thanks, it helps me a lot, can u post or send me more example.

  • @auskariukas
    @auskariukas 13 років тому

    Hi,how to edit items in windows form?

  • @CodeWhat
    @CodeWhat 12 років тому

    when ever I update it only updates the first item in the table even when i select any one.

  • @Hag3upaTeJIb
    @Hag3upaTeJIb 12 років тому

    Show error in da.InsertCommand.EndExecuteNonQuery(); and da.UpdateCommand.EndExecuteNonQuery();.
    Underline red line. Why ???

  • @premmainali931
    @premmainali931 11 років тому

    can you show simple way to update insert and delete data using SQLDATAADAPTER

  • @shawnlesner
    @shawnlesner 13 років тому

    HI fabio i did the same thing as in in this video but i found the error "Failed to convert parameter value from a String to a Int32"????
    can u plz check out this!!
    my arguments are differents from youu!!

  • @userM309
    @userM309 12 років тому

    im getting error in ds.Table[0] it says "Cannot find table 0."

  • @MrDur2011
    @MrDur2011 12 років тому

    Can you make a video showing how to filter a datagridview using a textbox on a form in vb.net using C# and retrieving the data form SQL Server 2008

  • @ryuzaki23mj
    @ryuzaki23mj 10 років тому

    hello fabio, i'm getting an error in dataset. it keeps on saying "Cannot find table 0". hope to hear from you soon

  • @yogeshkumarmahto1
    @yogeshkumarmahto1 13 років тому

    but database isnot updated code is on facebook page
    Learn C# - The Right Way

  • @domaine75atutube
    @domaine75atutube 13 років тому

    Could you make a video on how to drag and drop pictures for a game like in chess ?
    fred from Paris

  • @missmymanners
    @missmymanners 13 років тому

    hello sr, i would appreciate it if you would make a video of inserting, updating and deleting data from sql server for tables with joins. thankyou.
    p.s my project is pending sr and i am stuck. plz help me

  • @gioo444
    @gioo444 13 років тому

    what does "da" means ?

  • @lpjanaka
    @lpjanaka 13 років тому

    @gioo444
    da is the object of the Data Adapter class

  • @ZolbooBayanbulag
    @ZolbooBayanbulag 14 років тому

    hi, make custom dictionary english - japan and japan - english ...ect on c# 2008 with sql 2005. help me... example tutorial upload... please!!!

  • @alshezawi2010
    @alshezawi2010 10 років тому

    thanks Fabio for your tutorials

  • @SranKablar
    @SranKablar 12 років тому

    dim a as integer
    dim dt as datatable
    "select max(ID) as max from table" 'this is command
    da.fill(dt) 'fill table whit adapter
    a=dt.Rows(0).Item(0) 'value

  • @iHorus
    @iHorus 15 років тому

    5 star at least !!!