|
I have no examples on how to do this, but, in theory, you register your app with the power manager with a description of the minimum power configuration your app will tolerate. Being an app that is constantly running, I don't think your app will tolerate the machine going to sleep at all. The power manager has no wake-on-schedule support.
But, the description of the Power API's begins here[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This is what I am trying to accomplish:
Specify a number "123"
Look for that number in the database.
If found, read everything in that row.
If not found, append the info into the database.
I am getting close to being able to read the database but have no clue how to write to it.
Is there anyone out there that may have a simple example of how to read and write to an access database?
Thanks in advance.
Beginner in VB.NET
|
|
|
|
|
Well, let's see what you've got so far and we'll see what we can do about adapting what you have for writing and pointing you in the right direction.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Private Sub Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button.Click
Dim DS As New DataSet()
Dim Command As String = "SELECT * FROM Database WHERE Number1 = '" & cboNumber1.Text & "' AND Number2 = '" & cboNumber2.Text & "' AND Number3 = '" & cboNumber3.Text & "'"
Dim Adapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(Command, Connection)
Dim CMDBuilder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(Adapter)
Dim I As Integer
On Error Resume Next
If cboNumber4.Text = "" Then
Connection.Open()
Adapter.Fill(DS)
For I = 0 To DS.Tables(0).Rows.Count - 1
cboNumber4.Text = DS.Tables(0).Rows(I).Item(3)
cboNumber5.Text = DS.Tables(0).Rows(I).Item(4)
cboNumber6.Text = DS.Tables(0).Rows(I).Item(5)
Next
Else
Adapter.UpdateCommand = CMDBuilder.GetUpdateCommand()
Adapter.Update(DS.Tables(0))
End If
End Sub If the first three numbers are there then the other two are put onto the screen using comboboxes.
Here is my problem:
If cboNumber4.Text = "" then
search the database and if found write to cboNumber4.text and cboNumber5.text
If it isn't found then I need to choose the fourth and fifth number and then add all five numbers to the database.
Maybe I should do this procedure in another button, since I have to manually choose the fourth and fifth number and then add them all to the database.
Any suggestions? Thanks.
Beginner in VB.NET
|
|
|
|
|
Britnt7 wrote:
Here is my problem:
If cboNumber4.Text = "" then
search the database and if found write to cboNumber4.text and cboNumber5.text
If it isn't found then I need to choose the fourth and fifth number and then add all five numbers to the database.
Maybe I should do this procedure in another button, since I have to manually choose the fourth and fifth number and then add them all to the database.
Any suggestions? Thanks.
Huh? Let's see if I get this straight. You have 5 ComboBox's on a form. The use then picks numbers from each of these CB's, ComboBox1, ComboBox2, and ComboBox3. When all 3 of these ComboBox's have a value, the user clicks a button. ComboBox4 is then checked to see if it has a selected value. If it does not have one, the database is queried to see if it has the numbers selected in ComboBox's 1, 2 and 3.
If the numbers do NOT exist in the database, then ComboBox's 4 and 5 are enabled and the user gets to pick numbers from those two ComboBox's. Then the user clicks another button to write the values of all 5 ComboBox's to the database.
Else if the numbers DO exist in the database, then ComboBox's 4 and 5 are populated with the database values.
Correct?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Correct.
I could not of said it any better myself. As of now, the code I supplied earlier, checks the database and if found writes the values of ComboBox4 and ComboBox5. The part I need help with is: if it isn't found add the two numbers on the screen and then write it to the database.
Can you help? Please feel free to change any of this as long as I get the end result:"Search for the first three numbers in a database, if found show the other two, if not found add two numbers and the write it to the database."
Thanks again.
|
|
|
|
|
I am using VB.NET to develop an Outlook COM Add-In and require the addition of a custom property page. The process requires that I create my page as an ActiveX component which can then be added to the PropertyPages collection.
It appears that there is no way to create the required ActiveX object with VB.NET. Thus, the only way to create a custom property page for Outlook is to use VB6 or C++.
Is it possible to use VB.NET to create an object that can be added to the Outlook PropertyPages Collection?
RichSolutions
|
|
|
|
|
hi,
i want to send mail by using VB.net,
bau it dosen't know system.web.mail,
please tell me what should i do?
|
|
|
|
|
It doesn't know System.Web.Mail? Or YOU don't know System.Web.Mail?
It's really quite easy:
Imports System.Web.Mail
.
.
.
Dim Message As New MailMessage()
Message.To = "someone@whoknowswhere.com"
Message.From = "me@myhouse.com"
Message.Subject = "Who cares"
Message.Body = "I don't know what I'm supposed to say..."
SmtpMail.SmtpServer = "smtpmailserver.myISP.com"
SmtpMail.Send(Message)
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I had developed one message system by using winsok in vb .now I want to run my application into system tray and when any message is revieved at that time that application will flash on the screen.
can any body help? if possible give me code pls.
Thanks in advance
|
|
|
|
|
This should have been taken into account before you started your project. "In the System Tray" is not a special place where your app runs. It's just a place to put a Notification Icon. See NotifyIcon XP[^] on GotDotNet for a really good NotifyIcon class you can use.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
NotifyIcon[^] class documentation on MSDN. Comes complete with an example too.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
how character images can be segmented.
how can i interface my scanner through vb.net
saud
|
|
|
|
|
Stop it! If you want to write your own OCR software, you've got A LOT of RESEARCH to do before you can even get started. If you knew what you were doing with the technology behind OCR, you wouldn't be asking us this question, over and over and over again. Your asking about the basics behind OCR, which alone is a VERY complicated topic and well beyond the scope of this, or any Forum on CodeProject.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
WOuld've thought that you'll find it difficult to find a disassembler for VB6 project, unless it's been complied to P-CODE....
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
There is no decoder. If you try and disassemble the .EXE, you'll get back a bunch of assembly code, NOT your original source.
...and stop YELLING...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
If I have a propertygrid and I set its SelectedObject to nothing:
PropertyGrid1.SelectedObject = nothing
why would it continue to show the properties of the object I had set it to before setting it to nothing?
Rugby League: The Greatest Game Of All.
|
|
|
|
|
If I programmatically add a panel to a form and then add several child controls (buttons for example) then I remove the panel from the forms controls collection do I have to call dispose() on that panel and all its child controls?
Rugby League: The Greatest Game Of All.
|
|
|
|
|
No. But, it is good practice to call Dispose on the objects that you use, if available. This will make sure that any component that keeps open any unmanaged resources, like file handles being held open when you create an Image object from a file, are closed and released properly when then managed part of the object is destroyed. Not doing so could result in resource and memory leaks.
The Garbage Collector will call Dispose for you, in most cases, but since the GC is lazy when collecting objects, it may take a little while for it to get around to calling Dispose for you. It's best that you call it when you need the resouces released so that they may be used elsewhere in your app, without waiting around for the GC to do it for you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Greetings,
I have been working feverishly to learn VB.NET with VS.NET Academic edition, however, I have run into a number of issues when trying to run programs having to do with .NET Framework types. I have been using Michael Halvorson's book: Visual Basic.Net Step-by-step.
The first time I tried to do an Excel Interop, I was instructed to create a variable as so:
<br />
dim xlApp as Excel.Application<br />
The problem here was I kept getting the "Blue squiggly" under Excel.Application (Type Excel.Application is not defined). This is what I had to do to get this program to work properly:
<br />
Dim xlApp As Microsoft.Office.Interop.Excel.Application<br />
It was suggested that I could add the following to the top of the form:
<br />
Imports Microsoft.Office.Interop<br />
What I don't understand is why the book doesn't mention this at all. Another book I have is 101 Visual Basic.NET Applications and it seems to make the same sorts of assumptions about .NET Framework Types that Halvorson did.
So I am wondering if the strict option is on and that's why I'm having this problem, or if there is some other "tweak" I've missed, or whether it is just because I have Visual Studio.NET 2003 Academic that I keep running into what seems like rather large omissions to me. Any ideas?
I should like to add that when I look at the examples provided with the book, they do not need to use the fully qualified names, they seem to work as advertised in the book.
|
|
|
|
|
Nope, you didn't miss anything. And it has nothing to do with the Option Strict statement or anything else in the Academic version of VS.NET. All you have to do to fix the little blue squiggly is Import the namespace.
The book might also have gone and added the namespace import to the Project Properties. Go to the Project menu and select the Properties (last line in the menu), then click on Common Properties, then Imports, and you'll see a list of namespaces that are automatically imported into your project when it's compiled. You could add the Microsoft.Office.Interop namespace to this list and you'll see the exact same thing the book shows. In order to write the book and examples, it is possible that the authors made their own custom Windows Application template and included the M.O.Interop namespace in this list.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks for explaining that for me Dave. It was driving me nuts!
Still coaxing software out of the can after all these years...
|
|
|
|
|
I didn't find anything where you told me to look that looked like an Excel Interop. Curiouser and curiouser...
Still coaxing software out of the can after all these years...
|
|
|
|
|
No, it's not going to be there unless you add it! I said, the authors probably put it there in their projects when they built the examples. That way, they don't have to keep typing in the same Import statement, example after example. If you want the same functionality, you will have to either create your own Project Template (which the Academic version doesn't support!), or just type in the Imports Microsoft.Excel.Interop at the top of each project.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Here's the thing. The book came with a cd which includes all the examples so I can see the author's version of the code. His works as the book does and I cannot find anything about his that is any different than mine.
Keeping in mind that he warns the user at the beginning of the book that he wrote his using Visual Studio.NET professional and that is what he recommends the readers to use. As far as I know, academic is the same as professional.
Well, either way, I know how to fix the problem...
Still coaxing software out of the can after all these years...
|
|
|
|