Counting Items post RowFilter in a DataView - C# Discussion Boards

Amberite005-Mar-04 9:02

Amberite00

5-Mar-04 9:02

Hi Heath,

Thx for the response! But, I still have problems with this...

I know about the invalidated region, but this is exactly what I'm worried about... For example, imagine the user scrolls down (assuming there are enough items). When he scrolls, the invalidated region is probably going to look something like {X=0, Y=300, <control_width>, <control_height -="" 300="">}, since windows will simply move whatever has already been painted up, and ask to draw just the part on the bottom that needs to be drawn. However, if my columns are simply drawn normally, it will scroll the columns up too! If this is the case, that means I need to step outside of the invalidated region (since the columns are all the way at the top, whereas windows wants to draw at the bottom), make a new Graphics object, and draw the columns OVER whatever is now at the top.

Isn't there any way to get around this?

Thx for all the help!

Yaron

Heath Stewart5-Mar-04 9:09

5-Mar-04 9:09

The column headers shouldn't be part of the scrollable region. While the scroll bar control may overlap the column headers, the scrollable region is still the portion under the headers.

Microsoft MVP, Visual C#
My Articles

Amberite005-Mar-04 9:13

Amberite00

5-Mar-04 9:13

How would I specify that the column headers aren't scrollable? Since it's not a control, I'm just painting them, so how would I tell windows not to scroll it along with the rest of the control?

Yaron

Heath Stewart5-Mar-04 9:37

5-Mar-04 9:37

If you control the scrolling, you control which regions are invalidated. Handle all the scroll messages from the scroll bar yourself and invalidate only the regions below the headers, if headers are visible.

Microsoft MVP, Visual C#
My Articles

Install remote Window Service

Amberite005-Mar-04 9:41

Amberite00

5-Mar-04 9:41

But I'm not using a scrollbar, or at least not technically. I'm letting windows handle the scrolling by using AutoScroll.

hxxbin5-Mar-04 4:43

hxxbin

5-Mar-04 4:43

Hi
Someone knows where I could find documentation about how install remote Window Service, like in Dameware (remote administrator) where you can install the dameware service when you are Administrator of the domain, It'll be helpful install a service from my pc to the others, cuz many pcs are in other citys.

Any info will be greatful

Thanks

----
hxxbin

Counting Items post RowFilter in a DataView

MrEyes5-Mar-04 3:33

MrEyes

5-Mar-04 3:33

I have a DataTable (data) that contains 3 rows :

value1 value2
textA  0
textB  1
textC  1

I am placing this DataTable into a DataView and then filtering to get the rows where 'value2' does not equal zero :

DataView dvFiltered = new DataView(this.data, "totalUsed <> 0", "value2", DataViewRowState.CurrentRows);
int filteredCount = dvFiltered.Count;
string summary = string.Format("{0} Item(s)", filteredCount.ToString());

For some reason the count, sometimes returns the correct value but most of the time it doesnt, and I cant see a reason why. I have be stepping through the code to make sure the datatable contains the values it should and all that seems fine, as an example the following is taken from my VS watch list :

this.data.Rows[0]["value2"] - "0"
this.data.Rows[1]["value2"] - "1"
this.data.Rows[2]["value2"] - "2"
dvFiltered.Count - 1

post.mode = signature;
SELECT everything FROM everywhere WHERE something = something_else;
> 1 Row Returned
> 42

How can I pull multiple icons from a single embedded bitmap?

AppMaker885-Mar-04 1:20

AppMaker88

5-Mar-04 1:20

In the resources file of Web Matrix, I found that the program is using one long bitmap that contains all the icons for the menu, toolbar, etc.

I would like to do this for my application, but I am not sure how to go about this.

How is the bitmap split into individual images?
Are these individual images added to an imagelist somehow? (if so, how?)

What is the best way for me to duplicate the strategy Web Matrix uses to grab an embedded bitmap (representing many icons) to use for my menu and toolbar?

Thanks in Advance!

Re: How can I pull multiple icons from a single embedded bitmap?

Heath Stewart5-Mar-04 6:14

Graphics, Bitmaps, and a Process that doesn't close

5-Mar-04 6:14

If you want to create an ImageList, you can use ImageList.Images.AddStrip. To do this manually, it really isn't that hard. In most cases, squares are used. If the image is 32 pixels high, bitmaps consisting of 32 pixels wide are copied to individual Bitmap instances. You can use Graphics.DrawImage(Image, Rectangle, Rectangle, GraphicsUnit) or a similar method to assist with this process. Once Rectangle specifies the source bounds (in which case you increment the X coordinate by the height of the strip, if dealing with a horizontal strip) and the other specifies the destination bounds (in which case you use Image.GetBounds or the assumed Size and Point(0, 0)). Use the same GraphicsUnit, which you'll most likely want to use GraphicsUnit.Pixel.

In most cases, ImageList.Images.AddStrip will do nicely.

Microsoft MVP, Visual C#
My Articles

Rendall4-Mar-04 23:35

Rendall

4-Mar-04 23:35

I am creating a bitmap drawing a pie chart and saving it as a gif in my windows app.
I am then linking and empbedding that gif (in the same process) into another app that generates a pdf on the fly.

However, when I close my windows app, the process does not end and i have to do it manually. Here's the code where i'm creating the gif.

const int width = 500, height = 200;
Bitmap objBitmap = new Bitmap(width, height);

Graphics objGraphics = Graphics.FromImage(objBitmap);

objGraphics = Graphics.FromImage(objBitmap);

objGraphics.FillRectangle(new SolidBrush(Color.White), 0, 0, width, height);

DrawSpendingPieChart(ref objGraphics, alName, alNumber);

string path = storageFolder + "\\" + clientId + "chart1.gif";

try
{
objBitmap.Save(path, ImageFormat.Gif);
}
catch(Exception ioe)
{
throw ioe;
}
finally
{
// clean up...
objBitmap = null;
objGraphics = null;
}

r.cbChart1 = path;

Without the link to this gif, it works fine. The pdf generator links and embeds other gifs outside my windows app fine.

I have isolated the problem to the gif i'm creating. It seemingly remains in memory(even though i set it to null once saved) and is linked to my windows app process: and if used, it keeps my app open.

Does it have to do with Graphics.FromImage() creating a memory stream and retaining it even after I have set objBitmap to null?

Any help?

Dave

Re: Graphics, Bitmaps, and a Process that doesn't close

Heath Stewart5-Mar-04 6:07

Re: Graphics, Bitmaps, and a Process that doesn't close

5-Mar-04 6:07

When a Type implements IDisposable like the Graphics and Bitmap classes, you must call Dispose before nullifying the instance variable (which really isn't necessary):

Bitmap bmp = null;
Graphics g = null;
try
{
  bmp = new Bitmap(32, 32);
  g = Graphics.FromImage(bmp);
  //...
}
finally
{
  if (g != null) g.Dispose();
  if (bmp != null) bmp.Dispose();
}

In C#, you can use the using statement to do the same thing as above:

using (Bitmap bmp = new Bitmap(32, 32))
{
  using (Graphics g = Graphics.FromImage(bmp))
  {
    // ...
  }
}

Microsoft MVP, Visual C#
My Articles

Rendall12-Mar-04 20:01

Rendall

12-Mar-04 20:01

Thanks for the reply.

I rewrote the code and called .Dispose() on both objects. But I continue to get the same problem. The application continues to run until I manually close it. If I remove the reference to the created .gif, it closes fine.

Re: Graphics, Bitmaps, and a Process that doesn't close

Rendall13-Mar-04 0:11

Rendall

13-Mar-04 0:11

Heath,

I've isolated the problem and it has to do with the pdf generator. THANKS for your help!!

Dave

Marshalling Problem

nvenkat4-Mar-04 23:02

nvenkat

4-Mar-04 23:02

Hi,
Im doing a Firewall in C#,on the Process

"byte[] buffer = new byte[20000]; // Start with 20.000 bytes left for information about tcp table
int pdwSize = 20000;
int BufferSize = 100000;
IntPtr lpTable = Marshal.AllocHGlobal(BufferSize);
IntPtr current = lpTable;
int res = IPHlpAPI32Wrapper.GetTcpTable(buffer, out pdwSize, true);
if (res != NO_ERROR)
{
buffer = new byte[pdwSize];
res = IPHlpAPI32Wrapper.GetTcpTable(buffer, out pdwSize, true);
if (res != 0)
return; // Error. You should handle it
}

TcpConnexion = new IpHlpApidotnet.MIB_TCPTABLE();
int nOffset = 0;
// number of entry in the
TcpConnexion.dwNumEntries = Convert.ToInt32(buffer[nOffset]);

nOffset+=4;
TcpConnexion.table = new MIB_TCPROW[TcpConnexion.dwNumEntries];"

Iam passing the MIB_TCPROW object to SetTcpEntry...
But iam getting the Following Error
"Can not marshal field Local of type IpHlpApidotnet.MIB_TCPROW: The type definition of this field has no layout information."

Can u anybody help me out???
Thanx Rose | [Rose]

venkat

Re: Marshalling Problem

Roman Rodov4-Mar-04 23:51

Roman Rodov

4-Mar-04 23:51

definition of MIB_TCPROW????

Re: Marshalling Problem

nvenkat5-Mar-04 19:19

nvenkat

5-Mar-04 19:19

public struct MIB_TCPTABLE
{
public int dwNumEntries;
public MIB_TCPROW[] table;

}

public struct MIB_TCPROW
{
public string StrgState;
public int iState;
public IPEndPoint Local;
public IPEndPoint Remote;
}

checklistbox problem

ASGill4-Mar-04 21:34

4-Mar-04 21:34

hi..

im trying to populate my checklistbox with a column that im getting from a database.

well i get the column and store in a datatable my question how do i populate whats in the datatable into the checklistbox...pls help...

Cry | :((

Mazdak4-Mar-04 21:40

Mazdak

4-Mar-04 21:40

Set the DataSource propoerty of CheckListBox property to your datatable and its DisplayMember , name of your column.

And don't cry , there is always a solution. Wink | ;)

Mazy

"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope

ASGill4-Mar-04 22:09

4-Mar-04 22:09

well setting the property is another problem...im using Visual Studio .Net 2003 and it looks like they haved scraped these properties off checklisbox..i wonder why...i tought the more adavanced things got the more easier it got for us...sighhhhh...

Cry | :((

... i'll stop once i get this prblem fixed...hehehe

Mazdak4-Mar-04 22:25

Mazdak

4-Mar-04 22:25

ASGill wrote:
it looks like they haved scraped these properties off checklisbox

Eek! | :eek:

Although I donn't have VS.NET 2003 but how is this possible? I can understand it.

Anyway, can't you set it programiically? Like this:

checklistbox1.DataSource = mytable;
checklistbox1.DisplayMember = columnname;

Mazy

"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope

ASGill5-Mar-04 0:53

5-Mar-04 0:53

Hi Mazy...( Eek! | :eek:

yeah i know its kinda shocking.. Smile | :)

)

anyways... i got the adding part working, its working alrite, but with a flaw...and i have got no clue of what so ever abt why its happennin

<br />
private void frmPrescription_Load(object sender, System.EventArgs e)<br />
		{<br />
			try<br />
			{<br />
				oleDbConnection1.Open();<br />
<br />
				oleDbDataAdapter1.SelectCommand.CommandText = "SELECT [Med Name] FROM Pharmacy";<br />
<br />
				oleDbDataAdapter1.SelectCommand.ExecuteNonQuery();<br />
<br />
				oleDbDataAdapter1.Fill(dataSet1);<br />
<br />
                                // add items to checkboxlistname.<br />
				for(int i = 0; i < dataSet1.Tables[0].Rows.Count; i++)<br />
				{<br />
					//add items unchecked<br />
					this.checkedListBoxName.Items.Add(dataSet1.Tables[0].Rows[i][4], false);  <br />
				}<br />
			}<br />
			catch (Exception LoadError)<br />
			{<br />
				MessageBox.Show(LoadError.ToString());<br />
			}<br />
			finally<br />
			{<br />
				oleDbConnection1.Close();<br />
				oleDbConnection1.Dispose();<br />
			}<br />

well when it adds the item, it adds it twice...i.e i have the value "Aspirin" in the column in the table...its s'pose to display it only once but i get

1. Aspirin //numbers represent checkboxes
2. Aspirin
3. Piriton
4. Piriton

and so on.....all of the values are added twice..whats wrong...

D'Oh! | :doh:

MasudM5-Mar-04 1:50

MasudM

5-Mar-04 1:50

Hi I 'm wondering why you :

oleDbDataAdapter1.SelectCommand.ExecuteNonQuery();

oleDbDataAdapter1.Fill(dataSet1);

you olny need to oleDbDataAdapter1.Fill(dataSet1);

why did you write
oleDbDataAdapter1.SelectCommand.ExecuteNonQuery();
first .?

bye.

Mazdak5-Mar-04 4:51

Mazdak

5-Mar-04 4:51

As Masud said remove oleDbDataAdapter1.SelectCommand.ExecuteNonQuery();
line then you call fill method set the DataSource and DisplayMemerb ofCheckListBox as I told you.

Mazy

"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope

ASGill5-Mar-04 7:04