C# Discussion Boards - CodeProject

hdv2129-Aug-09 23:50

9-Aug-09 23:50

Hi i want to connect to mysql database that exists in customer website host via client c# app (via MySqlConnector for .net), but when connection wants to open, i got this error :

Unable to connect to any of the specified MySQL hosts.

where is my problem and how to solve it ?

here is my connection string :

string conStr = "server=hostIPAddress;user id=userName; password=password; database=dbName;";

thanks

Re: Problem to connect to mysql via c#.

stancrm9-Aug-09 23:55

stancrm

9-Aug-09 23:55

read this :

probably your mysql are listening only to localhost.

http://stackoverflow.com/questions/938047/how-to-make-mysql-accept-connections-externally[^]

Re: Problem to connect to mysql via c#.

senguptaamlan11-Aug-09 1:06

senguptaamlan

11-Aug-09 1:06

go to the following link to see whether al the option in the connection string are given properly or not.

http://dev.mysql.com/doc/refman/5.0/en/connector-net-programming-connection-options.html[^]

also see that the Port at the hosting environment is not blocked, if blocked then register in the exception list in Windows Firewall, or any firewall setting in the host computer

Using 'Like' in DataTable select query

kanchoette9-Aug-09 23:47

kanchoette

9-Aug-09 23:47

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.

Re: Using 'Like' in DataTable select query

Luc Pattyn9-Aug-09 23:55

Luc Pattyn

9-Aug-09 23:55

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.

Re: Using 'Like' in DataTable select query

kanchoette10-Aug-09 0:12

kanchoette

10-Aug-09 0:12

Many thanks.

Re: Using 'Like' in DataTable select query

rishimuni20-Jan-14 1:23

rishimuni

20-Jan-14 1:23

Re: Using 'Like' in DataTable select query

Member 1372147419-Jun-18 1:19

Member 13721474

19-Jun-18 1:19

If column name is (FIRST NAME)
If I use as Select("FIRST NAME LIKE '" + lastWord + "%'" );
It shows error

Re: Using 'Like' in DataTable select query

Jochen Arndt19-Jun-18 3:06

Jochen Arndt

19-Jun-18 3:06

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 + "%'" );

Re: Using 'Like' in DataTable select query

Pete O'Hanlon10-Aug-09 1:52

Pete O'Hanlon

10-Aug-09 1:52

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

Problem while set the window state to maximixed of the form

lnmca9-Aug-09 23:37

lnmca

9-Aug-09 23:37

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

Re: Problem while set the window state to maximixed of the form

Luc Pattyn9-Aug-09 23:57

Luc Pattyn

9-Aug-09 23:57

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.

Smile | :)

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.

imageList with treeView

reilak9-Aug-09 22:37

reilak

9-Aug-09 22:37

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??

Re: imageList with treeView

OriginalGriff9-Aug-09 23:21

OriginalGriff

9-Aug-09 23:21

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

deployment of window application

Milind Panchal9-Aug-09 22:32

Milind Panchal

9-Aug-09 22:32

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.

Re: deployment of window application

Vimalsoft(Pty) Ltd9-Aug-09 22:40

Vimalsoft(Pty) Ltd

9-Aug-09 22:40

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/

Re: deployment of window application

Milind Panchal9-Aug-09 22:48

Milind Panchal

9-Aug-09 22:48

you have not understood my quote, plz don't give answer

Re: deployment of window application

OriginalGriff9-Aug-09 23:24

OriginalGriff

9-Aug-09 23:24

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

Re: deployment of window application

Vimalsoft(Pty) Ltd11-Aug-09 23:03

Vimalsoft(Pty) Ltd

11-Aug-09 23:03

I normally hate your behavior , not you. i will pray for you that you change.

C# Desktop Apps

Marc Firth9-Aug-09 22:31

Marc Firth

9-Aug-09 22:31

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! Smile | :)

Cheers.

Neonlight

Re: C# Desktop Apps

Vimalsoft(Pty) Ltd9-Aug-09 22:42

Vimalsoft(Pty) Ltd

9-Aug-09 22:42

There is one thing i will say to you. WPF is the Next Generation.

Re: C# Desktop Apps

Pete O'Hanlon9-Aug-09 22:49

Pete O'Hanlon

9-Aug-09 22:49

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

Re: C# Desktop Apps

Marc Firth10-Aug-09 1:34

Marc Firth

10-Aug-09 1:34

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. Thumbs Up | :thumbsup:

Neonlight

Re: C# Desktop Apps

Pete O'Hanlon10-Aug-09 1:36

Pete O'Hanlon

10-Aug-09 1:36

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

Re: C# Desktop Apps

Marc Firth10-Aug-09 1:47

Marc Firth

10-Aug-09 1:47

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.

Neonlight

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.