How to update a field in a word 2007 document? - C# Discussion Boards

shafiullah1231-Apr-09 8:55

1-Apr-09 8:55

When i am doing it like that it gives error cannot convert System.Int32 to System.String

Actually both are Primary key IDs in individual master tables....but the value coming here is string...If i am not using AND clause this is working fine with individual listbox filtering it is auto converting those strings...Its only then when i want to filter by values from both columns its creating prob...I am not facing any prob with combo box in the same situation.......Its the only list box thats irritating

Re: BindingSource Filter

jaypatel5121-Apr-09 20:33

jaypatel512

1-Apr-09 20:33

(("Column1="+cbCol1.SelectedValue.ToString()+") AND (Column2= "+cbCol2.SelectedValue.ToString()));

This might work...
And one more thing.

it might be && inspite of AND

But not so sure. .

opacity problem

Try1-Apr-09 5:40

Try

1-Apr-09 5:40

Hi All,

I am using C#. I have a empty Form. When i move mouse on the Form, i am displaying the x and y position of mouse using DrawString() method.

Graphics grx = e.Graphics;
string xy = "X: " + cursorPos.X.ToString() + "\nY: " + cursorPos.Y.ToString();
grx.DrawString(xy, font, brush, cursorPos.X, cursorPos.Y);

The above code snippet is in Paint event. Hence the x and y values move along with cursor.

My problem,
When i change the opacity of Form from 100% to 10%, the Form becomes transparent. Even x and y values (displayed using DrawString) becomes transparent (faint).
I want the x and y values to be displayed clearly even if Form is transparent. How can i achieve it?

Thanks in advance.

Re: opacity problem

musefan1-Apr-09 5:49

musefan

1-Apr-09 5:49

Hmmm not sure if will work but try the following...

Set the backcolor of your form to a color not used for you text, the set the tranparencykey to match.
then put a panel on your form with backcolor as Transparent.
then do your paint code to the panels Paint Event.

hopefully it will work

EDIT:

just tested and works fine, just need to set the FormBorderStyle to None

Life goes very fast. Tomorrow, today is already yesterday.

Re: opacity problem

Try1-Apr-09 8:18

Try

1-Apr-09 8:18

Thank you very much for your help, but i am not getting the result.
Will you please elaborate? Have you set panel dock to fill?

Re: opacity problem

musefan1-Apr-09 21:39

musefan

1-Apr-09 21:39

ok this is all i did... the form contains only one panel, simply drag and dropped to design, set

Panel1.BackColor = Color.Transparent;

and double clicked Paint event handler, thats all i did to the panel

public Form1()
{
InitializeComponent();
//i set these in design mode but have put here to show you the code
this.BackColor = Color.Red;
this.TransparencyKey = Color.Red;
this.FormBorderStyle = FormBorderStyle.None;

}

void Panel1Paint(object sender, PaintEventArgs e)
{
   e.Graphics.DrawString("SOME TEXT", Label.DefaultFont, Brushes.Blue, 0, 0);
}

when the form loads all i can see is "SOME TEXT" in blue on my screen

Life goes very fast. Tomorrow, today is already yesterday.

Re: opacity problem

Try2-Apr-09 0:39

Try

2-Apr-09 0:39

Thank you.
Thanks a lot for your time and support. I am grateful to you.

How to update a field in a word 2007 document?

Krissh1-Apr-09 4:53

Krissh

1-Apr-09 4:53

A customer have an CRM with custom revision handling.

When I open, change and save a document (2007) I must force the custom revision on the document.

In the header I have 2 fields {AUTHOR \* MERGEFOMAT} and {INFO RevNum} that I need to update programatically using using Word = Microsoft.Office.Interop.Word

After a days serch I am bewildered. Does anyone know of a way to do this?

Java
C#
Gupta Team Developer 3.1
VC++ 2003
Oracle 8i79i
W2K-XP

Re: How to update a field in a word 2007 document?

musefan1-Apr-09 5:27

musefan

1-Apr-09 5:27

WordDocument has a property called 'Fields' which is a list of Word.Field Type which has a function called Select()

I not sure but i would assume that would select the field for you to add text to

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to update a field in a word 2007 document?

Krissh2-Apr-09 1:09

Krissh

2-Apr-09 1:09

Code like below below works. But I need to replace the text in a QuickPart in the header.
----
using System.Reflection;
using Word = Microsoft.Office.Interop.Word;
using System.Text;

namespace Word
{
public partial class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Label label1;

public Form1() //constructor
{
InitializeComponent();
}

private void button1_Click(object sender, System.EventArgs e)
{
Word.Application app = new Word.Application();

if (textBox1.Text.Length > 0)
{
app.Visible = true; // krister

object template = Missing.Value;
object newTemplate = Missing.Value;
object documentType = Missing.Value;
object visible = true;
object nullvalue = Missing.Value;
object truevalue = true;
object falsevalue = false;
object filepath = "C:\\testdokument.docx";

Word._Document doc1 = app.Documents.Open(ref filepath,
ref nullvalue, ref nullvalue, ref nullvalue, ref nullvalue, ref nullvalue,
ref nullvalue, ref nullvalue, ref nullvalue, ref nullvalue, ref nullvalue,
ref nullvalue, ref nullvalue, ref nullvalue, ref nullvalue, ref nullvalue);

doc1.Words.First.InsertBefore(textBox1.Text);
}

object saveChanges = false;
object originalFormat = Missing.Value;
object routeDocument = Missing.Value;

app.Quit(ref saveChanges, ref originalFormat, ref routeDocument);
}
}
}

Java
C#
Gupta Team Developer 3.1
VC++ 2003
Oracle 8i79i
W2K-XP

Re: How to update a field in a word 2007 document?

Krissh2-Apr-09 2:47

Krissh

2-Apr-09 2:47

A little known trick to help with MS Office automation by kubben gave me a good start Smile | :)

Java
C#
Gupta Team Developer 3.1
VC++ 2003
Oracle 8i79i
W2K-XP

How to use different Views in Smart client software factory shell form dynamically?

Vapctr1-Apr-09 4:19

Vapctr

1-Apr-09 4:19

Hello,

I am using the Smart client software factory(SCSF) to developing of an application.

I have created many views with UI.

By default When shell form loads..then..first view is loading into the shell form.

now i want to load second view form on shell application.

Can anybody help me how to solve this.

Thanks in advance,

Error while using Sub reports in Report Viewer

tauras811-Apr-09 3:03

tauras81

1-Apr-09 3:03

Hi all,

I am using Sql server reporting services for creating reports. While using Sub reports I am getting error :-

Error sub report can't be loaded.What is the reason.Can anybody tell the solution of it
Thanks

Building tree in c#

Reza S1-Apr-09 2:56

Reza S

1-Apr-09 2:56

can you tell me how can i build a tree in c#?
please show me source example

Re: Building tree in c#

MumbleB1-Apr-09 2:59

MumbleB

1-Apr-09 2:59

1. Dig a hole
2. Put Tree in
3. Put compost
4. Close with Sand
5. Throw water.

In a few years time you have a tree.

Excellence is doing ordinary things extraordinarily well.

Re: Building tree in c#

benjymous1-Apr-09 3:09

benjymous

1-Apr-09 3:09

Earth.Soil.Dig( 30cm );
Earth.Soil.Plant( new Tree() );
Earth.Soil.Fill( new Compost(), 30cm );
Earth.Soil.Cover( new Sand() );
Earth.Soil.Water( WateringCan.Get() );

Help me! I'm turning into a grapefruit!
Buzzwords!

Re: Building tree in c#

Abhishek Sur1-Apr-09 4:29

Abhishek Sur

1-Apr-09 4:29

You all are going great.... Laugh | :laugh:

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: Building tree in c#

Xmen Real 1-Apr-09 6:29

Xmen Real

1-Apr-09 6:29

Warning: Do not try this at home

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)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Re: Building tree in c#

Abhishek Sur1-Apr-09 4:31

Abhishek Sur

1-Apr-09 4:31

Add a Treeview control, and use

tv.nodes.add

Thats all you need. Nesting can be done using node objects

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: Building tree in c#

Le centriste1-Apr-09 5:30

Le centriste

1-Apr-09 5:30

People are not even trying anymore.

Re: Building tree in c#

0x3c01-Apr-09 6:59

0x3c0

1-Apr-09 6:59

Lego. Bricks and mortar. Origami. There are so many ways!

Change icon of exe file programatically

M.Daud1-Apr-09 2:48

M.Daud

1-Apr-09 2:48

How can I change the icon of an exe file programatically?

Re: Change icon of exe file programatically

Curtis Schlak.1-Apr-09 6:06

Curtis Schlak.

1-Apr-09 6:06

You need to read the portable executable format of the EXE/DLL, replace the image that you want in the binary, and then save it.

You'll need the PECOFF reference from Microsoft to understand the format of the file. You can find that reference here[^].

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

[Message Deleted]

hkjghkj11-Apr-09 2:10

hkjghkj1

1-Apr-09 2:10

[Message Deleted]

Re: Check Internet connection

SeMartens1-Apr-09 2:22

SeMartens

1-Apr-09 2:22

I guess you have to write InternetGetConnectedState(out int Description, ....

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

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