|
hi i want to filter base on lastname and firstname encode by the user in textbox1 and texbox2.. but i'm having hard time for the right code for this..heres my code but not functioning.. plz help hows the right way..
<br />
<br />
<br />
bindingSource1.Filter = "LASTNAME like '" + textBox1.Text.Trim() + "%'" AND FIRSTNAME like '" + textBox2.Text.Trim() + "%'";<br />
<br />
bindingSource1.Sort = "LASTNAME";<br />
<br />
<br />
<br />
<br />
|
|
|
|
|
What is happening? Or not happening that you expect to happen?
Obviously, it will depend on the content of textBox1 and textBox2, but I imaging they are pretty simple and you have checked them.
Try replacing the textboxes with something you know will match in the DB:
"LASTNAME like 'JON%' AND FIRSTNAME like 'MAT%'"
with a MATTHEW JONES in the DB.
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
i want to know to retrieve mails using the pop3 from gmail
|
|
|
|
|
Is Google not working where you are? A simple search using your own words with "C#" tagged on teh end gives thousands of code examples! "retrieve mails using the pop3 from gmail c#" is what I tried...
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
|
hi guys,
Iam try to validate a south african phone number.
I have tried this but it won't work:
Regex rx = new Regex(((?:\\+27|27)|0)(72|82|73|83|74|84)(\\d{7}));
here is an example of numbers I would want to validate:
- 0 74 3720198
- 0 72 3720198
- 27 74 3720198
- +27 74 3720198
Please help me if Iam making a mistake somewhere
I have tried google but no help so far...
Thanks,
Morgan Freeman
|
|
|
|
|
I'm afraid I can't help much with the regex for SA numbers, as I don't know the ins-and-outs of how they are comprised. (Someone else here might be able to help directly), but this [free] tool will speed up validation:
http://www.radsoftware.com.au/regexdesigner/[^]
Also this could be of some help:
http://regexlib.com/Search.aspx?k=south+africa[^]
Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
|
|
|
|
|
thanks man
I will try your links and thanks alot
Morg
|
|
|
|
|
Your first problem is the spaces between the digits.
Try something a bit simpler, and work your way up to the full expression:
"((0\s)|(27\s))(?<AreaCode>[0-9]{2})(?<LocalNumber>\s[0-9]{7})"
Feed this into Expresso[^] - examines and generates Regular expressions. It's free, and it really helps!
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
OriginalGriff wrote: Your first problem is the spaces between the digits
thanks man, with spaces I was just trying to indicate where the full number is branched or divided
I will try your idea and thanks alot
Morg
|
|
|
|
|
hey hey thanks man that program is so cool, I managed
to figure out what was wrong, the right expr:
Regex rx = new Regex("((?:\+27|27)|0)(72|82|73|83|74|84)(\d{7})");
Great one!
|
|
|
|
|
I wish I'd written it!
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
Hi,
First of all, regular expression must be defined using a string, so you have to instanciate it that way :
Regex rx = new Regex("((?:\\+27|27)|0)(72|82|73|83|74|84)(\\d{7})");
Moreover, as OriginalGriff told you, consider using a tool like Expresso to build and test your regular expressions.
Regards.
|
|
|
|
|
|
Hello!
Recently I have troubles with the following problem.
There's a website (unfortunately it is htpps) where you need to enter 2 values in a form. After you press the button, a POST method is invoked and based on entered values some calculations are made. The final values are dynamically (ajax) put in the corresponding part of the page.
What I need to do is to read this values and store in my database.
My idea was somehow to get source page after all ajax calls are made and grab needed values from it. The problem I have encountered is that I cannot get that kind of source. Using System.Net.WebClient and its UploadStringAsync method I only get the primary source. I tried this source, and some other, async one using UploadStringAsync and UploadStringCompletedEventHandler - results are the same.
Next idea was somehow to capture ajax responses (when certain number is calculated and inserted in the page), because basically that's all I need, the result numbers, but I haven't found any ways to do it.
So, is there a solution to my problem? I forgot to mention that I am trying to code it as a C# project.
|
|
|
|
|
You have been advised to use the ASP.NET forum previously for AJAX questions:
http://www.codeproject.com/Messages/3179251/Re-AJAX-Csharp-and-webpage-source.aspx[^]
The other thing is, getting the values from AJAX based pages isn't any different from normal, unless you have done something out of the ordinary. I suggest you find a good beginners book on this stuff.
Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
|
|
|
|
|
Hi,
I have a PictureBox inside a Panel control, the Panel being used to obtain scrollbars for the PictureBox. Having come from Delphi I can't work out a way to make the scrollbars update the position of an image in the PictureBox while the mouse drags the scrollbars (it only updates after the mouse is released).
IIRC with Delphi it was easily done by changing a couple of properties in a TScrollBox component. Does this have to be done manually in the Scroll event handler? Or would it be better to create my own scrolling control for this?
Thanks,
Dave.
|
|
|
|
|
you can also try div for this.
|
|
|
|
|
Best wishes,
Navaneeth
|
|
|
|
|
I assume PictureBox automagically handles the scrollbar's ValueChanged event. For smoother response, I expect you'll need to handle Scroll [^].
/ravi
|
|
|
|
|
I am using the following to save and use public variables:
<pre>private static int? _system_id;
public int? system_id
{
get { return _system_id; }
set { _system_id = value; }
}
</pre>
but now I have many fields from my system_parameters sql server table and i want to save it as public variable.. is it possible to get the field name as public variable name and field value as public variable value so it can be created at run time?
|
|
|
|
|
Probably create a separate class to hold the values or perhaps use a Dictionary to store them.
Basically, as I told you yesterday[^].
|
|
|
|
|
yup...
I knw about yesterday but I just wanted to know how to create it at run time instead of creating at design time..
|
|
|
|
|
Without resorting to codeDOM and dynamically generating code or an assembly, there is no way to create a variable or property at runtime.
You could use a hashtable.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
well, i was thinking of an sql table with the following fields:
system_param_id int (PrimaryKey)
system_param_name varchar(50)
system_param_value varchar(50)
and when logging to the system then it will populate each record with two things:
param_name
param_value
so if I have 100 records in that table then I will have 100 variables..
what's the best method to use?
|
|
|
|