|
What the.... 
|
|
|
|
|
He's talking about getting rid of the embedded double and single quotes in the string!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I know my thought process sometimes is funny to say the least, but i think this one is actually correct 
Do Or Don't, there is no "try catch ex as exception end try"
|
|
|
|
|
I am presently using WM_COPYDATA and SendMessage to pass string data from a c++ app to my vb.net app.
Everything works but the response time gets sluggish in the c++ app waiting for vb.net app to process the message.
I would like to use PostMessage to speed up the string data transfer.
I read somewhere that I cannot use WM_COPYDATA with PostMessage.
How can I use PostMessage to do my data transfer?
I would like to see both the vb.net code for receiving data from PostMessage
and
the c++ code for sending data with PostMessage
Will the use of PostMessage really speed up the sending app?
Any suggestions , examples or links would be greatly appreciated
Roger
VS2005 Std / WinXP Pro SP3
|
|
|
|
|
I have no clue what you are talking about with the PostMessage deal but my i suggest making a thread that handles the c++ to vb messaging like a background worker?
|
|
|
|
|
Be sure that the transfered data is in a valid data block ie global object.
And test it on the 'secure' Vista.
Greetings from Germany
|
|
|
|
|
Thanks for your quick replies.
I am interested in knowing how to use PostMessage which is a Windows OS function similiar to SendMessage
Thanks
Roger
|
|
|
|
|
Can someone please take a look at this code:
I notice that the code is not sufficient to connect to an access database what is wrong with this code?
<Dim db as NEW ADO DB.Connection
Dim rs as NEW ADO DB.Record-set
DIM spath as String ' Path for the database
Dim SQLL as String ' Sql statement
sPath = app.path & "\DB\Name.mdb
>
What I want to do is to connect to an access database, I'd really appreciate some assistance.
Thank you!
|
|
|
|
|
|
I know that line of code provided by the link that you sent.
That only answered my question in an infinitestimate way.
So much for human stupidity.
Jesus Christ is Lord!
DR
|
|
|
|
|
What you have given me is the connection string. But I am also having problems with the declaration of the variables.
Do you know how to do that, if you do, I will really appreciate your assistance. I have made several attampts to do this but it seems I am stuck. All I need is to know how to declare the variables and how to connect - that's all!
Jesus Christ is Lord!
|
|
|
|
|
Sorry I have not used access for 10 years but your syntax seems to indicate you are using VB6, recordsets do not exist in .Net, if this is the case I can only offer you a paddle.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I have one application in vb6.I want to convert it in vb.net.I have been trying alot to use recordset but giving error like arguments are of wrong type,are of out range or conflict with one another.What i do?
code:
If rs1.State = 1 Then rs1.Close()
rs1.Open("select * from UserTable where User_Id ='" & Trim(TextBox1.Text) & "' and User_Password='" & Trim(TextBox2.Text) & "'")
If rs1.EOF = True Then
MsgBox(" Password is not correct, check again .....?", vbCritical + vbOKOnly, "")
i = i + 1
If i = 3 Then
MsgBox("Sorry, you have lost your time.....", MsgBoxStyle.Exclamation)
Application.Exit()
End If
Else
MDIParent1.Show()
Me.Hide()
End If
|
|
|
|
|
VB no longer has recordsets. You need to read up on ADO.NET to see what is currently available as there are many ways to get data to and from a database now to cater for different scenarios.
Also, the code you showed is susceptable to SQL Injection Attacks, you should read up on them also so you can protect your application. This article will show you what SQL Injection Attacks are and how to prevent them[^].
|
|
|
|
|
recordset is easy to use.i am not feel comfort with datasets.If any one know plz solve.
|
|
|
|
|
lahsiv wrote: i am not feel comfort with datasets
There are other ways to access data in .NET.
DataReaders, for example. Or you could use the Data Access Application Block (part of the Enterprise Library). Or you could use an ORM (Object Relational Mapping) tool such as XPO or NHibernate. Or... Or.... Or....
|
|
|
|
|
lahsiv wrote: .i am not feel comfort with datasets.
Tough - get used to it, as a programmer you will continiously need to learn new things. You have 2 choices here, upgrade your skills or quit.
Dataset, datatable, dataview are the tools you are going to have to work with in .net. Unless you to linq of course  .
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: Dataset, datatable, dataview are the tools you are going to have to work with in .net. Unless you to linq of course
There are even alternatives to that. 
|
|
|
|
|
Colin Angus Mackay wrote: There are even alternatives to that.
Elaborate please - I may be guilty of finding the first successful method and ignoring other possibilities. I often do this and am continiously surprised when someone comes up with a different method.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: Elaborate please
DataReaders for starters - Read my other post in this thread, the one to the OP, where I list a bunch of ways.
|
|
|
|
|
I consider datareaders as part of the datatable/set infrastructure because dataset.fill uses a reader under the hood anyway.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: I consider datareaders as part of the datatable/set infrastructure because dataset.fill uses a reader under the hood anyway.
If that is your reasoning then there are no other ways because everything uses a DataReader "under the hood".
|
|
|
|
|
Can you advise me on which line you are getting here ? Please post here error message also.
Parwej Ahamad
R & D: REST services with WCF
|
|
|
|
|
after filling textboxes,click on the login button then i got message
|
|
|
|
|
lahsiv wrote:
If rs1.State = 1 Then rs1.Close()
Where did people develop the habit of using global variables for recordsets and using 'lazy close'? I've had to deal with such code, but I wonder how such sloppy coding came into common practice.
Doing things with a datareader is really pretty easy. Opening a connection by creating a new Odbc.OdbcConnection(connectString). Then create a new Odbc.OdbcCommand(theCommandString, theConnectionObject). Rather than appending string arguments, insert them using "@@" syntax, e.g. Dim MyCmd as New Odbc.OdbcCommand("SELECT User_Password from UserTable where User_ID=@@UserID", myConnection). Then fill in the parameters using the Cmd.Parameters.AddWithValue(name, value) method, e.g. Cmd.Parameters.AddWithValue("@@UserID", Trim(Textbox1.Text)).
Once the command object is loaded with parameters, you may use Cmd.ExecuteNonQuery() to perform a command that won't return anything, Cmd.ExecuteScalar() to perform a command that will return one object, or Cmd.ExecuteReader() to return an iDataReader object. Use theReader.read() to fetch each record (including the first) into the reader object; it will return false on EOF. After each record is read, you may use theReader(0) to read the first field, theReader(1) to read the second, etc. If your query is properly designed, you will know in advance how many fields will be returned and what they will be.
modified on Monday, August 18, 2008 6:37 PM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
