|
Newbie here again. I need to be able to take data that is in a txt file and import into a table. My senario is, I have 6 txt files that need to be imported/inserted into tables of the same name. The data in the files look like this- "data", "data", and so on. I am using vb.net and my sql server is 2000. How do I go about doing this? Keep in mind that I have no training and am just starting to learn this stuff. Thanks.
|
|
|
|
|
The text files you are describing sound like what are known as 'csv' files (comma separated values), so I suggest that you look at this[^] blog, for solutions.
If you do not understand it, or it simply does not fit your scenario then Google for sql server csv files, which is how I found that link. There are loads of hits, work your way through them till you find one that suits. 
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi guys,
I am writing (trying to write) a program in VBA for Excel 2003 and I got stuck. I need your help please.
I have an excel range where the upmost cell is initially fixed and the downmost cell moves down as more data arrive.
I have something like WorkRange = Range((1,1), (LastRow.Row,1)).
That range contains integers. I call LastValue.value the value of the integer in cell (LastRow.Row,1).
Over this range I calculate the maximum value (MaxVal.Value) and the difference between LastValue.Value and MaxVal.Value.
So far it's (almost) easy, even for me.
The problem is, when the difference between LastValue and MaxVal satisfies a certain condition ( ie LastValue-MaxValue=z; z=constant) I need to move down the upmost cell in the WorkRange, so that it is set to coincide with the cell where the MaxVal is.
After that the program should me made to loop.
Normally the data series would be 40k rows long, but it could get 500k rows long I am afraid.
IN THEORY I have an idea of how I can solve this problem but I do not know how to do it practically with VBA.
I thought that maybe I could define the upmost cell of the WorkRange as a Cell-object.
For example I could call it StartCell1. The WorkRange would then be:
WorkRange=Range(StartCell1,(LastRow.Row,1)).
StartCell1 would be the first cell where I have data.
When condition ( LastValue.Value-MaxValue.Value=z) is satisfied I could write the program to create a Cell-object called LastCell1 that would be the first cell where the condition is satisfied.
I would also create a Cell-object called MaxVal1, that would be the cell where you find the maximum value in the range up to that point.
Finally I could also create a Range-object called WorkRange1=Range(StartCell1,LastCell1).
Done that I could create a new Cell-object, call it StartCell2 , and set it to have the same properties of Cell-object MaxVal1.
At that point the WorkRange would be WorkRange=Range(StartCell2,(LastRow.Value,1)) and I could loop the program repeating the above.
Does it make sense ?
The problem is that I have no idea on how practically do this.
I am surfing through books and the web but did not find a solution so far.
Probably my question is naive but can anybody please help ?
Thank you in advance
Frank
|
|
|
|
|
Thanks in adv.
Can Some one Tell me any way to Navigate Fast in the Properties of any control in VS (2005,2008,2010)
as in VS 2000 you can go directly to a property by pressing ctrl + shift + 1st Letter (for Name :N) will go inside the Name property.
Best of Regards,
SOFTDEV_SUP
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Not sure about that particular shortcut. But I guess this[^] link will help you out.
Plus, I think Visual Studio forum would have been a better place for this.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
hi guys... im a newbie and a student here in the philippines... i need help.. and i appreciate it in advance...
here is my problem...
i have two datagrids...
grid1 and grid2
grid1 is like a cart...
and the data needed to populate it depends on grid2
by the way grid2 is a booklist
when i select a book from grid2
i should be able to pass the data to grid1
i already populated grid2 with data...
how can i populate grid1 with data coming from grid 2?
another info...
grid1 is in frmPurchasing while grid2 is in another form frmBooklist.
I hope i made it clear.. this is for subject in database programming.
I am using Visualbasic and sql server. thanks
|
|
|
|
|
Basically, you probably have two datagrids bound to datasources, right? All you do is copy the data from one datasource to the other. That's all. I can't give you the implementation details because you haven't provided any detail about your datasources.
I can tell you you're probably going to have an issue with having these datagrids on two different forms. Unless your datasources are exposed globally (not a great idea) or both forms can get to the sources themselves, you've made this process more complicated than it needs to be.
|
|
|
|
|
Hello
Have search far and wide for something that I think should be on MSDN, but no luck. It must be something simple, but I'm not that good with FP.
Anyway, I have List(Of MyObject) that I want to filter for an auto complete box.
Currently, I do this:
NameACB.ItemFilter = New AutoCompleteFilterPredicate(Of Object)(AddressOf NameSearch)
And then have this function for it to land on:
Private Function NameSearch(ByVal search As String, ByVal value As Object) As Boolean
Dim cust As MyCustomer = TryCast(value, MyCustomer)
If cust Is Nothing Then Return False
If cust.Name.ToLower.Contains(search.ToLower) Then
Return True
Else
Return False
End If
End Function
This works fine, but to cut down on the code (and maybe learn somthing), I was trying to use a lambda expression instead. This is what I thing it should look like:
NameACB.ItemFilter = New AutoCompleteFilterPredicate(Of MyCustomer)(Function(f As MyCustomer) If(f.Name= NameACB.Text, True, False))
But this throws a compiler error that the nested function doesn't have the same signature as delegate.
modified on Friday, September 25, 2009 2:27 AM
|
|
|
|
|
Since I'm not really sure what the definition of either AutoCompleteFilterPredicate or NameACB is, I can only point out that you did this the first time:
NameACB.ItemFilter = New AutoCompleteFilterPredicate(Of Object)(...)
and this the second time:
NameACB.ItemFilter = New AutoCompleteFilterPredicate(Of MyCustomer)(...)
The problem may not be with your lambda, but may be with trying to assign a delegate with that signature to a property that expects another signature.
P.S. There's no reason to write If(f.Name = NameACB.Text, True, False) (or it's multi-line equivalent). You can just say Return (f.Name = NameACB.Text) and get the exact same thing with less code the better expresses your intent.
|
|
|
|
|
Thank you for you reply Gideon!
Reading my original message, I realise I've been a bit short.
NameACB is an AutoCompleteBox(ACB), and I have attached a List(Of MyCustomer) to
its ItemsList. Now, MyCustomer has many fields, and when in doubt, ACB
defaults to searching by the .ToString value of an object. Because of some quirks
of WCF, I can't override the .ToString method in my objects, and so I have
to define the .ItemFilter property of the ACB, by way of the AutoCompleteFilterPredicate.
As far as I can tell It just loops trough all the instances in ItemList and returns
True if they match in the prescribed field, and False otherwise, using either a seperate
function or a lambda expression.
Anyway, your suggestion is one of many I tried, without sucess. I suppose it's not so
much a FP question as an UI problem, but if I understand you, you think it should be more like:
NameACB.ItemFilter = New AutoCompleteFilterPredicate(Of Object)(Function(f As MyCustomer) f.Name=NameACB.Text))
|
|
|
|
|
It appears you are using the AutoCompleteBox from the Silverlight library (finally found it). If so, you will need to change the lambda signature to Function(String, Object) As Boolean to match the signature expected by ItemFilter. This means that you will have to cast the item argument inside the lambda, like so:
NameACB.ItemFilter = _
New AutoCompleteFilterPredicate(Of Object)( _
Function(search, f) CType(f, MyCustomer).Name=NameACB.Text) _
)
You cannot pass a lambda of (string, MyCustomer)->Boolean to a function of (string, object)->Boolean because then you could not pass arguments of (string, int).
|
|
|
|
|
Thank you!
This works. And all I had to do was roll the function into one line of code!
I guess I over-thought the whole thing in the beginning. Thanks again.
|
|
|
|
|
Hello
i got all the keys to work in my screen keyboard but i cant get the under score working
i went online and found the hex code for it H5F
Anyone Have any ideas ??
Private Sub Key_US_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Key_US.Click
SetActiveWindow(8975651603260375040)
keybd_event(&H5F, 0, 0, 0)
keybd_event(&H5F, 0, KEYEVENTF_KEYUP, 0)
End Sub
Thanks
|
|
|
|
|
Does the underscore not require the shift key to have been pressed also?
|
|
|
|
|
I try that too
Private Sub Key_US_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Key_US.Click
SetActiveWindow(8975651603260375040)
keybd_event(VK_SHIFT, 0, 0, 0)
keybd_event(&H5f H2D, 0, 0, 0)
keybd_event(&H5f H2D, 0, KEYEVENTF_KEYUP, 0)
keybd_event(VK_SHIFT, 0, KEYEVENTF_KEYUP, 0)
|
|
|
|
|
That won't work. The keyboard, not the event system, decides what key is sent when shift is down or not.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
That work perfect for the at simble
Private Sub Key_AT_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Key_AT.Click
SetActiveWindow(8975651603260375040)
keybd_event(VK_SHIFT, 0, 0, 0)
keybd_event(&H32, 0, 0, 0)
keybd_event(&H32, 0, KEYEVENTF_KEYUP, 0)
keybd_event(VK_SHIFT, 0, KEYEVENTF_KEYUP, 0)
End Sub
every key worked perfect
|
|
|
|
|
This looks nasty. Why did you do it this way, was it so you could have all control keys working ? You'd do better to store the character you're sending in the tag of the button and write one method to handle all event clicks.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Bob Beaubien wrote: the hex code for it H5F
That is the ASCII code, not the virtual key number.
Bob Beaubien wrote: SetActiveWindow(8975651603260375040)
that is horrible.
Luc Pattyn
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Bob Beaubien wrote: SetActiveWindow(8975651603260375040)
You do know that the window handle for any window changes every time you create the window, right?
|
|
|
|
|
Hi Dave
No i dont no that the window handel change every time
so i guess i would have to check what it is every time and then use that ???
Thanks
Bob
|
|
|
|
|
you could use a variable and get the handle's value from Windows based on whatever it is you know about the window (or from the Process class if your app started it)
Luc Pattyn
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Hi,
I have a Windows Form application that runs TopMost. In this application, there is a print function, which silently prints out a PDF file to the default printer.
At the load of the Form, since the TopMost property is set to True, the Start Menu is hidden, which is exactly what I want.
However, when the printing action is launched, the Start Menu pops up. This is triggered by the Taskbar (a little print icon is shown upon printing).
Is there a way to prevent this?
This application needs to run at an exposition, and will be launched on a touchscreen computer. The idea behind this, is that a customer can print a brochure of a product he's interested in.
Secondly, I want to disable all the default shortcut keys to close the application (like ALT + F4, CTRL + ALT + DEL, etc.).
Any ideas anyone?
Kindly yours
|
|
|
|
|
To prevent closing of your application just put e.cancel = true in the formclosing event of your main form.
You can't prevent it from being closed in the taskmanager.
As to keeping the taskbar hidden you can try to put me.bringtofront after the print code but I doubt that it will work.
I don't think there is much you can do against it.
|
|
|
|
|
Isn't there another way around?
Like, an auto closing MessageBox, displaying for example the text "Please wait. Your information is being printed", and when closing the MessageBox, returning to the startup page (which is also defined as TopMost)?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
