C# help

esh_max

Well-known member
  • May 31, 2011
    1,176
    131
    63
    [SIZE="5"[COLOR="Magenta"]]Machanla mata loku uddawak oni Ape C# waddangen....[/COLOR]

    man c# project ekak hadala thiyene.. database eka access..

    mata oni eke Access Data base path eka manually configure karanne kohomada kiyala dena ganna..

    XML file ekaking wage Access Database Connection path ekakin wage configure karanne kohomada kiyala dena ganna..


    den coonection string eka thiyenne me vidiyata :[/SIZE]



    conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Projects\Road Des\RoadDes\DB\RDDb.accdb");

    me path eka manully configure karanna puluwan widiyak "D:\Projects\Road Des\RoadDes\DB\RDDb.accdb"); "
     
    Last edited:

    hans078

    Active member
  • Feb 17, 2008
    496
    179
    43
    Colombo
    Settings.Designer.cs කියන ෆයිල් එක Project Folder එක අතුලේ තියන Properties Folder එක ඇතුලේ තියනවා.. එකේ මෙන්න මේ ලයින් එක හොයාගෙන හරියට Re-Place කරලා බලපන් මචන්..


    [global::System.Configuration.DefaultSettingValueAttribute("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Projects\Road Des\RoadDes\DB\RDDb.accdb")]

    අනිත් එක තම මචන් උබේ Database එකේ type එක හරිද? ඕක .accdb කියල save කරලා බෑ නේද?? .mdb කියන format එකෙන් සේව් කරන්න ඕන නේද??
     

    rhn123

    Well-known member
  • Jul 20, 2012
    759
    37
    48
    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
    <connectionStrings>
    <add name="conn" connectionString="Data Source=rohan-PC;Initial Catalog=hasas;Integrated Security=True" @"Provider=Microsoft.ACE.OLEDB.12. 0;Data Source=D:\Projects\Road Des\RoadDes\DB\RDDb.accdb");
    </connectionStrings>
    </configuration>


    sure naha bn. math thama study karanwa
     

    Kasun k

    Well-known member
  • Mar 11, 2009
    10,357
    492
    83
    United States
    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
    <connectionStrings>
    <add name="conn" connectionString="Data Source=rohan-PC;Initial Catalog=hasas;Integrated Security=True" @"Provider=Microsoft.ACE.OLEDB.12. 0;Data Source=D:\Projects\Road Des\RoadDes\DB\RDDb.accdb");
    </connectionStrings>
    </configuration>


    sure naha bn. math thama study karanwa

    Meka hari. :yes:
     

    esh_max

    Well-known member
  • May 31, 2011
    1,176
    131
    63
    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
    <connectionStrings>
    <add name="conn" connectionString="Data Source=rohan-PC;Initial Catalog=hasas;Integrated Security=True" @"Provider=Microsoft.ACE.OLEDB.12. 0;Data Source=D:\Projects\Road Des\RoadDes\DB\RDDb.accdb");
    </connectionStrings>
    </configuration>


    sure naha bn. math thama study karanwa
    thanks machan


    machan meka c# program eke read wen widiya poddak kiyapanko..eka karanne kohomada ??
     

    Kasun k

    Well-known member
  • Mar 11, 2009
    10,357
    492
    83
    United States
    thanks machan


    machan meka c# program eke read wen widiya poddak kiyapanko..eka karanne kohomada ??

    configurationManager.ConnectionStrings["conn"].tostring();

    conn kiyala man gaththe uda exampe ake connection string aka name karala thiyenne conn hinda.

    Configuration maganer ubata anne naththan. system.configuration dll aka reference walata dala, using key word aka use kaala import karaganin udinma.