|
I have a datatable which I wish to search for 'Like' matches. So searching for "p" would bring up the entries "p1", "Pea green", "p3" etc. I have code
DataRow[] foundRows;
foundRows = debtorDataSet.Tables["AutoText"].Select("Code LIKE " + lastWord + "%" );
if (foundRows.Length == 1)
{
....
}
else
{
....
}
but this is not working. Any pointers much appreciated.
|
|
|
|
|
as it is a string literal you are using, your statement seems to be missing some quotes, try this:
...Select("Code LIKE '" + lastWord + "%'" );
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
|
|
If column name is (FIRST NAME)
If I use as Select("FIRST NAME LIKE '" + lastWord + "%'" );
It shows error
|
|
|
|
|
It is a bad idea to post a question to a more than four years old thread. Most users here will not even see it.
If you got an error message, add the full message text to your question. That helps others to help you.
However, your column name contains a space. Then you have to enclose it in brackets:
Select("[FIRST NAME] LIKE '" + lastWord + "%'" );
|
|
|
|
|
Luc's already given you the information you need, but I'd like to suggest that you should also look at using string.Format rather than explicit string concatenation - sometimes it just makes it easier to read. So, you'd end up with something like string.Format("code like '{0}%'", lastWord);
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hi All,
I have a window form.If we change the window state of the form to the maximized then the controls under that windows form does not change their Location and the size.I want that at run time after maximizing the windows form the controls under that form should automatically change their Location and size.
Please give me the solution,its urgent.
Warm Regards,
Lalit Narayan
|
|
|
|
|
Hi,
you can modify the Anchor and Dock properties of some controls, to get some standard behavior.
or you can add code to the Resize event to define your own behavior.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Hi all...
I have associated an ImageList with a TreeView, but now all of the nodes in the treeView has icons besides them.
Is there a way to remove the icons to some nodes, so they will be with no icon beside them??
|
|
|
|
|
The only way I know of is to create a blank icon in the ImageList and assign that - it still leave space for it though.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
I have developed the C#.net window application. Setup of this project is running on PC, where .NET Framework is installed but where .NET Framework is not installed setup is not running. So I want to install first .NET Framework by default and then start running actual setup of project.
This should be for crystal report also.
How can I do it.
|
|
|
|
|
Good morning swami
how do you expect a .net developed application to run where there is no .net installed ?
Secondly as a .net programmer this should always be in your mind. Before you start coding you must have decided what is a target framework for your application. e.g
Visual Studio 2003 = .net 1.1
Visual Studio 2005 = .net 2.0
Visual Studio 2008 = .net 3.5
You must install these frameworks depending to your target framework. lastly please please please buy a book and read , you cant learn everything on the internet. the reason i say this is because in every book this is a basic lesson an author gives to his reader and its very easy to understand.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
you have not understood my quote, plz don't give answer
|
|
|
|
|
That is quite rude of you - he gave a prefectly sensible answer.
However, the info you want is here: install .net with application[^]
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
I normally hate your behavior , not you. i will pray for you that you change.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
After slacking on the C# front for a year or two, I've decided to have another look. Previously I used C# for the web, but now I'm looking into creating desktop apps. And I'd like to use one of the latest technologies (to save me having to learn another one in a year's time...). I'd also particularly like to target Windows 7 - but also be able to make some apps for XP. My question is:
Which technology do you think is best to use for creating my desktop apps and why? Windows Presentation Foundation? Windows Forms? Other? I really don't have a clue, so I'm hoping for a nudge in the right direction!
Cheers.
|
|
|
|
|
There is one thing i will say to you. WPF is the Next Generation.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Marc Firth wrote: Which technology do you think is best to use for creating my desktop apps and why? Windows Presentation Foundation? Windows Forms? Other?
That's a tricky question, and not one that's easy to answer. First of all, let's address a misconception - WinForms aren't going to go away anytime soon, so learning them isn't going to be wasted effort. You'll still be able to develop desktop applications in them for a long time to come.
Now, saying that, I'd choose WPF over WinForms for a number of reasons.
1. While WinForms isn't going away, it's not going to be actively improved by MS, so you're stuck with what you get.
2. WPF makes it easier to create data bound applications. Rather than having to write lots of string myValue = txtName.Text; and txtName.Text = dr[dr.GetOrdinal("MyValue")].ToString(); code, you can use two way databinding in WPF to good effect.
3. It's easy to change the look and feel of WPF applications.
4. If you want to move over to Silverlight, it's based on WPF so the transition is a lot easier.
5. Microsoft is actively targetting improving WPF, and is starting to use it in its own applications.
6. The infrastructure underlying WPF is a whole lot more powerful.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Rated 5 - Good Answer! Thanks.
Pete O'Hanlon wrote: 1. While WinForms isn't going away, it's not going to be actively improved by MS
That's quite a big one I think. Whilst I'm sure there are a range of controls, code and tutorials available - I am looking at future expandability. So WPF looks like the way to go. Plus I've strong skills in web design (PHP,HTML,CSS,etc), so what I've seen of XAML is looking quite useful for GUIs and I think it'll be quite familiar.
I think WPF is the way to go for me...
Thanks again.
|
|
|
|
|
Marc Firth wrote: Plus I've strong skills in web design (PHP,HTML,CSS,etc), so what I've seen of XAML is looking quite useful for GUIs and I think it'll be quite familiar.
That's why I wrote this[^] article. If you're a web developer, WPF is a lot easier to get your head round.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Good article too. I used the beta/alpha version of MS blend and web and thought they were great. But they were too buggy at the time to keep learning on - maybe I should take your advice and invest.
|
|
|
|
|
I think you should try both atleast for practice level.
than you are in better position to decide your self
|
|
|
|
|
Well, I'd do winforms, because
1) the drag 'n drop editor does not suck
2) existing code will fit it better because everyone is used to it
3) text rendering is not blurry and headache-inducing
4) you're not writing an advert so why does it have to look flashy?
|
|
|
|
|
harold aptroot wrote: 1) the drag 'n drop editor does not suck
Do you mean the wysiwyg editor for creating the actual forms?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
