Re: problem accessing data in a btn event - C# Discussion Boards

PIA's with Word 2000 and C#

Michele@MERC1-Apr-05 7:58

1-Apr-05 7:58

Help ~

I am currently working on a project that will create Word documents. Everything was going great until I tried to run the application on a machine w/ Office 2003. This is where I found out about PIA's.

I have taken the MSWORD9.OLB file and generated an assembly for it and move the new Microsoft.MSWORD9.dll file to the machine w/ Word 2003 everything works great - accept that my machine (which has Word 2000) is now throwing the following error **

System.InvalidCastException QueryInterface for interface Microsoft.MSWORD9._Application failed

I have add the assembly to the GAC and registered it - the lines of code where the error is thrown are as follows:

_WordApp = new Microsoft.MSWORD9.ApplicationClass();<br />
_WordDoc = _WordApp.Documents.Add(ref Missing, ref Missing, ref Missing, ref IsVisible);

Any help will be greatly appreicated

Confused | :confused:

Michele

Mercer Engineering Research Center
mstusak@merc.mercer.edu

Re: PIA's with Word 2000 and C#

Mircea Grelus19-Apr-05 1:56

Mircea Grelus

19-Apr-05 1:56

As you probably are aware of, there is a big difference between Office 2000 PIAs and Office 2003 PIAs. If Office 2000 PIAs can be redistributed with the application setup, well Office 2003 PIAs can not.Except ifyou want to corrupt the Office installed on the deployment machine. Office 2003 PIAs should be installed using the Office's setup add/remove function. You can find more information on: http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/dno2k3ta/html/officeprimaryinteropassembliesfaq.asp[^].

The bottom line is if you want your application to support both Office 2000 and Office 2003 you should create two separate applications, one for each version of office and distribute them according to the installed Office on the deployment machine

Mircea

Many people spend their life going to sleep when they’re not sleepy and waking up when they still are.

Parsing coma seperated values

jctk1-Apr-05 6:44

jctk

1-Apr-05 6:44

I am trying to parse a string into seperate values and am drawing a blank.

I want to fill an array with each value so that I can loop through each item later to fill out a form.

Here is what I have, followed by the error message.

<br />
string apps = "Computers,Servers,Laptops,Routers";<br />
string []arr = apps.Split(",");<br />

error msg: Argument '1': cannot convert from 'string' to 'char[]'

Any thoughts or suggestions would be appriciated. I know it should be easy, I just can't think of the right syntax.

Re: Parsing coma seperated values

Judah Gabriel Himango1-Apr-05 7:12

Judah Gabriel Himango

1-Apr-05 7:12

apps.Split(','); // notice the single quote characters, which imply System.Char, whereas double quote characters imply System.String

or

apps.Split(new char[] {','});

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: He has a funny face. And he's my son.
Judah Himango

Re: Parsing coma seperated values

jctk1-Apr-05 7:27

jctk

1-Apr-05 7:27

Works now,

Thanks

Re: Parsing coma seperated values

Carl Mercier1-Apr-05 7:31

Carl Mercier

1-Apr-05 7:31

And if you're looking for something a little more powerful:

http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=3132&lngWId=10[^]

It lets you split strings like this:

"Hello World!",John Mitchell,"Smith, John", "My name is \"John\""

problem accessing data in a btn event

brian551-Apr-05 6:33

brian55

1-Apr-05 6:33

I can't get access to the reader in
private void btnLogin_Click(object sender, System.EventArgs e)

here is the whole program. I know it is somethinge very basic. Please point it out to me.

Thanks Brian

private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			// Put user code to initialize the page here<br />
<br />
		}<br />
<br />
		#region Web Form Designer generated code<br />
		override protected void OnInit(EventArgs e)<br />
		{<br />
			//<br />
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.<br />
			//<br />
			InitializeComponent();<br />
			base.OnInit(e);<br />
		}<br />
		<br />
		/// <summary><br />
		/// Required method for Designer support - do not modify<br />
		/// the contents of this method with the code editor.<br />
		/// </summary><br />
		private void InitializeComponent()<br />
		{    <br />
			this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();<br />
			this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();<br />
			this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();<br />
<br />
			this.dbLoginInfo1 = new dbLoginInfo();<br />
			((System.ComponentModel.ISupportInitialize)(this.dbLoginInfo1)).BeginInit();<br />
			this.btnLogin.Click += new System.EventHandler(this.btnLogin_Click);<br />
			this.lblMessageTextBox1.TextChanged += new System.EventHandler(this.lblMessageTextBox1_TextChanged);<br />
			// <br />
			// oleDbDataAdapter1<br />
			// <br />
			this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;<br />
			this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] <br />
			{<br />
				new System.Data.Common.DataTableMapping("Table", "tblEmployee", new System.Data.Common.DataColumnMapping[] <br />
			{<br />
														new System.Data.Common.DataColumnMapping("EmployeeID", "EmployeeID"),<br />
														new System.Data.Common.DataColumnMapping("FName", "FName"),<br />
														new System.Data.Common.DataColumnMapping("LName", "LName"),<br />
														new System.Data.Common.DataColumnMapping("Password", "Password"),<br />
														new System.Data.Common.DataColumnMapping("Username", "Username")<br />
			})});<br />
			// <br />
			// oleDbSelectCommand1<br />
			// <br />
			this.oleDbSelectCommand1.CommandText = "SELECT EmployeeID, FName, LName, [Password], Username FROM tblEmployee";<br />
			this.oleDbSelectCommand1.Connection = this.oleDbConnection1;<br />
			// <br />
			// oleDbConnection1<br />
			// <br />
			this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=0;Data Source=""D:\MGDevelopment\SIMDAC Viewer\DB\simdac_be.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";<br />
			// <br />
			// dbLoginInfo1<br />
			// <br />
			this.dbLoginInfo1.DataSetName = "dbLoginInfo";<br />
			this.dbLoginInfo1.Locale = new System.Globalization.CultureInfo("en-US");<br />
			this.Load += new System.EventHandler(this.Page_Load);<br />
			((System.ComponentModel.ISupportInitialize)(this.dbLoginInfo1)).EndInit();<br />
			// <br />
			//get the data reader<br />
			//<br />
			try <br />
			{<br />
				this.oleDbConnection1.Open();<br />
				// TODO: Use the connection<br />
			}<br />
			catch (OleDbException ex) <br />
			{<br />
				// TODO: Handle the exception<br />
			}<br />
			// <br />
			//get the data reader<br />
			//<br />
			OleDbDataReader OleDbReader = this.oleDbSelectCommand1.ExecuteReader(CommandBehavior.CloseConnection);<br />
			while(OleDbReader.Read())<br />
            {<br />
				string sUserName = OleDbReader["UserName"].ToString();<br />
				string sPassword = OleDbReader["Password"].ToString();<br />
				//int secondCol = rdr.GetSqlInt32(1);<br />
				//Get other columns using the Get methods<br />
				//and take action.<br />
			    <br />
			}<br />
<br />
		}

Re: problem accessing data in a btn event

Colin Angus Mackay1-Apr-05 7:42

Colin Angus Mackay

1-Apr-05 7:42

The code you have posted does not appear to have a private void btnLogin_Click method. Perhaps you could post this method on its own.

My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Re: problem accessing data in a btn event

brian551-Apr-05 7:55

brian55

1-Apr-05 7:55

Sorry for onitting this.

private void btnLogin_Click(object sender, System.EventArgs e)<br />
		{<br />
			if (Page.IsValid) <br />
			<br />
			{<br />
				while(OleDbReader.Read())<br />
				{<br />
					if(txtUserName.Text==OleDbReader["UserName"].ToString()&&<br />
						(txtPassword.Text==OleDbReader["Password"].ToString()))<br />
					{<br />
						Response.Redirect("SelArptFrmSet.htm");<br />
					}<br />
					else<br />
					{<br />
						lblMessageTextBox1.Text = "Invalid Login!";<br />
						lblMessageTextBox1.Visible=true;<br />
					}<br />
				}<br />
			}<br />
		}

Re: problem accessing data in a btn event

brian551-Apr-05 8:45

brian55

1-Apr-05 8:45

Thank you very much!

I removed the code from the Initial component area and placed it in the btn.

Works fine.

Brian Smile | :)

Re: problem accessing data in a btn event

Colin Angus Mackay1-Apr-05 8:04

Colin Angus Mackay

1-Apr-05 8:04

Your InitializeComponent() method contains some code to read information from the database. This does not look like code that Visual Studio added to this method. Please note that Visual Studio put at the top of the method some very useful comments:

/// 
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

You should not have code reading anything from the database in this method.

When your button click event is fired the contents of the data reader are exhausted becuase of the code in the InitializeComponent() method so there is no more data to get, therefor the method does not function as expected.

It is good practice to open a Data Reader, get the data and close it all in one sequence. In this case that sequence should be in the button click event.

Does this help?

My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

ThreeState Checkbox in TreeView?

Ian Bowler1-Apr-05 6:30

Ian Bowler

1-Apr-05 6:30

Hello,

Does anyone know how to get ThreeState checkbox behavior in a TreeView? This seems like it would be a fairly common need. If all subnodes are checked, I want a regulary checked state. If only some of the child nodes are checked, I want a "partial" checked state.

Any ideas?

Thanks!

-Ian

Re: ThreeState Checkbox in TreeView?

Judah Gabriel Himango1-Apr-05 7:14

Judah Gabriel Himango

1-Apr-05 7:14

Search CP for TreeView controls, there is such a control with 3 state checks available here.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: He has a funny face. And he's my son.
Judah Himango

Re: ThreeState Checkbox in TreeView?

Ian Bowler1-Apr-05 7:15

Ian Bowler

1-Apr-05 7:15

Thanks for you help! I appreciate it!

-Ian

Command Line

SJR_11-Apr-05 6:10

SJR_1

1-Apr-05 6:10

I'm trying to send commands from my C# project to the command line. The cmd is opening but the arguments are not being passed. Here is my code:

System.Diagnostics.ProcessStartInfo psi = null;
System.Diagnostics.Process proc = null;

psi = new System.Diagnostics.ProcessStartInfo("cmd");

proc = new System.Diagnostics.Process();
proc.StartInfo = psi;
System.Diagnostics.Process.Start(psi);
psi.Arguments = @"ping dev12";
Application.DoEvents();
System.Diagnostics.Process.Start(psi);
proc.WaitForExit();

Thanks.

Re: Command Line

Dave Kreskowiak1-Apr-05 7:09

Dave Kreskowiak

1-Apr-05 7:09

The argument ARE being passed. You're just not supplying the correct arguments to CMD. The command line your passing in is this:

cmd ping dev12

Try typing that in a Start/Run box and watch what happens.
What you should be passing in is:

cmd /c ping dev12

The "/C" tells CMD to execute the following string and a command, then terminate when that command is done.

"/K" will tell CMD to remain open after the command it execute returns.

All you have to do to find this out is type "CMD /?" at a command prompt.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

simple question about accessing value

montu33771-Apr-05 5:56

montu3377

1-Apr-05 5:56

HI,

In my project,i am having requirement that i want to use total 6-7 different variables in one class from another form.Now how to access all that variables
in my class.
i don't want to write 6-7 properties,i know that way but anybody know any simple and efficient way to do this?

Re: simple question about accessing value

yoaz1-Apr-05 10:16

yoaz

1-Apr-05 10:16

write a public method that returns an array with the parmaters?

there are no facts, only interpretations

Re: simple question about accessing value

Ashok Dhamija1-Apr-05 19:14

Ashok Dhamija

1-Apr-05 19:14

If both the classes (or form) are in the same assembly, you can use the "internal" access-modifier for those variables to access them directly. This way, you won't have to declare them public.

Re: simple question about accessing value

Luis Alonso Ramos1-Apr-05 22:04

Luis Alonso Ramos

1-Apr-05 22:04

Both other answers are correct, but here's another:

class Person
{
    public string Name;
    public int    Age;

    // Constructor and other members
}

// and somewhere else:

Person p = new Person();

p.Name = "Luis";
p.Age = 23;

Good luck!

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

ListView

Gary Kirkham1-Apr-05 5:20

Gary Kirkham

1-Apr-05 5:20

Does anyone know how to get a reference to the Label Edit TextBox control while it is being displayed?

Gary Kirkham

Forever Forgiven and Alive in the Spirit

He is no fool who gives what he cannot keep to gain what he cannot lose. - Jim Elliot

Me blog, You read

Re: ListView

Dave Kreskowiak1-Apr-05 5:22

Dave Kreskowiak

1-Apr-05 5:22

Gary Kirkham wrote:
get a reference to the Label Edit TextBox control while it is being displayed

What? Are you talking about dropping a Label control on the form at design time?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: ListView

Gary Kirkham1-Apr-05 5:27

Gary Kirkham

1-Apr-05 5:27

I am talking about the text box that is displayed when you click on an item in the list (LabelEdit = true). I want a reference to that textbox when it is displayed.

Gary Kirkham

Forever Forgiven and Alive in the Spirit

He is no fool who gives what he cannot keep to gain what he cannot lose. - Jim Elliot

Me blog, You read

Re: ListView

Dave Kreskowiak1-Apr-05 8:10

Dave Kreskowiak

1-Apr-05 8:10

Hmmm...There's no way to get it directly. The ListView creates that edit box on-the-fly and it only exists for as long as your typing in it. About the only way to do this would be to use the GetWindow API functions to enumerate the windows of the application and look for a specific window class. I can see a couple of possibl problems though. First, the window class used by the edit box can be used by TextBox's also. I think you'll also have to find a way to get the parent window handle from the windows that you find and compare it to the handle of the ListView. I don't know if they'll actually match though, or if you can even get that parameter from the edit box window.

Hmmm...A very interesting research project...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

write only one bit to file

Kiki991-Apr-05 4:23

Kiki99

1-Apr-05 4:23

I don't know how to write to binary file only one bit and not one byte.

Please help me!

FileStream fs new FileStream("1.dat", FileMode.CreateNew);
BinaryWriter w = new BinaryWriter(fs);

w.Write(true); //write one byte
w.Write(55); //write 4 bytes

fs.Close();

Thanks

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