|
how to read data from excel file and save results to sql table
platform is vb.net for windows forms
|
|
|
|
|
Just create an oledb connection to excel sheet and read data either using data adapter or data reader and then fill the desired data to the sql using another sqlconnection. i think this my help
|
|
|
|
|
how to read data from excel file and save results to sql table
|
|
|
|
|
If you are working with Sql Server 2000 by using the enterprise manager we have to import the excel file data into the sql server.
|
|
|
|
|
hi!
I write this code
Dim grfx As Graphics = CreateGraphics()
in class, but class draw under the CreateGraphics()
how do class get to know CreateGraphics()?
urgently help mi?
thank you![Smile | :)](https://codeproject.global.ssl.fastly.net/script/Forums/Images/smiley_smile.gif)
|
|
|
|
|
ela_85 wrote: Dim grfx As Graphics = CreateGraphics()
in class, but class draw under the CreateGraphics()
how do class get to know CreateGraphics()?
urgently help mi?
That doesn't make any sense. Could you rewrite your request?
|
|
|
|
|
I think what your asking is how does it know what graphics to create? If so the answer is, because you are likely using a subclass of a control...like a form, or a button, or something along those lines...the Base class knows how to create its own graphics and when you call CreateGraphics() you are really calling Me.CreateGraphics() which would be your base class implementation of CreateGrapics unless you have overriden it.
In short, Microsoft designed controls that know how to draw themseleves, your just tying into that.
Pablo
Sometimes I think there's no reason to get out of bed . . . then I feel wet, and I realize there is.
|
|
|
|
|
I was trying to use Windows API calls from VB6 programs,
While those programs are running, there seems to be a hugh delay when tryning to open Word, or Excl files.
This is very conatant phenomena: every time one or more of the programs is running,
the open time goes from 1 sec to 10 and even about 30 sec.
Kill the offending process gets the lag back to about 1 sec.
Seems that API wait calls are not compatible with the VB runtime on XP SP/2.
Any ideas?
Example 1:
==========
I was trying to write a VB6 based Service. The following code should be paste into a module (no form)
(Based on a service example)
'-------------------------------------------- Start of code ------------------------------
Public Const INFINITE = &HFFFF ' Infinite timeout
Public Declare Function CreateEvent Lib "kernel32" Alias "CreateEventA" (ByVal lpEventAttributes As Long, ByVal bManualReset As Long,
ByVal bInitialState As Long, ByVal lpName As String) As Long
Public Declare Function WaitForSingleObject Lib "kernel32" (ByVal hHandle As Long, ByVal dwMilliseconds As Long) As Long
Private Sub Main()
Dim hEvent As Long
hEvent = CreateEvent(0, 1, 0, vbNullString)
WaitForSingleObject hEvent, INFINITE
End Sub
'-------------------------------------------- End of code ------------------------------
Example 2:
==========
Open a new VB6 project, paste the attached to the form, run it, and try to open any WORD file.
(I converted this to run as a timer, and it seems OK, but I'd like to know why it is so WRONG?)
'-------------------------------------------- Start ot code ------------------------------
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMillseconds As Long)
Private Sub Form_Load()
Do While (True)
DoEvents
Sleep 1000
Loop
End Sub
'-------------------------------------------- End of code ------------------------------
![Confused | :confused:](https://codeproject.global.ssl.fastly.net/script/Forums/Images/smiley_confused.gif)
|
|
|
|
|
Hi all,
I want to record the browser events (like a user fills up a form over the internet). I want to record that using macros in vb.net. Anybody having some idea?
Thanks in advance
|
|
|
|
|
There are no such macros in VB.NET. You can't record what's going on in another application without writing some kind of application to do it. Probably using the Windows CBT Hook API's.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks Dave
I dont have any idea about these Windows CBT Hook API's. I searched a lot over the net bt all in vein. I think i should be more specific about what is needed? Actually i just want to record whatever user does with web page for example it should be able to record all the textboxes which a user fills on a webpage and should be able to generate some script (vbscript) accordingly.
|
|
|
|
|
The answer doesn't change. There is nothing that "records" what the user does, short of using the Windows CBT Hook. CBT stands for Computer Based Training. The hook calls your application before activating, creating, destroying, minimizing, maximizing, moving, or sizing a window; before completing a system command; before removing a mouse or keyboard event from the system message queue; before setting the input focus; or before synchronizing with the system message queue. Essentially, you get all the window, mouse, and keyboard messages before they are processed, enabling you to record them if you want.
The down side is that this is a complicated API to use and you MUST have an in-depth knowledge of how Windows works if you expect to use this API properly.
Documentation[^] on the CBTProc callback.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks Dave for your kind help, I'll go thru the documentation, once again thanks a lot
|
|
|
|
|
help guys... how can i store the .wmv file in ms access - database???
thanks!!!
|
|
|
|
|
hi,
i need to use split() but i need to split string depends on complete word such as "welcome" and i put split("welcome") but the problem that the string include just three welcome but it gave me more that 60 when i asked
lines.length-1
and when i but instead of welcome "w" letter and used split("w") it gave me the wanted value which is 3
i dont know why , i need to split whole word please help me
kilany
|
|
|
|
|
It looks like VB is "helpful" here, and automatically converts your string to an array of characters, so that you are splitting on any of the characters in the string, not the whole string.
Put the string in an array of strings and use the array in the call to Split.
If you only want to count the occurances, a Regex is better suited for this.
---
b { font-weight: normal; }
|
|
|
|
|
Hello !
I've been trying to rename accounts in Active Directory.
Where I can easily modify sn, givenName, UserPrincipalName, samAccountName or DisplayName, I can't figure a way to modify the cn.
Is there a way to modify a cn ?
I always get an error -2147016682 / 0x80072016.
The same applies to distinguishedName or canonicalName. No idea if they can be modified. If I try I get a constraint violation -2147016654 / 0x8007202f.
Do I have to clone the account with the new name ? or is there an obvious way to do that ?
I'm not too sure this belongs to the VB section of the boards but couldn't figure where to put it.
Thanks a lot !!
|
|
|
|
|
|
Hi,
I am Jats.I have a requirement in my project to connect to various Search engines no net & find out the plagiarism in the particular sentence or a file.
I am thinking to devl. a software(vb.net) which can connect to various search engines & search for plagiarism's in the text inputted.
I am not able to figure out how to connect my application to search engine and how to pass the text to the search engine.
Can any one plz help regarding this. Any links or suggestions.
Plz help...
Jats
|
|
|
|
|
I think you're gonna have one helluva time with this one.
I think your best bet for trying to achieve something like this is to use Google search API's. Here are two links that may help.
SOAP Search API[^]and look for Google Search Appliance API's halfway down this[^] page.
|
|
|
|
|
I want to store Images as OLE Object in Access OLE Object Field using ADO as database accessing object in VB6. What code will be useful to solve the task?
Kiran Sajanikar
Software Engineer
CleverBIT softwares.
Pune.
|
|
|
|
|
What does Google tell you with this as the search string?
store Images as OLE Object in Access OLE Object Field
Shreekar
http://shreekarishere.blogspot.com
|
|
|
|
|
|
Private Sub grd_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles grd.KeyDown
If e.KeyCode = Keys.Return Then
'do something
ElseIf e.KeyCode = Keys.Escape Then
'do something
ElseIf e.KeyCode = Keys.Right Then
'do something
ElseIf e.KeyCode = Keys.Left Then
'do something
ElseIf e.KeyCode = Keys.Up Then
'do something
ElseIf e.KeyCode = Keys.Down Then
'do something
End If
End Sub
hope this helps...
nathan
|
|
|
|
|