Re: question in word automation - C# Discussion Boards

Re: How to insert xmlDocument variable data or xml in column of table in sql server 2000

led mike4-Dec-08 6:14

led mike

4-Dec-08 6:14

Mika Wendelius wrote:
How stupid can I be

Having dense moments is a natural part of the activity of developing software. At least it better be because I have them every day! Laugh | :laugh:

led mike

Re: How to insert xmlDocument variable data or xml in column of table in sql server 2000

Pr@teek B@h!4-Dec-08 5:33

Pr@teek B@h!

4-Dec-08 5:33

How many characters is the xml file? My guess is that number of characters in the xml file exceeds 8000 characters.

Prateek

Re: How to insert xmlDocument variable data or xml in column of table in sql server 2000

trilokharry4-Dec-08 19:37

trilokharry

4-Dec-08 19:37

Not exceeding no. of specified characters but still not taking full data in column

thanks

You get the best out of others when you give the best of yourself.

How to convert string to xml

trilokharry4-Dec-08 4:51

trilokharry

4-Dec-08 4:51

Hi
How to convert string to xml.

I have saved xml data in string variable and now I want to assign these data in xmlDocument variable.

thanks

You get the best out of others when you give the best of yourself.

Re: How to convert string to xml

led mike4-Dec-08 4:55

led mike

4-Dec-08 4:55

trilokharry wrote:
I want to assign these data in xmlDocument variable.

They hide that information in the documentation[^]

led mike

Re: How to convert string to xml

J4amieC4-Dec-08 4:55

J4amieC

4-Dec-08 4:55

You create an XmlDocument and call LoadXml[^]

question in word automation

hatan864-Dec-08 4:22

hatan86

4-Dec-08 4:22

Q: i have file (***.docx) and i want separate it based on title.

how can i do it by using word automation.

thanks...

Re: question in word automation

dan!sh 4-Dec-08 4:25

dan!sh

4-Dec-08 4:25

What do you mean by "separate it"? Some example would help understand better.

Loading signature. Please wait...

Re: question in word automation

hatan864-Dec-08 5:02

hatan86

4-Dec-08 5:02

In my document i have more than one title I'need to extract each title in tO new document by word automation

example:
...........................................
title 1

title 2

title 3
........................................... in one document

in need to extract each title in to new document
..........
title 1
..........doc1

..........
title 2
..........doc2

..........
title 3
..........doc3

thanks

Re: question in word automation

dan!sh 4-Dec-08 5:13

dan!sh

4-Dec-08 5:13

Isnt it the same thing you have asked few posts down?

Loading signature. Please wait...

Set Default Value of DataTable field When Retrieving from Database

polishprogrammer4-Dec-08 4:00

polishprogrammer

4-Dec-08 4:00

I have an application that needs to retrieve data from a database using a left join query. The left join, of course, may return null values from the "right" database table (call it table2) if a matching record is not found in table2.

This can cause a problem because I have fields on my form bound to the values in the DataTable filled by the SQL query. I handled this problem by running through each line in the resultant DataTable and replacing any null values with an appropriate default, but this operation is relatively time consuming.

Is there a better method to set the default values on the DataTable.

Thanks.

Re: Set Default Value of DataTable field When Retrieving from Database

Ben Fair4-Dec-08 4:35

Ben Fair

4-Dec-08 4:35

Yes, in the query use the ISNULL() or COALESCE() SQL Server functions and provide the default values that you want there, then you don't have to do anything with the resultset in code.

Keep It Simple Stupid! (KISS)

Re: Set Default Value of DataTable field When Retrieving from Database

polishprogrammer4-Dec-08 5:42

polishprogrammer

4-Dec-08 5:42

Thanks. The application I'm working with uses Access, so I think I need to use IIF with ISNULL() to make it work with this software, but that's exactly the idea I was looking for. I wanted something that could work quickly, without iterating through the rows of the table or doing anything else in the code. Thanks.

Drawing a line with Custom Pen

pym4-Dec-08 2:55

pym

4-Dec-08 2:55

Hello,

I have encountered a problem trying to draw a line with a custom pen.
What I need to do is draw a line from point X to point Y, but use a certain shape (some polygon), as opposed to the standard pen I get in DrawLine(Pen, Point, Point) interface.
There is the PenLineCap, but it is not good enough as it supports specific shapes.

Anyone has any idea how to achieve this?
Thanks!

Re: Drawing a line with Custom Pen

#realJSOP4-Dec-08 3:44

#realJSOP

4-Dec-08 3:44

I don't understand what you mean by a "custom pen". You create a Pen object with a color (or a brush) and a width, and then use it to draw something (a line or a shape). I don't do new Pen() in a method call because you have to dispose the pen when you're done with it.

Pen pen = new Pen(Color.Black, 1);
Point point1 = new Point(0,0);
Point point2 = new Point(10,10);
Graphics graphics = Graphics.FromHdc(this.Handle);
graphics.DrawLine(pen, point1, point2);
graphics.DrawImage(bimap, blah blah blah);
// you can change the color and/or width and do some more drawing

// but then you have to dispose the pen when you're done with it.
pen.Dispose();
// clean up the graphics object too
graphics.Dispose();

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Re: Drawing a line with Custom Pen

pym6-Dec-08 21:17

pym

6-Dec-08 21:17

Thanks for your reply, but that is not what I meant.
What I need is to draw a line with a "star" shape for instance.
I mean, use a custom shape (any polygon/ellipse) in order to draw a line with it.

Take a look at the picture to see what I mean.
http://img242.imageshack.us/my.php?image=sampleiw3.png[^]
Thanks everyone!

Re: Drawing a line with Custom Pen

#realJSOP6-Dec-08 23:15

#realJSOP

6-Dec-08 23:15

Here's a codeproject article about drawing the US flag, which includes the code to draw a 5-pointed star:

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

I found this with the following google search:

c# gdi+ draw a star

It's not so much a custom pen as it is a custom polygon shape.

[Message Deleted]

tonyjsebastian14-Dec-08 2:08

tonyjsebastian1

4-Dec-08 2:08

[Message Deleted]

Re: how to create a make file for c#

Nissim Salomon4-Dec-08 2:16

Nissim Salomon

4-Dec-08 2:16

Hi
try the following:
http://www.pluralsight.com/community/blogs/dbox/archive/2005/07/18/13377.aspx[^]

Re: how to create a make file for c#

J4amieC4-Dec-08 2:26

J4amieC

4-Dec-08 2:26

For god sake man, have you not listened to ANYTHING you've been told today?

Re: how to create a make file for c#

leppie4-Dec-08 2:29

leppie

4-Dec-08 2:29

Stop asking and read you previous responses. D'Oh! | :doh:

Can you read?

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 beta 1 - out now!
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

Re: [Message Deleted]

EliottA4-Dec-08 2:39

EliottA

4-Dec-08 2:39

What the hell man, people aren't going to code for you, you've been answered 12 times! Get started already or quit.

Re: [Message Deleted]

#realJSOP4-Dec-08 3:05

#realJSOP

4-Dec-08 3:05

Help[^]

Re: [Message Deleted]

Simon P Stevens4-Dec-08 3:22

Simon P Stevens

4-Dec-08 3:22

Oh dear. I can't stop laughing....

Simon

Re: [Message Deleted]

#realJSOP4-Dec-08 3:36

#realJSOP

4-Dec-08 3:36

That's the most useful web page I've ever created. It's kinda like that commercial that ends with the line "...but I did stay at a Holiday Inn Express last night." - you eagerly await an opportunity to use it. Smile | :)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.