Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mr A 216 posts 278 karma points
    Mar 07, 2012 @ 15:28
    Mr A
    0

    Inserting data into manually created table in umbraco db

    Hi ,

    I need to create a simple form to capture user details and save into the database, The form consist of personal details, the user has to enter and then on pressing confirm, the system should save all the information into db, I have created a separate table in the umbraco database, but i am out of ideas of how to implement this , how to inject sql select queries , insert queries and how to get connecting string inorder to use ado.net for insertion. I cant find any example of carrying out these steps using umbraco. I have created a usercontrol just for a start but don,t know how to start from there.

    Any assistance or suggestions will be highly appreciated.

    Regards

    Thanks

  • gilad 185 posts 425 karma points
    Mar 07, 2012 @ 15:44
    gilad
    0

    hi mr A.

    you can wrap your form with user control.

  • Mr A 216 posts 278 karma points
    Mar 07, 2012 @ 15:46
    Mr A
    0

    how to get all the connection string stuff 

  • gilad 185 posts 425 karma points
    Mar 07, 2012 @ 15:52
    gilad
    1

    if your table/s are on your umbraco site DB you can find the connection string in web config, search for :

    <appSettings>

        <add key="umbracoDbDSN" value="connection string" />

  • Mr A 216 posts 278 karma points
    Mar 07, 2012 @ 16:07
    Mr A
    0

    Well to get ConfigurationManager.AppSettings["umbracoDbDSN"] working , what libraries i have to call?

Please Sign in or register to post replies

Write your reply to:

Draft