Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. C# Newbie, Database Programming

C# Newbie, Database Programming

Scheduled Pinned Locked Moved C#
databasecsharpvisual-studioquestion
11 Posts 5 Posters 24 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J Offline
    J Offline
    JasonParker333
    wrote on last edited by
    #1

    Hi, I have downloaded Visual Studio to write and run C# scripts. Can I use Microsoft SQL Manager for free to use with C# to create windows database apps? Or do you suggest another free DB to use? or even another app to run C#? Basically I want to get my Grand Daughter into programming using C# for, well FREE Any suggestions and code examples greatly appreciated. Thanks

    OriginalGriffO L M 3 Replies Last reply
    0
    • J JasonParker333

      Hi, I have downloaded Visual Studio to write and run C# scripts. Can I use Microsoft SQL Manager for free to use with C# to create windows database apps? Or do you suggest another free DB to use? or even another app to run C#? Basically I want to get my Grand Daughter into programming using C# for, well FREE Any suggestions and code examples greatly appreciated. Thanks

      OriginalGriffO Offline
      OriginalGriffO Offline
      OriginalGriff
      wrote on last edited by
      #2

      There is a free version of SQL Server: SQL Server Downloads | Microsoft[^] - you want the Express or Developer edition (probably the former). I use it myself as a testbed for DB apps so I don;t go near the production server and any cock-ups I make don't harm anything in the real world. But even in development, it;'s a good idea to back up your DB before testing extensive changes - this may help make that easy: Backing up an SQL Database in C#[^] And SSMS is free as well: Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Learn[^]

      "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

      "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
      "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

      J 1 Reply Last reply
      0
      • OriginalGriffO OriginalGriff

        There is a free version of SQL Server: SQL Server Downloads | Microsoft[^] - you want the Express or Developer edition (probably the former). I use it myself as a testbed for DB apps so I don;t go near the production server and any cock-ups I make don't harm anything in the real world. But even in development, it;'s a good idea to back up your DB before testing extensive changes - this may help make that easy: Backing up an SQL Database in C#[^] And SSMS is free as well: Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Learn[^]

        "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

        J Offline
        J Offline
        JasonParker333
        wrote on last edited by
        #3

        Thank you for the quick response, really appreciated :-) :)

        OriginalGriffO 1 Reply Last reply
        0
        • J JasonParker333

          Thank you for the quick response, really appreciated :-) :)

          OriginalGriffO Offline
          OriginalGriffO Offline
          OriginalGriff
          wrote on last edited by
          #4

          You're welcome! Good luck with the granddaughter - teaching isn't as easy as some people think ... :D

          "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

          "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
          "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

          1 Reply Last reply
          0
          • J JasonParker333

            Hi, I have downloaded Visual Studio to write and run C# scripts. Can I use Microsoft SQL Manager for free to use with C# to create windows database apps? Or do you suggest another free DB to use? or even another app to run C#? Basically I want to get my Grand Daughter into programming using C# for, well FREE Any suggestions and code examples greatly appreciated. Thanks

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #5

            You might like to download a copy of .NET Book Zero by Charles Petzold[^], which is also free, and very well written for people starting out with C#.

            J T 2 Replies Last reply
            0
            • L Lost User

              You might like to download a copy of .NET Book Zero by Charles Petzold[^], which is also free, and very well written for people starting out with C#.

              J Offline
              J Offline
              JasonParker333
              wrote on last edited by
              #6

              Excellent, Thank you very much

              1 Reply Last reply
              0
              • L Lost User

                You might like to download a copy of .NET Book Zero by Charles Petzold[^], which is also free, and very well written for people starting out with C#.

                T Offline
                T Offline
                trønderen
                wrote on last edited by
                #7

                Note that the current revision (1.1) of the book is more than 17 years old. Don't expect it to cover all the new bells & whistles. A few :-) things have been added since C# version 2.0 and dotNet 3.0, so don't expect to learn enough to understand all the sample code you'll find on the internet today. Do read the book - Petzold is a top notch technical writer, and most certainly for beginners. Just be prepared to discover that there is a lot more to C#/dotNet today that Petzold couldn't possibly have described in his 2006-2007 book. Additional comment: Once you are through Petzold, a nice way to learn about more recent additions is to read The history of C#[^] bottom up. The links to the descriptions of each new extension is mostly quite readable!

                Religious freedom is the freedom to say that two plus two make five.

                L 1 Reply Last reply
                0
                • T trønderen

                  Note that the current revision (1.1) of the book is more than 17 years old. Don't expect it to cover all the new bells & whistles. A few :-) things have been added since C# version 2.0 and dotNet 3.0, so don't expect to learn enough to understand all the sample code you'll find on the internet today. Do read the book - Petzold is a top notch technical writer, and most certainly for beginners. Just be prepared to discover that there is a lot more to C#/dotNet today that Petzold couldn't possibly have described in his 2006-2007 book. Additional comment: Once you are through Petzold, a nice way to learn about more recent additions is to read The history of C#[^] bottom up. The links to the descriptions of each new extension is mostly quite readable!

                  Religious freedom is the freedom to say that two plus two make five.

                  L Offline
                  L Offline
                  Lost User
                  wrote on last edited by
                  #8

                  I don't think you meant this message for me.

                  T 1 Reply Last reply
                  0
                  • L Lost User

                    I don't think you meant this message for me.

                    T Offline
                    T Offline
                    trønderen
                    wrote on last edited by
                    #9

                    It was meant as an extension to your message, an additional comment. I wasn't prepared for anyone having problems understanding that. In meatspace discussions, I am used to discussion participants expand on each other's contributions, directed to all listeners, not just to the one making the statement expanded upon. I frequently consider network discussions in a similar way: A post is not meant for one specific listener, but for all participants taking part in the discussion. I'm really sorry for creating this highly undesirable situation; I hope you do not feel terribly offended. That certainly wasn't my intention. I will try to remember in the future that if I add to something that you say, I will not do it as a followup to your post, but wait until someone else makes a followup to your post and rather add my addition to that post, rather than to yours.

                    Religious freedom is the freedom to say that two plus two make five.

                    L 1 Reply Last reply
                    0
                    • J JasonParker333

                      Hi, I have downloaded Visual Studio to write and run C# scripts. Can I use Microsoft SQL Manager for free to use with C# to create windows database apps? Or do you suggest another free DB to use? or even another app to run C#? Basically I want to get my Grand Daughter into programming using C# for, well FREE Any suggestions and code examples greatly appreciated. Thanks

                      M Offline
                      M Offline
                      Member 15270729
                      wrote on last edited by
                      #10

                      I retired from a career as a programmer, systems analyst, and SQL Server developer a couple years ago, but had very little experience with C#. Since there is so much info on programming available on the web (thank you Code Project and Stack Overflow), I almost never buy a book on programming. However, I did buy this one and found it valuable: Head First C# by Andrew Stellman and Jennifer Greene (Don't know them, have nothing to gain by this plug). I have the 4th Ed, there's a 5th coming out in August. I got the PDF version for the publisher's site, but print and kindle are available at Amazon. After information is presented, they use different kinds of non-conventional exercises designed to help understanding and recall. There are various places on the web where you can preview some chapters and see how they do it. It is aimed at young programmers just coming up, rather than old farts like me, and may appeal to your granddaughter.

                      1 Reply Last reply
                      0
                      • T trønderen

                        It was meant as an extension to your message, an additional comment. I wasn't prepared for anyone having problems understanding that. In meatspace discussions, I am used to discussion participants expand on each other's contributions, directed to all listeners, not just to the one making the statement expanded upon. I frequently consider network discussions in a similar way: A post is not meant for one specific listener, but for all participants taking part in the discussion. I'm really sorry for creating this highly undesirable situation; I hope you do not feel terribly offended. That certainly wasn't my intention. I will try to remember in the future that if I add to something that you say, I will not do it as a followup to your post, but wait until someone else makes a followup to your post and rather add my addition to that post, rather than to yours.

                        Religious freedom is the freedom to say that two plus two make five.

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #11

                        Sorry, I did not mean to offend you. And your comments are all valid, but I just thought that they would be best posted to the OP, as follow up to what I suggested. Experience (here) tells me that not everyone reads every message in a thread; even though you and I would seem to.

                        1 Reply Last reply
                        0
                        Reply
                        • Reply as topic
                        Log in to reply
                        • Oldest to Newest
                        • Newest to Oldest
                        • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Login or register to search.
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • World
                        • Users
                        • Groups