C# Discussion Boards - CodeProject

Re: Checking MAX() of a table in C#

8-Jul-08 2:46

if one stores data in a DATATABLE it's easy to see that :

DataTable DT;
DT.Columns.Count;

Have Fun
Never forget it

leppie8-Jul-08 4:08

Re: Checking MAX() of a table in C#

8-Jul-08 4:08

MAX not SUM.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Ashfield8-Jul-08 3:16

Ashfield

8-Jul-08 3:16

I think you want to get the max value of a column from a table in sql server?

select max(column_name) from table

You run this as an executescalar in your c#

hope this helps

Bob
Ashfield Consultants Ltd

TCP IP Any Port

half-life8-Jul-08 2:35

DB2 Query Validation in C#

8-Jul-08 2:35

is there a way to Listen to all Port's
Like the Ip Case ( IPAddress.Any )??

Have Fun
Never forget it

Member 19917268-Jul-08 1:59

Member 1991726

8-Jul-08 1:59

I'm using C#, .net2.0 framework and DB2 as my database.

I need to validate a database(DB2) query which is given by the user in the textbox. Please note that I just need to validate not to execute the query(text in textbox). I dont want any third party software and I want to do in .net2.0, ASP.net, C#, DB2

Please share your ideas and solution. Roll eyes | :rolleyes:

half-life8-Jul-08 2:57

8-Jul-08 2:57

if you're using any kind of a dataSet u can create a shallow copy of it
and without "Thouching" the original Exe the Qurey for test only

use the try and catch finlly Smile | :)

Have Fun
Never forget it

Member 19917268-Jul-08 3:28

Member 1991726

8-Jul-08 3:28

thanks for your reply..

Could you please tell me how to do in .net2.0 with c#. If you provide steps or code is very helpfull for me..

Thanks in advance

Ashfield8-Jul-08 3:20

Ashfield

8-Jul-08 3:20

Does db2 have the query parse facility like sql server? This allows you to parse the sql without executing. If so then you should be able to wrap it up in a try/catch and display any problems.

Bob
Ashfield Consultants Ltd

Member 19917268-Jul-08 3:25

Member 1991726

8-Jul-08 3:25

thanks for your reply..

I'm not aware of sql parser in .net.. Could you please tell me how can i get it so that I can test the same with DB2 also..

Thanks in advance

CP865 text encoding (a bit urgent).

Ashfield8-Jul-08 4:01

Ashfield

8-Jul-08 4:01

The parser is not a .net feature, it's a sql server feature - SET NOEXEC ON. By doing this, when you execute your sql it simply parses but does not execute. I don't know if db2 has a similar feature?

Bob
Ashfield Consultants Ltd

thomasa8-Jul-08 1:56

thomasa

8-Jul-08 1:56

Does anyone know how I can encode a string to a CP865 encoded text, (not for example Unicode or UTF8).

What I am trying to do is to transfer a string content as an txt file with CP865 encodeing.

Response.ClearContent();
Response.AddHeader("Content-disposition", "Attachment;filename=Myfile.txt");
Response.ContentType = "text/plain";
Response.Write("This text shall have de Norwegian charset of the CP865 encoder");
Response.End();

Thanks
Thomas

Re: CP865 text encoding (a bit urgent).

User 66588-Jul-08 2:05

User 6658

8-Jul-08 2:05

You can convert to a specific codepage using the Encoder class:

byte[] bytes = Encoding.GetEncoding(865).GetBytes("This text shall have de Norwegian charset of the CP865 encoder");

You may also need to specify the encoding in your response header.

regards

modified 12-Sep-18 21:01pm.

Re: CP865 text encoding (a bit urgent). SOLUTION

thomasa8-Jul-08 2:40

thomasa

8-Jul-08 2:40

Thanks, it worked great Smile | :)

Here's a example of my final solution, if anyone else ever needs it.

int chunkSize = 10000;
MemoryStream ms = null;
int dataLeft = 0;
try
{
Response.ClearContent();
Response.AddHeader("Content-disposition", "Attachment;filename=Myfile.txt");
Response.ContentType = "text/plain";
byte[] bytes = System.Text.Encoding.GetEncoding(865).GetBytes("This text shall have de Norwegian charset of the CP865 encoder");

dataLeft = bytes.Length;
ms = new MemoryStream(bytes);
while (dataLeft > 0 && Response.IsClientConnected)
{
byte[] currentChunk = new byte[chunkSize];
int currentChunkSize = ms.Read(currentChunk, 0, chunkSize);
Response.BinaryWrite(currentChunk);
dataLeft -= currentChunkSize;
currentChunk = null;
}
Response.End();
}
catch{}
finally
{
if (ms != null) ms.Close();
ms = null;
}

Dynamic interface display

Nir sheffi8-Jul-08 1:13

8-Jul-08 1:13

I'm trying to create a class that will dynamically load an assembly that will
hold a several definitions for structs (used as an interface to an existing application).
My class will then display those structs as strings - display the interface.
I need to load it dynamically since there are several versions of the same interface.
Thx.

leppie8-Jul-08 1:38

8-Jul-08 1:38

Thats nice. What is the problem you are experiencing?

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Nir sheffi8-Jul-08 2:11

8-Jul-08 2:11

How do i do that ?
I know how to display the struct layout.
I know how to load dynamically the assembly.
Let me try and explain my problem:
lets say that i have a class A which can display type S as a string.
S is defined in class B.
I have to reference B or else i get a compilation problem.
but, since B has two versions (1 and 2) i want to load it dynamically.
how do i do that ?

leppie8-Jul-08 4:10

8-Jul-08 4:10

Nir sheffi wrote:
how do i do that ?

Your problem is not very specific. Maybe you need to rethink the design and focus on smaller problem areas.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Nir sheffi8-Jul-08 4:14

8-Jul-08 4:14

but this is my problem !
i want to display a struct that changes between versions of assemblies.

leppie8-Jul-08 4:33

8-Jul-08 4:33

Nir sheffi wrote:
but this is my problem !
i want to display a struct that changes between versions of assemblies.

So what is the problem?

- Does it not load?
- Can you not differenciate between 2 versions of the same type?
- Do you get an exception when you do something?
- Anything else?

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Nir sheffi8-Jul-08 20:34

how to retrive photos which are stroed in the active directory?

8-Jul-08 20:34

class A
{
void print(B b){....}; // prints type B
}

struct B (ver 1.0)
{
int x;
}

struct B (ver 2.0)
{
int x;
int y;
}

if A does not ref. directly to assembly that holds B we can not compile since A does not know B.
but i want to load B dynamically, so i do not want to ref. B during compilation.
that is my problem.

kju0028-Jul-08 1:06

kju002

8-Jul-08 1:06

Hi everyone!!!

Is there anyone who knows how to retrive photos in the active directory using c#?

Re: how to retrive photos which are stroed in the active directory?

half-life8-Jul-08 3:03