|
Cant use wildcards with "LIKE" accessing oracle database
objDv = FilterDataSet(objDs, "SUPERVISOR_NAME LIKE 'se_n'")
where objDs is the data set
should return "sean" but is not
not fimilar with wildcards any ideas?
Cheers
|
|
|
|
|
This should work:
objDv = FilterDataSet(objDs, "SUPERVISOR_NAME LIKE '%se_n%'")
WM.
What about weapons of mass-construction?
|
|
|
|
|
No didnt work dont think dataset supports the wildcard "_" any other soloutions?
|
|
|
|
|
Hi All,
I dwnlded the article "Simulating recordset with ADO.NET".I found the coding was meant for SQLserver....I tried to modify to Access DB ..... What shl I do to replace these lines(Its meant for SQLConnection)
' Cursor declared with a SQL-92 syntax (BooksOnLine)
cmd.CommandText = "DECLARE crsr SCROLL CURSOR FOR " & mSelectString
cmd.ExecuteNonQuery()
cmd.CommandText = "OPEN crsr"
cmd.ExecuteNonQuery()
priya
|
|
|
|
|
AFAIK, Access/Jet doesn't support Scroll Cursors.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks ......... Is there any alternative
|
|
|
|
|
MSDE or some other DB besides Access.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
anyone knows the way to open the default email program with an attachment file??
Actually, i have found some code from internet. but,this code not able to attach a file to the email program. the code i found was written below.. thanks for helps..
Function openclient()
'string builder used for concatination
Dim MsgBuilder As New System.Text.StringBuilder
MsgBuilder.Append("mailto:abc@hotmail.com")
MsgBuilder.Append("&subject=this is test subject")
MsgBuilder.Append("&body=this is test body")
MsgBuilder.Append("&Attach=C:\abc.txt")
'Debug.WriteLine(MsgBuilder.ToString)
ExecuteFile(MsgBuilder.ToString)
End Function
Private Function ExecuteFile(ByVal FileName As String) As Boolean
Dim myProcess As New Process
myProcess.StartInfo.FileName = FileName
myProcess.StartInfo.UseShellExecute = True
myProcess.StartInfo.RedirectStandardOutput = False
myProcess.Start()
myProcess.Dispose()
End Function
|
|
|
|
|
Your code will generate a commanline like this:
mailto:abc@hotmail.com&subject=this is a test subject...
The & sign before "subject" should be a ? instead. All name value pairs after the first should be prefixed with a &. Like this:
mailto:abc@hotmail.com?subject=This is the subject&body=Message body...
Keep in mind that not all email clients support attachments from the command line. Some even have problems just interpreting the line...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
in vb.net ,how to get ascii value of a given character? (asc in vb6)
Regards,
aB
|
|
|
|
|
use ascw function for that
|
|
|
|
|
 looking for a way to create generic call center answer phone simple response menu useing voice modem is this possible
|
|
|
|
|
|
jimmysipe wrote:
is this possible
Yes...
jimmysipe wrote:
looking for a way to create generic call center answer phone simple response menu useing voice modem
If you have a TAPI compatible modem, then yes, there are lots of ways.
Unfortunatly, you've asked such a generic question, we really can't answer more then that.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
in c++, there a thing call Crecttrack. which is the tracking tool.Can it be done in vb.net? what is this called in vb.net.thanks
|
|
|
|
|
I'd say you need to write your own.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
The .NET Framework doesn't have an equivelent. You'll have to roll your own.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
First of all, I must say that my english language is very poor ,so excuse my stupid phrases  .
The Issue:
Now I had finished my User Control but I want to add a opacity percent property to it, I keep think and think but finally I have nothing , so I am wating for your great help ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif) .
Finally, I really feel that I must say that I think this web site is the best.
___________________________________________________
Sometimes when you happy no one see your smile
And sometimes when you sad no one see your tears
|
|
|
|
|
I can't believe this!!!
It must be someone in somewhere know the answer
Please any body... what you want me to do begging you?!
|
|
|
|
|
Add a Public Property to your control, just like any other. You'll also have to set your controls style that says your painting code support transparency. Then you'll have to update your painting code to support it.
In other words, this is something you should have designed into your control from the start. Adding it as an afterthought is a bit more difficult.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I don't think it's that difficult...
Lets say your old painting code looks like this:
Protected Overrides Sub OnPaint(ByVal e As System.Windows.Forms.PaintEventArgs)
MyBase.OnPaint(e)
'Painting starts here...
e.Graphics.FillEllipse(Brushes.CadetBlue, Me.ClientRectangle)
'Painting done
End Sub
Then your new paint code can look like this:
Protected Overrides Sub OnPaint(ByVal e As System.Windows.Forms.PaintEventArgs)
MyBase.OnPaint(e)
'Graphics of a bitmap to paint on instead of e.Graphics
Dim bmp As New Bitmap(Me.Width, Me.Height, Imaging.PixelFormat.Format32bppPArgb)
Dim g As Graphics = Graphics.FromImage(bmp)
'Painting starts here...
'Use g instead of e.GRaphics
g.FillEllipse(Brushes.CadetBlue, Me.ClientRectangle)
''Painting done
'Get rid of bmp graphics
g.Dispose()
'Assuming that Opacity is a Single from 0 to 1
If Me.Opacity = 1 Then
'Opacity = 100%, so just draw bmp
e.Graphics.DrawImageUnscaled(bmp, 0, 0)
Else 'Opacity less than 100%
'Attributes for the bmp
Dim attrib As New Imaging.ImageAttributes
'ColorMatrix for the transparency of the bmp
Dim colorm As New Imaging.ColorMatrix
'Set the Opacity of the colormatrix
colorm.Matrix33 = Opacity
'Set the colormatrix of the attributes
attrib.SetColorMatrix(colorm)
'Draw the bmp on e.Graphics with the right opacity
e.Graphics.DrawImage(bmp, New Rectangle(0, 0, bmp.Width, bmp.Height), 0, 0, bmp.Width, bmp.Height, GraphicsUnit.Pixel, attrib)
'Get rid of the attributes
attrib.Dispose()
End If
'Get rid of the bitmap
bmp.Dispose
End Sub
Hope this helps 
|
|
|
|
|
Doesn't help me, I know this stuff already. You might want to reply to the OP, though.
Hopefully, he doesn't just cut and paste your code and expect it to work!  And, yes, I still say this should have been a consideration when the control was designed and not an after thought.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I already added the porperty and set my control style to support transparency, I just want to know how to make the opacity in the painting code and (Absof***inlutely) give me the key so thank you all,
and i am not just cutting and pasting the code 
|
|
|
|
|
I'm happy to have helped you,
and i don't mind if you paste the code, do as you want!
But i maybe the code doesn't work (as Dave suggested), i didn't test it ...
For more info, check www.bobpowel.net!
That's a great site (though CP still is better;P)
|
|
|
|
|
Hi to all,
Is there any way to lock desktop after certain ammount of time.Like in xp ,it get automatically log off and ask for login.Just like that cant we make our login screen using winform (vb.net) to log in??
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
