C# Discussion Boards - CodeProject

glennPattonWork317-May-12 0:13

17-May-12 0:13

Okay,

Thanks for that, searchString Vis Studio 2008 can't find. Is it .NET4.0 VS2010 thing or
is part of a using that I am not using or is it a hand rolled thing?
Glenn

BobJanova17-May-12 4:52

BobJanova

17-May-12 4:52

Uh, that would be a variable you create to say what you're searching for.

glennPattonWork317-May-12 5:37

glennPattonWork3

17-May-12 5:37

ah, Okay, with you now.

glennPattonWork317-May-12 1:05

glennPattonWork3

17-May-12 1:05

Aaah LINQ there something...

Luc Pattyn17-May-12 2:17

Luc Pattyn

17-May-12 2:17

I wouldn't search against the content of a GUI Control, I'd rather search some memory-based data structures (a List!) and keep my business code GUI-independent.

Smile | :)

PS: watch the "Treat my content as plain text, not as HTML" checkbox.

Luc Pattyn [My Articles] Nil Volentibus Arduum

glennPattonWork317-May-12 2:28

glennPattonWork3

17-May-12 2:28

Thanks, I am doing that (or trying to!) also I spent a little while trying to figure out
why the code was not appearing correctly,
I now have:

for (int i = 0; i <= DataPitStop.Count - 1; i++)
{
    richTextBox2.Text += DataPitStop[i] + "\n";
}
DataPitStop = DataPitStop.Distinct().ToList();

it seems to be working. Can I ask is this the efficient way of sorting data (I'm guessing that they will be using cheap netbooks with some form of Windows).

Luc Pattyn17-May-12 2:59

Luc Pattyn

17-May-12 2:59

Hmm. That code isn't sorting anything, all I see is a chronological concatenation, and the elimination of multiples.

For maximum performance:
- I would NOT concatenate strings, and hence I would not use a TextBox or RichTextBox; I prefer a ListBox, it is a line-oriented control that never needs any implicit concatenation of strings;
- I would not rely on LINQ;
- I would not get a Count property more than once (you get it on every iteration of the loop);
- I would use a foreach, not a for loop;
- I would not work on string data (as in RTB content) unless the data really is text; the actual type (int, DateTime, whatever your data is) is always the preferred one for all operations other than human input/output.
- I would prevent multiples from entering the collection, rather than removing them afterwards;
- when needing a sorted result, I would consider using a collection that sorts all by itself (depends on circumstances, may be faster or slower).
- however I would not worry a bit if Count is below say 100.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

glennPattonWork317-May-12 3:12

glennPattonWork3

17-May-12 3:12

.... The elimination of multiple was really all I was after (RF system gives back data unreliably, varies on the surroundings/antenna position etc.)and cataloging all the devices that can be seen. The sorting will be via third party routine which I just pass strings to. Chronological Concatenation(?) do you mean after a time the values get over written (in part)?, as I was planning to clear the box after 60 reads....
Glenn

Luc Pattyn17-May-12 3:27

Luc Pattyn

17-May-12 3:27

Chronological Concatenation: you concatenate them as they come in, in chronological order, that isn't sorting anything.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

glennPattonWork317-May-12 3:30

glennPattonWork3

17-May-12 3:30

I miss my soldering iron! well at least that explains that.
Glenn

Luc Pattyn17-May-12 3:35

Luc Pattyn

17-May-12 3:35

Beware RoHS!

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

glennPattonWork317-May-12 3:39

glennPattonWork3

17-May-12 3:39

Ahh, We do a lot of work for the US, not quite so picky as the EU!

BobJanova17-May-12 4:53

BobJanova

17-May-12 4:53

He's already doing that, NAME is a list or array that he's filling the control from, but he's searching against the in-memory list (NAME) which is correct.

Luc Pattyn17-May-12 4:56

Luc Pattyn

17-May-12 4:56

sorry, my mistake.

Thumbs Up | :thumbsup:

Luc Pattyn [My Articles] Nil Volentibus Arduum

PIEBALDconsult17-May-12 3:19

PIEBALDconsult

17-May-12 3:19

glennPattonWork wrote:
i <= NAME.Count - 1

What's wrong with i < NAME.Count ? Confused | :confused:

glennPattonWork317-May-12 3:26

glennPattonWork3

17-May-12 3:26

NAME.Count There was a reason I wanted to sort to one below the limit not to the limit.
The reason was I wanted the last entry to be left untouched. Frown | :(

(honestly!)
Glenn

PIEBALDconsult17-May-12 3:33

PIEBALDconsult

17-May-12 3:33

That doesn't explain the =. Big Grin | :-D

glennPattonWork317-May-12 3:41

glennPattonWork3

17-May-12 3:41

Well it comes from for() and while() loops you don't need there but a belt and braces approach is not a bad thing to foster in my opion. Hmmm | :|

PIEBALDconsult17-May-12 3:46

PIEBALDconsult

17-May-12 3:46

Not in this case.

glennPattonWork317-May-12 3:51

glennPattonWork3

17-May-12 3:51

I agree in looking at the code, but my fingers type it out of habit now (I always review code before its release on unsuspecting users!)

SQL Server 2005

hunain.esh16-May-12 20:50

hunain.esh

16-May-12 20:50

I want to replicate my complete database to another database at remote location using C# .NET.How can i do that?? and the main catch is that i have a ID in parent table which should not be replicated in the new table

Re: SQL Server 2005

Dave Kreskowiak17-May-12 2:07

Dave Kreskowiak

17-May-12 2:07

SQL Server has Replication Services built in. You don't have to write any code at all to do this.

http://msdn.microsoft.com/en-us/library/ms166352(v=sql.90).aspx#Replication[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: SQL Server 2005

hunain.esh17-May-12 19:34

hunain.esh

17-May-12 19:34

Yes SQL Server has replication Service but i want to do it on a live project and and i want to do it via C# code using SQl Replication class...
So i need help regarding that

Thanks

Sybase DB access in windows 7

VenkataRamana.Gali16-May-12 18:14

VenkataRamana.Gali

16-May-12 18:14

Hi all

I am using .net FW 3.5, its desktop applicaiton.

MyApplication is fetching data from sybase adoptive server and populating in it. Below connection, code.

XML

connectionString=DRIVER=MERANT 3.60 32-BIT Sybase;UID=test;DB=db1;SRVR=XYZSERVER;PWD=*****

using (OdbcConnection connection = new OdbcConnection(connStringFromConfig)
			{
				OdbcDataAdapter adapter = new OdbcDataAdapter(query, onnection);
				connection.Open();
				adapter.Fill(dt);
				connection.Close();
			}

above code works fine in windows xp. where as same code is not working in windows 7. I am executing in 64bit machine.

i got error while opening connection.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Anything i am missing ? or do i need to configure anything?

appriciated u r quick response.

Ramana

Re: Sybase DB access in windows 7

Richard Andrew x6416-May-12 18:17

Richard Andrew x64

16-May-12 18:17

Ramana.Gali wrote:
where as same code is not working in windows 7. I am executing in 64bit machine.

What does "not working" mean? Is there an error message?

The difficult we do right away...
...the impossible takes slightly longer.

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