|
Sorry for disturbing.
My table name is General Issue table and the two fields are TestCaseName and TestScriptName. In TestCaseName column some testcases are same. i just want only one entry for particular test case.
The code i using is,
rs.Open "SELECT TestCaseName FROM [General Issue table]", oConnection
Do While (rs.EOF = False)
varTestCaseName_Repeat = rs.Fields(0).Value
rs.MoveNext
If (varTestCaseName_Repeat = rs.Fields(0)) Then
"here how to use update statement"
End If
Loop
|
|
|
|
|
Use this.
Dim Str As String
rs.Open "SELECT TestCaseName FROM [General Issue table]", oConnection
Do While (rs.EOF = False)
varTestCaseName_Repeat = rs.Fields(0).Value
rs.MoveNext
If (varTestCaseName_Repeat = rs.Fields(0)) Then
Str= "UPDATE TestCaseName SET name='" & value1 & "', age=" & value2 & " WHERE name='" & rs.Fields(0) & "' And age=" & rs.Fields(1) & ";"
rs.Open Str, oConnection
End If
Loop
Ananda
|
|
|
|
|
TO DELTE THAT RECORD WHAT U NEED DO IS TO SET UR DATABASE IN ORDER
NOT TO REPEAT A NAME.
FOR INSTANCE IF U ARE USING ADODC CONTROL
THE CODE WILL BE LIKE THESE
DIM RS AS NEW ADODB.RECORDSET
DIM CN AS NEW ADODB.CONNECTION
CN.CONNECTIONSTRING ="DATABASE PATH"
CN.OPEN
RS.OPEN "DELETE * FROM TABLENAME WHERE FIELDNAME='" & NAME & "'",CN
|
|
|
|
|
Hi
Help me.
- Use Visual Studio 2005
- As programming language, use C#
Merge SQLite data with HTML template. This action should be done using one 'Merge' button click.
Show merged document in webbrowser.
Save merged document to PDF.
- Merger
Replaces '##[fieldname]##' in the HTML template document with data from the corresponding
column of the SQLite table.
Create one new page in the document for each record in the SQLite table.
Thank you.
Regards,
Och-Erdene
|
|
|
|
|
Och-Erdene wrote: As programming language, use C#
So why are you also posting this in the VB forum?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Because he's a lazy prat who wants his homework doing. He has posted it multiple times and multiple places.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Use a more descriptive subject line.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
i need to code a bot which auto post link to my forum.
what procedure should i use?
webclient?
also the bot should be coded to login the forum itself.
i had search google but i need is code as i just want to put a timer and auto post some generated content.
|
|
|
|
|
Sounds like a spam bot, so you shouldn't be getting any help.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ditto to that.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
quit flame me.. i need it in my forum serious..
horaceloh
Administrator
ACT ACADEMY
帖数: 1015
Re: DAILY EOD (AFTER 9PM)
十一月 7, 2008, 7:37pm 引用 D20081107
回到顶部 D20081107.zip IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #1 - 十一月 11, 2008, 2:22pm 引用 D20081110
回到顶部 D20081110.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #2 - 十一月 11, 2008, 7:32pm 引用 D20081111
回到顶部 D20081111.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
horaceloh
Administrator
ACT ACADEMY
帖数: 1015
Re: DAILY EOD (AFTER 9PM)
回复 #3 - 十一月 12, 2008, 9:14pm 引用 D20081112
回到顶部 D20081112.zip IP已被记录
BL
Administrator
帖数: 10072
Re: DAILY EOD (AFTER 9PM)
回复 #4 - 十一月 14, 2008, 9:25am 引用 D20081113
回到顶部 D20081113.zip IP已被记录
horaceloh
Administrator
ACT ACADEMY
帖数: 1015
Re: DAILY EOD (AFTER 9PM)
回复 #5 - 十一月 14, 2008, 10:36pm 引用 D20081114
回到顶部 D20081114.zip IP已被记录
BL
Administrator
帖数: 10072
Re: DAILY EOD (AFTER 9PM)
回复 #6 - 十一月 17, 2008, 8:51pm 引用 D20081117
回到顶部 D20081117.zip IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #7 - 十一月 18, 2008, 9:14pm 引用 D20081118
回到顶部 D20081118.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #8 - 十一月 19, 2008, 7:45pm 引用 D20081119
回到顶部 D20081119.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #9 - 十一月 20, 2008, 8:11pm 引用 D20081120
回到顶部 D20081120.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #10 - 十一月 22, 2008, 7:27pm 引用 D20081121
i had to post those crap every day.. please help..
|
|
|
|
|
You're the one who created the very vague post about wanting to automate functionality in a bb - excuse us for being naive in that you were creating something beneficial to the world.
What the hell is your previous post about? Are there any details and explanations that you want to provide? Do you want to post any source so we can see what you're attempting to do, to better help?
No? Then you probably won't get any help esp. for the functionality you're asking for. Feel free to bash my score.
Cheers!
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
modified on Monday, November 24, 2008 10:35 AM
|
|
|
|
|
Well, I feel sorry for you but when you ask
syhs89 wrote: i need to code a bot which auto post link to my forum.
It suggests you want to log onto other people's forums and post a link to yours it does sound like a spam bot.
However, I expect the data will be held in a database so why not just add records to the database? It would be simpler and probably more secure.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
good idea.. let me check about my forum's mysql
|
|
|
|
|
i am sorry i dont have any source.. i just open a new vb.net project and dont know where to begin..
BTW, the mysql is far too complicated..
it contains some key(i dont know how to make it)
and the table for topic and post is different..
i scare i screw up the database.. lol
FYI, i need to do something like that..
http://wowps.org/forum/t2581-just_finished_making_ipb_post_bot.html[^]
but i need its code as i would need to set timer inverval like every 1 day
private sub somesub() handles timer1.tick
- get data from my pc
- login to forum
- post that attachment
end sub
i just dont understand what should i use.. webclient?
dont think so..
EDIT : sorry for my english.. i meant to get some link and post it AT my forum.. which means all posting will be on my forum..
modified on Monday, November 24, 2008 10:57 AM
|
|
|
|
|
First, a thanks for reading this and another if you decide to reply.
I basically am going to start a project that will take in a user-entered text in a text box and create from that an image for display on a LCD panel (pixel formatting)
Looking through VB specs, I come across the Graphics.DrawString method which "Draws the specified text string at the specified location with the specified Brush and Font objects" and will most likely employ CreateGraphics to put it up on screen for display preview. The formatting into the Pixel format will be done after confirmation and the end result is a string of bits to be sent to the LCD panel.
My question is to you, my great and intellegient friends, is : Am I approaching this in the best way or will I encounter some difficult problems and I should consider another approach now before I get too deeply entrenched in my path.
I wish to ask of all of your experience in this. I will try to answer any questions to my situation as afast as I can.
Thank you.
|
|
|
|
|
If you want to preivew the image on screen, then yes, you have to use DrawString to render the string to an Image (Bitmap) object so you can show it.
|
|
|
|
|
Hi
our company has a web system, i try to create a window form application and using two refreence(mshtml,SHdocVw), that purpose makes shell IE auto login web system. So far, i can use IE automation to login system , but i got a problem , when i login to system successfully , that IE window will popout alert(javascript alert), how to use IE auto click the alert message.
Thanks 
modified on Sunday, November 23, 2008 9:51 PM
|
|
|
|
|
Hi
I am working with iTunes library. I am supposed to implement it into a class library.
The problem is that to respond to events associated to iTunesApp I had to disable CheckForIllegalCrossThreadCalls but however in class library, this property isnt supported. Now, I am stuck in between and not able to figure out the solution.
Please help me that how to enable Cross thread operations or how to call the event safely without compromising cross thread restriction.
I would be very thankful for your kind response.
Thanks
MAP Tiger
Tiger Softwares
Software Designer and Developer
VB.NET, ASP.NET, VFP
|
|
|
|
|
Why are you cross posting about cross threading ?
Actually, you don't need to disable that, although that's the easy solution. You need to fix your code so it doesn't make the illegal calls across threads.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi
Again thanks for the reply.
But dear it is not upto me to stop this behaviour of cross threading. As I mentioned that I am working with iTunes library. So when I try to grab an event of e.g. PlayEvent on windows forms then it cannot run anything until I disable the Check for illegal cross threading calls.
I hope that I am much clearer now so that you can help me out for this.
By the way cross posting is just that some dont come on VB.NET boards and some dont come on C# board and I am in hurry to get it fixed. I hope you dont mind it now. 
Regards,
MAP Tiger
Tiger Softwares
Software Designer and Developer
VB.NET, ASP.NET, VFP
|
|
|
|
|
Hi
Thanks for the reply.
I actually needed it in class library which will be basically hosted as a BHO to IE. Moreover, I have solved the problem and mentioning that here so may be useful for any other person.
SongName = "Artist: " + myTrack.Artist & " - Name: " + myTrack.Name
Dim myThread As New Thread(ChangeText)
myThread.Start()
SongName is defined on class level and ChangeText procedure do the work needed with SongName
Now the other question needs attention which is about invoking javascript function if someone can do help.
Regards,
MAP Tiger
Tiger Softwares
Software Designer and Developer
VB.NET, ASP.NET, VFP
|
|
|
|
|
Ho to reading txt file line by line and store all lines in array.
After all line are stored in array, loop in this array line by line for next use...
You must know:
1- the dimension of text file is 163.457 MB
2- all line have max 132 lenght string
3 - into file is possible to have a blank line from one line to next line
I hope and think is the best way to import this BIG file...
I have count the lines are approx 3.364.120 lines!!!!!!!!!!!!!!!
|
|
|
|
|
Need a little more clarification. What is the requirement for having all of the lines stored in an array? What are you trying to do with all of the lines once they've been read in?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
ok...
i want to get a part of single line with MID,LEFT,RIGHT ecc and store the piece of line in a var.
About array mode, is simple one suggestion.. in Google i have seen with FSO is a good way to speed the reading or not?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
