|
nSQL = "Insert Into OrderDetail (OrderNo, ProductCode, ProductDesc, Quantity, Price) Values ('" & strOrderNo & "', '" & strCode & "', '" & strDesc & "', " & iQuantity & ", " & iFullPrice & ")"
Set RS = Conn.Execute(nSQL)
DataGrid2.Refresh
What the above code is trying to do is that when a command button is pressed, the values in the textboxes are saved to the OrderDetail table. However, what I also wish to happen is that the datagrid (the datagrid is bound to this OrderDetails table) is updated with this new record. This is not happening - what am i doing wrong?
Thanking you in advance!
|
|
|
|
|
if the OrderNumber is an autonumber(as opposed to text) in the Order table of the database, is it possible to display this number in a textbox on loading of the order generation form?
Thank you in advance!
|
|
|
|
|
I have doen this in the past by using a separate table that only contains the autonumber feild and a column for a username. I add a new record to the table (by writing the username), to get a new invoice number, then a run a querry that grabs the top 1 from the list with that username. I then use that number in the table that contains the invoice data. Seems to work quite cleanly.
Not sure just how leagle it is with regards to DB theory, but it has worked in the past.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
Does anyone know how you would detect an mp3 file that's currently playing, through WinAmp or Windows Media Player, and display the song information?
Any help would be much appreciated 
|
|
|
|
|
I think, there is no universal way for both players, but at least for WinAmp there must be some way, because some time ago I saw a plugin which writes the currently played song to the mIRC client and also lot of other plugins for WinAmp displays the song info. But this is an issue for the WinAmp Plugin SDK, how it is with WMP, don't know...
Good luck!
|
|
|
|
|
I want to write a client program(.dll). The Client Program Will response whe message from IE. When I visit a special document from address of IE,My application will run and open the document.Example: When I visit a file of the extend name is '.rm' from IE , the realplay whill run and open the file.
BUT I don't know how to response whe message from IE.
|
|
|
|
|
I have project that I found on a Russian web site, that registers it self as a service and monitors the microsoft internet explorer. It will only work under windows 98. it suppose to work under 95 but it does not. email me at ilya@pokrovskiys.com if you want this project.
It might be what your are looking for.
You might find a way make it work under xp and 2000
|
|
|
|
|
hi to ya'll..want to ask a ques..ok lets say i have an Linux operating system and i want to write a configuration file into the system that can read the data entered by the user(data enter by user is done using VB, VB is used to create the interface and then vbscript is used to generate a text file. The text file contains all info entered by the user. This text file is then sent to the Linux OS, and a configuration file in the os is used to validate the info entered).Ok, my ques is what language am i going to use, and how am i going to do it?
Nash Hon
|
|
|
|
|
I can send a file from the server to the client by having the client call a function which returns a FileStream. It works perfectly.
I tried to send a file from the client to the server by having the client call a function with a filestream as a parameter. Unfortunately, the client gives me an error saying the the remoting proxy has no channel sink. 
The client's call:
T.SendFileTest2(New FileStream("C:\in2.txt", FileMode.Open))
The function in the hosted object:
Public Function SendFileTest2(ByVal FSL1 As FileStream) As Boolean
Dim Buffer(4096) As Byte
Dim readed As Integer
Do
readed = FSL1.Read(Buffer, 0, 4096)
Dim i As Integer
Dim str As String
For i = 0 To readed - 1
str += Convert.ToChar(Buffer(i))
Next
MsgBox(str)
Loop Until readed < 4096
FSL1.Close()
FSL1 = Nothing
End Function
I would greatly appreciate any help on this.
Thanks,
Steve
|
|
|
|
|
I design a COM object by ATL, which has two IDispath. Default dispatch is IPlot2D, and the second is IMIDraw.
IMIDraw has a method Plot(), how do I launch Plot() method?
|
|
|
|
|
How can I check if a user is connected to the Internet. I used the function 'InternetGetConnectedState' but it does not work with IE 6 and WinXP. Any help is more than welcome !
*** Praise none, but the Creator ***
T-break SUX
|
|
|
|
|
Hi VB Experts
Normally, I'm using C++ for my developmments but I need to configure a supervision software that makes a heavy use of VBA ... so I apologize for my stupid question...
This supervision software allows us to make views of industrial processes. These vies are NOT use classical VB forms. So the methods of the VB forms are not available .... I need to set the cursor to hourglass for lengthy processing but I failed to succed.
I declared the functions SetCursor and LoadCursor as 'Private Declare Function SetCursor Lib "user32" .... and same for LoadCursor
Then I try to get the cursor with the call:
SetCursor( LoadCursor( 0, 32514&))
But it does not work !!!
What shoudl I do to succeed ?
Thanks for your help
Thierry
|
|
|
|
|
|
I have zero experience with vb for applications, but in regular dot net you don't need anything but this one line:
Cursor.Current = Cursors.WaitCursor
Then
Cursor.Current = Cursors.Arrow
Hope this helps,
Mike "MC5" C
|
|
|
|
|
This is using vb6...
Help I've just encountered some problem with my application. When i am running my application from the Project file, everything works fine, but when i made the exe file, a run-time error occurs when i run some process.
Does anyone know the error only occurs in the exe and not the project file?
btw, the error occurs regarding the sort method of the range class of the excel object
Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain
Get your facts first, and then you can distort them as much as you please
Mark Twain
|
|
|
|
|
I am writing an application, where a third party company is writing some components. My question is this: My boss is under the impression that a DLL can be dropped into the bin folder and we can run with it (i.e.: access properties/methods within the DLL) I tried dropping the DLL into my bin folder, then adding an Import in the projects property pages, to no avail. Does anyone know of anyway besides reflection that this can be done ??
|
|
|
|
|
Yes, Add a Reference to it...
Right-click on your References Section of your Project and Click "Add Reference...". Then browse to where you put it.
|
|
|
|
|
I'm making this application in VB.NET. I call it netDemon, it monitors a users Connection time and creates a log. I'm facing few problems rite now. I'm listing them with detail.
Firstly, I'm using Access as my database so that I can store the logs. The problem is that I cannot Insert a new tuple in my Database. I can update an existing tuple but fail to Insert. I'm using the following SQL query:
INSERT into users values ('" & myUser & "','" & myPass & "'," & myPriv & ",'desc');"
where myUser contains the value entered into the textfield and myPass is the password.
Secondly, my application is designed in such a way that it will disconnect any connection that is not made through it. The problem is that even though I'm not connected to the Internet the application keeps showing me a message that I'm connected to the Internet.
I'm using the Function 'InternetGetConnectedState'. According to what I read at 'AllAPI.net' this function returns ture when connected and false otherwise. Here's what I've written:
myCheck = du.InternetGetConnectedState(lpdWFlags, 0)
If (myCheck) Then
If (isConnected = False) Then
'MsgBox("You cannot connect to the Internet, except through netDemon")
MsgBox("You will now be disconnected")
du.InternetAutodialHangup(0)
End If
Else
'If he is not Connected, then do nothing 
End If
'isConnected' is a Globlal variable of type boolean which is set to 'true' when the user logs onto my application.
Lastly, I want my application to load when Window's loads. How do I do this.
Using VB.NET @ WinXP Pro.
This is very, very urgent cause I have to submit this project by Thursday (09-01-2003)  . Please reply A.S.A.P ...
|
|
|
|
|
Using VB.net
Can somebody help me? I'm using vb to connect to MySQL through ODBC using the following code
<br />
Dim Con as New ODBCConnection("some connection")<br />
Dim Adp as New ODBCDataAdapter<br />
Dim ds as New DataSet()<br />
<br />
Con.Open()<br />
Adp.SelectCommand.Connection = Con<br />
Adp.SelectCommand.CommandText = "SELECT * FROM tablename"<br />
Adp.Fill(ds,"tablename")<br />
The error occurs at the Fill with message: NO_DATA, but if I use ExecuteReader instead, there's no error and the data's there.
Is there something wrong with the code? Or is there something I should know about the Microsoft.Data.Odbc namespace? Please Help!
Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain
Get your facts first, and then you can distort them as much as you please
Mark Twain
|
|
|
|
|
Microsoft just recently announced that the "Everett" version of .Net will be released as .Net 2003. The beta version is available for download on their dev site. They have not said anything about upgrade policies for current owners of .Net. Does anyone have any info on this yet?
|
|
|
|
|
For Visual Studio .NET 2002 customers who do not subscribe to MSDN or to a Microsoft volume licensing program, Microsoft is committed to providing an inexpensive path to "Everett." Registered users of Visual Studio .NET 2002 will be able to license "Everett" for $29 US, the cost of materials, shipping and handling, for a limited time after release. Availability will be roughly concurrent with Windows .NET Server 2003. For those customers who prefer not to upgrade to Visual Studio "Everett," a service pack offering only bug fixes for Visual Studio .NET 2002 will be available soon after the "Everett" release.
from
http://msdn.microsoft.com/vstudio/productinfo/roadmap.asp[^]
Michael
Fat bottomed girls
You make the rockin' world go round -- Queen
|
|
|
|
|
I am doing something on my IExplorer.I have the form which set as
automaximize is true for every say 1 hour.So every 1 hour my form
awakes.Suppose if it gets activated,my focus will go from IE to vbform.how
to avoid this.i want to do my focus again to my IE.How to do.
1.i want API to activate another application.
2. i want to get the handle of the deactivation window, so that again i
activate the window.
|
|
|
|
|
Hi,
Please I need help,
I have a groupbox that contains 2 radiobuttons. So i want to bind to it a datafield (having only 2 values : 1 for the first radiobutton, or 2 for the second radiobutton).
Please can someone show me how to use databinding with this groupbox.
Thank you in advance.
Intibnin...
***
|
|
|
|
|
From what I understand in your message, you have:
Form
- GroupBox
- RadioButton1
- RadioButton2
You also have a dataset where each row has 1 column (or more). If this column has a value of 1 you want RadioButton1 to be selected, otherwise RadioButton2.
Can you clarify your situation a bit more? Are you using typed/untyped datasets? Are you using C#, VB, or J#?
I dont see how this isn't just basic databinding - and if it is you'd be better off checking MSDN for the documentation on DataBinding.
Tatham Oddie (VB.NET/C#/ASP.NET/VB6/ASP/JavaScript)
tatham@e-oddie.com
+61 414 275 989
|
|
|
|
|
Thank Tatham for help.
Well, the problem i encountred is in VB.NET Form.
I try to clarify the problem, so the dataset used in form is filled programmatically. I create a method for binding fields to dataset as follows :
Private Sub BindingFields()
cn = New SqlClient.SqlConnection(constring)
Dim da As New SqlClient.SqlDataAdapter("select * from parametres where type = 1 order by code ", cn)
'Note : Mydataset, MyBuilder and MyAdapter are declared public objects
Mydataset = New DataSet()
MyAdapter = New SqlClient.SqlDataAdapter("select * from client", cn)
MyBuilder = New SqlClient.SqlCommandBuilder(MyAdapter)
MyAdapter.Fill(Mydataset, "client")
TextBox1.DataBindings.Add(New System.Windows.Forms.Binding("Text", Mydataset, "client.r01_codcli"))
TextBox2.DataBindings.Add(New System.Windows.Forms.Binding("Text", Mydataset, "client.r01_adrcli"))
TextBox3.DataBindings.Add(New System.Windows.Forms.Binding("Text", Mydataset, "client.tel1"))
TextBox4.DataBindings.Add(New System.Windows.Forms.Binding("Text", Mydataset, "client.r01_nomcli"))
TextBox5.DataBindings.Add(New System.Windows.Forms.Binding("Text", Mydataset, "client.tel2"))
TextBox6.DataBindings.Add(New System.Windows.Forms.Binding("Text", Mydataset, "client.fax"))
TextBox7.DataBindings.Add(New System.Windows.Forms.Binding("Text", Mydataset, "client.dat_cre"))
da.Fill(Mydataset, "Categorie")
ComboBox1.DataSource = Mydataset
ComboBox1.DisplayMember = "Categorie.libelle"
ComboBox1.ValueMember = "categorie.cat_cli"
'*****************************
'The problem is here
'Client.stop_serv is 1 or 2
'******************************
GroupBox2.DataBindings.Add(New System.Windows.Forms.Binding("Text", Mydataset, "client.stop_serv"))
End Sub
this code does not work.
Thank you in advance
***
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
