C# help

[esh_max]

[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"); "

 

[Elakiri...user...]

try to write it to a txt file/ registry automatically when u update it n access to the db through the txt or the registry..

 

[hans078]

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]

<?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]

App config ake thiyaganin. App config ake Connection string kiyala section akak thiyenawa.

 

[Kasun k]

<?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.

 

[esh_max]

<?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]

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.

 

[moonrock]

MSDN එකේ බලන්න
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection(v=vs.110).aspx