C# Discussion Boards - CodeProject

Re: Retrieve the value of Inout parameter

25-Aug-05 17:19

You don't get the value of the parameter in the DataSet, but you have to get it from the Parameter collection of the Command object:

DB2Command cmd = new DB2Command("proc name", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("InOutParam", inputValue).Direction = ParameterDireciton.InputOutput;
 
DB2DataAdapter da = new DB2DataAdapter(cmd);
da.Fill(ds);  // Execute the stored procedure and get the returned data sets
 
// Get value of output parameter, cast to whatever type
int outputValue = (int) cmd.Parameters[0].Value;

I hope this helps!

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

-- modified at 23:20 Thursday 25th August, 2005

tsramkumar26-Aug-05 1:35

tsramkumar

26-Aug-05 1:35

Thanks Buddy! I got it working finally. Guess what!I was calling the wrong overload for that method. That was a very silly mistake that I had overlooked.
However, it's strange that the overload which I called by mistake (which takes a series of parameter values and uses the discoverparameter to find the storedprocedure parameters and assigns the values) does not return me the updated value for the inout parameter. May be I dont know where to look for. becos we are just passing the paraemter values in a params object. Do you have any idea abt this?

Thanks

xs:date type in DataSet

tadass25-Aug-05 11:10

tadass

25-Aug-05 11:10

Hi.

I have XML file events.xml:

<events>
<event>
<date>2005-08-25</date>
<title>...</title>
...
</event>
...
</events>

And events.xsd XML Shema file:

<xs:schema>
...
<xs:element name="date" type="xs:date">
...
</xs:shema>

Node <date> has "xs:date" type (format is YYYY-MM-DD).

Now i need to load events.xml data into DataSet (i not use strog typed DataSet). After that i need to filter my data. For example, i need to receive all events (rows from DataTable) in 2005 September.

How to retrieve these rows? How to specify DataTable.Select() method? I think code like this "myDataSet.Tables[0].Select("YEAR(Date) = 2005 AND MONTH(Date) = 09")" will not work? I might be wrong...

Thanks

Tadas Sukys

-- modifed at 17:11 Thursday 25th August, 2005

Using ArrayList

MarkMokris25-Aug-05 10:49

MarkMokris

25-Aug-05 10:49

IN my C# apps, I use ArrayList's to store many types of objects. Of course when I pull anything out of any ArrayList I have to employ a cast. For example:

ArrayList listOfStrings();
:
String myString = (String)listOfStrings[3];

I end of doing so much casting! Is that typical? Can I avoid all the casting? Or is there some fundamental technique using ArrayLists that I am missing?

Thanks!

Mark Mokris

gnjunge25-Aug-05 10:54

gnjunge

25-Aug-05 10:54

You want to create your own strong typed collection by deriving from System.Collections.CollectionBase class. Check the MSDN for CollectionBase to see how to implement this (override Add, Remove, this[] etc methods).

Daniel132425-Aug-05 13:33

Daniel1324

25-Aug-05 13:33

I think the question was is there anything wrong with all of the casting.

I also employ the arraylist for the same purpose, so I'd like to hear from the C# gurus too.

Matt Gerrans25-Aug-05 16:59

Matt Gerrans

25-Aug-05 16:59

Well, generics will help if you're using VS 2005, but with the current version, you're stuck with the cast or using the as syntax.

Of course if you are iterating over the items in an ArrayList, you can use foreach and that is nicer.

foreach( string s in arrayListOfStrings )
    Console.WriteLine( "The list contains {0}", s );

Matt Gerrans

-- modified at 22:59 Thursday 25th August, 2005

Luis Alonso Ramos25-Aug-05 17:12

25-Aug-05 17:12

It depends on what types of objects you are inserting in the ArrayList. If you are inserting reference types (basically any object) there's a very slight, almost negligible, performance penalty in casting to and from object.

On the other hand, if you insert value types (ints, doubles, DateTimes and so on) in the ArrayList, the performance penalty is big because when you put a value type in an object variable, the compiler has to create a dummy object to contain the value and insert a reference to that object (a process called boxing). When you cast an object to a value type (when getting an item from the ArrayList for example) the process is called unboxing and is the exact opposite: go get the object and take the value from inside it.

An advantage of using specialized collections derived from CollectionBase is that the compiler does type checking for you. You usually can't assign an object to a typed variable without casting, but the other way around is not true: you can assign a variable of any type to a object variable. With a specialized collection, you can't add items of other types without the compiler complaining.

-- LuisR

Kevin McFarlane26-Aug-05 0:33

Kevin McFarlane

26-Aug-05 0:33

And this can save you time...

TypedCollectionGenerator
http://kristopherjohnson.net/cgi-bin/twiki/view/KJ/TypedCollectionGenerator[^]

Kevin

radic.feng26-Aug-05 1:23

radic.feng

26-Aug-05 1:23

My experience is adding objects with the same type to one arraylist.
if casting is needed, for instance, to a string array. you can use this statement:
string[] myString = ( string[] )listOfStrings.toArray( typeof(string ));

Job Scheduler

mohitTheOne25-Aug-05 9:46

mohitTheOne

25-Aug-05 9:46

A have C# application which is required to do a specific task
on a scheduled basis..i.e. may be once a day ,twice or thrice daily...

The application needs to be up all time and reads a scheduled timings information through a DB table and updates its scheduled time settings accordingly..

Any idea how to implement a simple customizable scheduler for this which
can reconfigure it self for the schedule and runs ,calls the specified funtion
that does the job...

Thanks in advance
Mohit

Re: Job Scheduler

miah alom25-Aug-05 11:45

25-Aug-05 11:45

Windows Service is the right way to go. All you need to do is having a Time ticker which will control when you want the specific methods to get executed.

Check this out

http://www.codeproject.com/csharp/CSharpWindowsServiceInst.asp

Subclassing in .NET

Luis Alonso Ramos25-Aug-05 9:43

25-Aug-05 9:43

Hello,

I want to subclass the list box of a dropdown combobox. I already have the Win32 handle of the list box, but how can I subclass it so I use a ListBox-derived class I have to handle its events and messages?

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Re: Subclassing in .NET

Daniel Turini25-Aug-05 10:31

Daniel Turini

25-Aug-05 10:31

Try the System.Windows.Forms.NativeWindow class for subclassing a Window.

I see dead pixels
Yes, even I am blogging now!

Re: Subclassing in .NET

Luis Alonso Ramos25-Aug-05 16:59

25-Aug-05 16:59

I'll take a look into it... thanks!

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

[Message Deleted]

miah alom25-Aug-05 11:59

Setting the exact position of a tooltip

25-Aug-05 11:59

[Message Deleted]

Luis Alonso Ramos25-Aug-05 9:37

25-Aug-05 9:37

Hello,

I'm extending a ListBox with tooltips for items that don't fit, but I can't find out how to position the tooltip exactly over the item. I already got the item coordinates, but how do I tell the tooltip where to appear. It is possible via a Windows message, but how do I get the Win32 handle of the window?

[EDIT: There's a private Handle property... it could help]

Any other ideas?

-- LuisR

miah alom25-Aug-05 12:00

25-Aug-05 12:00

I guess this is all you need. Give me a candy if this works for you.

private void ListControlMouseMove(object sender, MouseEventArgs e)
{
Point ptOnlist = Point.Empty;
ListViewItem item = null;
int subItemIndex = -1;
int subItemTextWidth = -1;
ListViewItem.ListViewSubItem curSubItem = null;

if (e.Button == MouseButtons.None)
{
item = this.GetItemAt(e.X, e.Y);
if (item != null)
{
subItemIndex = this.GetSubItemIndexFromPoint(item, new Point(e.X, e.Y));
if (subItemIndex != -1)
{
curSubItem = item.SubItems[subItemIndex];
if (curSubItem != null)
{
if (curSubItem.Text.Length > 0)
{
subItemTextWidth = this.ListViewGetStringWidth(curSubItem.Text);
if (subItemTextWidth != -1)
{
subItemTextWidth += 12;
if (subItemTextWidth > this.Columns[subItemIndex].Width)
{
this.SetToolTipText(curSubItem.Text);
}
else
{
this.HideToolTip();
}
}
}
}
}
else
{
this.HideDynamicControls();
}
}
}
}

protected int GetSubItemIndexFromPoint(ListViewItem item, Point ptInList)
{
int sumOfWidths = 0;
int columnIndex = 0;

foreach (ColumnHeader column in this.Columns)
{
if (sumOfWidths < ptInList.X && ptInList.X < sumOfWidths + column.Width)
{
return columnIndex;
}
sumOfWidths += column.Width;
columnIndex++;
}
return -1;
}

private const int LVM_GETSTRINGWIDTHW = 4183
protected int ListViewGetStringWidth(string subItemText)
{
IntPtr hString = Marshal.StringToHGlobalAuto(subItemText);
int width = UnsafeNativeMethods.SendMessage(this.Handle, LVM_GETSTRINGWIDTHW, 0, hString);
Marshal.FreeHGlobal(hString);

return width;
}

protected void SetToolTipText(string toolTipText)
{
if (toolTipText != null)
{
this.toolTip.Active = true;
this.toolTip.SetToolTip(this, toolTipText);
}
}

Cheers.

Luis Alonso Ramos25-Aug-05 16:47

25-Aug-05 16:47

Sorry. It won't work. As matter of fact I'm using a ListBox, not a ListView, so all the above code doesn't really aply. But I appreciate your effort! Thanks! Smile | :)

I found out using .NET Reflector that the ToolTip class uses "normal" tooltips (using TTM_ACTIVATE to make it active.) There's a special type of tool tips, called "tracking" that have the TTF_TRACK flag, and you activate them with TTM_TRACKACTIVATE, and set their position with TTM_TRACKPOSITION (all of them Win32 window messages). Tracking tooltips don't move with the mouse; they just stay where they appear.

So I guess I'll have to rewrite the entire ToolTip class into something like TrackingToolTip. It doesn't really seem that hard to do, it's a simple class. I'll be sure to post an article here when I'm done.

Thanks!

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

miah alom26-Aug-05 11:03

26-Aug-05 11:03

I hope the following works for you. As faar as ListBox is concerned you can do the following

[DllImport("user32.dll")]
public static extern IntPtr GetDC(IntPtr hWnd);

[StructLayout(LayoutKind.Sequential)]
public struct POINT
{
public int cx;
public int cy;
}

[DllImport("gdi32.dll")]
public static extern int GetTextExtentPoint32(IntPtr hdc, String str, int len, ref POINT pt);

[DllImport("user32.dll")]
public static extern int ReleaseDC(IntPtr hWnd,IntPtr hdc);

private void listBox1_MouseMove(object sender, System.Windows.Forms.MouseEventArgs e)
{
int index = this.listBox1.IndexFromPoint(e.X,e.Y);

if ( index > 0 )
{
IntPtr dc = GetDC(this.listBox1.Handle);

POINT pt;
pt.cx = 0;
pt.cy = 0;
GetTextExtentPoint32(dc, this.listBox1.Items[index].ToString() ,this.listBox1.Items[index].ToString().Length,ref pt);

ReleaseDC(this.listBox1.Handle, dc);
if(this.listBox1.Width < pt.cx)
{
this.SetToolTipText(this.listBox1.Items[index].ToString());
}
}
}

and as far as ToolTip is concerned

///

/// Set the position of the control with respect to the anchor control
///

/// <param name="anchorControl" />
private void SetPosition(Control anchorControl)
{
//
//Resolve the Balloon Coordinates
//to the client area
//
UnsafeNativeMethods.GetClientRect(anchorControl.Handle, ref this.toolInfo.rect);
UnsafeNativeMethods.ClientToScreen(anchorControl.Handle, ref this.toolInfo.rect);

//
//set the position of the toolTip to be
//displayed
//
int pt = MAKELONG(toolInfo.rect.left, toolInfo.rect.top + toolInfo.rect.bottom);
IntPtr ptr = new IntPtr(pt);

UnsafeNativeMethods.SendMessage(
this.Handle, TTM_TRACKPOSITION,
0, ptr);
}

[DllImport("User32", SetLastError = true)]
public static extern int GetClientRect(IntPtr hWnd, ref Rect lpRect);
[DllImport("User32", SetLastError = true)]
public static extern int ClientToScreen(IntPtr hWnd, ref Rect lpRect);
private const int WM_USER = 0x0400;
private const int TTM_TRACKACTIVATE = WM_USER + 17;

private int MAKELONG(int loWord, int hiWord)
{
return (hiWord << 16) | (loWord & 0xffff);
}

Luis Alonso Ramos26-Aug-05 16:31

26-Aug-05 16:31

That looks more like what I need... I'll try that code and get back to you. Did you test it?

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Alomgir Miah26-Aug-05 17:31

Alomgir Miah

26-Aug-05 17:31

Yes I did. If you want I can send you the zipped project.

Live Life King Size
Alomgir Miah

Luis Alonso Ramos26-Aug-05 22:08