VB.Net with SQL Server. Insert, Update, Delete, Search (CRUD) in VB.Net with SQL Server. Source Code

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

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

  • @cheiulin3375
    @cheiulin3375 2 года назад

    u dont know how much i love u!!!!!!!thanku so much!!!!!!!!!!!!!!

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

    Thank You. Very clean tutorial and helpful.
    Subscribed from Mozambique.

  • @rjbasketballtv868
    @rjbasketballtv868 4 года назад +2

    Subscribed

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

      Thank you very much sir 🙏🙏

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

      @@SourceCodePH743 welcome boss

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

      Boss comnpatible ba to sa 2010 na vs ?

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

      @@SourceCodePH743 Boss, hndi parin nag aappear yung sa servers name sa 1:44 po. Meron na ako nung pinadownload nyo.

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

    Just got subscribed!
    Sir Gawa ka naman ng relational db na may atleast 3 tables at may crud operation katulad nitong video. Salamat

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

      Okay sir soon mag upload lang ako. Salamat sa request

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

      Pro tip : watch movies at kaldrostream. I've been using it for watching lots of of movies these days.

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

      @Tomas Gibson definitely, I have been watching on KaldroStream for since november myself :D

  • @johnharryramos9955
    @johnharryramos9955 Год назад +1

    Hi, pwede ba para sa mga multi user? Ex. 1 database to many user /(pc) ang gagamit simultaneously ?

  • @Yuri-lb3qt
    @Yuri-lb3qt 2 года назад

    Thank you amigo,it is a nice video. I really apprecited, what language are you speaking?

  • @산하-q2m
    @산하-q2m 3 года назад +2

    Sir bakit po nag eerror yung sa cmd. ExecuteNonQuery() kapag nag uupdate?

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

    Sir pwde po mag request ung una po? bago makarating sa window na yan?anung project ung create na exact? salamat sir

  • @Mandaragat1969
    @Mandaragat1969 Год назад

    sir yung about sa moduiles naman, like pano amg CRUD gamit yun kesa sa form ka mag lagay ng codes

  • @christopherdomingo7049
    @christopherdomingo7049 2 дня назад

    Paano po kung empty yung textbox and nag search ka, mag yeyellow code po siya

  • @justin34930
    @justin34930 4 месяца назад

    sir ask ko lang pwde po ba ma transfer yan sa another pc ? problema ko po kasi pag ka e pupublish ko na sya di nasasama ung database

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

    salamat sa tutorial sir, tanong ko lang po kung paano pag more than 1 table po sa CRUD SqlDatabase......

  • @nheldionforsuelo6296
    @nheldionforsuelo6296 Год назад

    sir pano naman mo pag galing sa button yong data na iinput sa datagridview, pano po yon ma insert sa MySql? Katulad po nang POS na naka button type po yong item tsaka yong price automatic na input sa datagridview, ano po ang gagawin para po ma save sa database yong "item, qty, at total price" po?

  • @eloytv8639
    @eloytv8639 Год назад

    Nag successfully update yung inupdate kung primary key pero nung isearch ko ay no record found, kaya po bang iupdate ang primary key?

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

    ahh hello po. pano ko po ma retrieve ung photo galing sa database sir?

  • @Liquid179
    @Liquid179 2 года назад

    Hi! boss. salamat sa mga tutorials. nagka problema lang kase sa pag export ng data galing datagridview papuntang excel file. meron na kaseng laman programmatically yung datagridview. then sa pag export, bibigyan pa ulet sya ng laman via properties. ano kaya alternative na pwedeng gawin. ang goals is export

  • @bradlyvidal2916
    @bradlyvidal2916 Год назад

    Hindi ko gets: Ayaw mag save ng mga infos na tina-type ko sa Visual Basic. Pag dating ko sa MS Access, wala dun 'yung sinave ko. Tama naman lahat, hindi ko gets.. naka 64-bit siya since ayaw gumana kapag "Any CPU" 'yung resolution.

  • @SeriesFamilyFreestyle
    @SeriesFamilyFreestyle Год назад

    When I update, click on edit mouse cursor first and last name in the textbox. It will literally stay away from it. Do you have a solution?

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

    Sir gumagana pa din po ba to kapag po MS Access database yung ginamit imbis na Sql server

  • @dhensorayao1556
    @dhensorayao1556 Год назад

    Good day po sir ask kolang po bakit po nag eerror yung akin eto po lumalabas "to type 'Integer' is not valid"?

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

    Appreciate This video... It's very clear.. Can you help me with the source code Pls

  • @user-by2lj5rm4f
    @user-by2lj5rm4f 2 года назад +1

    how i can click search and lead me to other form? pls help

  • @AMPATERRailhieBenjE.
    @AMPATERRailhieBenjE. 7 месяцев назад

    hi ser pwede pu mag ask about sa sql data base paano po sya makikita

  • @marvinramos2775
    @marvinramos2775 2 года назад

    Need pa po ba mag download ng sql server?

  • @prekyyethvlog2289
    @prekyyethvlog2289 2 года назад

    Sir Paano po ma fix yung wala pong SqlConnection

  • @itnewhatchin6574
    @itnewhatchin6574 2 года назад

    Good day Sir Pa help naman lagi nag eeror ung executenonquery()

  • @MANILACOVAX
    @MANILACOVAX Год назад

    Papano mo sinet up ung database sa VB?

  • @CoRX_AE
    @CoRX_AE 2 года назад

    Boss pa help naman bakit ganto lagi sinasabi kapag nag run ako " System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'TO'.' "
    doon sa part ng cmd.ExecuteNonQuery() laging nag error.

    • @omarrahim673
      @omarrahim673 Год назад +1

      In any code that gives you this error, you have to make sure that the data of the columns of the table matches the data. The error will go away, God willing. Good luck.

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

    Boss pwede ba magpaturo sa zoom for thesis sana

  • @Liquid179
    @Liquid179 2 года назад

    Thanks bro

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

    Thanks po.
    Sir i wnna ask po kung anong version ng vs at ms sql nyo ?

  • @johnrobertm.austria5235
    @johnrobertm.austria5235 3 года назад

    Sir pwede po paturo paano maayos kapag hindi makita yung MySQL sa Add reference.

    • @florantelaguit9052
      @florantelaguit9052 2 года назад

      Nasa folder ng MySQL na nasa Program Files o sa Program Files (x86) hanapin mo doon sa browse ng Reference ng Visual Studio para ma Add.

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

    nag invalid column name ako sa update button. pa help naman po.
    Dim query As String = "UPDATE Community SET FN =@First_Name, LN =@Last_Name, ST =@Street,PH =@Phone"
    dyan po akong statement may mali

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

    SA THUMBNAIL MO NAKA RADIO BUTTON YUNG GENDER MO. TAPOS SA VIDEO NAKA COMBO BOX

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

    Boss san mo ginawa yung server na SQL EXPRRES wala sakin boss Paano po Gumawa ? Salamat

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

      Hello po, mag install ka ng sql server managemenr

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

      @@SourceCodePH743 slr boss matic na magdirect na yun dum boss ?

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

      @@SourceCodePH743 btw subscribed!

  • @ojidelouiedeed.2227
    @ojidelouiedeed.2227 3 года назад

    New subscriber here boss ahm ask ko lang kung oks boss pano pag ibang form ang pagcreate ganun padin ba code nun? Sana. Ibang form makikita si data grid hindi sa mismong create para hindi makita si data grid habang nagreregister salamat boss

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

    subscribed

  • @harenzivangesulgonllamas4616
    @harenzivangesulgonllamas4616 2 года назад

    tutorial po para sa download po ng application poniyan po

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

    Boss

  • @ryroshark9372
    @ryroshark9372 2 года назад

    Nagrun po yung akin pero need magdebug

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

    boss pwede bang mysql gamitin na database server?

  • @judahalfredsolon4553
    @judahalfredsolon4553 2 года назад

    Nakakalito lang kasi pare parehas ang ginagamit na data variables.

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

    Nacopy ko na po code nyo, pero yung sa umpisa wala ako server name yun nalang Boss
    paaano po iconnect dun hehe salamat

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

    Wala po kasi ako sql pwede access po sir?

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

    cmd.ExecuteNonQuery() ayaw neto hays

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

      Review. Mo ang codes

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

      @@SourceCodePH743 Ayaw po talaga ,wala naman pong mali sa codes

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

      same error
      System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'Table'.'

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

      may sagot na kaya dito?

    • @hxhx8673
      @hxhx8673 2 года назад

      Hindi nyan maaccess table ng database mo, kase mali code mo dito -> Dim query As String = "INSERT INTO member VALUES (@ID ,@FirstName,@LastName, @Gender)" Ginaya nyo name ng table sa video, palitan nyo yung "member" ng pangalan ng table ng database nyo. Ex. Dim query As String = "INSERT INTO LagayMoDitoTablenameMo VALUES (@Fname,@Lname,@Loginname,@Pass)"

  • @aiscollection4977
    @aiscollection4977 2 года назад

    Pwede mag request?

    • @SourceCodePH743
      @SourceCodePH743  2 года назад

      Ano po sir?

    • @aiscollection4977
      @aiscollection4977 2 года назад

      @@SourceCodePH743sa button SAVE, save to multiple different table, for 3 tables po

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

    Hi sir pwede po makahingi ng source code nyo po mismo :(

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

    100