I want to save a datatable to the app.config file (My.Settings) and what i have understand is that you can use the Datatable.WriteXML to convert it to XML and then save that string to the settings.
But how do i rebuild it from the xml? Do i have to create my own code to do that or is there a method?
Is there a really simple way to save the app.config file to a location then load it again? I'm making a multiclient app. I was planning on having each user have a folder, and in that folder would be their personalized app.config file that would load when they log in. I don't really know any XML.
View 13 RepliesI have picturebox that the user can import an image, and then save it to the datatable. I can save it with no problem, and the image, which is a logo, will populate onto my crystal reports pages.My issue, is that I want the logo to automatically load into the picturebox when the user opens my settings form. How can I do the opposite of the following:
'set the company datatable for sub
Dim borrowersrow As PlannerFilesDataSet.CompanytableRow
'use only the first row
[code]....
I have an application that users will save a list of clients to a database. The extension on the database is .sdk, and I think is some kind of sql database. The user can save rows and add rows to maintain a client list, but when I release an update, I have to install it without the database file. If I install with the database file, then their current client database is replaced with a new blank database.
my issue is that I need to add columns to tables in their existing database without overwriting their current rows. For example, i have columns for client name, address, and phone number currently. On my next update, I want the user to be able to save client birthdays. Here is what I have:
[Code]...
I have a DataTable (comprising of three columns) created at runtime & populated by the users selections in other parts of the app. The DataTable is required as I need to manipulate the users data before graphing it, etc.I now need to save the DataTable (& associated data) to an Access DataBase so that I have a record of what the users data was.
Everything works fine apart from the saving of the DataTable bit........
I've managed to get the following working :-
For Each row As DataRow In ResponseTable.Rows
[code].....
I'm using this code:
Dim tfLines() As String = System.IO.File.ReadAllLines("Config.ini")
For Each line As String In tfLines
Dim arr As String() = line.Split("="c)
If arr(0) = "title" Then textbox1.text = arr(1)
Next
To read from a config file that looks like this this:Quotetitle=this is the text Now is the question, how can I save to the config file?Like, replace "this is the text" with the new text in textbox1.text
Private Sub SaveButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SaveButton.Click
Dim Config As Configuration
Dim Section As ConnectionStringsSection
[code]....
Is there any way to save a form window state including all of the controls etc that it has on it in their current state? I'm having to write long functions for each control just to save and reload from a config file, so I'm spending more time on user saved settings than on my actual project.
View 3 RepliesI want to save picture in app.config file,first time when i start my application picture will come from database then all the time it will come from the app.config file.I also update app.config file from front end with two fields user name and user picture
View 3 RepliesI'm using this
[code]...
Now is the question, how can I save to the config file? Like, replace "this is the text" with the new text in textbox1.text
I have an XML configuration file to which I will occasionally add new elements and, for ease of reading outside of the application, I want to keep it sorted alphabetically - by the "key" attribute of the "add" elements.After a lot of trial and error - using code I've gleaned from here, there and everywhere - I've come up with the code below. It appears to work okay, but I'm only just starting to learn Linq to XML, so I'd like to know whether this is an appropriate method or if there is a better/ more efficient method I've missed. It just feels like I might be taking an unnecessary step in recreating the entire file element.
Dim newEx = cfgEx.<appSettings>(0)
newEx.Add(<add key=<%= sNewKey %> value=<%= sValue %>/>)
Dim sortEx = <configuration>[code]....
EDIT: I think I've worked out a better way to do this - without explicitly recreating all the parent tags in thesortExvariable:
Dim newEx = cfgEx.<appSettings>(0)
newEx.Add(<add key=<%= sNewKey %> value=<%= sValue %>/>)
Dim sortEx = From c In newEx.<add> Order By c.@key Select c
newEx.ReplaceAll(sortEx)
cfgEx.Save(sXmlConfigFile)
(My question is similar to this one, but the code is slightly different, and the solution doesn't work for me)I'm trying to save settings changes to the app.config:
Dim config As System.Configuration.Configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None)
config.AppSettings.Settings("HistoryRootDirectoryPath").Value = p_historySavingPath
[code].....
I am currently working on a WPF/.Net project, In this project the user has the choice to change the the skinning of the app entirely, I am trying to write those settings after submission using configurations management, but I don't seem to be able to add the new values to the app.config file, here is my method underneath
[Code]...
I would like to commit the data put in a checkedlistbox to the user.config. I have found a way to commit them to my.settings but no matter what Save() method I call, it does not commit the new data (that is not bound to a control, through the propertybindings) to the user.config, either immediately or when I shutdown the application. Which means, when I loop through the settings when the application starts back up, the data is not there to be added back to the checkedlistbox. I have put save methods in the formclosing events as well as when the data is created in the my.settings. using my.mysettings, my.settings and my.settings.default. Thank you in advance for your input.
This first method is a called when a button is pushed. it checks the text and then calls the next method (AddProperty) which should add the property to my.settings and save it to user.config, but my understanding is that it is not written to the file till the applicatoin closes.
[code]...
I have done a fair amount (days)of searching, before posting this,and cannot seem to find an answer.ata put in a checkedlistbox to the user.config. I have found a way to commit them to my.settings but no matter what Save() method I call, it does not commit the new data (that is not bound to a control, through the propertybindings) to the user.config either immediately or when I shutdown the application. Which means, when I loop through the settings when the application starts back up, the data is not there to be added back to the checkedlistbox. I have put save methods in the formclosing events as well as when the data is created in the my.settings
View 3 RepliesI am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
I have a datatable which has 5 column. It is possible to copy only its 2 column in and save it into new datatable.I used this code but it copies all the 5 column
Code:
Dim qry As DataTable = (From obj In temptable Where obj.Item("Column1") = 0 _
Select obj).CopyToDataTable
i used this one but it is not supported
Code:
Dim qry As DataTable = (From obj In temptable Where obj.Item("Column1") = 0 _
Select obj.item("Column1"), obj.item("Column2")).CopyToDataTable
Dim accConn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ConfigurationManager.AppSettings("Access") & "")
<?xml version="1.0" encoding="utf-8" ?>
[code].....
I work with windows forms and on the form I have a DataGridView. This gridView I fill with a DataTable dt. The dt I fill with OdbcDataAdapter. For save the changes I use adaper.Update(dt) on Event Handler gridView_RowLeave. The problem is that dt doesn't have last changes of gridView. For exemple if I modify some data in one row or add a new row with data when I leave that row the method dt.GetChages() return false and I must leave more that 1 row for dt.GetChanges() return true.
[code]...
how to update my database table by the data inside my datatable.this is my class
public class Sample
Private ds As New DataSet("myDs")
private dt as new Datatable("myDT")
Private data_adapter As SqlDataAdapter
[code]....
i had problem in sub deleterow AcceptChanges() method not seems to work.i cannot update my database if i put AcceptChanges() method after the delete row..if i delete 1 row then hit the updatedatabase sub the record in my database is the same..seems like there is no delete happened..my server is mssql2000
in vb.net i am trying to save application settings but for USER but i cannot find the user.config file
when does this file get created?
i searched my entire hardrive. i also searched the entire project.
Whenever I change a user setting in app.config (via running the program) the change doesn't appear in the app.config file (it stays the same). When re-running the program, however, the change is reflected in the program's behaviour. How can this happen if app.config wasn't altered when the program was last run?
View 2 RepliesI have a "For
Each
Row As
System.Data.DataRow
In
DataTable.Rows" type loop. I want to save the contents of a field to use in subsequent processing.
It looks to me like the proper way would be to use something like the following:
Dim saveCatalogWorkID As VariantType
For Each clsWTRow As System.Data.DataRow In clsWTDataTable.Rows
saveCatalogWorkID = clsWTRow.Field("CatalogWorkID")
Next clsWTRow
I have a question for store data from vb.net
I want to store data a file without use any database engin and
Retrieve and save data from DataTable
I have compiled some information into a DataGridView.How can I save all this DataGridView info into a DataTable?
dt As New System.Data.DataTable
dt = DataGridView1.DataSource
I have a class library (Named ADI), that needs some configuration settings from the project using it (like connectionstring, filesystem locations etc).
I want to define these settings in my Windows Forms/Web Projects App.Config or Web.Config, like other settings.
Here is part of my app.config for my windows forms application:
<applicationSettings>
<PhotoImportRobot.My.MySettings>
<setting name="ADIImageRoot" serializeAs="String">
[Code]....
is there any tool to validate configuration file?
View 1 RepliesI'm creating an small application where I search from the databse table tems and add the result line to a datarow of my datatable "dt", I the set the datagridviewe datatsource to this same dt.How can I save this dt content into another table of the same database.I'm not ussing stored procedures and dont understand much of parameters.
CODE
Dim cs As New SqlConnection("Data Source=myserver;Initial Catalog=mydatabase;Integrated Security=True")
Dim da As New SqlDataAdapter
Dim ds As New DataSet("Chosed")
[code]....
A year ago I saw a beautiful simple code that gets a data table and saves it in an excel file. The trick was to use the web library (something with http) and I'm almost sure it was a stream. I find a lot of code with response but I can't make it work in a win-form environment. There is also a cell by cell code - not interested -too slow. I want to paste it as a range or something close.
View 5 Replies