VB.NET Database Tutorial - Connecting To Microsoft SQL Server (PART 1) (Visual Basic .NET)

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

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

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

    I tried this on a Visual Studio 2019 Community and SQL Server v18.5 and it worked perfectly. Thumbs up. Great tutorial.

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

    Your vb videos have been more helpful than many other videos, I can understand you, yo explain things very thoroughly, and your topics are spot on. I know you have updated many of your videos and look foreword to watching your other videos!

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

    Great job. You move slow enough for me to get it without repeating the video a million times. Great teaching skills. I just got connected to my sql db via my vb.net. Thanks a bunch.

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

      Thank you for the encouragement, Sean! :-) I'm happy that it was helpful.

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

    I'm currently a intermediate programmer. I skipped SQL lessons from my book because its not understandable easily. But you helped me learn SQL very easily.

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

      I'm very happy that it's been helpful. :-)

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

    Thank you so much for this video series!! I spent a day and a half over a weekend trying to figure out how to do this via separate tutorials, and couldn't make a dent. You spelled it out for me perfectly, and I got it to connect to my local SQL Database!

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

      I'm glad that it has been helpful! :-) I highly recommend checking out the latest iteration of the SQLControl class as it has been greatly improved and simplifies usage.
      Source: www.dropbox.com/s/qv2ywbrfsjpdahy/SQLControl.txt?dl=0
      I've been planning a reboot of the SQL series using the updated class once things get settled a bit for me.

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

      +VB Toolbox Thanks! I will look into that when I get to set down and work on it again :)

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

    Posting my codes used might also help out other people .. What I really like your tutorials you sound so experts, know what you are doing and can debug codes without any hassle you know what are the inside out no matter how lengthy it is...Thumbs upp!!!

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

    I want to say a lot of thanks to you for this great tutorial. Very very helpful.

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

    I never thought I'd nerd out enough to enjoy doing this, but you made it so simple!

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

    thank you so much for sharing your brain wealth, Sir!!! It has been a month sifting through countless tutorials knowing there's a better way than what they're showing...

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

      +Julius Espinosa Hey! I'm happy to be of help! :-) It gets better, too. I have a new and vastly improved SQLControl class if you're interested. You're welcome to check it out if you like.
      www.dropbox.com/s/qv2ywbrfsjpdahy/SQLControl.txt?dl=0

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

    Love your tutorials, great job and Thanks alot from a guy who is a bit lost in his VB MIS class right now.

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

      I'm very happy that they've been a help, Todd. I appreciate the feedback. :-) Let me know if you have any suggestions for future tutorials.

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

    Great video, someone in a previous comment said to use: Trusted_Connection=true works fine in place of sa/pswd. Thanks for the comments that told me to use trusted_connection=true, this works better if you are windows authenticated already logged in to your windows, they help too

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

    this video might be old but still saved my life. thanks a lot, man!

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

      Awesome, Jamie. I'm glad that it was helpful! :-)

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

    I see there is a lot of thanking you going on, still I want to add my appreciation for this crystal clear tutorial. This is something I can build and expand on!

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

      Awesome, Sven! I really appreciate the encouraging feedback. :-D

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

    the best VB Teacher i glad to see VB Pro Programmer and your good series

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

    That would be awesome. Thank you so much. Your videos are the only thing i have found so far to help me with VSTO. I'm a huge fan! I would love a copy of the project. :)

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

      Here ya go, Sunni: www.dropbox.com/s/ugy6uz8zycy1vvb/DGVtoExcel.zip?dl=0
      I just threw it together so it's likely got some imperfections, but I tried to comment the code to make it easy to see how it works.
      What it does:
      1.) Connects to and Queries a SQL Database
      2.) Returns SQL records to DataGridView
      3.) Export Options: (With or Without Column Headers)
      4.) Export button click launches SaveFileDialog
      5.) Select a file name to save to *[.xlsx - Excel 2010]*
      6.) Generates a new Excel spreadsheet and populates from DataGridView
      Bear in mind that is just one of several ways to work with Excel, and it may not be the most efficient, but it seems to be working well for me. Hope it helps! :-)

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

    This is a very nice tutorial vdo. I am an absolute beginner. Just following your steps now i can build my own app!

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

    you help me recall my programming knowledge in vb.net and ms sql..thanks a lot!

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

    I really appreciate your work, you're good talking and explaining, I'm sorry about my grammar but I'm spanish speaker, anyway thanks for your good work sir!

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

      +Peter García Thank you, Peter! I appreciate the encouraging feedback. :-)

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

    I really love your tutorials, I wish you could make one on declaring variables in VB

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

      That's a good idea. I'd really like to start doing more beginner videos so I appreciate the suggestion. :-) Hopefully, I can get some time in the near future to make more videos. For now, if you have any specific questions, I'll be happy to help when I'm able.

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

      I appreciate it, thanks a lot. I will contact you

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

    Thank you for this tutorial. It is very helpful for beginners looking for simple explanations how it should be. We appreciate your work.

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

    Excellent set of video tutorials. Many, many thanks.

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

    At last, classes tutorial!!!!,it is very helpful video,you are really the best!!,thank you sooo much

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

    Fantastic tutorial. You've no idea how much this has helped me. Thanks!

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

      I'm very happy that it's been helpful to you! :-)

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

    Merci :) you are a calm clear and freaky easy to understand....
    Many thanks to take the time to share your knowledge.

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

    Thanks a lot!! (Following your tutorials from Argentina)

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

    Worked and easy to follow! Thank you!

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

    This is grate, I really appreciate your time and effort to giving us a good lesson.

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

    Fantastic tutorial! Very helpful and doesn't drag on, thank you!

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

    thanks this video tutorial really help me out😀😀😀😀

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

    Thank you very for your help. All its working fine. I'll see all your videos

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

    thank you dude please keep going that so amazing tutorial i'am from Egypt i learn so much from you :D !

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

      MrSilk Gaming Hello, MrSilk! That's awesome! I've always wanted to visit Egypt and see the pyramids. Thanks for stopping in and commenting. :-)

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

      ME TOO egypt

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

    Thank you so much for this! Maybe you can also make a tutorial for MS Access connection, insert, update, view, delete .. and also populating database on Datagrid and how to use crystal report for vs2010 .. keep sharing!

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

    This is the most helpful tutorial and channel. Thumbs up :like: :)

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

    Very helpful and excellently explained! Thanks!

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

      I'm very happy that it has been helpful! Many thanks for the encouraging feedback. :-D

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

    Thank you for this tutorial , I really appreciate your effort to giving and teaching us thru this video

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

    thanks bro! great tutorial keep it up...i'm still learning .net

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

    Thank you so much, your tutorials are awesome.

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

      Thank you for watching, Paul! :-)

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

    i love it, you explain it real good

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

    thanks to your tutorial. it helps me a lot

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

    Thanks a lot! You're a life saver. God bless you! Nice tutorial, I just listened to your instructions and It worked flawlessly. Thanks again~ :)

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

      And thank *YOU* for the feedback, Nell. :-) I'm very happy that it was helpful.

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

    Love your videos. I appreciate all of your time and hard work. Keep up the good work!
    Question - How could I change that connectionstring to connect to a sql database which is located on a shared drive using file browser so that the end user may located and pick their own mdf? Thank you.

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

      DV8 Computers Unfortunately, I’m not in a position to demonstrate this, but you should be able to pass the selected file path from your OpenFileDialog directly into your connection string.
      You can store the path in a text file, .ini, or application variable if you want the application to remember it. 🙂

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

    Thanks for this. Informative and to the point!

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

    this was awesome, super easy

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

    Thanks. It is very helpful.

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

    Perfect! It simply helps me out a lot!
    Thanks a lot. :-)

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

      I'm very happy that it was helpful! :-)

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

    Ya bro. I like your friendly talking and nice tutorial. It helped me. Thanks bro.

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

    Awesome vid! thank you for making a very helpful video

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

    Thank You. Very useful to me.

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

    Thank you so much!

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

    Excellent!

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

    Great tutorial! Thumbs up!

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

    This is a very clear video; though my attempts to apply its contents to my education seem to be failing. I set up the function in the SQLConnection class but that code doesn't seem to run when I use the IF SQL.HasConnection line

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

      Chris Read Hello, Chris. I'm sorry that it's giving you trouble. :-( Is the Catch reporting any errors from the connection? When you declare an instance of your SQLControl class in your main form are you using "New"?
      If you continue to have issues with it, feel free to zip it up and share your project with me and I'll be happy to check it over when I get some time.

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

      VB Toolbox Mr VB Toolbox - You got me to relook at the bit I needed to look at!
      I've got 20+ years experience of programming in COBOL and SQL(professionally) and Access Basic(for my own use) and I'm now trying adapt in my own time to OO coding! Its taking some adapting but I'm sure I'll get there!
      You were right, I didn't have the keyword New in the declaration of the SQL Control... So let me get this right, I needed the 'New' for the declare of the SQL Connection and the SQLControl (which is a self created object).... but no 'new' is required for the SQLCommand. Is that a different sort of Object?
      Thanks for your help

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

      Chris Read Excellent! Glad that got you steered in the right direction. :-)
      Generally, when you declare an object variable (without new) you're setting aside an empty (null) memory space as a placeholder for that object. When you use the *New* keyword, you're actually creating an instance of that object.
      In the case of the SQLCommand [In the SQLControl Class], we've prepared the object, but it hasn't actually been used in this tutorial because we haven't created any queries yet. That was my fault. I should have omitted it from this tutorial, but it *is* used in the next.
      The SQLCmd [SqlCommand] will be instantiated with *New* each time that we run a new query.

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

      VB Toolbox Ha! Its hardly your fault that I hadn't watched your next video yet! I'm sure there will be many things I will learn later, but I usually have to try things out while I'm learning.
      I do have one question though, - and I hope I'm not going to over-assume your assistance here - But when I created the database I'm trying to connect to in SQL Server management studio I used the Windows Authentication option, so it doesn't have a password as such. I've tried using a null string as a password but that doesn't work.
      But at least its telling me its not working now! So the code you showed in the first video is doing its job!

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

      Chris Read No worries, Chris. I'm happy to assist as I'm able. :-)
      The Windows Authentication (Trusted Connection) is an easy fix. Simply remove the user and password parts [User/Pwd] of the connection string and replace them with: Trusted_Connection=True;

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

    This was the most elegant and helpful coding I have yet to find on VSTO. However, I am completely stuck on trying to get data from a database into a worksheet. I'm working with an add-in, have your basic form as an action task pane, and I've been able to get my query onto a data grid, but I can't figure out how to export that onto my excel spreadsheet afterwards. I don't suppose you have a tutorial on this? Thanks in advance for your help.

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

      Thank you for the feedback, Sunni! :-)
      Unfortunately, I don't have any VB to Excel videos, yet. I wish that I had a simple and straight forward solution for your app, but there are so many different options and controls for working in Excel with VB.
      On a positive note, Excel has native database access built in, so pulling database records directly into Excel is surprisingly simple using Microsoft Query. You can write SQL queries directly in, else run Stored Procedures right from Excel/Microsoft Query.
      In Excel (2010) --> Select the Data tab --> The click the "From Other Sources" button --> Choose or Create a new Data Source.
      Once it connects to the Data Source, the Microsoft Query window will open.
      You can then select your columns and tables via the wizard, else cancel and continue editing in MS Query. (I usually just cancel and write my SQL code directly by clicking the "SQL" button in MS Query.
      When you're done and see your query output, just click File --> Return Data to Microsoft Excel and select the worksheet to place the query output in.
      This will generate a refreshable query within your worksheet.
      If you must be able to edit Excel data via VB.NET, then we'll have to take a different approach and probably add a .NET reference to the "Microsoft.Office.Interop" namespace. This will give us access to our Excel controls in VB.NET.

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

      I went ahead and made a small sample project that populates a DataGridView from SQL and then exports the contents of the DataGridView to Excel. If you want a copy of the project, let me know and I'll be happy to share. :-)

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

    you are the best... thanks a lot :) I am from chile

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

    Hello.. I'm new here with SQL SERVER.
    What should I do with the 'user' and 'pwd', just because I set them with 'Windows Authentication'.
    When I installing the SQL Server, I set them to default settings.
    Your coding is work very well, but seems like I can't access my database.
    PLEASE HELP!

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

      Pretty sure it's too late for Eddie, but I found this on stackoverflow and it worked for me, so i'll just leave it here for anyone who needs it. If you selected windows authentication during SQL Server installation you can add Integrated Security=SSPI instead of the username and password.

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

      "Trusted_Connection=True;" should also be a viable replacement for the username and password segments of the connection string. :-)
      Improved SQLControl Class:
      www.dropbox.com/s/qv2ywbrfsjpdahy/SQLControl.txt?dl=0

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

      +VB Toolbox thank you sir

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

      +Florin Militaru yaa.. but it's okay.. thank you sir

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

    good work bro.. thanks

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

    Hi Aaerderimus! Your SQL videos have been of great help. Will you be doing one for working with SQL Transactions as well?

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

      +Oli Milo Funny you should ask. I'm working on a refresh of my SQL series right now. :-D

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

      I'll be looking forward to that! Hope you include SQL Transactions as well, thanks!

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

    Thank you , it help me a lote

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

    Great tutorial, thanks a lot.It is impressive to see that you have helped so many people with their questions also!
    your steps worked well for me but I have one question; is there an issue using "Integrated Security=SSPI" rather than supplying a username and password? My app will be used by multiple clients connecting to a central server and I have assumed this method will use windows login credentials so will be secure. thanks

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

      Bernie Milne Greetings, Bernie! Trusted connections (Integrated Security) are more secure, but the reason that many apps rely upon a SQL username/password is due to the fact that managing application access on the database end - especially in larger environments - could be a nightmare. Instead of using a single SQL db account to gain access to the application database, you'd have to grant access and permissions to each Windows client within the SQL server. In a smaller environment this may not be a big problem. For an app that would require very few installs, a Trusted Connection may actually be a better solution.
      Most large scale applications use a single SQL login to access the database, and then apply more granular security within the application itself.

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

    Found very useful, thanks

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

    Thx! I just need to connect VB + SQL 2008. It's simple work! :)

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

    great tutorial!!!

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

    i subscribe because you make me laught in the good way im not joking or trollin when you show your sql server name xD hahaha you sound so serious and that.. nice dude :)

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

    Hi, this is very helpful series that I plan to watch them all. Quick question? I'm working on capstone project & it requires that we use the datafile (.MDF) SQLserver datafile. That way, you can attach to the project to send with it. Is there a ways to make this connection happen?

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

      Hello! :-) I'm honestly not certain if it's possible to directly interface with the master data file of a SQL server. Are you trying to ship an empty database with your application, or does it need to contain data? How large must it be?
      If you are shipping an empty MDF template, it would be best to script generate a new database on the destination server. This would be done with SQL and can be fairly complex but is likely the cleanest way.
      If you must ship the MDF, you'll want to ship the LDF (Transaction Log) and then attach them to SQL server on the client side. I'm not sure if that process can be done in VB or if it must be done in the SQL server environment.
      Finally, if the database doesn't need to be very large (less than 4GB), the easiest way to ship a database with your app is to use SQL Compact Edition (native to VB). I haven't made a SQL Ce tutorial yet, but I'm planning on doing this.
      I hope this points you in the right direction.

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

      VB Toolbox Small database around 5 tables, with almost less than 100 records. Probably database is not more than 10mb. I'm trying to ship the database with the application and it is not going to be in production, just for academic. Your tutorials were really awesome. I'm going to finish them all.

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

      Abdillahi Jibril
      Thank you, Abdillahi. :-D In your case, I think that SQL Ce would be perfect for your application. SQL Ce is easy to use and very similar to SQL Server except that it requires no server install and is contained completely in a single database file that can ship with your app. :-) I have a sample app that you're welcome to download and review until I'm able to get working on a tutorial. Let me know if you're interested and I'll link it.

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

    thanks for the video
    just want ask: what are the benefits to contact to the database with a connection string vs connecting with sql server data tools
    thanks again

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

      What's the Username and Password?

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

      No idea how to find the username and password

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

      Functionally, I don't think that one way is really better than another. I mainly do a coded connection class because it helps us understand what's actually going on under the hood of our application, unlike components that are derived from wizards.
      One place where the wizards and bindings do win, however, is when working with Reporting. I've found that it's absurdly difficult (which is ridiculous) to work with the Report Designer and custom Datasets.

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

      😭😭😭

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

    Hello, and thank you for sharing the most useful information about Data base programming that I have ever found .I have question and a very big problem . I want to create a setup file for install the program I have built on another system . I have tried very videos and tutorials but any of them wasn't useful and complete . I beg you help me and upload a video

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

    Great tutorial thanks :)

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

    Very, very Nice!

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

    Its an awesome sir

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

    thank you very much...

  • @rafy-ivanmorales3077
    @rafy-ivanmorales3077 10 лет назад

    Do you have any tutorial on how to make a project with name last name and address but how to write the code?

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

    perfect >>>> thank you

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

    thanks a lot.
    it's helpful..
    waiting next tutorial :D

  •  7 лет назад

    Hi! How can i change the conn. string variables (for ex. the location, database name...)? How can i create PUBLIC variables to change this informations, and access there from another forms?

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

    I like it a lot! Thank you!

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

    Nice.... Thanks!!!

  • @raven-hawk6153
    @raven-hawk6153 8 лет назад

    if we are planning to supply values to the sql connection separately than doing it in the declaration part. do we have to type
    SQLCon.ConnectionString = { " " }

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

    Awesome!!

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

    Sir, can you make a tutorial on how to validate data from textbox before adding the values to the database?

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

      This would be a good tutorial, but I've been super tied up lately. :-(
      There are different ways to handle validation.
      One way is enforce data types via SQL parameters (I have videos on Parameterized queries, but they don't show DataType enforcement).
      If you learn these, you can Add the params and then set their DBType property to be the type of your choosing.
      Another way that doesn't require parameters, is to simple build functions to look over the input data and return a value - either an updated/cleaned value, or a Boolean indicating that the data was proper.

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

    Hi there! This is really a very helpful video. I just notice an issue when connecting to my DB. When I used a connection string using servername\instancename and username "sa" with the correct password, I am getting a network-related or instance specific error....But when I removed the instance name and only use the server name I am connecting to the DB successfully. Now if I try to connect using ODBC to test, I cannot connect without the instance name. Any ideas why is this happening?

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

      I'm not 100% certain, but I believe that if you're connecting to the default instance of SQL server with ADO.NET it doesn't need or want the instance name.I think that you will only need the instance if you're connecting to a non-default instance. ODBC likely handles the connection slightly differently.

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

    This is great, but one question, when I build my project, the other user cant access it. I have added my PC name (host of the database) to their hosts file.a network related or instance specific error occurred while establishing a connection to SQL Sever. The server was not found or was not accessible. I have added the ports to my firewall as well as the service (even though my firewall is OFF)Thanks,

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

      +Shootingnewb Make certain that the "SQL Server Browser" service is turned on and running on your server machine. You can do this via "services.msc" or via the SQL Server Configuration Manager.

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

    Thanks for this tutorial .. anyway I am having a bit of a problem when I am inserting multiple data only four of it are created ! Why is that ?! Thanks in advance!!

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

      Can you give me an example of your insert?

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

    Hello, i'm a beginner and i'm having trouble setting up a decent database.
    Do you happen to have a tutorial on this aswel on your profile or a link to a good tutorial that could help me? thx

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

      Hi there, Oliver. Unfortunately, I don't have any Database setup tutorials. A big problem with this is that there are so many setup variables based upon the specific needs of applications and environments. My recommendation would be to check out "Best Practices" for your preferred database platform. Beyond that, data normalization and good indexing practices are always a good thing to check out. :-)

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

    HEYYY!.. thanks..... good tutorial. =) *cheers*

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

    For the connection string how can you default to windows user and password login?

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

    Thanks sir

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

    Hello, a subtle point, in the lines where you Dim the classes SQLConnection and SQLCommand. The key word 'New' appears in one line but not the other. I was expecting it to be in both lines. I tried running with it in both lines, seems not to make a difference ..............................or does it ????????

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

      +Les Collier Hello, Les. :-) Sorry for the confusion. I got a little ahead of myself in this tutorial. The SQLCommand isn't even used until the next tutorial.
      The reason I use *New* for the SQLConnection and not the SQLCommand is because I'm only defining the connection one time (giving it default values that won't be changed). The SQLCommand, on the other hand, will be re-initialized every time a new query or command is run against the database.
      When we don't use *New* it only sets aside a _bubble_ of memory, kind of like an empty box. When we use New we fill that box with items like Properties and other useful things.
      It's the difference between 'Dog' and 'Yellow Labrador with short hair, brown eyes, and loves to fetch sticks'. One is just an empty idea that could represent any kind of dog, and the _New_ dog is fully defined. I hope that makes sense. :-)

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

    I have a question. Can the information that you store in this SQL server be accessed by other computers that has installed my app?
    For example:
    Computer 1 put Orange in the SQL database.
    ..then the other computers or users accessing the database can see the "Orange." Is this possible with SQL server?

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

      Absolutely. This is what SQL Server is designed for. :-) There are many considerations that must be taken for a large scale and multi-user environment, but in the end, SQL Server is designed for this and many high end systems use SQL Server as their back end.

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

    Hi, I currently have VB 2013 downloaded and want to link it to SQL Server Databases. What version of SQL should I download? If possible could you reply with a link to a suitable download? Thanks

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

      Hello, Ryan. The version of SQL server that you'll want to download is really dependent upon your needs. You should be able to connect to most any SQL version with VB, though I'm not sure what version the native ADO.NET library is in VB 2013. Older databases may require an additional ADO.NET download and reference.
      If you do not wish to download and run a complete SQL installation you can use the Local Database option in VB. This is a great, lightweight database, though is not as robust as a fun SQL install.
      Beyond that, you can download SQL Express (free, 4GB size limit) from Microsoft:
      SQL Express 2008 R2: www.microsoft.com/en-us/download/details.aspx?id=30438
      SQL Express 2012: www.microsoft.com/en-us/download/details.aspx?id=29062
      SQL Express 2014: www.microsoft.com/en-us/download/details.aspx?id=42299
      Also, you're not limited to SQL Server with VB. Most all databases (MS Access, MySQL, etc.) have a downloadable ADO.NET library which can be referenced within your project. The syntax is nearly identical with each connector.
      I hope that helps. :-)

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

    thanks buddy

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

    hi, can i ask what server version you are using? i wonder what server i need to download for this tutorial thanks.

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

      Hello, Melina. :-) I'm using SQL Server 2008 Express for these videos. However, my next series will be on SQL Ce (Compact Edition), which is awesome because the SQLCe database is portable and requires no installation. It's a great alternative to SQL Server if your needs do not require a full server.

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

    Hi sir, can you make a tutorial like this vb.net + sql server while making a whole system, like library system from scratch?

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

      Hello, John. I appreciate the suggestion. While the library system seems to be a very common theme among various university courses, I'm afraid that it would be difficult to provide a series on this due to time constraints, complexity, and the fact that I'd be duplicating a lot of material. It's much easier for me to focus on basic tasks. Still, I may consider this, but I'd have to research common course-ware for it to be of benefit to students.

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

    hi! Please help me because im having problem with connecting to sql server. I am using vb .net 2012 and i have installed sql server management studio 2012 with database engine. First, I followed your tutorial and it worked fine and i actually finished part 1 and 2 of your tutorial but after I restarted my computer, it didn't work anymore. So I tried to do it again from the start but it didn't worked well. The try catch command isn't working also even though i checked every command many times. I don't see any problem with the codes and i think the sql server is running properly. I might have disabled something very important. Thank You in advance, I'll really appreciate your help.

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

      I Apologies for this comment, I finally found my error on code. It took me a while because it didn't show any error message while running the program.
      What i did was this "Private SQLUSER As SQLControl" instead of this "Private SQLUSER As New SQLControl" i didn't notice New. That was a big mistake because my class became useless. The only problem is myself :D, by the way THANK YOU SO MUCH FOR VERY HELPFUL TUTORIALS.

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

      Hello, King Pineda! Sorry for the slow reply, but I'm glad that you got it sorted. :-D

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

      Thank you sir! I've learned a lot from your tutorials. Hope to see more. Thanks in advance.

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

    would you mind if I ask what version of VB.Net and SQL did you used in this tutorial?

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

      +daizaree dablo Not at all. :-) I'm using VB.NET 2010 Professional and SQL Server 2008 Express.

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

      thanks for the qiuck respond..=) can I ask some advice from you master if I have a problem in coding using this app?

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

      +daizaree dablo I'm always happy to help if I am able. :-) I can't promise that I'll be able to solve every problem, but we can always try. Feel free to ask and I will respond if I am able.

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

      Thank you master =)

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

    hi, I executed this code but it says login failed for user 'sa'. any username I give would show same message. Please help

  • @سعیدهعارفی-ذ9ص
    @سعیدهعارفی-ذ9ص 9 лет назад

    This is very nice tutorial. But i have 1 question.
    In VB I can make a dynamic control(such as button). but i want to save the location in db. so when user closes and again opens the app, he will see the control in the location that he had chosen before closing.

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

      +alef pe There are a few different ways to handle this. You could save a property to your project via My.Settings or in a config/ini file.
      If you wish to store it in the database you can simply save the X/Y coordinates as integers in individual columns with the Button name in another column which you could query for.
      Example:
      SELECT LocX, LocY FROM controlTable WHERE objName = 'Button1'
      Then, if records were found, you could pull the LocX, LocY values that are found for Button1 as a DataRow. For example, Dim r As DataRow = SQL.yourDataTable.Rows(0)]
      Then something like: Button1.Location = New Point(r("LocX"), r("LocY")
      This is a bit thin an I recommend some record or error catching.
      Let me know if you need a better sample and if I'm not too busy today I might be able to make something for you. :-)

    • @سعیدهعارفی-ذ9ص
      @سعیدهعارفی-ذ9ص 9 лет назад

      +VB Toolbox Thank you so much
      I did it. every thing was OK until I wanted to add event to these buttons(addhandler).
      The problem is that this Addhandler work with just the last button that i loaded from db.
      I have a global variable.
      Dim a as control
      I wanna move the controls.
      I use a timer and add event for mousedown and mouseup.
      these work just for the last one.

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

      +alef pe What code are you using to add the event handlers?

    • @سعیدهعارفی-ذ9ص
      @سعیدهعارفی-ذ9ص 9 лет назад

      +VB Toolbox
      For event mouse down:
      Timer1.Enabled = True
      Timer1.Start()
      renew()
      For event mouse up:
      Timer1.Stop()
      renew()
      The renew() sub:
      op = a.Location
      cp = MousePosition
      The timer1 code:
      a.Location = op - cp + MousePosition

    • @سعیدهعارفی-ذ9ص
      @سعیدهعارفی-ذ9ص 9 лет назад

      +VB Toolbox I found the solution
      Thank you
      May I ask you other question here?

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

    *Hey if you get errors like me* try writing this to the ConnectionString:
    Server=YOUR_SERVER;Database=YOUR_DATABASE;Trusted_Connection=True;

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

      I was fighting with the error for about hour hope this help if you get errors

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

      Hey! i would like to say thank you becuase we have some problem, all we just need todo is remove the instance name

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

    Sir I have question. it is necessary to have an sql server authentication?

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

      +John Roish Beduya It is not necessary to use SQL Server Authentication. As an alternative you may use a Trusted Connection [Windows Authentication] by simply replacing the "User=username; and Pwd=password;" sections of the connection string with "Trusted_Connection=True;".
      You will want to ensure that your credentials have been added to the proper SQL security roles for your database.

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

      Thank you sir. I really appreciated your help. And a happy new year :D

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

      Sir can I ask again, what's the difference between windows and SQL authentication? and what is more efficient to use for creating database?

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

      +John Roish Beduya The main difference is that Windows authentication is passed from your operating system or domain, whereas SQL credentials are held within SQL server's security system.
      As far as efficiency goes, it really depends upon the nature of your system and how you intend to use it. If you're creating a database application that will be distributed to others [clients], then it might not make sense to grant security roles to _your_ windows account which will be inaccessible to the client. For a quick "out of the package" deployment, using a default 'sa' or master security account will allow the end user to forego worrying about individual SQL user accounts.
      In most cases, all clients using the db app will be using the same [SQL] account to access the system, but they will not see this. The administrator can change the credentials on the back end as desired, but the end user will not need to know how to connect to SQL server.
      The client will access the database with an administrative account, typically, but will be restricted within the application by separate application account (stored within your application database tables).
      From an administrative standpoint it doesn't really matter, since it all comes down to the SQL security roles. If the account has the necessary roles applied then it's all the same to the server whether SQL or Windows authentication is used.

  • @0401jhay
    @0401jhay 9 лет назад

    Hi there! i just want to ask, do i need to download ms sql server if i already downloaded and installed the visual studio 2010?? thank you..

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

      Yep. SQL Server is a separate product as must be downloaded by itself; However, VS 2010 _should_ come with SQL Ce (Compact Edition), which I've used in several videos. :-)

  • @s-linkcomputer5594
    @s-linkcomputer5594 9 лет назад

    awesome