I am working with Vb.net 2005 and SQL server. I have a form which has a browse option to find .txt files from my PC and display the path to a text box using the code below; [code]Now, my task is to create a button called "Export" , when clicked this button should read the dataof the text file displayed in TextBox1 and load the data to a database already created table in SQL.
View 15 Replies
I am working with Vb.net 2005 and SQL server. I have a form which has a browse option to find .txt files from my PC and display the path to a text box using the [cod]e...
View 1 RepliesI want to create a CLR on SQL Server for reading flat files (txt) line by line.
I done it like this.
Imports System
Imports System.IO
Imports System.Collections
[Code]....
Is there a way to import data from a flat file or a .txt file to a sql server table and implementing the process from vb.net??
View 1 RepliesI need to make an address book that doesnt use a database.It suppose to have [code]All information shall be stored in a structure at run time.The application should read and write to a data file.Make sure the application includes previous, next, add, save, and delete buttons.When graded by your instructor, there should be at least five entries in the address book.But the book doesnt show me how to do it and the only online stuff I can find is threw databases and nothing else. I asked the teacher and he says no database for this one, the idea is to use flat files (txt) and I have no idea how to even really start this one.[code]
View 5 RepliesI am trying to create a datagrid and export the contents to a text file using VB.NET and I am doing this inside an SSIS script task in order to automate the process to export a dynamic table to text file. I don't get any error and the files are created but the files are empty. [code]
View 2 RepliesI want to add few files into my application (through "My Project" -> Resources) And then i want to make button that exports them into folder with SaveFileDialog... In Simple Steps -> I Open The Program That I Made In Other PC -> I Press "Export Files" -> It Opens Me Save Dialog -> I Save The Files -> They Appear From The Application...
View 4 Repliesis there a way to export the whole data in one table from sql server 2008 directly using asp.net and vb.net without using datagridview to EXCEL FILE?
View 6 Repliesi want to know how to export sql server 2005 database to access through vb.net coding..no need to select n insert table one by one,just save package...
View 8 Repliesis it possible to build "vnc enabled" programs using .net?The idea would be to allow several threads of some custom program to be controlled by different persons.
View 5 RepliesI'm using VB2008 and I have a CmdButton and a Listbox. When the CmdButton is clicked, it will look for all the files contained on a fixed directory and the names of the files will be enumerated to the listbox. I have that piece working perfectly.
The question is -- after the listbox is populated with the filenames, can I select one or multiple items from the listbox and copy the actual files from the original directory to a directory that the user will specify via browse folder dialog? Maybe right click on the selected item(s) then export? Just a thought..
My application is in VS2008 and coded in Vb.net. I have my database in Sql Server 2005.I have a Database table say Table1 in My Database named Test. Now i want to export the data in Table1 to a MS-Excel(.xls) file on the click of a button. An excel file should be generated after the user clicks on the button and the generated Excel file should have the data that is present in Table1. Can anyone provide me with a link. My code is in Vb.net
View 9 RepliesI am developing an application using VS 2008/MySql and I am trying to export the crystal report on runtime using my own code. I get an error saying:
Quote:Invalid export DLL or export format.
My code is:[CODE].....
I have some code that retrieves some data from multiple tables.This works fine.Now I want the data I retrieved to ADD to an excisting table in an Access 2003 DB.
How can I achieve this.I searched this forum and google...without succes :-(
The code I use to retrieve the data from sql server 2005: Dim connection As New SqlConnection(strConnectionStringSQL)
[Code]...
I am trying to develop an app that will export a large amount of zip files all of which have the same single file in them - simply named 'dw' (with no extension). They will all be in the same directory. I want the file 'dw' to be renamed to the zip file name + .tif. (I will actually eventually need for this to use the magic number to determine if the file is a .tif or a .rtf.) I have been able to get it to cycle through, if the file is NOT renamed. I seem to run into issues when I want the file renamed. It just creates the first .tif file and thats it. I think its actually just cycling through but everything is getting that same name. For the record i am not a programmer by trade, just trying to help with something at work - thus I know the code I have peiced together probably isn't 'by the book'
Dim p As New ProcessStartInfo(ByVal unzipit As String, ByVal zipdir As String, ByVal arg As String, ByVal arg2 As String)
Dim di As System.IO.DirectoryInfo
di = New System.IO.DirectoryInfo(zipdir)
For Each diar In di.GetFiles()
[code]....
Does anyone knows how to export/extract/copy (or whatever is the right word) a file wich is added to the soulution, on the startup of a program, like somekind of installation?
View 5 RepliesI have this code for my "Scan" button: [Code] It displays the FULL PATH for the file into the ListBox1. Then I have a button called "export list of items" and I want to export only the NAMES of the files not the full path. How can I do it?
View 3 RepliesI am dealing with survey data at the moment and i am interested in extracting data of identical 5 columns from 3 excel files and then aggregate them into one excel file.below is the code im working on, fairly new to VBA so my apologies if my code doesnt make sense to you.
Sub extraction()
Dim a As Range
Dim r As Range
Dim wbSource As Workbook
Dim wbDestination As Workbook
[Code]...
i have 2 application clinet/server the server broadcast media files to client i used tcp/ip protocol the server code is work good but i have a problem in client code i need ineed someone to correct the code .iwll show where the error is in the code note: i call the class in the main form dim a as recive in the starter of the main form class to be gloable .
[Code]...
I am developing an app that will import numeric data and export it to various text files using ascii templates. I am basically converting the template file into a single string, replacing application fields in the string with {0}, {1}, etc... and adding the result into an array that is then passed to the String.Format(str_Template, Params()) to provide the final output. I have set it up so the template will use the standard VB.Net formatting syntax.
A simple template example:
{<prt_Mark>:G} {<prt_Qty>:F2} {<prt_Length>:F2} {<prt_Remarks>:G}
[code].....
Scenario: I want to develop an application.The application should be able to connect to my remote server and download data to the local disk , while downloading it should check for new files and only download the new ones simultaneously creating the required(new) folders.
Problem: I have no idea how to compare the files in the server with the ones in the local disk.How to download only the new files from the server to the local disk?
What am thinking?: I want to sync the files in the local machine with the ones in the server. I am planning to use rsync for syncing but i have no idea how to use it with ASP.NET.
I am using vs 2010 web..I want to know that:how to upload only modified files/file to server instead of upload full project.if a made a small change in a aspx file and want to see how it look like live . then vs 2010 upload each time all pages/files to server and it take time.
View 1 RepliesI'm doing a project where we are re-creating a very old system.The client wants the same base functionality and some improvements.One of the things I'm currently working on is the note-system. These are used as flags of some sort, but are also used as a comment field for some products or client profiles.In the old system you could write the text and save it like you would get in a .txt file. They want the new one to be able to do word formatting such as:
Different font sizes (Only some parts of the text)
Different font colours (Only some parts of the text)
Underlining of words
Bolding
Italics
Tab-spaces
Those are the specs they want. What I need to know is the following:
1) How do I do that?
2) Currently they store all these files on the server as text files and the database have paths that refers to each file. I want to be able to save a text file with that formatting to the HDD of the server like in the old system.
3) If possible I would like to save that text to the database with the formatting.
I am using the following code to copy files from one folder to another...
Public Shared Sub CopyFlashScriptFile(ByVal SourceDirectory As String, ByVal DestinationDirectory As String)
Try
[Code]....
Is there anyway I can programmatically stop SQL Server and copy the files, then start the server again?
I'm using a border-less form. Well when i press the Tab button the form looks like it refresh for a sec then when i click the button it looks like this ( After - Before ) url....how can i prevent it to look with that border ?
View 1 RepliesI want to create a Dicom PACS which will import and export dicom image files. At this time i am using a batch file for dicom file importer but i have nothing to export dicom files.
View 1 RepliesI have an app, which has a form. a tab is at the center of the form. the tab is a normal tab, and it has 3d style. today, I was adjusting something, and forgot what I changed. suddenly, all controls become flat style. especially, I have datagrid in the form. in the grid, one cell is a dropdownlist style. before i can change how many items to show when is clicked. now, it does not change. now, even I add a control on another form which is in the same app, the style is flat too. what can cause this? very weird.
[Code]...
I've gotten the code I posted a few weeks ago working to export a tab delimited file. ([URL]) Now, I've already converted it from tab delimited to "tilde delimited." My goal is to import this flat file created as an EDI 850 Purchase Order. My ordering system rejects the file, yet it looks identical to other working files. My thought is the encoding / format is wrong.
[Code]...
i've to insert in my project, the progressbar control, but i'd like to show it in flat style, is this possible?
View 3 RepliesI have been able to export data from a query to the xlsx file..howerver those fields which are currency in my sql server 2005 table are currency are showing up in the spreadsheet as text. The column mappings are correct when I look at it in connection manager.
Also Is there also a way to create a new worksheet each time the export is run or does the file have to be already named?
