Crystal report dynamically load an image on report document - C# Discussion Boards

god4k wrote:
8-9 seconds that I tell you not include Load AND PARSE Xml file.

Then why did you say so?!?

god4k wrote:
DateTime d1 = DateTime.Now;
DataGridView1.DataSource = MyDataTable
DateTime d2 = DateTime.Now;
TimeSpan ts = d2 - d1;
Console.WriteLine(ts);

You're not seriously rendering 100,000 rows in a dataGrid, are you?? Is the user even going to look at all of that crap?? You really need to rethink your design, 'cause there is no way to speed up the rendering of 100,000. What does the user need to see?? That is all you should be showing them. I can't think of a single good reason to show a user 100,000 rows of a table...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Cut the amount of data down as Dave has said. Only pull up the data that the user is going to be using at the moment, and 100,000 rows is not going to be the case. Allow the user to filter the rows he/she is going to need.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Why is it that no machine is fast enough for some "developers"??? Sigh | :sigh:

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

No kidding. I've got a P4 running at 2.5ghz and 1gig ram. It fits the bill for my development projects. I even have test station boxes running between 233mhz and 1.8ghz :->

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

The DataGridView can be a pretty slow control to render large amounts of data, and as noted by others, it looks as if you're getting pretty good performnace. However, performance, and the illusion of performance are not quite the same thing.

If your application looks as if it has hung during this 8-9 second load, then users might suspect it as having crashed. In which case, you might like to have this loading happening in a different thread, at least that way you can update the UI with a natty progress bar or similar. Taking this approach, however, may actually slow down the load - but the user will probably think it works more quickly than if the screen just locks up.

"It was the day before today.... I remember it like it was yesterday."

-Moleman

Have you given a thought of using the Virtual mode in the Datagrid?

GJ

Nice idea, but it's not a solution to the root cause of the problem - poor design.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Hi
I have a crystal report invoicing application that generates invoices. i have a logo on that invoice. I wanted to change the image based on if some condition met on code behind.

Can anyone please shed some light on how to do this.

This is what i am doing currently.

private void CreateImageDataTableAndWriteSchema()
{
this.DsImages = new DataSet();

DataTable ImageTable = new DataTable("Images");

ImageTable.Columns.Add(new DataColumn("path", typeof(string)));

ImageTable.Columns.Add(new DataColumn("image", typeof(System.Byte[])));

this.DsImages.Tables.Add(ImageTable);

//this.DsImages.WriteXmlSchema(@"c:\myinvoices\ImagesSchema.xsd");
}

as you can see from commented code that, I am creating an xsd dataset and I have added that dataset to the database fields. Then i have place image field from that table on to the report document. Then below i am loading an image file in that dataset/datatable.
then i am loading image in to the dataset created above

private void LoadLogoImage()
{
FileStream FilStr = new FileStream("C:\\mystuff\\Images\\my_logo.jpg", FileMode.Open);
BinaryReader BinRed = new BinaryReader(FilStr);

DataRow dr = this.DsImages.Tables["Images"].NewRow();

dr["path"] = "C:\\mystuff\\Images\\my_logo.jpg";

dr["image"] = BinRed.ReadBytes((int)BinRed.BaseStream.Length);

this.DsImages.Tables["Images"].Rows.Add(dr);

FilStr.Close();

BinRed.Close();

}

Lastly, i am setting the datasource of the report document as following

reportDocument.Subreports[SummaryDocument].Database.Tables["Images"].SetDataSource(DsImages.Tables["Images"]);

I get error, invalid index when i try to execute this line.

As stated above, i am trying to set the Images table datasource to the dataset we just poppulated with image path and byte data.

fyi: i have a master report which holds 8 subreport. The SummaryDocument listed above is one of those subreport.

Thanks
Needy

Hie again!
My friend has sent me a controlcode for viewing a GISMAP,but unfortunately I don't know how to use it.I mean how can I add a map in a C# project to view that map? Cry | :((

Please read the forum guidelines and going forward give your messages a title with meaning.

_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!

maybe your friend knows ?

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Considering we know NOTHING of the control (is it really?) he sent you, you're ONLY two sources of information on how to use it are (1) your friend, and (2) the manufacturer of the control.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Like the other posters have replied, try your friend and the control manufacturer. Your post is not very detailed...

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Hello,

I thought this would be easy to do but the answers I have found tend to involve writing a strongly typed data table or adding a linked table in SQL Server.

My SQL Server table has a value listed of 1 and 0 in the column for Status. I have added a DataGridView control to my form and I want to change the 1 to "Administrator" and the 0 to "User". Is there a simple way of doing this without adding a data table to my SQL Server or typing a strongly typed Data table class?

Thanks,

Boyd

Boyd

Yes, you can use a calculated column. For example:

DataTable table;
table = .... // Get from the database however you do it (data adapter)?

table.Columns.Add("TextStatus", typeof(string), "IIF(Status = 1, 'Administrator', 'User')");

For more things you can do with calculated columns, check DataTable.Expression[^]

I hope this helps! Smile | :)

Luis Alonso Ramos
Intelectix
Chihuahua, Mexico

My Blog!

Can you try this in your SQL statement when retrive the data:

SELECT
....
StatusValue = CASE WHEN Status = 1 THEN 'Administrator' ELSE 'User' END
FROM
...

Not sure this answer your question?

Eliz.K

Hi All,

This is Windows Forms, not web.

I've got a class, who's properties are normally exposed to my users in a PropertyGrid control.

Some of the properties have attributes from the System.ComponentModel namespace to hide, force read only, or rename attributes (DisplayName, ReadOnly, Browsable etc).

Now, for some users (those with a superuser access), I need to expose some of the hidden properties, in a DataGridView.

But the attributes are causing problems... When I bind a DataGridView to a List<t> of my objects, only the columns shown in the PropertyGrid are shown.

Even if I disable automatic column generation, and try to manually create columns, like this:-

dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = my List<T>;

DataGridViewColumn column = new DataGridViewTextBoxColumn();
column.Name = "Column Name";
column.DataPropertyName = "HiddenProperty";
dataGridView1.Columns.Add(column);

The created column simply comes out blank.

Does anyone know a way round this? Other than (of course) losing the databinding functionality and filling the DataGridView manually?

Thanks

Jon

using System.Beer;

Hi Jon

This is just a shot in the dark, but have you looked into AttributeProvider[^]?

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: How could God prove Himself to humanity?
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Guys,
How can I access a shared secured folder from code (VB/C#) that will not show the UserName/Password dialogue box?

Thank you

ThaScorpion

ThaScorpion

If the account your code is running under isn't recognized by the server, you MUST supply a username and password to it in order for it to let you into the Share. You simply have no way around this.

You can find an example of logging into a remote server here[^].

If you don't have appropriate credentials recognized by the remote server, you're outta luck until you get an account that IS recognized.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

How do I get the user's current wallpaper bitmap? (keeping in mind that the user might have set the wallpaper with either the desktop properties control panel applet, or with the SetParametersInfo method in user32.dll) Is there an API call that returns a bitmap or a handle that I can use to create a Bitmap object?

I'm not wanting to change or alter the wallpaper, I'm wanting to display it as a Bitmap object on a Form.

-Daniel
Typing too fast fro my owngood

Microsoft.Win32 is used for accessing the registry, while System.Runtime.InteropServices is used for accessing the unmanaged user32.dll.

Next comes the preparation of the unmanaged function SystemParametersInfo() - this should be located at the top of the Smile | :)

class definition:

[DllImport("user32.dll", CharSet = CharSet.Auto)]<br />
<br />
static extern int SystemParametersInfo(int uAction, int uParam, string lpvParam, int fuWinIni);

First thing is to retrieve the current desktop wallpaper, and to do that we don't need to use a function, but simply read a value in the Windows registry. Let's create the method for that:

private string GetCurrentWallpaper()<br />
<br />
{<br />
<br />
    // The current wallpaper path is stored in the registry at HKEY_CURRENT_USER\\Control Panel\\Desktop\\WallPaper<br />
<br />
    RegistryKey rkWallPaper = Registry.CurrentUser.OpenSubKey("Control Panel\\Desktop", false);<br />
<br />
    string WallpaperPath = rkWallPaper.GetValue("WallPaper").ToString();<br />
<br />
    rkWallPaper.Close();<br />
<br />
    // Return the current wallpaper path<br />
<br />
    return WallpaperPath;<br />
<br />
}

Next comes the definition of the method that actually sets the wallpaper, Additional for you . And it's only a few lines of code:

private void SetWallpaper(string WallpaperLocation, int WallpaperStyle, int TileWallpaper)

{

// Sets the actual wallpaper

SystemParametersInfo(20, 0, WallpaperLocation, 0x01 | 0x02);

// Set the wallpaper style to streched (can be changed to tile, center, maintain aspect ratio, etc.

RegistryKey rkWallPaper = Registry.CurrentUser.OpenSubKey("Control Panel\\Desktop", true);

// Sets the wallpaper style

rkWallPaper.SetValue("WallpaperStyle", WallpaperStyle);

// Whether or not this wallpaper will be displayed as a tile

rkWallPaper.SetValue("TileWallpaper", TileWallpaper);

rkWallPaper.Close();

}

Smile | :)

I only needed to get the wallpaper. I didn't know that the registry's value was updated that well (I just looked on mine and it's correct, despite me circumventing the control panel applet), so I'm good to go. I already know how to set the wallpaper (and I have a handy app available for free download from my blog). Thank you for the info! It helps me greatly!

-Daniel
Typing too fast fro my owngood

Hi!
I developed a Pocket PC application in VS2005 and i want to deploy it on Pocket PC so how do i make setup and deploy to it. Any suggestion will be appreciated.
Thanks in advance.

Its the same as a windows application,

In new project, select Other Project Types, Setup and Deployment and select
Smart Device Cab Project