|
It is returning records because you have two sets of wildcards in the query. In other words, you have the % and the _ characters. Effectively, your query is %TEST%.
|
|
|
|
|
If you want to use the _ as a valid identifier in your query rather than having it act as a wildcard, you should precede it with a \, so your query would become %TEST\_%.
|
|
|
|
|
Are you aware that, in Sql Server at least, the underscore character (_) is the wildcard for a single character? Very nasty in my opinion. You may wish to specify a different character in your query.
|
|
|
|
|
Hi
I have 50 splitcontainers.. i want to read all the splitcontainers & its panels programmatically...Is it possible...?
Because the below code only reads Splitcontainer4 & Panel1, But Iam looking to read all the splitcontainers and its panels programmatically...
foreach (Control Ctrl in this.splitContainer4.Panel1.Controls)
{
if (Ctrl is RichTextBox)
{
((RichTextBox)(Ctrl)).KeyPress += new KeyPressEventHandler(this.Common_KeyPress);
}
}
Thanks for ideas...
Regards
PARAMU
|
|
|
|
|
Just expand your code to add a foreach statement to check each SplitContainer in this, and each Panel in the SplitContainers.
The best things in life are not things.
|
|
|
|
|
Can you show some samples..I tried...I didn't get...?
foreach (Control AllCtrl in this.Controls)
{
if (AllCtrl is SplitContainer)
{
foreach (Panel MyPanes in AllCtrl.Controls)
{
MessageBox.Show(MyPanes.Name, "some text", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
Thanks
|
|
|
|
|
Paramu1973 wrote: I didn't get
Didn't get what?
Try running this in your debugger to see exactly what containers you are picking up at each point. Apart from anything else it will help you to understand exactly what each step of your program is doing.
The best things in life are not things.
|
|
|
|
|
Hi Thanks.
But the problem is splitcontainer1.panel2 is having splitcontainer2
And splitcontainer2.panel1 is having splitcontainer3
and splitcontainer3.panel2 is having splitcontainer4
and splitcontainer4.panel2 is having richtextbox1
like wise no any order..they docked...and some panels are having label & some panels are having richtextbox...
I need to catch that control...
Thanks
|
|
|
|
|
Naming a variable "AllControls" won't get you "all controls". Instead, when you find a SplitPanel, call your method again, using the SplitPanel as the new source;
void Bla(Control SourceCtl)
{
foreach (Control Ctrl in SourceCtl)
{
if (Ctrl is RichTextBox)
{
((RichTextBox)(Ctrl)).KeyPress += new KeyPressEventHandler(this.Common_KeyPress);
}
else if (Ctrl is SplitPanel)
{
Bla(Ctrl);
}
}
}
The technique is called recursion. (Didn't test the method, but should be close enough to get you started)
Bastard Programmer from Hell 
|
|
|
|
|
You're getting closer. Try this:
void DoAllRichTextBoxes(Control control) {
RichTextBox rtb=control as RichTextBox;
if (rtb==null) {
foreach(Control c in control.Controls) DoAllRichTextBoxes(c);
} else {
rtb.KeyPress+=new KeyPressEventHandler(this.Common_KeyPress);
}
}
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
I got it. Thanks a lot.
Again Thanks Regards
PARAMU![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
you're welcome
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
If you've got 50 splitcontainers on a form, your bigger problem is that you have a user interface that is horrible. For the vast majority of apps, 2 splits on a single form would probably be the maximum you would ever use at once.
|
|
|
|
|
Loop all controls on your form and match all splitContainers, for each splitContainer loop controls to find your RichTextBox.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.cacttus.com
|
|
|
|
|
Controls can be nested in a hierarchy. A SplitContainer typically contains two Panels, inside these Panels you could have RichTextBoxes directly, but also other Containers (Panels, GroupBoxes, SplitContainers, ...) which again contain whatever you like.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
whats the need of this much spit containers ?
|
|
|
|
|
Hello,
I have question in my mind since long time. While using exception handling, we guess which exception would come and use catch block like, catch(FileNotFoundException) or DivdeByZero etc.
Instead of this why should I not always us base class 'Exception' and let .Net Framework decide which exception has occurred? And using StackTrace property we can easily know type of exception.
Regards
|
|
|
|
|
You are free to do it any way you like in your code. However, the reason for catching specific exceptions is that you may be able to take some action that will recover from the error. For example, if you catch FileNotFoundException then you can always offer the user the opportunity to manually select a different file etc. If you just print out the stack trace and terminate you may have wasted some minutes or hours of the user's working day.
The best things in life are not things.
|
|
|
|
|
Pranit Kothari wrote: Instead of this why should I not always us base class 'Exception' and let .Net
Framework decide which exception has occurred?
To add to Richard's comment, by catching several exception types you can distinguish what has gone wrong (and depending upon the type, as Richard says , recover). If you just catch Exception you can't do this as easily, you also potentially hide things that are going wrong in your code, I've seen this:
try
{
}
catch
{
}
This is appalling discipline. If you are worried about exceptions getting to the user (and my take is that as far as possible they never should) you can add "catch all" blocks (sometimes called Top Level Exception Handling), which at the minium should inform the user that something unexpected has gone wrong and (optionally, possibly dependant on build type) log the error/stacktrace somewhere. This[^] looks like a pretty good article on this strategy, but I think the Introduction unintentionally misleads the reader: this Top Level Exception Handling is really to catch unhandled exceptions, you should really catch those you can where they are called and deal with them there.
|
|
|
|
|
I think , it is not a good practice to catch Top level exception.If you are catching the exception for logging and re-throwing , use top level .Otherwise go for specific exceptions.Dont try to catch exceptions like "divideByZeroException" , because you can fix such exceptions in the code itself.
modified on Monday, May 23, 2011 6:21 AM
|
|
|
|
|
I assure you, that Top Level Exception handling is good practise for user facing applications, it is really bad to allow the user to see a raw .net exception. At best it will give the user a load of technical detail that will get them annoyed as they won't understand it, poor dears, this will also make them think the problem is worse than it is when compared to a friendly "Something has gone wrong" popup. At worst I've seen the unhandle exception expose sensitive informtaion such as a connection string with password. Another benefit of Top-Level handlers, is logging for unexpected exceptions across the whole app, this allows the dev team to add new try/catch blocks for specific exceptions that were missed before release. This strategy quickly helps build robust systems.
What is bad practise is to locally provide a "catch all", you should try to catch only specific exception types locally.
|
|
|
|
|
|
There are two courses in one DataGridView, the name and status, the names of those who have the situation I want to show the messagebox. How do I do this?
image : http://www.imageupload.org/?d=302251731[^]
|
|
|
|
|
This got voted down, presumably for the English; however I do not think that fair so I have added a five.
If I understand your question correctly you want to check each row in the grid that contains a keyword ('var' or 'yok'), and take some action based on that word. You will need to iterate through the rows of the grid and check the value in the second column for a match. I expect you need to start with the Rows[^] collection, and proceed from there.
The best things in life are not things.
|
|
|
|
|
Hi, I have 20 TextBoxes in a form. And I have a Common KeyPress Event for all of that Textboxes.
So I try to declare the keypress event like the following manner... is it possible?
for (int Cnl = 1; Cnl < 21; Cnl++)
{
((RichTextBox)Cnl).KeyPress += new KeyPressEventHandler(this.Comn_KeyPress);
}
Thanks for the Ideas..
PARAMU
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
