|
Try replacing dtgCustomSched.Item(row,2) with a literal string that represents a time. Something like "12:29:01". That should certainly work. Once you've verified that try using a string variable to hold the date instead of using dtgCustomSched.Item(row,2) directly. So simply assign that value to a string and then in the ParseExact line use the string variable instead. Worth a shot I guess. If that doesn't work then go back and double and triple check the string your getting from the DB. Are you sure there aren't any other characters in it that you don't want. A space? Some sort of linefeed character or something silly like that? Basically if the string isn't 8 characters long then something isn't right. In fact try using the string.length function to verify it's length.
If you still can't get it I'd try another method. Do as christian said and use the string.split function to parse the numbers out of the string. Once you've got the individual hours, minutes, and seconds you should be able to pass those to the constructor of the date class to create your date object.
|
|
|
|
|
I would like to know how to use a button to open and existing Excel file and just view it.
|
|
|
|
|
|
hello MidwestLimey,
try out following ex..
Dim excel As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
Try
excel = New Microsoft.Office.Interop.Excel.Application
wb = excel.Workbooks.Open("c:\\test.xls")
excel.Visible = True
wb.Activate()
Catch ex As COMException
MessageBox.Show("Error accessing Excel: " + ex.ToString())
Catch ex As Exception
MessageBox.Show("Error: " + ex.ToString())
End Try
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
i am using vb.net 2003.i do my project in windows application.i want to send a mail from vb.net windows application.plz help me.
|
|
|
|
|
Google it[^], for the great Sage that is google has many answers to your question.
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Hi,
Is there any way to re-order childs of same parent. Consider example as,
A
---1
---2
---3
Using drag drop I need to change this child order as,
A
---2
---1
---3
Any luck.
Be simple and Be sample.
|
|
|
|
|
Have you looked at this[^] example? It should you what you have to do to support doing this.
|
|
|
|
|
I'm trying to give the user a chance to confirm the userdeletingrows event after the event starts,but before the datagridview row is actually deleted.
I can not seam to quit the event without deleting the row.
I can bring up a message box and run branching logic, but I'm not sure what command will prevent the row from being deleted.
Any ideas?
Kermit888
|
|
|
|
|
Hi, I have some problem while designing a windows form application in vs 2005 pro edition. The problem occure while I drag a data grid on the form and create the column for the data grid manually.
When I run an application, an error display and told me that there is a conflic name in the designer. I do not know the real error but the column that I create in the grid named: Code, Name, Strength, Form...
When I return to the designer I found my form disappear and just display some error in the designer page. I do not know how to fix it while vs 2005 do not allow me to see my form and change the property of the control.
On the other hand, VS should inform me if there name of the column is matched with the keyword using in VS. I really feel disappoint while I challenge this problem and could not find the solution.
Does anyone have any idea about this problem? Please help me to find the solution.
Thank in Advance!!!
|
|
|
|
|
Post the error.
Tom Wright
tawright915@gmail.com
|
|
|
|
|
It because you used "Name" as column name
Try change the column name "Name" to example "Customer Name" or other name
|
|
|
|
|
Thank you very much for your help. So, how could I prevent in the future to avoid duplicate keyword with vb.net 2005?
|
|
|
|
|
I think you should read or search about vb.net keyword
GoodID
|
|
|
|
|
Thank you very much for your solution.
|
|
|
|
|
Hi, I used visual studio .net 2005 standard edition in my laptop. Vs 2005 standard do not have crystal report integrated with. So I plan to purchase crystal report v11 pro edition.
My question is, if i install crystal report v11 pro edition on my laptop, could I design a report in crystal report and integrate it with my application design in vs.net 2005 standard edition?
Thank in advance!!!
|
|
|
|
|
hi, anyone can help me figure out how to read data from a text file like this:
10980012907200228082002
and extract the data according to this kind of format:
Record type 1
TY-RECORD PIC (1).
ID-PARTICIPANT PIC (6).
DT-START PIC (8).
DT-END PIC (8).
the data can be read as ty-record = 1, id-participant = 98001, dt-start = 29072002, and dt-end = 28082002. i would want the program to extract the data and display them in a table according to their respective fields:
TY-RECORD ID-PARTICIPANT DT-START DT-END
1 098001 29072002 28082002
and to save them in an excel format. I have plenty of record types (0 - 9) and need to display them in separate tables.
does anyone has a source code for this? or at least somebody pls guide me to figure out ways to create the program.
many thanks!
|
|
|
|
|
you can read each line and replace the space with a comma, and Excel will just open it. To have multiple tables, you need to look into the visual studio tools for office.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi all
Can any one help me about how (Cut and paste files and folders from clipboard )
and i will be very thankful to everyone help me
|
|
|
|
|
can you explain some more what exactly you wanted to do ?
|
|
|
|
|
hi,
i create text file through following code
here argument FilePath contain full path of file and Data contains Contents which has been written to text file. if file already exist then it add data to previous contents of file otherwise it create a new text file
<br />
Private Sub CreateTextFile(ByVal FilePath As String, ByVal data As String)<br />
Dim oFile As System.IO.File<br />
Dim oWrite As System.IO.StreamWriter<br />
Dim oRead As System.IO.StreamReader<br />
Dim PreviousData As String = ""<br />
Dim CheckHypen As String<br />
<br />
If File.Exists(FilePath) Then<br />
oRead = oFile.OpenText(FilePath)<br />
While oRead.Peek <> -1<br />
If PreviousData = "" Then<br />
PreviousData = oRead.ReadLine()<br />
Else<br />
<br />
PreviousData = PreviousData & ControlChars.NewLine & oRead.ReadLine()<br />
<br />
End If<br />
End While<br />
oRead.Close()<br />
End If<br />
<br />
<br />
oWrite = oFile.CreateText(FilePath)<br />
<br />
If PreviousData = "" Then<br />
oWrite.WriteLine(data)<br />
Else<br />
oWrite.WriteLine(PreviousData & ControlChars.NewLine & data)<br />
End If<br />
oWrite.Close()<br />
<br />
End Sub
i don't specify encoding format . some time text file is created with ANSI encoding format and sometime UTF-8 encoding format(dependent upon content). my problem is that i strictly create file as ANSI encoding.how it is possible?
How can i set text file Encoding format to ANSI?
any help will be appreciated.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Following one line will do the all above mentioned task including appending and all ...
My.Computer.FileSystem.WriteAllText("c:\x.txt", ControlChars.NewLine & "あだsだsd", True, System.Text.Encoding.Default)
Third parameter "True" specifies appending and fourth parameter specifies ANSI depending upon ur systems ANSI code page.
|
|
|
|
|
hi prasad,
thanks for your support. i recently find method (AppendAllText) on internet during searching.i want to ask one more thing
what is the difference between My.Computer.FileSystem.WriteAllText and AppendAllText method(of system.io.file object)
can i use AppendAllText method ?
thanks in advance
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Hi Rupesh,
Ofcource you can use it. Methods in My.Computer.FileSystem provides easy to use wrapper function to use the functionality implimented in System.Io.File.
Regards
Prasad
|
|
|
|
|
Thanks a lot
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|