I coded in it along time ago, back in middle of the 90's, but not heavily, so I don't remember that much, and never really worked with databases or file import/export. I'm trying to write code in to take my table or recordset thats active and export it to a XLS file.
[Code]...
I am trying to write a program that deletes temp files from my entire c drive. windows 7 will not allow any file manipulation. access denied . everything works fine in windows xp. what needs to be changed in my code to allow anyone to install this program on their computer and run it without errors like this. I need to change my code to correct this not windows 7, as other people will be installing this on their systems and they can't be setting their c drives. every answer i've found online is either to change c drive to have no security or set the code to demand uac to run as administrator(which doesn't work )
View 7 Replieswhat I am trying to do is i have a table with four records and I want to write it to a txt file. I am running sql server 2000.I am able to connect to my database and I am able to right data to a txt file my only problem is it always returns the 1st row of data.
Dim FILE_NAME As String = "C: emp est2.txt"
Dim conn As New SqlClient.SqlConnection
Dim da As New SqlClient.SqlDataAdapter
[code]....
I am looking for some code to help me backup up my table data to a text file using vb.net, I just want to write all the rows in the table to the text file.
View 1 Repliesthis code get the data from the sql where the name = @word which is the variablecontaining the word to search for my problem is i want to check all the table columns not only one column ? is it doable ?
Public Function Search(ByVal word As String) As DataTable
Dim Dt As New DataTable
Dim Adp As New SqlDataAdapter
[code].....
do i clear and entire database through the program?
View 11 Repliesstore entire xml document using vb.net in a sql 2005 table
View 5 RepliesI am designing an clock-in/clock-out program as a learning exercise. So far I can type the name of an employee and add them to my timeclock database in a row called "EMPNAME". The issue I'm having now is that I need each of those employees in column of EMPNAME to appear in a combobox when I hit "GET LIST". Is there a simple way to do this using a SELECT statement for the commandtext? I've tried to google but cant find exactly what im looking for.
[Code]...
How do i read information from a mysql server and write all info on table name links to a file?
View 3 RepliesI have created several different colored 6 x 9 pixel rectangles (with a white border). I'm placing these rectangles on a large map, based on x y location and color code from a database. As I'm building the database, I occasionally run the program using the Debug in VB Express just to make sure everything is being place in the right location. I started getting an error when my rectangle count got up around 4500.
System.ArgumentException was unhandled
Message="Parameter is not valid."
Source="System.Drawing"
The release .exe works fine with no errors and a count of 6700 ... so far. As it is now it's taking near 60 seconds to place the 6700, and I'll eventually have 10,000 plus. (P4 3.20 GHz - 1 GB Ram). I'm placing each rectangle on the image as I read a row of data. Would it be beneficial to read the entire table into and array and then plot the rectangle?Would I be better off drawing each rectangle as needed or placing a my pre-drawn rectangle ?
I have a column in the table with datatype xml.
how can i store the entire xml document in that column using vb.net?
Is there any way to create a button which basically clears a entire table in your database?
I was hoping to have 2 buttons, 1 to empty a table 1 to fill the same table again.The idea is to store a year long values, and at the end of the year delete all of those with a button.The other button i want to use to fill the same table again.Starting from 1st day of the year untill the last day of the year.
Reading a .txt file in VB.net. My file path is C:UsersMyLilMulePepeDocumentsVisual Studio 2008Projectscurtain_calls.txt.
This is my line of Dim LoanOptionsFile As String = "C:UsersMyLilMulePepeDocumentsVisual Studio 2008Projectscurtain_calls.txt"
I can read the file when I run the program, but how do I write the file path so that someone else can download my program and file and read the file on their system?
how can i manually iterate through an entire datatable record by record, but only moving to next record after clicking a button. am using vb 2008 express and below is the code i wrote: Private Sub STARTButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles STARTButton.Click
Dim RealName As String
Dim UserName As String
Dim PASSWORD As String
[code].....
What i am trying to do is open a save file dialog and write to a .txt firl the contents of my listview. so far:
[Code]...
i have this, but i'm not to sure how to write to the .txt file i know i need to use a for each to loop the contents of the list view
I have a text file and I want to take the data from the text file and write each line into the excel file (into the same column). How do I accomplish this? I know how to read data from a text file, but I don't know how to insert the data to a excel file..
View 5 RepliesDoes anyone have any ideas on how to create the code that will write the files in a specified folder as lines in a new csv file? I am stuck on this. i saw negative0's post a while back [URL].., but I cannot get the the types to work even after adding the reference. I can't seem to find those commands in VB2008.
View 6 RepliesI am trying to make a program in which i can configure it to write data into a .reg file, This data will be stuff such as "Open In Notepad" code, its to make a simple program, Where you press a button, It loads a save dialog, You choose name etc, Then it saves the data (Which had gaps in it, Im not sure if this matters), as a .reg file, so it can be loaded into the registry, Or even better, Write to the registry instead of saving it, How is this possible?
View 10 Repliesi have been working on a GUI to export verification data to a text file. I have it set up to work at home but I would like to adapt the code so that it will write the text file to the directory that I use at work also. I have the areas commented out where things that I have attempted do not work.
[Code]...
How do I
1. Create text file
2. Write text to text file
3. Save
I have an INI file built like this:
[registration]
key=<key goes here>
passkey=<passkey here>
and using a registration system (found in codebank here), I'd validate it like that. I just need to know how to read and write from it. All the ones on google are too vague, or focus on the wrong part.
get the whole and same content of any file i uploaded, for my editing purposes in my editor w/c retrieves file from the database. i.e of files are ".doc and .txt"and by the way what i meant by same content is the whole same appearance of my .doc or .txt file i.e "if the text is bold, forecolor is red and etc.."
i successfully established a file upload and a function to store it in a database... but what i'm missing is the whole and same content of the file. Another thing is i don't want the file to be saved in a local folder or somewhere..i just want it to be save directly to my database Below is my sample code of trying to retrieve the content.. but it is an error when you run..
Private Sub cmdSave_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If filMyFile.PostedFile IsNot Nothing Then
Dim fs As FileStream
[code]....
nLog for .NET has the capability to send log entries as email. But if we want to send the entire current log file, how can it be done, short of reading the log file into a string and passing that as an nLog {$message}? I don't see that nLog has a property in its mailtarget for attachments.
View 1 RepliesMy XML file looks like this:
<?xml version="1.0" encoding="utf-8" ?>
<Tabel>
<Member>
[Code]....
When more nodes are added, how can I get the value in the <Naam> tags to be added into a listbox?
Note: there isn't a fixed amount of <Member> nodes and they all have to have their <Naam> elements added into the listbox.
Is it possible to encrypt the whole app.config file rather than encrypting any particular section of the config file using VB.Net ?
View 1 RepliesUsing the Microsoft VB 2008 Express program, I'm making a SWd20 character sheet (D&D) to be distributed to a few friends. It's a program where the user can figure out stats, species, class, etc without having to make any calculations him/herself.. but this will all be in vain without saving it..
So I'd love to know how I could make it so the user can save and load the entire file(including buttons, labels, text boxes, menu strips, possibly multiple forms, etc) on his/her own computer.. Is this possible, and if so, how can I go about this?
I've already searched through and found lots on saving text in the files to .txt files, but that doesn't cover everything I need
Is it possible to store entire CookieContainer in a file and then retrieve it when needed?
View 5 RepliesI'm having an issue with the streamreader. I had it working but I've changed something and it has stopped.
I have it in a Do While loop reading line by line, but it doesn't finish reading. It reads about 27 lines out of 4000, then stops.
I changed the contents of the file it was reading, but it's still just save as a txt notepad file.
I also changed how I tell it which file to open (UserSelection.T2) however it does open the file just doesn't finish reading it.
Doesn't kick back any errors, it just doesn't read the entire file.
Dim FSO As Object
Dim File As Object
FSO = CreateObject("Scripting.FileSystemObject")
[Code].....
I'm trying to write out a date like this 09-16-2008 so I can put the date in the name of a directory. Here is my code:
Code:
Dim aDate As Date
aDate = Date.Today
aDate.ToString("MM dd yyyy")
[Code].....
I can't seem to get the leading 0 in front of the month if it's a single digit. I can't get rid of the time, and I can't get the dashes.
I have an integer and a button.After clicking on the button, the integer value would be for example 10.Then how could I store that value 10 into the memory, and when I click the button again, the new integer value now is 5. I'd like to add up the old and new value together and write it to a text file.
View 2 Replies
