C# Discussion Boards - CodeProject

Anonymous25-Jul-05 20:45

Anonymous

25-Jul-05 20:45

Same problem Frown | :(

Can I make a stored procedure and pass the "order by" parameter? I think that's going to solve the problem. I am using Crystal Reports that comes with the VS.net 2003. How can I call a stored procedure and pass the parameter?

Many thanks.
Zishan

Craig G Fraser25-Jul-05 21:40

Craig G Fraser

25-Jul-05 21:40

I have used crystal in a few of my apps and the way I handle sorting is by sorting the datasource ( i use a dataset as the source ). So based on a selected column by the user, sort the dataset into the desired order or load the data into the dataset by specifying the SORT keyword in the sql statement when retrieving the data.

Hope this helps.

Craigo

Zishan Haider25-Jul-05 22:27

Zishan Haider

25-Jul-05 22:27

Craigo, I tried what you told me.. it is picking up all the records in the table without any order. I commented the t.SetDataSource line.. still the same result. I am not sure if this is the right way to define Data Source. Here is my code :

Report2 t = new Report2();

string Query = "Select * from Orders order by ordertype asc";
SqlComm.CommandText = Query;
SqlDataAdapter da = new SqlDataAdapter(SqlComm);

DataSet data = new DataSet();
da.Fill(data);

t.SetDataSource(data);

this.Viewer.ReportSource = t;

Zishan

Craig G Fraser25-Jul-05 22:43

Craig G Fraser

25-Jul-05 22:43

2 Things you can try.

1) change the code where you set the datasource to :
t.SetDataSource(data.Tables[0])

2) Add the line: t.EnableSaveDataWithReport=false;
after you have set the datasource

Let me know how you get on

Craigo

installing a c# web service on the server

Zishan Haider25-Jul-05 23:07

Zishan Haider

25-Jul-05 23:07

Hey Craig, thanks a lot man.. you saved my life.. although I don't have t.EnableSaveDataWithReport property but the problem is now solved.. Thanks for your help! Smile | :)

Zishan

fady_sayegh24-Jul-05 21:43

fady_sayegh

24-Jul-05 21:43

hi to all,

i have developped a web service in c# .net on my local machine (localhost).
then i create a c# win application and i added the web reference (on the local host) to cosume this web service and everything works fine.

how can i put the web service on the server (windows 2000 server). and then where can i add the web reference to my c# win application to cosume it.

do i have to install the .net frame work on the server and then copy my web service project on that server ?

note that all the client terminal does not have an IIS

best regards and thanks in advance

fady

cshaaaa24-Jul-05 21:59

24-Jul-05 21:59

You have to install iis to your server and deploy your service there.
Then you can add a web reference to the server
Eg: http://ipAddress/......

Regards,
charith

fady_sayegh24-Jul-05 22:12

fady_sayegh

24-Jul-05 22:12

thanks to your reply charith,

do i have to install .net framework on the server or not ?

best regards,

fady

cshaaaa24-Jul-05 22:37

24-Jul-05 22:37

Hi fady
I think you have to install the framework.Not sure!
Sometimes it might work without the framework..
regards;
charith.

fady_sayegh24-Jul-05 22:50

fady_sayegh

24-Jul-05 22:50

thanks charith,

i will try with the .net framework

thanks to your reply again

fady

J4amieC25-Jul-05 0:40

J4amieC

25-Jul-05 0:40

charith@ramedian.com wrote:
Sometimes it might work without the framework..

Nothing .NET works without the framework....ever (I cant see how you could say "sometimes it might work" WTF | :WTF:

)

cshaaaa25-Jul-05 0:49

Creating an object wrapper through a web service

25-Jul-05 0:49

Thanks

cshaaaa24-Jul-05 20:04

Measuring size of a string

24-Jul-05 20:04

I have written a webservice using ASP. There is a class named ReferenceDetails. I can add the webservice to my client side
and create a object of type ReferenceDetails.No problem!

private int _intRefID;
private int _intPatientID;
private int _intDoctorID;
private DateTime _beginDateTime;// = new DateTime();

public ReferenceDetails()
{
this._beginDateTime = new DateTime();
}

I have written another class at the backend containing ReferenceDetails object;

private ReferenceDetails _refDetails = new ReferenceDetails();

public RemindDetailsWrapper()
{
}

The problem is when i am creating a RemindDetailsWrapper() object at the client side it doesn't contain ReferenceDetails object. Confused | :confused:

Thanks :

wasife24-Jul-05 19:39

wasife

24-Jul-05 19:39

Salam,
I have a rectangle(whose width, height etc is in millimeters) and a string. I want to know how much(no. of characters) of the string can be drawn in that rectangle keeping in view word breaks, line spacing etc. I have used MeasureString but the characters given by it are greater than actual that can be drawn in that rectangle.

Re: Measuring size of a string

Guffa25-Jul-05 1:31

Guffa

25-Jul-05 1:31

How have you used MeasureString? It does not return a number of characters but the size needed to draw the string.

Have you specified the same font and size for MeasureString as you use when you draw the text?

---
b { font-weight: normal; }

Getting value with Reflection?

kbalias24-Jul-05 19:31

kbalias

24-Jul-05 19:31

Hi

If I have a class Person eg:

Class Person
{
private int identity;

public int Identity
{
get
return this.identity;
set
this.identity = value;
}

How can I get the value of identity (for example) using Reflection if I use the following type of code.

Person person = new Person();
this.DoSomething(person);

public void DoSomething(object obj)
{
//int identity = ???????;
Console.Writeline("Identity = " + identity);
}
}

I tried using the Type.PropertyInfo and GetValue, but the help documentation is not that clear and I did not manage.
Can anybody help me with an example perhaps.

Thanks.

Kobus

Re: Getting value with Reflection?

[Marc]25-Jul-05 7:56

[Marc]

25-Jul-05 7:56

public static int GetIdentity(Person person){
    // Get the type
    Type type = person.GetType()
    // Flags to get the private variable
    BindingFlags flags = BindingFlags.NonPublic | BindingFlags.Instance
    // FieldInfo for the identity variable
    FieldInfo field = type.GetField("identity", flags)
    // Get the identity from the specified person
    Object value = field.GetValue(person)
    // Convert value to int and return it
    return (int)value
}

I'm a wreck at C#, but i hope this helps! Cool | :cool:

A missing using directive

Jerry Hammond24-Jul-05 18:29

Jerry Hammond

24-Jul-05 18:29

For anyone working their way through the Que Certification for exam 316 there is an error in exercise 2.18. For the code to work correctly you will need to add a using System.IO directive otherwise you will not be able to compile the code.

Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
My Grandkids

need help to develop C# software

Soulblazer24-Jul-05 17:03

Soulblazer

24-Jul-05 17:03

How do I develop my C# project into a stand alone software that can run on any computer?

ekynox24-Jul-05 17:07

ekynox

24-Jul-05 17:07

fire up vs and select new visual c# project then choose the "Windows Application" Template. That will create your stand alone software.

Soulblazer24-Jul-05 17:16

Soulblazer

24-Jul-05 17:16

But I face problems when i try to run the application in computers that do not have visual studio .net.

[Marc]24-Jul-05 17:41

[Marc]

24-Jul-05 17:41

.Net apps need the .Net framework to run.
Maybe those computers don't have that framework.
If that is the case, you can download it here[^].

Soulblazer24-Jul-05 17:41

Soulblazer

24-Jul-05 17:41

Is it possible to run a visual C# windows application project on a computer that does not have visual studio?

Vasudevan Deepak Kumar24-Jul-05 22:57

Vasudevan Deepak Kumar

24-Jul-05 22:57

You don't need Visual Studio .NET. You only need .NET Runtime (appropriate version). You can get one from http://msdn.microsoft.com/net/[^]

Deepak Kumar Vasudevan
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/