|
Dim refDV As DataView = New DataView(DataSet11.Tables("references"))
refDV.RowFilter = "" & ComboBox1.SelectedItem & " = like ('%" & TextBox4.Text & "%')"
DataGrid1.DataSource = refDV
=================================
Above code cause error
"Missing operand before '=' operator"
Why that happen. I want to perform selection using 'like' operator as in sql statement and want to include control inside the filtering.
Could someone help plz.
|
|
|
|
|
Get rid of the '=' operator.
WM.
What about weapons of mass-construction?
|
|
|
|
|
The error like this again
"Missing operand before 'like' operator"
those message is really i cant get it.
|
|
|
|
|
refDV.RowFilter = "" & ComboBox1.SelectedItem & " = ('%" & TextBox4.Text & "%')"
Maybe this will work.
WM.
What about weapons of mass-construction?
|
|
|
|
|
Hi,
- Operator "=" will not take place with the "Like" Operator.
With Regards,
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
