Deployment :: Importing/Exporting A Config File?
Aug 11, 2009
I'm brand new to this forum. i have a question. i wrote some software a while back and now have a few new features I need to implement. this software currently makes use of "application settings" to store all of it's settings. Which works just fine.
I have a client that has about 40 users. He wants to be able to share his settings (that he set up in his copy of the software) with all of users. Preferably by distributing a copy of a config file that they would be able to import into there software.
View 1 Replies
ADVERTISEMENT
Jul 15, 2008
I want to export data from a DataGridView to a CSV/text file. I then also want to be able to load that same CSV/text file and populate that same DataGridView at a later point in time. My information is loaded into columns in the DataGridView. That is, I am not using rows to represent records, I am using columns. As such, I need to load all the data in each column and export this, by column to the CSV/Text file. Likewise, when I load the control from the CSV/text file, I need to load each column with this information.How do you export/import from/to a DataGridView controlHow do you organize the data in the CSV/File
View 5 Replies
Sep 5, 2007
This is in vb 2005, and I would like to be able to click a button (i.e. export to excel, import from excel) and do this.If you need any more information then just let me know.
1)How do you export the data that is displayed in a datagrid to Excel.
2)How do you import data from an excel file, and fill the datagrid with that information.
View 2 Replies
Jan 26, 2010
I have a weird situation. I have a C++ code that overloads the +,-,* operators and exports them in a .DLL file. Now, I want to import those overloaded operators from within VB.NET code. So it should be like this:
<DllImport("StructDLL.dll")> Public Shared Function
Operator +(ByVal a1 As A, ByVal a2 As A) As A
End Function
So what I'm trying to do above it just import the lovely overloaded operator + from the DLL.Note that the operator is already overloaded from inside the DLL, so should I import it as a Function or as an Operator like this?
<DllImport("StructDLL.dll")> Public Shared
Operator +(ByVal a1 As A, ByVal a2 As A) As A
End Operator
The overloaded plus operator is supposed to add structs. So the DLL is programmed to work on structs (C++) and I want to import it in VB.NET to work on Structures.
View 1 Replies
Apr 21, 2011
I need to be able Import and Export data from my database in the app im developing. I have been having trouble finding the proper way to do this. I have to assume some of the people using this wont have Office installed so this process as to be able to work on its own. Im using Visual Basic Express with SQL server 2008. Using LINQ to SQL with a local database. I would like it to be a simple process for the users.
View 1 Replies
Aug 15, 2011
I've seen a lot of posts over time relating to importing and exporting CSV. Most of the answers involve using TextReader.readline and String.split, which will not work with any but the simplest data. When you are writing for users who have the expectation that your application will work with anything they export from Excel, you will have to cover all the CSV bases.
I hope that this post will give you a clear idea of what you're involving yourself in when you decide you need to read a CSV file. The characteristics of CSV data are:The comma character is used to separate the fields. (This is obvious, but I thought I'd start with a couple of obvious points to warm up) The last field on the line is ended by the end-of-line character or the physical end of the file.Any field that contains commas, double-quotes or control characters will be surrounded by double-quote marks. Any double-quote marks within the field will be "escaped" with an extra double-quote character. For instance, the value Paul "Chuck" Norris would be converted to "Paul ""Chuck"" Norris".After the opening double-quote ANY character is valid. Including line breaks. This is why you can't use readline.I have a parser class that works nicely and I'll post that on this thread in a little while, along with some notes on using it.
View 1 Replies
Jan 31, 2011
how to setup my deployment project so that users can customize thier own settings in app.config? Which special folder in the File System browser should I add, Personal Data, Application Data, or Programs Menu? How do I add the app.config to the folder? What about the project output, should it also be in the same folder? If so, should the project output be taken out of the Application Folder, in other words, exist in one place? I tested my deployment and was shocked that the icon only opened on the test user's pc after installation. I have custom settings in the app.config file that have default values, but must be configurable for user specific settings.
View 3 Replies
Apr 21, 2010
I've created a console VB.Net application and encrypted the app.config file with RSAProtectedConfigurationProvider.I've used an article http:www.codeproje...eAppConfig.aspx as an example for the Encryption. It works fine in an IDE on my XP desktop.Then I deployed my application to a Windows 2003 server. The package included the app's executable along with the encrypted app.exe.config file. However, the application failed on the server with the following exception:Unhandled Exception: System.Configuration.ConfigurationerrorsException: Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: The RSA key container could not be opened.I decided to encrypt app.config on the server so I copied app.config and encrypted it. The app.exe.config looked encrypted and I ran the application. However, it failed: although it didn't raise an Rsa exception as before,
[Code]...
View 1 Replies
Jul 10, 2009
I am trying to replace the following section to blank section
<secureWebPages mode="RemoteOnly" encryptedUri="abc.co.uk" unencryptedUri="www.abc.co.uk" maintainPath="True" warningBypassMode="AlwaysBypass" bypassQueryParamName="BypassSecurityWarning" ignoreHandlers="WithStandardExtensions">
<files>
<add path="abc.aspx"/>
</files>
</secureWebPages>
But after executing it is giving me the following error
WDP00002: missing section secureWebPages/configuration.
View 1 Replies
Apr 21, 2010
I've created a console .Net application and encrypted the app.config file with RSAProtectedConfigurationProvider. It works fine in an IDE on my XP desktop. Then I deployed my application to a Windows 2003 server. The package included the app's executable along with the encrypted app.exe.config file.
However, the application failed on the server with the following exception: Unhandled Exception: System.Configuration.ConfigurationErrorsException: Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: The RSA key container could not be opened.
I decided to encrypt app.config on the server so I copied app.config and encrypted it. The app.exe.config looked encrypted and I ran the application. However, it failed: although it didn't raise an Rsa exception as before, it couldn't read a connection string. After I decrypted app.exe.config, I found that it contained only the below string
although the original app.config had contained an application-specific connection string. I think that in order to resolve my issue I should export the RSA keys from my desktop to the server. Can you advise how can I do it (it's not a Web application!).
View 1 Replies
Jan 18, 2010
is there any tool to validate configuration file?
View 1 Replies
Feb 24, 2009
I am deploying sql express as a prerequisite. I have created a custom prerquisite using bootstrap manifest generator. The problem I have is replacing the template.ini file which exists in the sqlexpr32.exe cab file. Winrar and winzip allow me to open the sqlexpr32.exe but will not allow me to edit, add or replace the template.ini.I also cannot find the path where the sqlexpr32.exe extracts to as I want to use that path for the settings file eg "template.ini".[code]
View 1 Replies
Jan 17, 2011
I am writing a program that uses several textboxes that a user will fill in and then click the add button to add the data into the datagrid. There is no backend database or anything. Just seeing the data in the program only.
What I want to do is then export this data from the datagrid into a file, preferably excel.
I've done copying textbox data into txt files but I can't find a method to copy datagrid data into a file.
View 1 Replies
Jan 8, 2011
I do one project in visual basic 2010.In visual basic 6 project can be make Package and deployment (setup file or install file) file using Package and deployment wizard.But in visual basic 2010 express edition does not have Package and deployment wizard.how to make Package and deployment (setup file or install file) file in visual basic 2010 project?
View 4 Replies
Jan 24, 2011
I have the following code:
Public Class Payrollfinal
Private Sub Payrollfinal_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub payrollsubmitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles payrollsubmitButton.Click
[Code] .....
And when two things happen when I try to use this code (which I modified after finding it on another site)
1. Intellisense tells me that MyDataSet is not defined.
2. When I define MyDataSet as
Dim MyDataSet as New Dataset
Intellisense tells me that I'm told that AppendText is not part of String.
View 14 Replies
Jan 24, 2011
I have a form that I'm writing that will run a stored procedure, present data from that stored procedure in a datagridview and then allow users to export that data to a csv file. I found the following code:
Code:
Imports System.Data.SqlClient
Public Class Payrollfinal
Private Sub Payrollfinal_Load(ByVal sender As System.Object, ByVal e As
[Code]....
View 1 Replies
Jan 21, 2011
I have the following code:
[Code]...
End Class and what intellisense is telling me is that MyDataSet is not declared (I took the code for this portion from another site and modified it to suite my needs.) I tried adding the declaration Code: Dim MyDataSet As Dataset but when I added that, where ever there is a .AppendText statement, I'm told that AppendText is not part of String.
View 6 Replies
Oct 19, 2009
I wish to import data (into a text box) from specified tags within an XML file.[code]Instead of loading the whole file into a text box I would like it to load data within <ABC></ABC> tags.The amount of <ABC></ABC> tags varies for each XML file. As does their placement (which line they are on).
View 2 Replies
Jan 18, 2011
Currently I am building an application that will do Data Validation on an Excel Spreadsheet.The application will allow a user to load an Excel Spreadsheet in and runs checks on the data. The application needs to export the spreadsheet as a pipe delimited file with all of the fields separated by the character.Currently I have written an Excel Macro that will export it as a Text File then delimit it and save the text file as a .ps1 file. I cant seem to figure out how to write this same code in VB instead of VBA.I am currently using Visual Studio 2010.Here is the code for my Macros that work fine but I need it in the application and not on the spreadsheet.
[Code]...
View 2 Replies
Sep 9, 2011
I need to export data to a .txt file but don't know how to do that.
I have a query like this SELECT * FROM TABLE1, from that query it should be directly saved to .txt file without any datagridview.
This code below creates a .txt file bit does't have any data when I opened it.
Dim command As New SqlCommand
Dim reader As SqlDataReader
Dim st As String
[Code].....
View 3 Replies
Aug 25, 2009
I have a a DGV with the following fields:
FirstName
LastName
Address
Job
StaffNum
Nationality
DOB
Notes
Picture
FileName
Now my DGV has records in it and I try to export it to Excel File. Now it exports the the Column Names above but none of the records. My code is below.
Dim fs As New IO.StreamWriter("C:exported.xls", False)
fs.WriteLine("<?xml version=""1.0""?>")
fs.WriteLine("<?mso-application progid=""Excel.Sheet""?>")
fs.WriteLine("<ss:Workbook xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet"">")
fs.WriteLine("<ss:Styles>")
[Code] .....
I got this code from the MSDN forums from a link someone posted. They said they changed IntCol and it worked to incoude the records as well but I cant figure it out. When I hit Export it does prom,pt me to save the file and saves the Names above to excel sheet but none of the records.
View 5 Replies
Apr 29, 2010
this is my problem: i've some data in an access database, i collect this data from the table and when i try to record the data in the text file, with the fields separated with a "!",the registration fails, better, doesn't register all the datas that are in the table.This is the
Dim tw As TextWriter = File.AppendText(Application.StartupPath & "DStampa.csv")
Dim objDataTable As DataTable
Dim TotaleDatiStampa As String = ""
[code].....
View 19 Replies
Feb 22, 2012
I am trying to export text from the following textboxes:textbox1.textextbox2.text To a standard text file (notepad) to save the data. I want to be able to click a button, and what I type in the 2 textboxes save to this file, then I want to be able to add more values from textbox1 and textbox2 to then add to my textfile, so that I have several strings stored in the textfile.
View 2 Replies
Jan 12, 2009
I have a field that needs to be 10byts long. However, if the number does not use all 10 bytes, then it will need to have zeroes in front of it.say you have a Check number of 12345, well in the text file it would need to show up as : 0000012345..This is the code I'm currently using but when I open the text the other 5 remaining bytes are just spaces. [code]
View 8 Replies
Mar 19, 2010
i have my program and it does what i need it to do but when i export the contents of the text file it does not show the new line characters. it displays it in the text file like this all on one line
View 2 Replies
Sep 14, 2010
i am importing a csv file into my app. this is to let the users pull in info they have in excel.somehow, they have slanted apostrophes, and not tick marks. so when i open the file stream and do the import, it pulls in those characters as blank boxes (unknown char).
View 1 Replies
Sep 1, 2008
Is this possible? I upgraded to VB Express 8 and have several programs that I would like to import into VB Express 8 from VBE 5. But everything I have tried so far has not worked.....This is the first time I have imported files from one computer to another. I have tried to save the file as a zip file and unzipping it in VB 8, but that didn't seem to work.
View 4 Replies
Jan 31, 2012
I can export my radgrid to an excel file but I want to add some more info into the sheet.If it is possible, I would appreciate for a tutorial/sample code for doing a custom excel file generation.
<tel:radgrid runat="server" id="mygrid" skinid="RadGrid_Search_Standard">
<ExportSettings HideStructureColumns="true" />
</tel:radgrid>
Grid is databound with some datatable and I need to add some data to add some strings above
mygrid.MasterTableView.ExportToWord()
View 3 Replies
Jul 13, 2011
I made a program for my friend, a patient database program using VS 2010. I'm worried if my program messes up she loses all the records. Here's what I remembered doing. Maybe you guys can identify how I can fix this or you can give ideas on how to avoid the same mistake.
1. I used Visual Studio
2. I made a VB Windows Forms Application
3. I made a Service-Based Database called Database1.mdf which is a Dataset Model
4. I chose save connection string to Database1ConnectionString
[code]....
She was glad with how simple it was cause I made it with Visual Studio. Now I dunno how to export the database file from her computer/copy of program to make a backup. I dunno what to do.I know I didn't ask for anything in return but if the program messes up I'd feel bad. 1k+ records already jesus christ and the program has like 74 columns/textboxes.
View 3 Replies
Apr 7, 2010
I have a datagridview on my form with 7 columns and a variable number of rows. It's used to track stats on games (kills, deaths, assists, etc.) The way I ended up saving it was in a .xls file for the simplicity of being able to edit it in excel as well as my program. how to import the file back into the DataGridView though.
Here's the code I'm using the save the file:
VB.NET
Private Sub exportExcel(ByVal grdView As DataGridView, ByVal fileName As String, _
ByVal fileExtension As String, ByVal filePath As String)
' Choose the path, name, and extension for the Excel file
[Code]....
View 5 Replies
