C# Discussion Boards - CodeProject

Re: Writing to the compression stream is not supported.

2-Sep-08 2:02

How about CompressionMode.Compress?

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

tamour2-Sep-08 2:03

tamour

2-Sep-08 2:03

I told ya, I have already compressed the document, i want to decompress them now.

Re: Writing to the compression stream is not supported.

leppie2-Sep-08 2:04

Re: Writing to the compression stream is not supported.

2-Sep-08 2:04

Well then you must read from the compressed stream.

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

tamour2-Sep-08 20:09

tamour

2-Sep-08 20:09

Thankyou Very much dear. I made it worked but not without ur help.

Re: Writing to the compression stream is not supported.

leppie2-Sep-08 2:07

Re: Writing to the compression stream is not supported.

2-Sep-08 2:07

Looking at you code snippet again. There is something wrong with your logic. How can you read and write to the same stream?

You should read from the SPFileStream and write to GZipStream that be wrapping the FileStream or MemoryStream.

Hope this helps.

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

Guffa2-Sep-08 3:42

Guffa

2-Sep-08 3:42

Why are you trying to write to the stream that you are decompressing. You should read from the GZipStream (zip) and write to the destination stream (fs).

Despite everything, the person most likely to be fooling you next is yourself.

Re: Writing to the compression stream is not supported.

Mbah Dhaim2-Sep-08 10:08

Mbah Dhaim

2-Sep-08 10:08

GZipStream zip = new GZipStream(fs, CompressionMode.Decompress, true);
int fileSize = zip.Read(buffer, 0, (int)buffer.Length);
zip.Write(buffer, 0, (int)buffer.Length);-->YOUR ERROR GOES HERE
zip.Flush();

1. create a stream to buffer decompressed bytes
2. write bytes from read result in zip.Read(...) to the stream above
3. you will have a decompressed stream as result

hope it helps

dhaim
programming is a hobby that make some money as side effect Smile | :)

Re: Writing to the compression stream is not supported.

tamour2-Sep-08 20:10

tamour

2-Sep-08 20:10

Thankyou very much Dhaim. Without ur halp specially, i wouldnt have done this.

Using smo????

omegazafer2-Sep-08 1:39

2-Sep-08 1:39

Hi,
How can I reach database relation diagram of sql by using smo? I want to learn parent key table of any column if that column is foreign key.
Forexample, in northwind database, in products table, there is categoryid column. This column is related to id in Category table. I want to find this.

Best Regards

THANKS

leppie2-Sep-08 2:01

2-Sep-08 2:01

omegazafer wrote:
How can I reach database relation diagram of sql by using smo?

Not possible.

omegazafer wrote:
I want to learn parent key table of any column if that column is foreign key.

Very possible Smile | :)

You do not need SMO for this. Look at calling one or both of the following stored procedures:

sp_foreignkeys
sp_primarykeys

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

omegazafer2-Sep-08 11:07

2-Sep-08 11:07

Thanks,
But I don't need only foreign key or primary key columns. The table that the column ,which is foreign key , is related. For example, I search the categoryId column for this in Product table. The result wanted is Category table.(I mention on NorthWind Database)

Best Regards

leppie2-Sep-08 19:52

2-Sep-08 19:52

Did you read the docs on those 2 store procedures? Sigh | :sigh:

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

omegazafer2-Sep-08 20:09

2-Sep-08 20:09

Sp_foreign keys gives only foreign key column . I don't need only these as I said before. If it is possible , can you reply my sample question ?

Have a good day
Kemal Akkanat

leppie2-Sep-08 20:20

2-Sep-08 20:20

Look at the source of this article[^]. I wrote it many many years back, and AFAIK I used those procs. You can get all the info you need.

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

Ashfield2-Sep-08 2:10

Ashfield

2-Sep-08 2:10

omegazafer wrote:
How can I reach database relation diagram of sql by using smo

You can't, and you don't need to. Have a look at my article aboutr smo, it should put you on the right track to get the details you want - although there are also non-smo methods.

http://www.codeproject.com/KB/cs/smo.aspx[^]

Bob
Ashfield Consultants Ltd

omegazafer2-Sep-08 11:14

2-Sep-08 11:14

Thanks for you reply,
I looked at your article but I didn't understand. Can you explain a little more?

Have a good day

Ashfield2-Sep-08 20:05

Ashfield

2-Sep-08 20:05

Well, its only meant to be an introduction, giving you an idea of what smo can do. Try Googling EnumForeignKeys, it will give you waht you are looking for I think

Bob
Ashfield Consultants Ltd

omegazafer2-Sep-08 21:23

how to find the number of tables in an XML file???

2-Sep-08 21:23

Thanks.

preetpal2-Sep-08 0:43

preetpal

2-Sep-08 0:43

string sQuery = "/html/body/table/tbody/tr";
XmlNodeList tables = xmlDoc.SelectNodes(sQuery);

i am using the above code to find the number of lines in an XML file. but i always get the count as zero.
Can anyone plz correct me what i am doing wrong or any new sQuery??

Thanks in advance....
Smile | :)

Re: how to find the number of tables in an XML file???

Manas Bhardwaj2-Sep-08 1:02

Manas Bhardwaj

2-Sep-08 1:02

string sQuery = "//html/body/table/tbody/tr";

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: how to find the number of tables in an XML file???

preetpal2-Sep-08 2:11

preetpal

2-Sep-08 2:11

it did this but still my table count is zero. Can u plz suggest me something else.

Re: how to find the number of tables in an XML file???

preetpal2-Sep-08 2:14

preetpal

2-Sep-08 2:14

hey thx...
act it needs to be written in CAPS...my fault...

Re: how to find the number of tables in an XML file???

leppie2-Sep-08 2:29