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. Database & SysAdmin
  3. Database
  4. mysql with asp.net

mysql with asp.net

Scheduled Pinned Locked Moved Database
databasecsharpphpasp-netmysql
4 Posts 4 Posters 0 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.
  • H Offline
    H Offline
    hazzem elrefai
    wrote on last edited by
    #1

    iam going to develop e-commerce website (shopping basket,catalog,.....) with ASP.NET adn Mysql i didn't use mysql b4, i developed by sql,access,oracle but not mysql. so plz if any one know there is problems with this compination plz tell me, i know mysql is stable and nice database but all mysql samples was with php languge, and this is why iam afried to use asp.net with it. thnx in advance

    C G V 3 Replies Last reply
    0
    • H hazzem elrefai

      iam going to develop e-commerce website (shopping basket,catalog,.....) with ASP.NET adn Mysql i didn't use mysql b4, i developed by sql,access,oracle but not mysql. so plz if any one know there is problems with this compination plz tell me, i know mysql is stable and nice database but all mysql samples was with php languge, and this is why iam afried to use asp.net with it. thnx in advance

      C Offline
      C Offline
      Colin Angus Mackay
      wrote on last edited by
      #2

      hazzem elrefai wrote: b4 plz thnx This is not an SMS text message - you have more that 160 characters to play with. The use of these contractions make the text difficult to read. Okay, I'll answer your question now. For an e-commerce application I would ensure you use transactions. From the MySql manual: MySQL Server (version 3.23-max and all versions 4.0 and above) supports transactions with the InnoDB and BDB transactional storage engines. So you need at least the above version plus, it would appear, one of the transactional plugins. (These may or may not be supplied with MySQL, I don't know) The other thing that I think is important is Stored Procedures. From the MySQL manual: Stored procedures are implemented in MySQL version 5.0. For the benifits of Stored Procedures click here[^]


      Do you want to know more?


      Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

      1 Reply Last reply
      0
      • H hazzem elrefai

        iam going to develop e-commerce website (shopping basket,catalog,.....) with ASP.NET adn Mysql i didn't use mysql b4, i developed by sql,access,oracle but not mysql. so plz if any one know there is problems with this compination plz tell me, i know mysql is stable and nice database but all mysql samples was with php languge, and this is why iam afried to use asp.net with it. thnx in advance

        G Offline
        G Offline
        Gavin Jeffrey
        wrote on last edited by
        #3

        If you are using framework 1.0 you will need to download the mysql odbc 3.51 driver which you can get from the mysql website. It does already come with 1.1

        1 Reply Last reply
        0
        • H hazzem elrefai

          iam going to develop e-commerce website (shopping basket,catalog,.....) with ASP.NET adn Mysql i didn't use mysql b4, i developed by sql,access,oracle but not mysql. so plz if any one know there is problems with this compination plz tell me, i know mysql is stable and nice database but all mysql samples was with php languge, and this is why iam afried to use asp.net with it. thnx in advance

          V Offline
          V Offline
          Vasudevan Deepak Kumar
          wrote on last edited by
          #4

          Hi: I think you need to use ODBC driver to connect to MySQL from ASP.NET. Either System.Data.Odbc (for 1.1 or higher) or Microsoft.Data.Odbc (for 1.0) I have seen some managed providers for MySQL database but I think they are not free. Deepak Kumar Vasudevan Personal Web: http://vdeepakkumar.netfirms.com/ I Blog At: http://deepak.blogdrive.com/

          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