|
What is this sequence all about?
Text File
(to)
Excel Sheet
(to)
Oracle Table
Did you try out making straight text file to Oracle Table?
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Hi guys.
Is it possible to change the horizontal scroll of a table into a button page scroll.
Example. A button "Next" when click, will carry out the same function as the horizontal scroll by scrolling to the next page.
Anyone able to help? Very much appreciated. Thank you.
With regards,
Desmond
|
|
|
|
|
|
That code is just setting a property, the property must be exposed to .NET as well, surely ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
Thanks for the prompt reply. Yeah, it just requires it to be exposed, yet I am unable to write the proper interface declaration. I was hoping someone could help me with it. Cant find much on the net.
Thanks,
Ahmad
|
|
|
|
|
First three google hits all looked good:
http://www.codeproject.com/KB/cs/advhost.aspx[^]
It's C#, but should be easy to convert, or there are converters online.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I've tried the method of directly referencing the file yet VB.net doesnt recognize it as a valid assembly. As for his code, the online converter at developerfusion gives an error on:
[
uuid(47F05070-FD66-45cc-AD99-74260F94A16B)
]
"Invalid Expr"
Thanks in advance,
Ahmad
|
|
|
|
|
That's just an attribute, I guess check how attributes are declared in VB.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
explanation:
i have 4 songs in my listview all numbered from 1 to 4.( as listview.item)
1. tina turner
2. queen
3. golden earing
4. 10cc
when i play number 3 end it ended it wil remove
so i have
1. tina turner
2. queen
4. 10cc
how can i make the numbers
1. tina turner
2. queen
3. 10cc
thanks
|
|
|
|
|
You're obviously adding the numbers yourself. So, iterate over the rows again, starting with the one below you remove, and reset the number to what you want.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hello
I work in VB6
my database on SQL server 2000 settings are :
server name = S72M
databasename = test
tablename = test_tbl
columnname1 = a_val
columnname2 = b_val
and in VB forms i want to read in textbox1 value from a_val and in textbox2 value from b_val
please show me some example of code to do my request
I new in conncetion with SQL server , for now i work only with access database
Thank you again for your time !
|
|
|
|
|
I don't do VB6 examples since it is long dead...
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
|
obarahmeh wrote: I want to insert data into SQL 2000, but the code is not working for some reason I do not know.
What do you mean by "not working"? Does it cause an exception? Does it do something different? Does it do nothing?
obarahmeh wrote: Dim com2 As New SqlClient.SqlCommand("insert into Customers(HOTCODE, HYEAR, HMONTH, HWEEK, NPALEST, NARAB, NISRAELI) " & _
" values(" & Me.SHCODE.Text & "," & Me.SYEAR.Text & "," & Me.SMONTH.Text & "," & Me.NSelectweek.SelectedValue & "," & Me.NPalest.Text & "," & Me.NArab.Text & "," & Me.NIsrael.Text, con)
Don't inject data into your SQL Strings. This leaves you vulernable to SQL Injection Attacks. Please read SQL Injection Attacks and some tips on how to prevent them[^]
I'm guessing that your problem is that some of the user input damages the SQL String which is a symptom of vulernability to SQL Injection Attacks.
|
|
|
|
|
|
Christian Graus wrote: 'Palestinian Central Bureau of Statistics (PCBS)'
Sounds like the same as the Census Bureau or the Office of National Statistics or what ever you call it in your country.
|
|
|
|
|
Sure - but you'd think people whose job in life is data, would hire people who know some SQL.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I want to kknow that if I create many datasets in my application or taking bulk of data in dataset then speed of execution will be affected?
Will this make my application work slower?
|
|
|
|
|
Well, that really depends. How many datasets are we talking, how much memory will the PC you're running the program on have, etc ? A dataset, sitting in memory, shouldn't slow your app down, because it doesn't use the processor, just sitting there.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
|
I converted a large VB6 ap to VB.NET 2005.
I have found that a Late Binding works in VB6 but not in VB. NET when a Function is used.
Ex.
Select Case Type
case 1
LineObj = Type1
case 2
LineObj = Type2
end Select
The below works without a problem
LineObj.itemref.fullname.setvalue(mItem)
But the below fails after it does it
438 Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))
QBSetVal(LineObj.ItemRef.fullname, mItem)
QBSetVal does some checking and eventual does a
pObj.setvalue(mItem)
Public Function QBSetVal(pObj,.....)
pObj.setvalue(mItem)
RETURN
And the value IS SET properly but when control to returned back to the caller after the RETURN it gets the MEMBER NOT FOUND.
I do not understand how it can set the variable properly in the object but throw the error just on the return.
Can someone tell me what is occurring?
Please help!!!!
|
|
|
|
|
Hi everybody, i desperately need help regarding combo box coding.
i have a combo box for hardware selection in my database. In the list i have pc's, scanners/printers, laptops etc and I have also created an 'OK' command which when clicked is supposed to return a form depending on the hardware selected. The RowSourceType is a "Value List".
Please help and thanks in advance
|
|
|
|
|
I didn't get your problem.
|
|
|
|
|
i need help on a vba code that would return/load a specific form depending on the user selection from the combo list
|
|
|
|
|
Hi Friends,
I am calling one batch file from vb program like the below code.
Dim d As Double
d = Shell("\\sysl\share1\overtime log\Overtime Log\Ext.bat", vbHide)
the above 2 lines are given in form_load event.
When I try to run this application which is having the above two lines to call the batch file from the Server : sys1 it is working fine and calling the batch file.
But when i create package and deployement of this application, and installed in other system and when i try to run the project, it gives error Runtime Error: Call to invalid procedure or argument
But the i am not getting the above error if i give the ipaddress of sys1 instead of giving the system name like sys1.
Please suggest me some ideas for this. Since my ip address is dynamic, i cannot give that address, so i can only give my sys name ....So Expecting your help.
Thanks in Advance,
Regards
|
|
|
|