|
Here are some more links: (Same image all of them)
http://xs136.xs.to/xs136/09074/clipboard01md8980.png
http://bildr.no/image/345164.jpeg
http://s5.tinypic.com/2aihpxf.jpg
The red text says:
"Here, i should be able to drag controllers from the visual studio designer, just like a normal tabcontrol"
|
|
|
|
|
I am trying to filter fields in a table that contain percent (%) and apostrophe (') characters. I kow that to filter an apostrophe you need to add another apostrophe (''). However, when a text contains the percent (%) character in combination with an apostrophe (') character, an exception is thrown. Also, when using the % character in a filter string, it will be function as an "*" (fields starting or ending with). I need the % to be considered as a character whenever the % makes part of a string in the field. How can I address these issues?
To explain my question, say I have a table with 6 rows with the strings below in one of its columns
AnyString
AnyString%
AnyString'
AnyString%'
AnyString%AA
AnyString%AA'
The code below and comments explain the issue.
TheTable.Select("Col1 Like 'AnyString%'") 'RETURNS ALL RECORDS STARTING WITH AnyString (TOTAL OF 6). IT IS EXPECTED, BUT NOT WHAT I NEED. I NEED ONLY ONE ROW: AnyString% <br />
<br />
TheTable.Select("Col1 Like 'AnyString%%'")'RETURNS ALL RECORDS STARTING WITH AnyString (TOTAL OF 6). I NEED ONLY ONE ROW: AnyString% <br />
<br />
TheTable.Select("Col1 Like "AnyString%''") 'RESULTS IN AN ERROR. I NEED TO GET AnyString%'<br />
TheTable.Select("Col1 Like 'AnyString%AA'")'RESULTS IN AN ERROR. I NEED TO GET AnyString%AA
So, I need a way to filter the % character as part of the string and not as a start/end with function.
|
|
|
|
|
Any ideas to this post please?
Let me try this. The example is just an ADO table with 6 rows. I just need to figure out the work around to filter a table that may contain the % character as "part of the string" and not be taken as a wildcard.
dim rows() as datarow = table.select("col1 LIKE 'Filter Me%') 'WHERE % IS PART OF THE STRING AND NOT A WILD CARD. THIS LINE SHOULD RETURN ALL RECORDS EQUAL TO "Filter Me%"
I would also need something like this of course
dim rows() as datarow = table.select("col1 LIKE 'Filter Me%*') '* IS THE WILD CARD AND % IS PART OF THE TEXT. THIS LINE SHOULD RETURN ALL RECORDS STARTING WITH Filter Me%
Thanks,
Mauricio
|
|
|
|
|
|
I want to Delete the Duplicate records from a perticular table except the minimum ID of these Duplicate records.............Using Sql Query
|
|
|
|
|
Are you doing this from a VB application or from a database environment? Also, what data is duplicated? Is it the entire row or just certain fields?
If you're doing this from a database application then you'd be better off posting in the database forum, you're more likely to get an answer there.
|
|
|
|
|
I am doing this from vb.net ;
And the Duplicate records are just certain field
not an entire row
|
|
|
|
|
Hi!
i have made a user control with combo box over it. now i want to hide the BorderStyle property of the user control so that end user could not change this property. how can i achieve this functionality?
|
|
|
|
|
You need to 'shadow' the BorderStyle property in your control, then set property attributes to hide it from the VS property editor, e.g.
<Browsable(False), DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _
Public Shadows Property BorderStyle() As BorderStyle
Get
Return MyBase.BorderStyle
End Get
Set(ByVal value As BorderStyle)
MyBase.BorderStyle = value
End Set
End Property
The Browsable attributes hides the property from the VS editor, the DesignerSerializationVisibility atrtibute stop the VS designer generating code for the property in the InitialiseComponent method. You need to use the Shadows keyword in the property def to stop the compiler generating a warning.
"An eye for an eye only ends up making the whole world blind"
|
|
|
|
|
Thanks a lot dear! its working fine.
|
|
|
|
|
Please tell me one thing. how can i add summary detail for my user control property? the way you can see for anyother property and methods and even for events in objectbrowser.
|
|
|
|
|
Hi, use the Description attribute. You may also want to check out the Category and DefaultValue attributes, e.g.
<Description("example property"), DefaultValue(1), Category("Testing")>
All these attributes are in the System.ComponentModel namespace
"An eye for an eye only ends up making the whole world blind"
|
|
|
|
|
hi to all,
I want to get last inserted id from a particular table,
how i write the sql query.....
|
|
|
|
|
Normally, you wouldn't do this at all. You let the database keep track of and assign the ID itself when you create a record.
Why? Well, say you have 2 clients accessing the database at the same time. They both execute that little function that returns the last ID used and they both get the same ID number. Then, they both generate the next logical ID number and try to use it. Boom. You either just corrupted your data because you don't have any constraints on the key column or you just got an exception thrown back in your face about using the same key more than one in a table.
|
|
|
|
|
Although you have 3 remarkable haphazard in your example, but they are acceptable 
Every table should have unique key (PK), that key is usually an Autoinc field type, when insert new record, the table will automatically generate the next ID to be used for the next client.
But very often, you need to make your own sequence number need to be written in the table, and you can usually do that by creating a table (numbering) which store in it the next ID for (let say new invoice) and you can luck this record and prevent any one from accessing this record and the user get his ID and unlock the row.
My point is, you will not let the database generate new ID for you in every situation.
Samir R. Ibrahim
modified on Friday, February 13, 2009 7:50 AM
|
|
|
|
|
True, but locking records manually is VERY problematic if not done with the utmost of care. Most newbies asking questions around here have no idea what they're doing, so using a solution like this is going to be beyond them.
|
|
|
|
|
I understood what you want to say.
Regards.
Samir R. Ibrahim
|
|
|
|
|
What has that to do with VB.Net?
SELECT @@IDENTITY returns the last inserted primary key.
|
|
|
|
|
I have an application in which i want to run multiple threads periodically.For this i am using the system.threading.timer in an array.
When i start the timer i also want to pass a string as a parameter to the timer callback method.There is a parameter; 'state as object'.Can i pass the the string through this?
For j As Integer = 0 To m_TimerList.Count - 1
'Dim oCallback As New TimerCallback(AddressOf timer1_tick)
Dim s As String = "1"
m_TimerList(j) = New System.Threading.Timer(m_Timercallbacklist(j), New Object() {s}, 1, 5000)
k = k + 1
Next
How do i get the string in the timer callback method 'timer1_tick'
|
|
|
|
|
|
I am still not getting it...dont know how to adapt the example for my case.
Private Sub timer1_tick(ByVal state As Object)
Dim j As String = DirectCast(state, String)
End Sub
this gives an error.
|
|
|
|
|
Ok, what error, an invalid cast exception maybe? I don't programme in VB but I think the answer may be to pass s directly not as New Object() {s}.
m_TimerList(j) = New System.Threading.Timer(m_Timercallbacklist(j), s, 1, 5000)
Alan.
|
|
|
|
|
thanks alot.that worked,
Dim s as string
m_TimerList(j) = New System.Threading.Timer(m_Timercallbacklist(j), s, 1, 5000)
in the timer callback method...
Private Sub timer1_tick(ByVal state As Object)
Dim st As String = state
End Sub
NO casting...what is it used for anyway?
|
|
|
|
|
It is used for when you have Option Strict on (which you should turn on by default in the Options menu)
|
|
|
|
|
Glad the problem is sorted now. The compiler has done an implicit cast of Object to String but if you were to specify "Option Strict On" in your code you would have had to explicitly code the cast.
It's not a bad idea to code with strict on as it forces you to state your intentions more precisely, i.e. this parameter of type Object is actually a String and must not be anything else. The explicit cast does that for you.
Many implicit conversions will succeed and then you can be left with a major problem debugging difficult to comprehend logic errors in your code. Option Strict On will stop many of these errors before they happen and make your code more reliable.
Alan.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
