|
Dear all
Dim ProductAdapter As New OleDb.OleDbDataAdapter( _
"SELECT * FROM TCAP WHERE NTCIDCODE LIKE 'VARIABLE' ", _
sConn)
======================================================
I has a ploblem with VARIABLE String. i want to declare
variable and replace than VARIABLE
Exam : Public const strTest As string = "TEST" i 'm cannot declare strTest variable in sql command like that.
Please help and advise me. Many thaks & best regards
sriwirko
|
|
|
|
|
Declare a variable like strVariable and replace VARIABLE with strVariable but without the single quote. 
Luckyhuss
|
|
|
|
|
thank for you advance
sriwirko
|
|
|
|
|
USE
Public const strTest As string = "TEST"<br />
Dim ProductAdapter As New OleDb.OleDbDataAdapter( _<br />
"SELECT * FROM TCAP WHERE NTCIDCODE LIKE '" & strTest & "' ", _<br />
sConn)
|
|
|
|
|
|
Hi,
I am partially new to vb.net, but have vb.net standard 2003. I am more interested in microcontroller development, but am working on some software to interface and debug some registers from the microcontrollers RAM.
Using a RS232 connection (with a MsComm wrapper) i am able to get text to and from the controller very easily. But i am not interested in text (ascii) i am interested in the values. So 0x41 sent from the controller appears as a A in the textbox i display it in, but i want to display 0x41.
Any ideas?
I have looked through the help system without too much luck, many thanks in advance.
- Martyn Pittuk
|
|
|
|
|
If you are absolutely sure your input data is all in the form of text ASCII characters, and does not contain binary data, you can convert an ASCII character into it's ASCII integer code, and then convert the integer to Hex format. But the hex will not be in the "0x41" format - you'll just get a "41".
For example:
txtMyTextBox.Text = (Hex(Asc("A")))
will display "41" in the textbox.
The functions will only work with a single character. If you have data in a string you can convert it into an array of characters using the String.ToCharArray function then enumerate each character to convert it to Hex.
Good Luck
Robert
|
|
|
|
|
Ok thanks thats just what i want, the bytes can only be values from 0x00 to 0xFF which is the range of the extended ASCII dataset i think, so Asc should handle it!
|
|
|
|
|
How do you change the size of a font dynamically being read only doesnt help
|
|
|
|
|
Fonts are immutable. You need to create a new Font with the desired size.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
I have to copy rows from one data view to another.
Fot this am using the following loop and each time creating a new row.
But somehow in the final result the resultatt view only has one new row.
The loop actually runs for each added row but only the last row is actually added.
Any suggestions?
Am copying rows from view2 to view....
For i = 0 To view2.Count - 1
view.AllowNew = True
Dim dv As DataRowView
'adding the new row
dv = view.AddNew()
' copying each column value
For j = 0 To view.Table.Columns.Count - 1
dv(j) = view2.Item(i).Item(j)
Next
dv = nothing
Next
no matter how many times the above loops get executed only the last row is added 
|
|
|
|
|
Greetings,
I have 2 grids, a master and a detail. When I try to add a new blank
record in the detail, I get a contraint error "column 'PROPID' does not
allow nulls" How can I get the detail record PROPID value to default to the
value of PROPID of the selected recortd in the master grid? Here is a short
sample data structure:
Master Grid:
QAID - int - not null
PROPID - int - identity - not null
ITEMDESC - varchar(50)
Detail Grid:
PROPDETAILID - int - identity - not null
PROPID - int - not null
ITEM AMOUNT, etc, etc.
*As you can see there is a one to many relationship between Master.PROPID
and Detail.PROPID
Thank you for your help in advance!
|
|
|
|
|
I am getting stuck on a class that implements IEnumerator for a custom object. Here's the relevent portion of the code:
<br />
class testEnumerator<br />
implements IEnumerator<br />
<br />
private copy() as customObject<br />
private orig() as customObject<br />
private cursor as integer<br />
<br />
public sub new(ByRef v() as customObject)<br />
me.cursor = -1<br />
me.orig = v<br />
me.copy = v.clone<br />
end sub<br />
.<br />
.<br />
.<br />
end class<br />
I am getting hung up where the MoveNext and Reset methods throw errors if the original collection has been modified. What I have right now compares the orig() and copy() arrays to see if there are any differences.
I'm not sure this is correct, though. Does me.orig = v make me.orig a reference to v(), since v was passed ByRef ? Or are orig() and copy() identical copies of the array v() ?
Any help, or alternative methods, would be greatly appreciated.
|
|
|
|
|
I want add BCC all ountgoing and incoming emails. How can i do?
I think i have to control SMTP and POP3 port.
NOTE : This will be Server application.
|
|
|
|
|
I have to ask, why the incredibly long name? Couldn't you just shorten it up to "Greeky Creek" and stop wasting my screen space?
If you want a generic implementation that supports all mail applications, you'll have to write an app as a proxy server. The mail application would then log in to your server, which in turn will impersonate the person using his/her credentials, login to the real mail server, download all mail, go through each message and add the appropriate strings to the message, then return the altered mail to the client mail program.
The same goes for sending mail.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
First Pls Look Name  ,
Second
I have a proxy server, Norton checking mails is installed on proxy. I donna how can i catch email network packets to alter? What will do use, socket programming, or net.mail namespace, Do u know any sample ? or any artical about this aim.?_
|
|
|
|
|
Just Greeky Creek wrote:
I donna how can i catch email network packets to alter?
You don't!
You have to write your own proxy server, just like Norton. If you check your email application configuration, you'll notice that it's connecting to your own machine using different ports than the normal POP3 and SMTP. The configuration in Norton is setup to connect to your ISP mail server.
You'll be writing something that does exactly the same thing. Except the configuration of your application will be the same as your email application. This will have your application connect to Norton so it can do it's job. The chain will go something like this:
Your email app configuration:
POP3 -> 127.0.0.1 on port 8001
SMTP -> 127.0.0.1 on port 8005
(or whatever ports you pick)
Your mail modification app listens on these two ports for connectios from your email app:
POP3 -> listen to 127.0.0.1 on port 8001
SMTP -> listen to 127.0.0.1 on port 8005
Your mail modification app will talk to your ISP mail server, in this case, your Norton app on:
POP3 -> talks to 127.0.0.1 on port ???? (whatever Norton is listening on)
SMTP -> talks to 127.0.0.1 on port ???? (whatever Norton is listening on)
Norton listens for connections from mail applications, in this case your modification app, on:
POP3 -> listen to 127.0.0.1 on port ???? (whatever it's configured for)
SMTP -> listen to 127.0.0.1 on port ???? (whatever it's configured for)
Finally, Norton will talk to your ISP mail server on:
POP3 -> talks to pop3.comcast.net on port 110 (or whatever server your ISP uses)
SMTP -> talks to smtp.comcast.net on port 25 (or whatever server your ISP uses)
Essentially, your writing a proxy application that must be both an email server (POP3 and SMTP) and an email client application. There are articles all over the web that discuss and demonstrate both applications independent of each other, but it'll be up to you to figure out how to put them together into one automated application. You'll also what to pickup the RFC documentation on how POP3 and SMTP clients and servers work. You'll need them for this project...
You might want to check out this[^] little artcle on CP for ideas behind a POP3 client. This will be just 1/5th of your application.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi guys
Can anyone guide me to a tool that converts vb6 code to vb.net,
it's a an access db application, and I was wondering whether it'll make it slower or not?
Thanks
|
|
|
|
|
This is already built into Visual Studio .NET. All you need to do is open Visual Studio, then click File->Open->Project. Navigate to the .VBP project file you want to convert and click Open. It's that simple...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I know what you mean but will it convert all the different syntax, db connection and all difference between vb6 and .net?
I doubt!
anyway i'll give a try,
thanx
|
|
|
|
|
No converter is going to convert everything properly. You WILL have to do some editing and the conversion tool lets you know this by putting comments into the code and generating a conversion report.
And as far as I know, this is the ONLY product that will convert your VB6 code to VB.NET.
But, IMHO, the best method for code conversion, by far, is to rewrite it yourself...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi,
when u open a VB6 project file (*.vbp) in DotNet IDE, the migration utility for conversion popps up... just follow the instructions.....
finally it will generate a list of errors or code which it was unable to convert into VB.NET... for that some perticular help is also provided...
by just following those steps u can get ur work done...
all the best....
- thanks and regards,
Basavaraj P.Umadi
|
|
|
|
|
Microsoft(R) guys have already provided you with such a tool in .NET development environment itself. Go to Tools on the menu 
Luckyhuss
|
|
|
|
|
i have connected access97 with vb6 ..
now, when i put data control on the form
and when trying to put value
on proprty RecordSourse
vb6 answer me by the messag:
"unorgnizet database format"
what is the solution?
|
|
|
|
|
I suggest you pick a more current ADO reference. Go to Projects menu then click Reference i.e Projects->Reference and when the reference dialog pops up, check the A.D.O 3.6 or most recent ADO reference.
or try this:
option explicit
dim cn as new ADODB.connection
dim rst as new ADODB.recordset
dim sql as string
in the form load event
with cn
.provider="Microsoft.jet.oledb.315"
.cursorlocation=aduseclient
.open
end with
try to read more about ADO
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
