Datasets and Reports

[Lost User]

I am having a little issue that I figured Microsoft would of changed. So I am trying to do my reports, which I can only figure out how to do with Datasets. I typically do not use datasets and do everything by writing the code when connecting, and retrieving/insertings information into a database. So anyways, I am storing everything in the applications settings. Before inserting the information I am encrypting the words so you cannot read it in the XML file. One problem I am having though is that you cannot write a connectionstring. It is readonly?!? So how do I do these reports (Microsoft reports) without using Datasets?

[Samuel Cherinet]

well, what visual studio does when storing connection strings is, it only codes the get method of the "connection string" property. this is an auto generated code,you will find it in a file called "Settings.Designer.cs" you will find a code roughly like this [global::System.Configuration.ApplicationScopedSettingAttribute()] [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)] [global::System.Configuration.DefaultSettingValueAttribute("Default Connetction string")] public string Setting { get { return ((string)(this["Setting"])); } //add this set method for this properit set { this["Setting"] = value; } } delete the default connection string and assign it before trying to fill the dataset hope it works for you,

[Lost User]

Sweet that looks like exactly what I needed! Thanks!