|
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
|
|
|
|
|
aaraaayen wrote: Shell("\\sysl\
Your code says sysL but your description says sys1. ie: Ell instead of One. Is this your problem?
-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!
|
|
|
|
|
hi
Thanks for your reply.
No.thats not the problem. I have given the system name its just typo mistake here. thats it.
Expecting your reply.
Regards,
|
|
|
|
|
Do all the users who are using this application have the appropriate permissions to that share?
|
|
|
|
|
Hi all..
im, looking to send the printpreview/printdocument data to a file ..is their a way to do this to a PDF at all..
if not i know there is a way to create a bitmap of some sort any help would be appreciated..
Thanks Again.
Robbo 
|
|
|
|
|
You can create a PDF, if you buy a library to do it. In fact, there's a free library called pdf995 or something, which prints to a PDF.
There's a DrawToBitmap method on your form and it's controls you can use to create a bitmap
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 )
|
|
|
|
|
Thankyou.. your information allowed me to view great alternatives and methods.. thanks again
|
|
|
|
|
Hi there,
I have a problem regarding Resources.resx in VS 2005.
I have put an icon on a button on some form, then I wanted to remove the icon and use another. (I went buttons Image property -> project resources file -> import) then I tried to delete the icon from this interface, but no luck so I deleted the whole Resources folder and resources.resx And now my project wont't compile, and there is an error could not find resources...
This is kind of a bug because when this happens, couldn't just VS create another resx file and reset all resources... lame.
Any help greatly appreciated?
thanks
|
|
|
|
|
It's not really lame that you did something silly and VS isn't magically restoring your file.
The way to change the icon on a button, is to change the property in the designer. If you can get your resx file back to do that from.
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 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
