|
You can use the SQL intrinsic stored procedure xp_cmdshell in a trigger to call an external app. That app could then notify your app that a change has occured.
Or you could write an app that monitors the windows event log and put xp_logevent call in your trigger to send an alert to the event log.
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
Thanx Duncan,
I red on a few places to use xp_cmdshell but it don't know how to do it, haven't found any sample code and also i think it can only be done with c++(non .net languages). Can you please refer me to somewhere where i can find some sort of an example
Qaiser
|
|
|
|
|
I have developed a Windows Service, which send daily SMS using Clickatell SMS Gateway and getting values from remote MS SQL server but the problem is service works fine for some time like 10 days, some times 5 days, some times just for 2 days but the service is not stable, it don’t work for a long time, I am in a deep trouble kindly help me as soon as possible, I'll be very thankful to you all, especially a person who will help me.
|
|
|
|
|
Hisham Javed,
Check to see if you are using the right kind of timer for the job..
or you could post the code so we can see what your service is doing.
progload
|
|
|
|
|
Well, thanks for response. I am sending you the only source code, Please check this code and suggest me a better approch if there is any. i have sent you an email with source zip file code
Thank you very much for taking interest in my problem.
-- modified at 17:56 Friday 10th March, 2006
|
|
|
|
|
Maybe you have a memory leak chewing up resources - or possibly un unhandled exception?
Have you inspected the event logs for any clues?
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
Hello! 
My aim is to use one of DLL file what resides under the application's startup path. However the declaration below is looking for the dll file under the system directory of windows. If you have any idea, how to declare a dll file with a speific path, please let me know. Application.StartupPath cannot be used with a constant variable.
Thank You!
Public Declare Function kWabOpen Lib "wab.dll" (ByRef kw As tWab) As Boolean
|
|
|
|
|
B Journey,
The default path your program look to find a dll
is normaly, in this order:
If it is registered... right to location where it is registered.
Otherwise:
1.Directory containing the .exe file
2.Current directory
3.Windows system directory (often but not always \Windows\System)
4.Windows directory (not necessarily \Windows)
5.Path environment variable
Do you have it registered? if you do, unregister it and put it in the folder with your applications .exe file.
progload
|
|
|
|
|
Thanks Progload!
Sorry I didn't have time to return you according wab related project which we suppose to be working on it. My father passed away and I couldn't find time to work on it. Finally I found kwab.dll file which is free to use it even commercially.
I successfully fixed the errors in the program because of version differencies. Now it is working! However, it is looking kwab.dll file under windows/system32 directory. I put it under executable file's directory but it didn't work out.
I didn't register the kwab.dll that what is confusing me...
Thanks!
|
|
|
|
|
Interesting...
I downloaded the kwab1.2.zip from the authors site..
In the note.txt file it states:
"The dll must reside
- in the same folder of the executables that use it
or
- in the system32 directory in the windows folder (C:\WINNT or C:\WINDOWS)"
Is how you declared it correct? I noticed in your post you put wab.dll not kWab.dll
"Public Declare Function kWabOpen Lib "wab.dll" (ByRef kw As tWab) As Boolean"
Shouldn't it be declared:
Public Declare Function kWabOpen Lib "kWab.dll" (ByRef kw As tWab) As Boolean
progload
|
|
|
|
|
Thanks progload!
I have solved the problem it was my mistake. It was out of my attention. The dll file wasn't under the bin directory. I moved the file under the bin directory and now it is working!
Thank You!
|
|
|
|
|
Hi,
can any one tell me how to find the code for GoogleToolbar1.dll
which we are using in IExplore.
thanks
Paritosh
|
|
|
|
|
|
i'm doing a dice function which user click on the button then the dice will start rolling a while then it stop itself. i only able to make it random dice, but there is some problem when it stop casue after it stop it cannot perfomr my next action.Anyone pls correct my mistake ? :
---when user click on the button
Private Sub Dice_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Dice.Click
DiceTime.Enabled = True
movepiece()
End Sub
-----run tis when DiceTime.enabled=True
Private Sub DiceTime_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DiceTime.Tick
'Randomly pick a number from 1 to 6
Dim z, y, bc As Integer
Randomize(bc)
For z = 1 To 6
dicelabel.Visible = True
Next
y = (Int(Rnd() * 6) + 1)
dicelabel.Text = y
BTime.Enabled = True
End Sub
---- plan to stop it after the dice rolling a while
Private Sub BTime_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTime.Tick
DiceTime.Enabled = False
End Sub
|
|
|
|
|
Move BTime.Enabled = True out of the DiceTime_Tick() method and into your Dice_Click() method. This will help reduce the chance of bugs by ensuring this timer is only started at the start of a dice roll.
Add BTime.Enabled = False to your BTime_Tick() method.
This is why it's not working for you. This timer was still running and was turning off your DiceTimer.
|
|
|
|
|
I have a windows application that has been developed in VB.NET 2003. As part of this application I have included a help (chm) file that can be called from the main application menu, or using F1 on one of the data entry screens.
I am having a small issue in navigating within the help file when calling it from F1. Here is an example of the code I have implemented:
Private help As New HelpProvider
help.HelpNamespace = Application.StartupPath & "\HelpFileName.chm"
help.SetHelpKeyword(Me, "PageName.htm")
help.SetHelpNavigator(Me, HelpNavigator.Topic)
When I click F1 from a data entry screen, the help file is loaded and the correct page is displayed. The problem I have is that the Contents page is still show the first icon and does not navidate to the correct page marker. Therefore the user cannot see the location of the displayed page in the contents panel.
Is there any way of getting the contents page to also navigate to the page name for the specific page that is being displayed so the user can see where they are.
Thanks
Jason
|
|
|
|
|
how can i count the total no of row in datagrid vb.net
asdf
|
|
|
|
|
|
kostasdiktia2 wrote: DataGrid1.RowCount
buth -1
<blink>FeRtoll Software.net
------------
E-Mail me
WebPage
|
|
|
|
|
Hi: help code program play sound wav from path "C:\dicsound\sound\..."soundfilename" by SELECT * From diccom ORDER BY id_dic ASC
///////////////////////////////////////////////////////////////////////
Private Sub ShowPostion()
'Dim Oledr As OleDbDataReader
Dim oleCmd As OleDbCommand
Dim sqlTmp As String
Dim box As New PictureBox
sqlTmp = "SELECT * From diccom ORDER BY id_dic ASC"
Cursor.Current = Cursors.WaitCursor
With Conn
If .State = ConnectionState.Open Then .Close()
.ConnectionString = strConn
.Open()
End With
oleCmd = New OleDbCommand
daPro = New OleDbDataAdapter(sqlTmp, Conn)
daPro.Fill(ds, "testdic")
TextBox1.Text = (ds.Tables("testdic").Rows(0).Item("id_dic"))
TextBox2.Text = (ds.Tables("testdic").Rows(0).Item("read_dic"))
TextBox3.Text = (ds.Tables("testdic").Rows(0).Item("sub_dic"))
TextBox4.Text = (ds.Tables("testdic").Rows(0).Item("content_dic"))
TextBox5.Text = (ds.Tables("testdic").Rows(0).Item("sample_dic"))
soundbox.Text = (ds.Tables("testdic").Rows(0).Item("soundFilename"))
Conn.Close()
asp dropdownlist for access
|
|
|
|
|
por favor alguien puede decirme como cuando pongo el puntero del mouse sobre un grafico(o sea un Graphics que esta dibujado sobre un PictureBox) puedo tomar las Coordenadas X y Y del grafico donde esta el puntero?
Gracias
|
|
|
|
|
Babelfish translation for those who can possibly help...
please somebody can say to me like when I put the leader of mouse on grafico(o is a Graphics that this drawn on a PictureBox) I can take Coordinates X and and of the grafico where this the leader?<br />
<br />
Thanks.
Please post in english if possible.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
-- modified at 0:48 Thursday 9th March, 2006
|
|
|
|
|
Somthing like this...
Private Sub PictureBox1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles PictureBox1.MouseMove
Label1.Text = "X." & e.X & " " & "Y." & e.Y
End Sub
progload
|
|
|
|
|
Hi all,
I am building a online dating site (users may be 200-300 or more). each user can only store upto 5 images. my table structure looks like below
------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserImage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserImage]
GO
CREATE TABLE [dbo].[UserImage] (
[Bits] [image] NULL ,
[Description] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UserId] [int] NULL ,
[UserImageId] [int] NULL ,
[UploadTime] [datetime] NULL ,
[ImageSize] [int] NULL ,
[Mime] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
------
I just want to know will it have any performance issue when i store images in DB rather than in file and only have a reference to that filename in DB?
I dont want my user to type the URL parameter and do silly stuff such as.
i only want them to type
www.mysite.com
and if they type in URL anything other than that it should take them to
a page saying page not found or sumthing. the reason is.
when i delete image i am getting a parameter from query. like
www.mysite.com/managepictures.aspx?UserId=12&DeleteImgId=4
that means if user passes diff. parameter it will actually delete others image and they can even browse the pic by chaning UserID para.
i dont know how to achieve this
please help
many thanks in forward
Robin
|
|
|
|
|
In general, storing images in a database for this purpose is probably not a good idea. Your database will grow very large over time and become unmanageable (and possibly performance will degrade too).
The better way would be to store the images in the file system and store the path to those images in the database.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
