|
just try this
SELECT * FROM MSysObjects
solidIT.de - under construction
Components for Microsoft .Net
audittrail, objectcomparer, deepcopy and much more ...
|
|
|
|
|
Sir/madam,
Thanks for ur kind attention.But how i will get to know that whether that table exist or not.
Thanks and Regards
|
|
|
|
|
no prob
SELECT COUNT(*) AS TABLE_EXISTS FROM MSysObjects WHERE Name = 'Forms'
- and now you only have to replace "Forms" in the where clause with the table you want to check
- if the TABLE_EXISTS field is bigger than 0 (zero) then the table exists otherwise it doesn't
solidIT.de - under construction
Components for Microsoft .Net
audittrail, objectcomparer, deepcopy and much more ...
|
|
|
|
|
Hello All!
I have two applications in a solution. ServerA and ClientB lets say. I need to be able to open a form on ClientB from ServerA. SoI'm using a Filewatch to do this. First I create a file in the watched folder. I'm doing this by a button click event on ServerA.
Dim TimeStamp As String = Guid.NewGuid.GetHashCode<br />
Dim TempFile As String = "C:\PlayC\Qtr2\"<br />
Dim ext As String = ".out"<br />
Dim FileName As String = TempFile & TimeStamp & ext<br />
Dim fs As New FileStream(FileName, FileMode.Create)<br />
fs.Close()<br />
End Sub
The my Filewatch is like this on ClientB.
AddHandler NKWatch.Created, AddressOf NKWatch_Created<br />
Try<br />
NKWatch.Path = "C:\PlayC\Qtr2"<br />
NKWatch.Filter = "*.out"<br />
'' NKWatch.IncludeSubdirectories = False<br />
NKWatch.EnableRaisingEvents = True<br />
Catch ERR As Exception<br />
MessageBox.Show(ERR.Message)<br />
End Try
Then the response once a file gets created in the folder.
Public Sub NKWatch_Created(ByVal sender As Object, ByVal e As System.IO.FileSystemEventArgs)<br />
Dim frmFour As New frm4th<br />
<br />
Me.Hide()<br />
frmFour.Show()<br />
frmFour.GetUID(Me)<br />
Application.DoEvents()<br />
End Sub
So when my form shows up, it displays, but then freezes up on me. I use to get a white screen when the form came up, but I put in Application.DoEvents, and that seem to help.
I even tried just a plain form with a couple of buttons.
But if I try a message box, it works perfect.
Am I missing something? Any thougts on this, and how I may get this to work? I try to get debug it, but I can't find anything. The server A form is pretty simple, the clientB form has alot of stuff going on, that why I tried a simple blank form. But the same results.
I have two clientB forms, prety much the same, except diffrent labels for the buttons.
Thanks!
Rudy
|
|
|
|
|
Hi Rudy,
I have had problems myself with hiding and showing forms, and I found that me.hide() sometimes seems to act a little like me.close(), and therefore doesn't always nicely handle subsequent code.
rudemusik wrote: Public Sub NKWatch_Created(ByVal sender As Object, ByVal e As System.IO.FileSystemEventArgs)
Dim frmFour As New frm4th
Me.Hide()
frmFour.Show()
frmFour.GetUID(Me)
Application.DoEvents()
End Sub
Just a wild guess, but you could try to move Me.Hide() after Application.DoEvents()
If it doesn't help, it shouldn't hurt either.
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi Johan!
I tried that. I even tried just to show the form, without hiding it. Same thing. Still trying to figure it out.
Thanks for the reply!
Rudy
|
|
|
|
|
Dear all,
Some of most popular program (e.g., meetro) has no proxy setting.
I want to use that program with proxy server. But I don't know how to redirect IP
to proxy server. Can I developed a program with VB for that problem?
Please help me...
(stup!x...)
|
|
|
|
|
Well, how this is done depends on the application. There's two possibilities.
The first is if you can change the IP that your application is using. If so, then you have to write your proxy server as both a server AND a client for the kind of server that your app attaches to. The server accepts the connection from the application and forwards the request to the REAL server the application was trying to connect to. This forwarder is actually a client of the REAL server. The response comes back from the server and the client side forwards the responds to your proxy's server side. Get it?
Now, if you can't change the IP the app uses, you have a MUCH more difficult problem. Now, instead of a proxy server, you're stuck writing a packet sniffer, just like any network protocol analyzer. You have to use a 3rd party library, like WinPcap, to capture the packets as they go down the network stack, modify the packets to redirect them to a new server IP.
Since your even asking this question, and the language you've picked for it, tells me that you have a very limitied knowledge of how TCP/IP communication works. Make no mistake, both of these projects require an ADVANCED level of knowledge of how your application works and how IP communication works.
No, I don't have an example of either of these types of apps.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thank you for your answer DAVE.
(stup!x...)
|
|
|
|
|
Hello,
I want to hide a column in a datagrid.
This is my code below that works, but isn't there a better way to do this.
<br />
ds = objComponents.RefComponentsTypes_selAll()<br />
Me.dgvComponents.DataSource = ds.Tables(0)<br />
Me.dgvComponents.Columns("AssemblyID").Width = 0<br />
Thanks in advance,
Steve
|
|
|
|
|
You can set the width to zero.
Or you can just delete the column all-together.
Or you can get a new view of the DataSet and not include that column in the view, then bind the DataGridView to the new DataView.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hi
i m using datagirdview in my vb.net(winforms)-2005 application.
i m validating each cell in "datagridview_CellValidated" procedure. and after validating each cell i wnt to set focus on that cell so i wrote following code in above procedure but it doesnt set focus on that cell to which im validating.
code----->
DGCustDept.CurrentCell.DataGridView.Focus()
or
Me.DGCustDept.CurrentCell = New DataGridCell(e.rowindex, e.columnindex)
Please tell me wht shuld i do?
priya
|
|
|
|
|
control.column(0).visible=true/false
|
|
|
|
|
Please don't tell me that this should be sending off red lights, but I need to know how to declare "global" variables (where, and how). I am using Visual Basic.net Express Edition... If this has any effect on it. Anyways, I have two forms, and I need to have the variables from one accessible to the other. Any help you can give me would be appreciated.
|
|
|
|
|
jacob.vankley wrote: Please don't tell me that this should be sending off red lights
OK. It should, tho
jacob.vankley wrote: but I need to know how to declare "global" variables
You can't. You can create a class with public, static properties, tho.
jacob.vankley wrote: Anyways, I have two forms, and I need to have the variables from one accessible to the other.
Then globals are the wrong approach (as is often true ). You should define delegates that pass the info between forms as it changes. Or, if you're only passing from parent to child, add properties on the child that the parent can set.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Alright, i think i understand, i will try that.
|
|
|
|
|
It's a common question, I keep meaning to write an article on it. If you get stuck, just ask again.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
|
I thought I'd do one that goes over all the things I see people trying to do in the forums, and why they are all bad.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Christian Graus wrote: I thought I'd do one that goes over all the things I see people trying to do in the forums, and why they are all bad.
Ah... It reminds me of a session I attended at the DDD4 conference last month. "How to write crap C# code" - It was surprisingly well attended.
|
|
|
|
|
jacob.vankley wrote: I need to know how to declare "global" variables
jacob.vankley wrote: I have two forms, and I need to have the variables from one accessible to the other.
That is no reason to use global variables.
jacob.vankley wrote: Please don't tell me that this should be sending off red lights
Well... It seems you already know it is a bad idea.
Perhaps your question should have been: I need to share information between two forms. Is there any way to do this without using global variables? If so, how?
To which my answer would have been: Read this article[^] about passing variables between forms. It was written for VB.NET 1.1 but it should still be valid for 2.0
|
|
|
|
|
Thanks so much! I will try that, and it should work.
|
|
|
|
|
I've been trying to figure out how to connect to the DHCP database on a 2003 DHCP server. It's a jet database, but I can't find a way to access it.
What I want to do is pull scope range and options from my 2 DHCP servers and then compare them to make sure everything is redudant. I also want to set up email alerts for any scope that's >90% utilization.
But first I have to connect to the database. I've been playing with the netsh command which gets me some information, but it's not very legible. I'd rather pull just what I need and leave everything else out.
Any help would be greatly appreciated.
Thanks.
JnyBot
|
|
|
|
|
I don't have a 2003, or any other version, DHCP server running anywhere, but I would imagine that that database is locked exclusive while the DHCP server is running. It's entirely possible that just getting a connection to it would be impossible without stopping the DHCP server.
You can find out just by trying a connection to the database file which, I THINK, is in C:\Windows\System32\dhcp\dhcp.mdb, or somewhere south of there. If the OleDbConnection fails to open, try stopping the DHCP service and try it again. If it works, you have your answer.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I am writing a front-end for a car PC project. I have managed to code an FM Tuner and an MP3 player by using windows messages and Winamp. My next part of the project is a DVD player. At first I thought that this would be quite easy, use WMP. So I tried and got a few of the functions working, but it keeps crashing and rebooting the computer at random times. I have read a lot about using it and everyone says that DirectX is the way to go, (well DirectShow anyway). Please could someone give me a sample piece of code for VB.net as I have searched for hours and can't find anything.
Thanks in advance for any replys
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
