|
Checking the Message string is a bad idea. Sure, it might work in this case, but it's a bad nabit to get into considering an Exception message can be thrown in many different languages.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi Steve,
It seems the guys misunderstood the problem you are facing. (Otherwise I misunderstood, in which case you can skip over this answer  )
I suppose you call this function or sub somewhere in your code, and then continue the rest of the code depending on what gets returned, right? So when an exception happens, whatever it is, you need it to return neither True nor False.
I'd say the simplest solution is to forget about the boolean and instead return an integer:
<br />
Private Function YourFunction() as Integer<br />
If something = True Then<br />
Return 0<br />
Else<br />
Return 1<br />
End If<br />
Catch Ex as Exception<br />
Return 2<br />
End Try<br />
End Function<br />
and then:
<br />
Select Case YourFunction()<br />
Case 0 'your function would have returned True<br />
<br />
Case 1 'your function would have returned False<br />
<br />
Case 2 'an exception would have occurred in you function<br />
<br />
End Select<br />
Hope this helps you,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
I've made a simple user control that has two properties and 3 different states. I'd like to prevent this control from accepting focus. Basically I want it to act like a label or panel. I've tried overriding wndproc, but haven't had any luck. All research has also turned up nothing. Any help would be appreciated.
|
|
|
|
|
If the label class does what you want, why not just derive from that ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I suppose because I'm stubborn  Actually, I hadn't thought of that. In my fiddling I stumbled across a different solution. It seems a UserControl inherits from UserControl and a custom control inherits from Control. A UserControl will recieve focus when clicked, but a Custom control won't. I'm assuming Usercontrol inherits a class that handles the focusing, which is why that type of control will always focus. I tried researching what the differences could be but came up empty handed.
So now I know in a situation like mine just inherit from control if I don't want it to get focus.
I've discovered another mystery in my pointless pursuit of information. How come the TabStop property doesn't exist for labels? TabStop is a property in the Control class and a Label is a control. How could it not be there? Oh, well. Unless somebody knows, I give up. I've figured out what I needed to know. Thanks for your reply.
|
|
|
|
|
Anyone know how to get the mouse scroll wheel to work in an MSHFlexGrid (or any control with vertical scroll bars, for that matter) in VB6?
|
|
|
|
|
Not supported. Scroll Wheels came out well after the FlexGrid did.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Actually it does work (at least it does in our implementation). Just change the ScrollTrack property of the MSHFlexGrid control on your form to True.
|
|
|
|
|
I am trying to create a "Wife is coming" button and I need a 1-click solution. I already know how to create an icon in the internet explorer task bar that will run a .exe or .vbs file using regedit.exe. Now I need a file to run that will do what Internet Explorer does when it deletes the cache, history, etc that I can link to the icon in the registry.
I know that when I click the "Delete All" button in IE7, the rundll.exe process turns on for a few seconds until the cache is clear, then ends when it is finished. What I need to know is what .dll is being run to delete the history/cache and how can I create a .vbs file that can do the same thing?
Any help I can get is greatly appreciated.
Matt
|
|
|
|
|
i am usind dataadapter and dataset objects to bind some data from the database in the textbox control. the code i m using is as follows:
textbox1.databindigs.add("text",dataset.tables(0),"Name")
This code is able to retrieve the field 'Name' from the database and puts it in this textbox. Now i want that if some change is made in this textbox,then that should be updated to the database table as well. for this purpose i m using dataset.acceptchange method. But this is not giving result. please guide me in this..
thanks..
-- modified at 14:42 Monday 19th March, 2007
|
|
|
|
|
manni_n wrote: the code i m using is as follows:
textbox1.databindigs.add("text",dataset.tables(0),"Name")
This code just sets up a single databinding and it's not even the code you used. Copy and Paste the REAL code you're using. Do not retype the code yourself! What's the code that's filling the DataSet your binding to? What does the code look like where you're writing the DataSet back to the database?
manni_n wrote: for this purpose i m using dataset.acceptchange method
Do you know what AcceptChanges does?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
Try<br />
Dim da As New OleDbDataAdapter("select * from dbo_info where IDNo='" & Label2.Text & "' ", "provider=microsoft.jet.oledb.4.0;data source=e:\new folder\testIP.mdb;")<br />
Dim ds As New DataSet<br />
da.Fill(ds)<br />
Label2.DataBindings.Add("text", ds.Tables(0), "IDNo")<br />
Label43.DataBindings.Add("text", ds.Tables(0), "Name")<br />
Label42.DataBindings.Add("text", ds.Tables(0), "ParName")
i am using this code to bind the text box ... imean i am able to retrieve the data in the database now i want if something is changed in that textbox then that change should be updated in same data base..
i want to use dataset acceptchange method ....
i dont have that much knowledge in this coding...
please tell me the way to do this....
method other than dataset accept is also welcome....just i want to solve my purpose
thanks....
|
|
|
|
|
You don't have any code to write the dataset changes back to the database. You can use the same dataadapter object that you use to populate the dataset, but you have to give it the SqlCommands to make the Insert, Update, and Delete changes to the actual database. You can either do this by hand or, if you're old using a single table in your SELECT query, you can use the OleDbCOmmandBuilder class to make the other thre queries for you.
You could modify your code like this:
Dim da As New OleDbDataAdapter("select * from dbo_info where IDNo='" & Label2.Text & "' ", _
"provider=microsoft.jet.oledb.4.0;data source=e:\new folder\testIP.mdb;")
Dim cb As OleDbCommandBuilder = New OleDbCommandBuilder(myDataAdapter)
Dim ds As New DataSet
da.Fill(ds)
You'd probably also want to make the DataSet and DataAdapter class-scope so you can use it from something like a "Submit" button.
When you want to save the changes back to the database:
da.Update(ds)
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
you have initialized cb but havnt used anywhere....
whats the use of cb in this coding....?
|
|
|
|
|
You don't do anything with it.
Read up on the OleDbCommandBuilder class here[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello!
I want to syncronize between two SQL 2005 databases. I'm quit new at this.
I want to have a maste database where I do all changes. The slave database i supposed to connect to the Master database and syncronice onec per day.
Can I write a application that triggers this or how can I make it work?
Thanks for all help!
Best regards Richard Segerlund
|
|
|
|
|
You wouldn't normally do this with any VB.NET code at all. This is something that you'd do with Replication Services[^] built into SQL Server.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks for your help. I will read and see what I can find.
Best regards Richard Segerlund
|
|
|
|
|
Ho do i remove this attribute xmlns="" (blank namespace) from my XMLDocument
-- modified at 10:56 Monday 19th March, 2007
|
|
|
|
|
Hi Tomlinson,
Your question is a bit vague (the structure of xml documents is not standardized, the way for example EDI is), so I'll make a few assumptions:
- you need to process xml documents from a single source, on a regular basis
- the documents are created by another party, and you have no say over their structure
- the structure of the documents is constant
- you only need the content of the document and are able to read it into a recordset/datatable/dataset.
If so, then I advise you to read the content into a dataset, using your own xml schema.
If not so:
- why do you want to remove this attribute? In other words, how is this attribute bothering you?
- who creates the xml documents to begin with?
- do you need to process many similar documents, many dissimilar documents, or only a single document?
regards,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi,
I'm using VB.NET 2005 Express, and I'm working with an XML file, which populates a DataSet, DataTable and DataGridView. An amazing achievement for somebody of my current skill set!!
The way my app works at the moment, there is a possibility that I could end up with duplicate entries in my XML file, so I was thinking of running an SQL statement to remove any duplicates.
Everything I've found so far seems to suggest that I need to use an adapter and a connection in order to be able to run an SQL statement. OK - but this doesn't seem right to me.
If it IS correct, it seems that I'd have to create the adapter and a connection AFTER I've read in all my data (ReadXML) - which seems odd.
Perhaps I'm just over-complicating my problem???
Any advice would be really appreciated.
|
|
|
|
|
It sounds to me like you're over complicating the problem. You'd do better to just check for a node before you add it, don't add it if it exists. Solve the underlying problem instead of trying to fix it later.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks for your reply. Your advice is good.
My project is an Exchange Rate application which is importing 200 rows of data from a Word document. At the moment, I'm just reading it in from Word, reading in my XML file, adding the new rows to the existing table, and writing my XML file containing everything.
With your suggestion, am I right in thinking that I'd need to sort my DataTable so that when I come to add my new row, I've got all my countries sorted so that they're together, and it only has to work with a few rows to determine if the data already exists?
Meanwhile, I'd still like to know (for future reference) whether I need an adapter/connection to run SQL statements.
|
|
|
|
|
If you have XML, you can use SelectSingleNode on an Xmldocument to see if you r node existss.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Been coding for about 3 months now and am currently making a "login" client for myself. I hve created a streamreader and have linked it to a .txt file which is located on my hardrive and i am struggling to get it to read of multiple lines so i can have more than one user. This is the code i have at the moment
Public Class Form1<br />
Dim webe As New ProcessStartInfo()<br />
Dim username1 As New IO.StreamReader("C:\Textfile.txt")<br />
<br />
Private Sub Login_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login.Click<br />
If Username.Text & Password.Text = username1.ReadToEnd & "lol" Or Username.Text & Password.Text = "Admin" & "admin" Then<br />
StatusStrip.Text = "Welcome " & Username.Text
Thanks In Advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
