Re: crestal report - C# Discussion Boards

Judah Gabriel Himango30-Aug-06 14:08

Judah Gabriel Himango

30-Aug-06 14:08

Tareq, you'll need to be more specific with the problem you're running into. Do you need help reading from the database? Do you need help with displaying the label read from the database? If you're more specific, we can better answer your question.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Dumbest. Movie. Title. Evaaar.
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

TAREQ F ABUZUHRI30-Aug-06 21:18

TAREQ F ABUZUHRI

30-Aug-06 21:18

i want to send parameter from my form to crestal report file ...

Palestine

gus_br31-Aug-06 7:36

31-Aug-06 7:36

dataset

gus_br30-Aug-06 16:09

30-Aug-06 16:09

Tereq,

you can use a typed dataset to do that, for instance. This dataset can be filled in code, maybe using a Data Adaptor (along with a data connection and a SQL Select command), or manually, if you want.
The point is that you need add this dataset as a datasource to your crystal report. Therefore, you just need do drag and drop the desired field onto your report.
About showing a label associated with the fields i'm not sure. Just as a sugestion (not so good), you could create another typed dataset (or another datatable, or even, another column) to hold the string value associated with the numeric value. These stirng values could be code filled based on numeric values.(I supposed you are trying associate a numeric value (from the DB) to a sring value (excelente, very good, and so on...))
I'm sure will find something very useful if you search for a article related to crystal here in code project.

cya

Glen Harvy31-Aug-06 13:10

Glen Harvy

31-Aug-06 13:10

Hi,

I've just spent days trying to learn Crystal Reports that ships with VS2005 and have found the easiest way to do anything is to create specific database tables that hold the data you wish to incorporate into your Crystal Report. Then just drag the field from the datatable view onto the Crystal Report.

Good luck and BTW. - I couldn't find *any* decent help on how to use Crystal Reports VS2005 *anywhere*. Some joker called his article "A beginners guide to CR" but it certainly isn't written for beginners.

Glen Harvy

gus_br31-Aug-06 15:36

31-Aug-06 15:36

sure, crystal report is harder than .rdlc reports in VS2005, but it's a lot more powerfull

Glen Harvy31-Aug-06 17:41

Glen Harvy

31-Aug-06 17:41

pontonet wrote:
sure, crystal report is harder than .rdlc reports in VS2005, but it's a lot more powerfull

It's a world apart Big Grin | :-D

, now that I think I've got the basics!

Glen Harvy

Win32 CEdit class?

wbjohnson30-Aug-06 13:00

30-Aug-06 13:00

Hey guys

just another quicky, i want a simple way of discovering all "text boxes" on an application via interop... i figured that getting the class name would work.... mmm kinda,

some control give me:
Class: Edit

but apps wrote in .net give me:
Class: WindowsForms10.EDIT.app.0.3b95145

if there another way of asking if this hWnd IntPtr a textbox (edit) control?

Cheers

Will

Re: Win32 CEdit class?

Nader Elshehabi30-Aug-06 13:22

How to use .ico files in toolbar, buttons, etc

30-Aug-06 13:22

Hello

With this way you are trying to access CEdit controls which differs from Edit control in one simple fact, CEdits are made by MFC, while the Edit scope is much larger. Each CEdit is a windows Edit control but not vise versa.

To identify an Edit control -whether CEdit, C# Edit, or whatever...-, you should sen a EM_ message specific to it. If it give you a respond, then it supports this message and it's an Edit control. If not then the probability goes that it's not an edit control.

Much harder, but more sensitive to Edit sontrols. Of course carful choice of the EM_ message you'd send is important. I don't have any in mind, but you should search windows messages for the best one -even if it was not an EM_ message-. Try EM_GETLIMITTEXT for a start. If it returns a number larger than zero, you are probably in a valid esit control.

Regards

monrobot1330-Aug-06 12:48

monrobot13

30-Aug-06 12:48

Is it possible to use .ico files for the Image property of ToolbarItems, Buttons, etc? If so how? If not does anyone know a good program I could use to convert .ico's to a bmp, jpg, etc?

Thanks!

- Aaron

Re: How to use .ico files in toolbar, buttons, etc

Nader Elshehabi30-Aug-06 13:07

populating data into a listbox (SLOW)

30-Aug-06 13:07

Hello

monrobot13 wrote:
Is it possible to use .ico files for the Image property of ToolbarItems, Buttons, etc?

Yes. In the designtime click on image property => Click import => emove the images filter => Choose in .ico file Smile | :)

monrobot13 wrote:
a good program I could use to convert .ico's to a bmp, jpg, etc?

You don't need any extra program to convert icons to bitmaps. use MyIcon.ToBitmap() method

Also you can add icons to your resources files directly.

Regards

Saamir30-Aug-06 11:26

Saamir

30-Aug-06 11:26

Hi guys;
I have 2 listboxes in my form that I am loading data into on load of the form. Here is the code for one of them:

public void populatelbBranches()
{
SqlConnection cnn=null;
SqlCommand cmd=null;
SqlDataReader reader=null;
try
{
cnn=new SqlConnection(m_ADBCnn);
cnn.Open();

string query="SELECT BrnId,Name FROM tblBRANCHES";
cmd = new SqlCommand(query, cnn);
reader = cmd.ExecuteReader();
if (reader != null)
{
while (reader.Read())
{
lbBranches.Items.Add(reader["BrnId"]+ " - " + reader["Name"]);
}
}
}
catch (Exception ex)
{
MessageBox.Show(this,ex.Message)
}

finally
{
reader.Close();
cmd=null;
lbBranches.SelectedIndex = 0;
if(cnn!=null && cnn.State !=ConnectionState.Closed)
{
cnn.Close();
}
cnn=null;
}

Is there any way I can make the reading/loading faster? it takes almost 2 minutes to populate 3500 records. It takes 2 seconds if I run the query in SQL Query Analyzer. Please Help!!!!

sasa

Re: populating data into a listbox (SLOW)

Nader Elshehabi30-Aug-06 12:04

Re: populating data into a listbox (SLOW)

30-Aug-06 12:04

Hello

As a small demo of the time cose of a try block:

long TicksA, TicksB;
TicksA = DateTime.Now.Ticks;
try
{
    int A = 0;
    while (A < 1000000000)
        A++;
}
catch { }
TicksA = DateTime.Now.Ticks - TicksA;

TicksB = DateTime.Now.Ticks;
int B = 0;
while (B < 1000000000)
    B++;
TicksB = DateTime.Now.Ticks - TicksB;
MessageBox.Show(TicksA.ToString() + "\n" + TicksB.ToString());

1- Your code will never be as fast as the QueryAnalyzer
2- Try removing the try and if blocks -Bad but fast-
3- As a last solution you might want to make multiple threads reading at multiple areas of your datatable -like download accelerators-
4- Make a thread to read and give it high priority -dangerous-

Regards

gus_br30-Aug-06 16:23

User32 SetFocus not working - any ideas?

30-Aug-06 16:23

It's very strange, speacially in only 3500 rows. Your code are pretty good.
As a sugestion, try to use a dataset to retrieve these values using a Data Adaptor to fill it. And then, set the datasource property of you list box. But i think this will not solve your problem, cause it's indirect access, and you have made simple access, which is faster.

good luck!

wbjohnson30-Aug-06 11:24

30-Aug-06 11:24

hey guys, ive wrote a little app that takes a given a IntPtr handle to a random application.... it when gets all childwindows and looks for the first EDIT (CEdit) class and then tries to set focus to it.. i know it seems pointless, but its part of a large plan! hehe

anyway, its just not working! im calling SetFocus(IntPtr) to the Edit class and its just ignore me! (ive even tried bringing the parent application to te front - that works btw)

any ideas why SetFocus isnt putting the cursor in the Edit class ready for user input?

Nader Elshehabi30-Aug-06 11:34

30-Aug-06 11:34

Hello

Quoted from MSDN:
If the hWnd parameter is invalid or the window is not attached to the calling thread's message queue, the return value is NULL. To get extended error information, call GetLastError.

Try to see the returned value, and GetLastError().

Also I suggest to SendMessage(WM_SETFOCUS) yourself, instead of calling SetFocu(hWnd).

Regards

wbjohnson30-Aug-06 11:59

30-Aug-06 11:59

hi there,

when i use SetFocus(), it doesnt work and i get this last error message:
1008 An attempt was made to reference a token that does not exist. ERROR_NO_TOKEN

(i looked up the message on google)

however - if i do what u suggested it works Big Grin | :-D

do you know why this way works and the other one doesnt?

Nader Elshehabi30-Aug-06 12:12

30-Aug-06 12:12

Hello

I'm glad that it works now. Smile | :)

If you revise the qoute I posted from MSDN, you'd notice that SetFocus() function, sends the message to the current message queue. You are sending WM_SETFOCUS message to another application with another message queue. That's why you need to explicitly send the message yourself.

Regards

wbjohnson30-Aug-06 12:15