C# Discussion Boards - CodeProject

Re: Combining in and like

User 66586-Jul-06 9:59

User 6658

6-Jul-06 9:59

awesome

modified 12-Sep-18 21:01pm.

Re: Combining in and like

Alexander Wiseman6-Jul-06 10:36

Alexander Wiseman

6-Jul-06 10:36

This gets the best post of the day award hands down!

I can just see the Valley Girl SQL compiler error messages now:

line 1: "CREATE PROCEDURE"
compile error, expected token UMM, LIKE, or UHH

Sincerely,
Alexander Wiseman

Re: Combining in and like

Dustin Metzgar6-Jul-06 11:18

Dustin Metzgar

6-Jul-06 11:18

Alexander Wiseman wrote:
compile error, expected token UMM, LIKE, or UHH

Hilarious!

Josh, I think you should patent the name.

Logifusion[^]

Re: Combining in and like

Vikram A Punathambekar6-Jul-06 20:50

Vikram A Punathambekar

6-Jul-06 20:50

I think your post should share the award. Laugh | :laugh:

Cheers,
Vikram.

"I am not Jesus and will never be. The fact is I was a piece of cr*p till I found Him." - Paul Selormey.

Re: Combining in and like

Blake Miller7-Jul-06 3:47

Blake Miller

7-Jul-06 3:47

line 1: "CREATE PROCEDURE"
Ya know, there was this like compile error, and I kinda expected a token umm, like, UMM, LIKE, or UHH

I've seen better runs in my shorts! - Patches O'Houlihan

Re: Combining in and like

DontSailBackwards7-Jul-06 21:22

DontSailBackwards

7-Jul-06 21:22

How about ...

Umm SELECT LIKE STUFF
FROM YOU KNOW LIKE DUH
WHERE THINGS ARE LIKE WHATEVER
ORDER BY DRIVETHROUGH, FRIESWITHTHAT = YES

Re: Combining in and like

ToddHileHoffer6-Jul-06 9:09

ToddHileHoffer

6-Jul-06 9:09

No you can't do that. You would have to say where (field like '%list1%' or field like '%sdf%') but that would be inefficient anyway.

how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06

Re: Combining in and like

NRavep9-Jul-06 20:55

NRavep

9-Jul-06 20:55

Select Field1,Field2,Field3 From TableName Where Field1 In(Select Field4 From Table2 Where Field4 Like '%Something%')

Passing a Class as a method parameter?

joshp12176-Jul-06 8:40

joshp1217

6-Jul-06 8:40

I mean be an idiot for asking this question too but is there a way to pass a class as a parameter of a method i.e.

I have a repeated block of code like this:
class pTermsEditor;
pTermsEditor = new class();
pnlViews.Controls.Add(pTermsEditor);
pTermsEditor.Dock = DockStyle.Fill;

This Block of code is repeated many times but the class type may and almose always does change, so I want to control it more by putting it into a method something like this:

myMethod(class)
{
class x;
x = new class();
//blah blah blah
}
Any help or even a better solution what be greatly appreciated

Re: Passing a Class as a method parameter? [modified]

ToddHileHoffer6-Jul-06 8:51

ToddHileHoffer

6-Jul-06 8:51

You can use the object type, and it is a valid question.

for example

<br />
myMethod(object obj)<br />
{<br />
if (obj.GetType() == typeof(classA))<br />
{<br />
 ClassA objA;<br />
 objA = (ClassA)obj;<br />
return;<br />
}<br />
if (obj.GetType() == typeof(classB))<br />
{<br />
ClassB objB;<br />
 objB = (ClassB)obj;<br />
return;<br />
}<br />
<br />
}

how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06

-- modified at 14:58 Thursday 6th July, 2006

Re: Passing a Class as a method parameter?

Josh Smith6-Jul-06 9:04

Josh Smith

6-Jul-06 9:04

You can pass a Type object and then use Activator.CreateInstance to create an instance via the default (parameterless) constructor.

Or, if you're using .NET 2, you can make a generic method whose type parameter is the type that you want to create. Then just do T obj = new T(); where T is your type parameter name.

If all else fails, you can always do the magical type parameter dance and everything should work out fine. Wink | ;)

:josh:
My WPF Blog[^]

Re: Passing a Class as a method parameter?

Judah Gabriel Himango6-Jul-06 9:29

Judah Gabriel Himango

6-Jul-06 9:29

That'll work, so long as you put a new() (that is, default constructor) constraint on the method:

void CreateNew<T>() where T : new()
{
   T instance = new T();
   ...
}

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Messianic Instrumentals (with audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: Passing a Class as a method parameter?

Jun Du6-Jul-06 12:10

Jun Du

6-Jul-06 12:10

That's cool. Thought it wasn't doable Blush | :O

Best,
Jun

Re: Passing a Class as a method parameter?

Jun Du6-Jul-06 9:05

Jun Du

6-Jul-06 9:05

C++/C# hasn't invented that feature yet Big Grin | :-D

Best,
Jun

adding icon to systemtray

Mridang Agarwalla6-Jul-06 7:41

Mridang Agarwalla

6-Jul-06 7:41

hi,
i'm using VS.NET 2003 and I would like to add some systemtray functionality to my C# application. The SystemTray icon should support the follwoing features:
1. Display Baloon Tooltips
2. Display a context menu when right clicked
3. Repsond to mouse events such as Click, DoubleClick etc.
...and other such suff

ANyone know a good class that would help me do this. I have a came across a few but each of them lack some or the other feature. I'm looking for a free one - don't wanna shell out a penny for this one. :->

Re: adding icon to systemtray

Stefan Troschuetz6-Jul-06 8:15

Stefan Troschuetz

6-Jul-06 8:15

NotifyIcon[^]

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: adding icon to systemtray

Mridang Agarwalla6-Jul-06 17:15

Mridang Agarwalla

6-Jul-06 17:15

cool, but i guess it doesnt support balloon tooltips.

Re: adding icon to systemtray

Stefan Troschuetz6-Jul-06 20:56

Stefan Troschuetz

6-Jul-06 20:56

From MSDN: "The Text property assigns ToolTip text."

Copying UserControl Variables to another instance of the UserControl [modified]

TheBlindWatchmaker6-Jul-06 7:39

TheBlindWatchmaker

6-Jul-06 7:39

Greetings!

I was wondering if I could get some direction to get me started in implementing a "copy/paste" of the properties of a UserControl.

In my application, I have 10 instances of a particular UserControl. This UserControl has, say, 10 properties. I would like to be able to use the right-click menu that I have for this UserControl and be able to copy the "settings" of one instance to any other instance of the UserControl.

From what I've read on MSDN, I understand that I have to make the UserControl class Serializable and that the variables that I do not copied can be excluded using the [NonSerializable] attribute, thus so:

<br />
[Serializable]<br />
<br />
public class ctlMyControl : ctlBaseControl<br />
{<br />
int nNum1; // Copied<br />
float fNum2; // Copied<br />
<br />
[NonSerializable]<br />
float fNum3; // Not Copied<br />
<br />
// The rest of the code<br />
}

My question is how does one implement the actualy copy and paste?

What function(s) do I use to perform the copy and what function(s) do I use to paste?

Your help is appreciated!

Thanks!

-- modified at 13:39 Thursday 6th July, 2006

Re: Copying UserControl Variables to another instance of the UserControl

Dustin Metzgar6-Jul-06 7:55

Dustin Metzgar

6-Jul-06 7:55

Well, I'm not sure about the right-click menu, but serializing is a trick you can use to copy a complex object. Mark the class as Serializable and then use the System.Runtime.Serialization.Formatters.Binary.BinaryFormatter. You binary serialize your object into a MemoryStream and then deserialize it into a new object. Voila - a copy of your original without having to hand-code all the copying.

Logifusion[^]

Re: Copying UserControl Variables to another instance of the UserControl

TheBlindWatchmaker6-Jul-06 8:13

TheBlindWatchmaker

6-Jul-06 8:13

Hi Dustin,

Could you give me some example code or point me to some examples of how this could be done?

Thanks for your time!

Re: Copying UserControl Variables to another instance of the UserControl

Dustin Metzgar6-Jul-06 8:28

Dustin Metzgar

6-Jul-06 8:28

Sure thing. I needed to be able to copy a CodeCompileUnit object. This represents an entire CodeDom graph which can get really huge. It's a Microsoft library, so I can't just edit the code myself, and digging through the entire graph to copy it would not only be tedious but potentially faulty. It's just not an option. Luckily, serialization is there:

private CodeCompileUnit CopyCcu(CodeCompileUnit ccu) {
   try {
      BinaryFormatter bf = new BinaryFormatter();
      MemoryStream ms = new MemoryStream();
      bf.Serialize(ms, ccu);
      ms.Position = 0L;
      CodeCompileUnit newCcu = bf.Deserialize(ms) as CodeCompileUnit;
      return newCcu;
   }
   catch (Exception exc) {
      // Do something
   }
}

This is at least how you would get a copy of your UserControl. I'm lost on the whole right-click thing. Where are you doing that? In the Visual Studio designer?

Logifusion[^]

Transferring data from database to database

Stephen Hurt6-Jul-06 6:27

Stephen Hurt

6-Jul-06 6:27

This is not exactly a C# question, but I'm not sure where else to ask it.

I have an Access database program I wrote some years earlier. I am porting it into C# and trying to import the data from the older database to a newer version of the same database. Some tables are not identical, so I am writing an import feature.

The problem I am having is when importing from a memo or text field where the data includes " or ' characters since these characters are needed outside the SQL statement to indicate a text import.

Example: "INSERT INTO [Table] ([Field1]) VALUES ('This is a 'very' large project.')

Thanks in advance for any help.

S Hurt

Re: Transferring data from database to database

led mike6-Jul-06 6:40

led mike

6-Jul-06 6:40

Stephen Hurt wrote:
but I'm not sure where else to ask it.

Stephen Hurt wrote:
"INSERT INTO [Table] ([Field1]) VALUES ('This is a 'very' large project.')

Well since that is a SQL statement I would think the SQL / ADO / ADO.NET forum might be helpful? Wink | ;)

"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum

led mike

Re: Transferring data from database to database

BambooMoon6-Jul-06 7:09

BambooMoon

6-Jul-06 7:09

I think you just double up the single quotes:

Example: "INSERT INTO [Table] ([Field1]) VALUES ('This is a ''very'' large project.')

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