C# Discussion Boards - CodeProject

Re: C# Project corrupted?

30-Jul-07 20:02

Hello,

The Problem is that both classes have design support.
It is not good practice to but them all in one file.
If you put the picturebox in a special file you will also be able to open it over the designer.

All the best,

Martin

Vikas K.30-Jul-07 20:12

Vikas K.

30-Jul-07 20:12

Thank you Martin and others who gave quick answers!
I created another file and things are pretty nice now!

Help is really appreciated Smile | :)

problem in generating crysatl reports

monuSaini29-Jul-07 21:14

29-Jul-07 21:14

Hello Every body,

I am new with crystal reports. I want to generate report for those employees whose age is more than 50 yrs.

But I am not able to do so .It is showing all the records.

I had added an crystal report in my project.

I link it with the database through wizard only,

On form1 it had inserted an crystal report viewer. on the load event of the form1 I had used the following code but it is use less.

SqlConnection Connection = new SqlConnection("server='server1'; user id='sa'; password='admin'; database='employee'");

SqlCommand myCommand = new SqlCommand("SELECT * from companyEmp where age < '50'");

myCommand.Connection = Connection;
myCommand.CommandType = CommandType.Text;

SqlDataAdapter DA = new SqlDataAdapter();
DA.SelectCommand = myCommand;

DataSet DS = new DataSet();
DA.Fill(DS);

crystalReportViewer1.SetDataSource(DS.Tables[0]);
crystalReportViewer1.ReportSource = objNewReport;

But it is still showing all the record of companyEmp.

Regards,

rahul saini

Edwin Syarief29-Jul-07 22:18

Edwin Syarief

29-Jul-07 22:18

monuSaini wrote:
SqlCommand myCommand = new SqlCommand("SELECT * from companyEmp where age < '50'");

U just need:
SqlCommand("SELECT * from companyEmp where age < 50");

'50' -> type string
50 -> int

Regard,

Edwin

monuSaini29-Jul-07 22:58

29-Jul-07 22:58

Hello Edwin,

Thanks for ur rply.

But still same problem.

It is showing all the records.

If I am using only this

crystalReportViewer1.ReportSource = NewReport;

then also it is showing all the records.

Rregards,

rahul saini

T.EDY29-Jul-07 23:28

T.EDY

29-Jul-07 23:28

may i know the data type of age in your database?

Regards,

Tomi

monuSaini29-Jul-07 23:33

29-Jul-07 23:33

Hello Tomi,

Thanks for ur rply.

Its int.

Regards,

rahul saini

T.EDY29-Jul-07 23:42

T.EDY

29-Jul-07 23:42

Hi Rahul,

I wonder if u want to show the data if the age is above 50 right?

if u use query:

SELECT * FROM Your_Table Where age < 50

u got an output data age below 50, if u want to show the data where age is more than 50 than u must change your query into :

SELECT * FROM Your_Table WHERE age > 50

i try to my query analizer thats work Smile | :)

Regard,

Tomi

Edwin Syarief29-Jul-07 23:47

Edwin Syarief

29-Jul-07 23:47

TomiEdy wrote:
if u use query:

SELECT * FROM Your_Table Where age < 50

u got an output data age below 50, if u want to show the data where age is more than 50 than u must change your query into :

SELECT * FROM Your_Table WHERE age > 50

I think U right Tomi, maybe U must check your query Rahul

Regard,

Edwin

T.EDY29-Jul-07 23:57

T.EDY

29-Jul-07 23:57

Thank You Edwin

Regard,

Tomi

Edwin Syarief29-Jul-07 23:41

Edwin Syarief

29-Jul-07 23:41

SqlDataAdapter adapter = new SqlDataAdapter(yourQuery, conn);
DataSet ds = new DataSet();
DataTable dt = new DataTable("tablename");
adapter.Fill(dt);
ds.Tables.Add(dt);
ds.WriteXml("C:\text.xml");

Then On your crystal report Database Fields:
change your dataset with "text.xml"

If U have finish it, then create a dataset with your query, then change the code like this:

SqlDataAdapter adapter = new SqlDataAdapter(yourQuery, conn);
DataSet ds = new DataSet("YourDataSet");
DataTable dt = new DataTable("tablename");
adapter.Fill(dt);
ds.Tables.Add(dt);

ReportDocument rd = new ReportDocument();
rd.SetDataSource = ds;
crystalReportViewer1.ReportSource = rd;

Regard,

Edwin

monuSaini30-Jul-07 0:08

30-Jul-07 0:08

Hello Edwin,

When i m writing the xml it is giving me following error.

ds.WriteXml("C:\text.xml");

Illegal characters in path.

Regards,

rahul saini

PhilDanger30-Jul-07 3:42

PhilDanger

30-Jul-07 3:42

ds.WriteXml("C:\text.xml");

-- \t is the character code for a tab. You need to escape your backslashes by... using another backslash.

ds.WriteXml("C:\\text.xml");

monuSaini30-Jul-07 17:22

30-Jul-07 17:22

Hello Edwin,

One of my friend had told me that this issue can be resolved through SELECT EXPERT. Do you had any idea about this.

Regards,

rahul saini

Developer61130-Jul-07 0:24

Developer611

30-Jul-07 0:24

Hi there .

Look my friend you set you ReportViewer data source it's wrong . you must create new instance of your CrystalReport.rpt file . for example i have an report file named report.rpt .

// Create new instance of your CrystalReport File
Report _Report = new Report();

// Set Report data source ,no your viewer .
_Report.SetDataSource(Your_DataSource);

// Finally set your report viewer report source to your Report file .
crystalReportViewer1.ReportSource = _Report;

DMASTER

monuSaini30-Jul-07 1:54

30-Jul-07 1:54

Hi,

I had use this also but again it is showing the same result.(all the records are showing)

this the code i m using

SqlConnection Connection = new SqlConnection("server='sName'; user id='sa'; password='admin'; database='employee'");

SqlDataAdapter DA = new SqlDataAdapter("SELECT empId,empName,empAge from companyEmp where age < 50", Connection);

DataSet DS = new DataSet();

DA.Fill(DS);

newReport objNewReport = new newReport();
objNewReport.SetDataSource(DS.Tables[0]);

crystalReportViewer1.ReportSource = objNewReport ;

Regards,

rahul saini

How to detect a Mouse Double Click under Mouse_Down?

Developer61130-Jul-07 5:10

Developer611

30-Jul-07 5:10

Wow , I got it .you are using untyped dataset , right ?

look answer to my question I hope, I can help you .

1: Did you put any typed dataset in your report form ?
2: Did you used directly connection in report ?

Send your email address to my mail : www.Developermaster61@gmail.com

I hope, I elaborate in more detail .

DMASTER

Khoramdin29-Jul-07 20:28

Khoramdin

29-Jul-07 20:28

Hello everyone,

Is there anyone that I can know there was a Mouse Double Click in the MainForm_MouseDown? I currently can detect if there has been a Left or a Right click but I would like to be able to check for Double Click.

if (e.Button == MouseButtons.Left)<br />
        {<br />
            MessageBox.Show("You have just clicked on " + e.Button + " button.");<br />
            MessageBox.Show("X: " + e.X + " -- Y: " + e.Y);                                      <br />
        }<br />
        if (e.Button == MouseButtons.Right)<br />
        {<br />
            MessageBox.Show("You have just clicked on " + e.Button + " button.");<br />
            MessageBox.Show("X: " + e.X + " -- Y: " + e.Y);<br />
}

Thank you very much and have a great day.

Khoramdin

Re: How to detect a Mouse Double Click under Mouse_Down?

Martin#29-Jul-07 20:41

Re: How to detect a Mouse Double Click under Mouse_Down?

29-Jul-07 20:41

Hello,

I don't think that it's possible in MouseDown, as MouseDown is fired bevore Click and Double Click.
But MouseUp is fired after Click and DoubleClick.

So this would work:

private bool FlagDoubleClick = false;
protected override void OnDoubleClick(EventArgs e)
{
    FlagDoubleClick = true;

    base.OnDoubleClick (e);
}

protected override void OnMouseUp(MouseEventArgs e)
{
    if(FlagDoubleClick)
    {
        //Do it here!
        FlagDoubleClick= false;
    }
    base.OnMouseUp (e);
}

All the best,

Martin

Luc Pattyn29-Jul-07 23:35

Luc Pattyn

29-Jul-07 23:35

Hi,

MouseDown event offers MouseDownEventArgs parameter
its Clicks member contains what you need:
on a double click, the event fires twice, once with Clicks=1, once Clicks=2

Smile | :)

Luc Pattyn

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

Re: How to detect a Mouse Double Click under Mouse_Down? [modified]

Martin#29-Jul-07 23:51

Re: How to detect a Mouse Double Click under Mouse_Down?

29-Jul-07 23:51

Hello Luc,

I just tested it and saw that it works.
But I don't understand why.
When is the Clicks property reseted?
And isn't a Click only a Click if the MouseUp is excecuted?

I'm sure you will clear my confusion!
Thanks for your time!

-- modified at 5:56 Monday 30th July, 2007

Just did additional tests, and now I think I understand it.
Looks like the DoubleClick is fired only by the correct MouseDown delta time, no second MouseUp needed for the validation.
But it get's fired only after MouseUp is excecuted.
I'm not sure if this behaviour is very logic, but who said that programming has to be logic at all!
Smile | :)

All the best,

Martin

Luc Pattyn30-Jul-07 0:27

Luc Pattyn

30-Jul-07 0:27

Hi Martin,

Martin# wrote:
I just tested it and saw that it works

A click consists of a down followed by an up (both keyboard and mouse)
To count clicks, you could wait until you get a click, then increment counter;
or you could simply count physical downs (cant have two physcial downs without an
up in beteen !)

So you may argue that the member name should have been Count instead of Clicks,
but it is no miracle they can make it work.

And you would be right if you don't like MSDN saying "MouseEventArgs.Clicks gets
the number of times the mouse button was pressed and released"

Smile | :)

Luc Pattyn

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

Re: How to detect a Mouse Double Click under Mouse_Down?

Martin#30-Jul-07 1:25