due to folder size limitation in Outlook/Exchange I must archive older mails on disk as *.msg files. So I am still able to search for <TEXT> in explorer.
I create the *.msg files by drag&drop a bunch of mails from the Outlook folder to the disk folder. Unfortunately the changed-at date displayed in explorer is the date of the file creation and not the sent-date as displayed in Outlook.
I know how to change the changed-at date using SetFileTime but I don't know how to extract the sent-date from the .msg file to use it.
My question is: how can I open (in VBA) a .msg file and extract the sent date of the mail?
I am trying to programitally download a file from a https server, that uses cookies (and hence I'm using httpwebrequest). I'm debug printing the capacity of the streams to check, but the output [raw] files look different. Have tried other encoding to no avail.
Code: Sub downloadzip(strURL As String, strDestDir As String) Dim request As HttpWebRequest Dim response As HttpWebResponse request = Net.HttpWebRequest.Create(strURL) request.UserAgent = strUserAgent [Code].....
So I get the right size file downloaded, but dotnetzip does not recognise it, and the files that get copied out are incomplete/invalid zips.
i m working on the project like retrieving the data from the tally using our vb application and store the data in database. i have fetched the xml tags from my vb application to the tally by sql query. now my question is how to extract the data stored in between the tags using vb,.. and store in database.. i need the procedure and the code.
Can anyone explain with program how to extract the serial number or unique ID of the hard disk. i need a clear explained program. i m using some tools but i couldn't really understand how they do it.
VB.net seem to place my database file into/userprofile/local settings/apps/2.0/data/random/random/appname/data/ folder.Can I define easier location for my published app. I am also worried that when upgrading this database is ignored or something bad happens?
I can't really figure out how to extract frames and what not from an animated image stored in a picturebox. I made a post earlier similar to this matter. But now I must ask how it is that you work with GetFrame and SetActiveFrame.
I am traying to use the DateTimePicker to extract days diff from a date selected on DateTimePicker1 to a date selected on DateTimePicker2. I have no problem substracting the daydiff in numbers of days. The problem I have is that I need the DateTimePicker to tell me how many of those days are weekends (friday, saturday) and how many are weekdays.
Need to design a program that can encrypt and decrypt messages stored in simple text files using a private key stored in a separate file. Software should also be able to allow the users to enter simple messages that either displays the encrypted or decrypted message. The encryption method should use a simple substitution method. It should be set out in the following format:
Example (the "@" is the separator):
@ The character The Code End of line A @ 4gh EOL B @ 84!9 EOL
Has to use the 256 ASCII character codes. The separator will be used to separate the character and its corresponding code.Here are the pseudocodes I have come up with:
� Read any private key file separator = readline(file); while not EOF(file) do tempStr = readline(file);
I have a sql query which extract a field of datatype smalldatetime. I read this field using datareader, convert it to string and store it in a string variable.I get the string as 1/1/2012 12:00:00 AM ,here i want to use only date part of this string and i have nothing to do with the time.How can i cut only the date from the string and get the output as 1/1/2012?
I have a variable stored in db which is created when a new person is added it takes the day of todaysDate on the day they register and stores only the day
I would like to use this date as the same day of every month the user is due
i.e dueDate actualDate
so if the user joined on the 20/02/2010 and then makes a payment on the 25/03/2010
I want to be able to add 20/03/2010 to the dueDate and 25/03/2010 as the actualDate
I can get the stored day querying the db how would I then add the current month and year to that date
I want to execute a method on VB.Net to return a date which is in the stored procedure. I tried using ExecuteScalar but it doesnt work it retruns error
'Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query'
below is the code
Public Function GetHolidaydate(ByVal struserID as String) As DateTime Dim objArgs1 As New clsSQLStoredProcedureParams objArgs1.Add("@userID", Me.Tag)
I have a quick Questiom On a ASP.net form, I need to add a textbox to update a date field in MS SQL server via stored procedure. Using a text box datemissed
The following gives me an error when I try to open an Excel file if the value of lblFileName is different than the file on disk by differences of upper or lowercase letters.
how data is stored in a DB vs how it is displayed in a DataGridView, but i cant come up with a solution to my problem ...I have a DGV being filled by a Datatable. I have set the DGV Date column to format as "yyyy-MM-dd" and it shows that accordingly.
I also have a sub that USED to take the DataTable that filled the DGV and used it to generate a CSV file. But since i had modified how the date was displayed in the DGV i decided to change the CSV Export to use the DGV instead of the DataTable.
Dim writer As System.IO.StreamWriter writer = File.CreateText(PathToSaveFile) For intRows As Integer = 0 To DGV.Rows.Count - 1
[code]....
My issue is that even though i changed the VIEW in the DGV to show me the date how i want it, the CSV does not take the displayed date when it writes the lines, it seems to still take the DB date, and then displays it as "dd/MM/yyyy". how am i supposed to tell the CSV Sub to change how the date is displayed in this file ?
My application is asp.net with vb. In my page I have a textbox for passing date. If I didn't enter date and on clicking submit, I have to pass null value to the stored procedure. I tried following codes such as DBNull.Value and DateTime.MinValue. In that case instead of null ,"#12:00:00#" is passing. I have to pass Null.
Actually I have datetime value stored in the database. What I am taking from the textbox is a time value. I want to extract those results from the database which are between the given time value....To be more concise, my application is a booking system for a sports club and provides an option to view alreaady made bookings.. Here i offer two options either to view all bookings for a specific game or to filter bookings. In filter bookings one option is to filter through date and time...Date option is running okay but problem lies in time part...I provide two times but unable to view bookings between them...
My code is:
Dim prmtimefrom As New SqlParameter("@booking_time", SqlDbType.DateTime) prmtimefrom.Value = TextBox3.Text Dim prmtimeto As New SqlParameter("@booking_tim", SqlDbType.DateTime)
Deleting a file is one of the controversial matters of computing. When a user deletes a file (removing it also from the Recycle Bin), they assume that the file is indeed deleted. However, what happens is that only the reference to that file is deleted, so the system can no longer remember where the file is located, but the file itself is very much intact.
I am looking for a way to delete a file permanently, the way e.g. the application Wipefile would do it, by applying successive overwrites (up to 30) over the actual position of the file on the disk. There must be a way to do this through code (I just presented an example that this has indeed been done ), so I'd like to know how to do it.
I'm using XamlWriter, XML Transform (with XSLCompiledTransform), and XamlReader to create deep copies of a user control with multiple user controls and lots of inheritance. I have it working and am using it in my Print and Print Preview logic. The problem is that it's SLOW and I need to speed it up. Currently when the user selects Print Preview it takes about three seconds for the view to display. I need to reduce this to less than one second!
I am trying to make a little app and I have a problem regarding embeded resources.I have added a dll file to my app resources and now I am trying to get that file back and write it to disk in a specific folder.
My application uses structures that contain strings and arrays that I want to write to disk. I understand that I can create the fixed length data types in the structures by using "ReDim" and "String$", but my question is: Does VB reallocate the storage for the structure which includes these redimensioned members in-line (which would be necessary in order to write the contents to disk), or does it allocate heap and merely store a pointer in the structure?If only a pointer is provided, is there a straightforward workaround to allow me to create fixed length data types in a structure that could be written to a disk file?Or, Is there an I/O method that will handle the situation by recreating a contiguous buffer containing the structure before writing it to disk?
After I ran a disk-cleanup (in my case AVG PC-TuneUp), the loading of my VB.net project gave error on a missing file.Changing the build-configuration (DEBUG->RELEASE->DEBUG) would recreate the file and all is OK. But I have basic configuration-info for the build, maybe in more complex cases some important details could be lost when the file gets deleted.I would think an information as critical as that, would be placed in the project folder, or be part of one of the many files that make up the project, but not in the temp-folder.
I'm developing a winform application. I want to take input from user (i.e. the user provides username) and use that input as part of filename and save to file.How do I check if the username provided by the user didn't contain windows' reserved characters. And what is the list of reserved characters for windows?
I am using BinaryWriter class to write a binary file to disk. When I invoke the Write method, passing an unsigned short value, it writes it in little-endian format. For example:
bw.Write(0xA000);
writes the value in the binary file as 0x00 0xA0. Is there a way to make BInaryWriter use Big Endian? If not, is it possible to create a new class, inheriting BinaryWriter and overload the Write function to make it write big endian?
I have a mySQL table(IMP_SCANS) holding the file, it's name and size for every document:
scan_1 blob description varchar filesize int doc_no varchar doc_date date
I managed to insert a file to the table. Now I need to save the file to disk.
So I have the code:
Dim conn As New MySqlConnection Dim cmd As New MySqlCommand Dim myData As MySqlDataReader Dim SQL As String Dim FileSize As UInt32 Dim fs As FileStream
[CODE]............
I all works fine up to the line: myData.GetBytes(myData.GetOrdinal("scan_1"), 0, rawData, 0, filesize) Where it says "Object reference not set to an instance of an object". I cannot figure out why I receive this error.
