|
Hi
How to insert xmlDocument variable data or xml in column of table in sql server 2000.
I have taken xmlInfo varchar(8000) column in table in sql server 2000 and
I am passing string variable that have complete data of xml.InnerXml but I am not getting full data in column in table
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
In SQL Server 2000 you have to use nvarchar data type to store the xml document. There are several stored procedures that help you to use the xml at database side if you need. Fr example have a look at: Retrieving and Writing XML Data[^]
|
|
|
|
|
Mika Wendelius wrote: Fr example have a look at:
Look at documentation! Never, never I say! Next you will want him to inject himself with the bubonic plague.
led mike
|
|
|
|
|
Now I didn't quite get it What's wrong with the doc?
|
|
|
|
|
Mika Wendelius wrote: Now I didn't quite get it
I was having some fun with harry and his apparent aversion to reading documentation, like so many other losers we see here on CodeProject.
Is that what you were confused about?
led mike
|
|
|
|
|
|
Mika Wendelius wrote: Let's not tell to anyone, okay?
Now this can well become a record. "A secret among 5,702,067 people worldwide."
Loading signature. Please wait...
|
|
|
|
|
d@nish wrote: Now this can well become a record. "A secret among 5,702,067 people worldwide."
Well, only 16,155 online... I don't think anyone will notice... Hey but you just did, damn, there goes the plan
|
|
|
|
|
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!
led mike
|
|
|
|
|
How many characters is the xml file? My guess is that number of characters in the xml file exceeds 8000 characters.
Prateek
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
trilokharry wrote: I want to assign these data in xmlDocument variable.
They hide that information in the documentation[^]
led mike
|
|
|
|
|
You create an XmlDocument and call LoadXml[^]
|
|
|
|
|
Q: i have file (***.docx) and i want separate it based on title.
how can i do it by using word automation.
thanks...
|
|
|
|
|
What do you mean by "separate it"? Some example would help understand better.
Loading signature. Please wait...
|
|
|
|
|
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
|
|
|
|
|
Isnt it the same thing you have asked few posts down?
Loading signature. Please wait...
|
|
|
|
|
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.
|
|
|
|
|
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)
|
|
|
|
|
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.
|
|
|
|
|
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!
|
|
|
|
|
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);
pen.Dispose();
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
|
|
|
|
|
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!
|
|
|
|
|
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.
"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
|
|
|
|