How to insert xmlDocument variable data or xml in column of table in sql server 2000 - C# Discussion Boards

Re: blocking all windows operations or locking system

Xmen Real 4-Dec-08 6:16

4-Dec-08 6:16

http://search.barnesandnoble.com/Windows-Group-Policy-Resource-Kit/Derek-Melber/e/9780735625143[^]

hmmm... costly, wont bother to buy just for one thing. Any other idea man.

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Re: blocking all windows operations or locking system

Dave Kreskowiak4-Dec-08 8:03

Dave Kreskowiak

4-Dec-08 8:03

Costly, huh? How much do you get paid an hour?? How long will it take you to write this app and support it??

Think of it this way. You have many holes to plug in this dam and not enough fingers and toes to plug them all.

And, on top of that, there are some holes that you cannot plug with code, but can only be plugged by policy.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: blocking all windows operations or locking system

Xmen Real 4-Dec-08 13:37

Xmen Real

4-Dec-08 13:37

HEHEHE....dude im not working under someone neither its my job. I just make programs for fun and for my use.

Re: blocking all windows operations or locking system

Xmen Real 4-Dec-08 14:49

Xmen Real

4-Dec-08 14:49

no worries, i have done what i wanted by using some API.

PictureBox Control Arrays

tim_gunning4-Dec-08 5:25

tim_gunning

4-Dec-08 5:25

Hi all

i've created a Form (Form1.cs) and Control Array handler (PictureBoxArray.cs) which all works fine but my problem is I want to be able to access the *clicked on* picturebox but it doesn't seem to be working, well I cant make it work is a bit more truthful. I'm sure its fairly simple but I can't work out a way of doing it and now I've been looking so long I'm kind of blinded by it!

I have this in my PictureBoxArray.cs

private void pictureBox_MouseDown(object sender, MouseEventArgs e)
{
    System.Windows.Forms.MessageBox.Show("You have clicked button " +
        ((System.Windows.Forms.PictureBox) sender).Tag.ToString());
}

but but from here I can't do things like change the background colour, if I put a button into the main form (Form1) and do a :

public void button2_Click(object sender, System.EventArgs e)
{
    pictureBoxArray[0].BackColor = Color.Red;
}

then it works fine but I want to be able to change the colour of the one I clicked on so I need to know which one it is (does that make sense ?)

I folowed the msdn guide on creating the control array here http://msdn.microsoft.com/en-us/library/aa289500(VS.71).aspx[^]

I sure it is probably fairly simple but like i said I've just lost it now !

thanks in advance for any help
tim

Re: PictureBox Control Arrays

User 66584-Dec-08 5:30

User 6658

4-Dec-08 5:30

So you want to change the color on the picture box you clicked on last, is this correct?
If yes, then you could for example store the last selected picture box in a variable:

PictureBox lastSelectedPictureBox = null;
	
private void pictureBox_MouseDown(object sender, MouseEventArgs e)
{
   lastSelectedPictureBox = sender as PictureBox;
}

and in your button click handler:

public void button2_Click(object sender, System.EventArgs e)
{
   lastSelectedPictureBox.BackColor = Color.Red;
}

You could also set the "selected" property of the last selected PictureBox into the Tag property, if it's not already used for other purposes. Btu then you'd need to loop over the entire array to get the last selected picture box, so I prefer the method above.

regards

modified 12-Sep-18 21:01pm.

Re: PictureBox Control Arrays

tim_gunning4-Dec-08 6:10

tim_gunning

4-Dec-08 6:10

hi greeg

thanks for that, that worked out just fine, what I actually wanted to do was control from within the PictureBoxArray.cs and not from the button_Click, but I just did a little method in there and it ow swaps the colours depending on which one you click on which is perfect for me.

thank you again

tim

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

trilokharry4-Dec-08 4:56

trilokharry

4-Dec-08 4:56

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.

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

Wendelius4-Dec-08 5:09

Wendelius

4-Dec-08 5:09

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[^]

The need to optimize rises from a bad design.My articles[^]

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

led mike4-Dec-08 5:21

led mike

4-Dec-08 5:21

Mika Wendelius wrote:
Fr example have a look at:

Look at documentation! OMG | :OMG:

Never, never I say! Next you will want him to inject himself with the bubonic plague.

led mike

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

Wendelius4-Dec-08 5:27

Wendelius

4-Dec-08 5:27

Now I didn't quite get it Confused | :confused:

What's wrong with the doc?

The need to optimize rises from a bad design.My articles[^]

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

led mike4-Dec-08 5:33

led mike

4-Dec-08 5:33

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

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

Wendelius4-Dec-08 5:41

Wendelius

4-Dec-08 5:41

Okay I see Smile | :)

led mike wrote:
Is that what you were confused about

Yep, because I have absolutely no sense of humour, none at all Poke tongue | ;-P

Seriously speaking, I actually did read the doc twice after your post trying to understand what went wrong.... How stupid can I be D'Oh! | :doh:

Let's not tell to anyone, okay? Smile | :)

The need to optimize rises from a bad design.My articles[^]

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

dan!sh 4-Dec-08 5:49

dan!sh

4-Dec-08 5:49

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...

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

Wendelius4-Dec-08 6:53

Wendelius

4-Dec-08 6:53

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 Smile | :)

The need to optimize rises from a bad design.My articles[^]

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...

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