|
You can extract the values from the excel file using following code:
Private ds As DataSet
Private myCommand As OleDbDataAdapter
Private myConnection As OleDbConnection
Private Sub FillDataSet()
myConnection = New OleDbConnection( _
"provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=E:\EmbedBday\Bday.xls; " & _
"Extended Properties=Excel 8.0;")
If Not myConnection Is Nothing Then
myCommand = New OleDbDataAdapter( _
"select * from [sheet1$A1:A35]", myConnection)
If Not myCommand Is Nothing Then
ds = New DataSet
myCommand.Fill(ds)
myConnection.Close()
End If
End If
DataGrid1.DataSource = ds
End Sub
where "Extended Properties" refers to the MSExcel version on your system which is Excel 8.0 for version higher than Excel 97(inclusive).
Lata Agrawal
|
|
|
|
|
i have coding a program that uses access database which was filled on a datagrid using oledb. my programing has a delete buttonwhen it was clicked the update button will be enabled. here is problem i have some trouble in coding update function to update the records out of the underlying datasource.(saving the changes on the access database)
any info is greatly appreciated!!!tnx
|
|
|
|
|
can i write a textfile on an ftp using vb.net? the textfile is situated on my ftp. i want that when i click on send the textfile will add my words in that textfile which is on the ftp. Can i make this happen using vb.net??
|
|
|
|
|
Sure. You have to download the file to your machine first, modify it, then upload it back to the FTP server. An FTP server caanot be used like any other filesystem. It doesn't support "random access" like your local file system.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I can't modify my textfile within the ftp then??
|
|
|
|
|
No, there is no FTP command to "append text" or similar. As stated you can download the file, access it and upload it back.
|
|
|
|
|
can download the textfile from the ftp and upload back using vb.net?? Sorry but i want to make it happen! 
|
|
|
|
|
So what are you having a problem with?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I want to make a small messanger that will recieve the text from a textfile inside my FTP. I dont know how to make this happen! Can someone tell me the coding how can i download the textfile, modify it and upload it back!  Thanks!!
|
|
|
|
|
Search the articles for "FTP". You'll find a bunch of examples, mostly in C#, but they get the concepts acrossed.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
the articles from here?? on codeproject? because i am not finding a suitable one for me! 
|
|
|
|
|
What, you want'ed it to be cut and paste and do everything exactly how you needed? It doesn't work that way. You have to read the articles and study the code to see what's going on so you can "roll your own". The articles and code samples are meant to teach techniques, not be free code snippets that work like plugin modules.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This group "LEARNVBDOTNET" is a yahoo group of close-knit individuals who are gathering together to learn VB.Net under the guidance of Bill Dennis. He uploads lessons and files periodically to the group. This is not a site which you would use in place of CODE PROJECT though. It is for individuals who want to learn with others at the same level of experience as themselves in a very personal and interactive level. It is owned and operated by Bill Dennis. I am just a member, but found it usefull enough to make me want to share it here with my fellow CODE PROJECT lovers. I am not trying to advertise a competing site at all. Check it out and you will see what I mean. 
Yahoo! Group LEARNVBDOTNET
Mark Linehan
|
|
|
|
|
get out of here if you don't like CodeProject (the best programming forum ever !! )
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
hello, i want have a messanger and i want to make the form to read the textfile every 2 seconds automatically! how can i do this? I want the textfile to be read by the form and put the words that are in the textfile into a RichBox which is situated in my form. Please help me in this!?
Adrian De Battista
|
|
|
|
|
If you want to read a text file every 2 seconds, drop a Timer on your form and set it's Interval for 2000 milliseconds. In the Tick event for the Timer, put your file reading code.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
where do i want to put the reading code? in the timer or in the formLoad? and how can I make the code?
|
|
|
|
|
Hello,
You would put the code in the Timer's Tick Event... just double click on the timer control and it should create the event for you.
To load a textfile into a richtextbox, look into the RichTextBox.Load(<parameters>) method.
I hope this helps,
Mitch
My sig:
"And it is a professional faux pas to pay someone else to destroy your computer when you are perfectly capable of destroying it yourself." - Roger Wright
Get Perpendicular! (Hitachi Storage)
My CodeProject Blog
Most recent blog post: April 11
|
|
|
|
|
Hi
I am a newbi ish at visal basic .net, i have some experiance with simple programs but am not too up to date and i have a couple of questions:
I am a web developer and use apache installed on my computer to develop within, it is start/stopped using command line calls to the apache.exe program (-k start, -k stop) is it possible for me to make a program which will start / stop these services as i do not want them running all the time.
Ideally i would like to use one of the shortcut buttons on my laptops keyboard to start a program which will toggle the status of the server, so i will need to know if the servie is running.
Thats about it, at the moment i do not have vb.net installed on my laptop, but i have exams tomorrow and after them i will have a day or so to play and it would be great to have a working program ASAP
Many thanks to all replies,
- Martyn
|
|
|
|
|
One key question is this: Are you running apache for linux or for windows?
With linux you can create a shell script that can do what your asking.
|
|
|
|
|
Windows, otherwise i would use a bash script.
I need certain softwares which do not have a linux equivalent, so am forced to use windows.
|
|
|
|
|
You can write a batch file that can accomplish this task. Use one for turning on and one for turning off.
Trying to keep it simple.......
Apache.exe -K start
apache.exe -K stop
|
|
|
|
|
I have a customer that has over 3000 photos and they need to be accessable inside the UI.
MY question is how is it that i can get thoses photos into the database with manually writing each record?
Is there a insert statement that i can use?
Pleae help;)!
|
|
|
|
|
You'll have to write a little application to import these pic's into the database. There is no INSERT statement that will do it for you automatically.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am trying to create an autocomplete combobox that can be readonly. My problem is with my autocomplete handler, not properly selecting the text. If I type slow, I have no problems, however, if I type fast, the selection does not work correctly; the "auto-completed" text is not selected properly. Please Help!
Autocomplete code:
<br />
Private Sub CompletionCombo_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyUp<br />
Dim sTypedText As String<br />
Dim iFoundIndex As Integer<br />
Dim oFoundItem As Object<br />
Dim sFoundText As String<br />
Dim sAppendText As String<br />
<br />
If Me.Items.Count > 0 Then<br />
'Allow select keys without Autocompleting<br />
Select Case e.KeyCode<br />
Case Keys.Back, Keys.Left, Keys.Right, Keys.Up, Keys.Delete, Keys.Down, Keys.ControlKey, Keys.ShiftKey, Keys.Alt, Keys.ShiftKey, Keys.MButton, Keys.LButton, Keys.RButton, Keys.Home, Keys.End<br />
'e.Handled = False<br />
Exit Sub<br />
End Select<br />
<br />
'Get the Typed Text and Find it in the list<br />
If Me.Text.Length > 0 And Me.Text.Length <> Me.SelectedText.Length Then<br />
sTypedText = Me.Text<br />
iFoundIndex = Me.FindString(sTypedText)<br />
<br />
'If we found the Typed Text in the list then Autocomplete<br />
If iFoundIndex >= 0 Then<br />
'Get the Item from the list (Return Type depends if Datasource was bound <br />
' or List Created)<br />
oFoundItem = Me.Items(iFoundIndex)<br />
<br />
'Use the ListControl.GetItemText to resolve the Name in case the Combo <br />
' was Data bound<br />
sFoundText = Me.GetItemText(oFoundItem)<br />
<br />
'Append then found text to the typed text to preserve case<br />
sAppendText = sFoundText.Substring(sTypedText.Length)<br />
Me.Text = sTypedText & sAppendText<br />
<br />
'Select the Appended Text<br />
Me.SelectionStart = sTypedText.Length<br />
Me.SelectionLength = sAppendText.Length<br />
'Me.SelectedIndex = iFoundIndex<br />
End If<br />
End If<br />
End If<br />
End Sub<br />
<br />
Private Sub CompletionCombo_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Leave<br />
Dim iFoundIndex As Integer<br />
<br />
If Me.Items.Count > 0 Then<br />
Dim sFoundText As String = ""<br />
If Me.SelectedText.Length <> Me.Text.Length Then<br />
sFoundText = Me.Text.Substring(Me.SelectedText.Length, Me.Text.Length - Me.SelectedText.Length)<br />
End If<br />
If sFoundText.Length > 0 Then<br />
iFoundIndex = Me.FindString(Me.Text)<br />
<br />
Me.SelectedIndex = iFoundIndex<br />
End If<br />
End If<br />
<br />
End Sub<br />
Thanks,
Jake
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
