Re: Collection properties should be readonly. - C# Discussion Boards

Re: Convert SQL data to XML data using nHibernate

Henry Minute24-Aug-09 3:25

Henry Minute

24-Aug-09 3:25

NHibernate has its own forums, you could try asking here[^].

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Excel + C#

GrgBalden24-Aug-09 2:16

GrgBalden

24-Aug-09 2:16

Hi all,

I've been given source code for a program that created a form post from values within an excel document, however I keep getting the following errors:

Property, indexer, or event 'Value' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Excel.Range.get_Value(object)' or 'Microsoft.Office.Interop.Excel.Range.set_Value(object, object)'

I've had a root through the MSDN site, and cant seem to work out whats wrong:

private void btnBatchExecute_Click(object sender, System.EventArgs e)
		{
            
            Excel.Application xlApp;
			Excel.Workbook xlWorkbook;
			Excel.Worksheet xlWorkSheet;
			Excel.Range xlRange;

			string method;
			string postString;
			string[] values;
			string returnString;

			XmlDocument xDoc = new XmlDocument();
			
			try
			{
				//Start Excel and get Application object.
				xlApp = new Excel.ApplicationClass();
				xlApp.Visible = true;

                string thisFileName = txtFileName.Text;

                xlWorkbook = xlApp.Workbooks.Open(thisFileName,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing);

                xlWorkSheet = (Excel.Worksheet)xlWorkbook.ActiveSheet;

				
				//int i = 5;
				for(int i = 5;;i++)
				{
					xlRange = xlWorkSheet.get_Range(xlWorkSheet.Cells[i,2],xlWorkSheet.Cells[i,52]);

					values = ConvertToStringArray((System.Array)xlRange.Cells.Value);

					if(values[0]=="") break;

					postString = "ESERIES_FORM_ID=AUTHENTICATE_3&CTRL_TYPEINDICATOR=C&CTRL_SEARCHCONSENT=Y&CTRL_CHANNEL=I&CTRL_CALLTYPE=I";
					// Main App Name
					postString+="&NAME_TITLE="+values[0];
					postString+="&NAME_FORENAME="+values[1];
					postString+="&NAME_INITIALS="+values[2];
					postString+="&NAME_SURNAME="+values[3];
					postString+="&NAME_SUFFIX="+values[4];
					postString+="&NAME_DATEOFBIRTH_DD="+("0"+values[5]).Substring(("0"+values[5]).Length-2);
					postString+="&NAME_DATEOFBIRTH_MM="+("0"+values[6]).Substring(("0"+values[6]).Length-2);
					postString+="&NAME_DATEOFBIRTH_CCYY="+values[7];
//					postString+="&NAME_DATEOFBIRTH="+values[7]+("0"+values[6]).Substring(("0"+values[6]).Length-2)+("0"+values[5]).Substring(("0"+values[5]).Length-2);

					// Alias - need to check if title supplied first
					if(values[8]!="")
					{
						postString+="&NAME_TITLE="+values[8];
						postString+="&NAME_FORENAME="+values[9];
						postString+="&NAME_INITIALS="+values[10];
						postString+="&NAME_SURNAME="+values[11];
						postString+="&NAME_SUFFIX="+values[12];
						postString+="&NAME_DATEOFBIRTH_DD="+("0"+values[5]).Substring(("0"+values[5]).Length-2);
						postString+="&NAME_DATEOFBIRTH_MM="+("0"+values[6]).Substring(("0"+values[6]).Length-2);
						postString+="&NAME_DATEOFBIRTH_CCYY="+values[7];
					}
			
					// Current Address
					postString+="&ADDR_FLAT="+values[15];
					postString+="&ADDR_HOUSENAME="+values[14];
					postString+="&ADDR_HOUSENUMBER="+values[13];
					postString+="&ADDR_STREET="+values[16];
					postString+="&ADDR_DISTRICT="+values[17];
					postString+="&ADDR_TOWN="+values[18];
					postString+="&ADDR_COUNTY="+values[19];
					postString+="&ADDR_POSTCODE="+values[20];
					postString+="&RESY_DATEFROM_CCYY="+values[28];
					postString+="&RESY_DATEFROM_MM="+("0"+values[27]).Substring(("0"+values[27]).Length-2);
					postString+="&RESY_DATEFROM_DD="+("0"+values[26]).Substring(("0"+values[26]).Length-2);
					postString+="&RESY_DATETO_CCYY="+values[31];
					postString+="&RESY_DATETO_MM="+("0"+values[30]).Substring(("0"+values[30]).Length-2);
					postString+="&RESY_DATETO_DD="+("0"+values[29]).Substring(("0"+values[29]).Length-2);
//					postString+="&RESY_DATEFROM="+values[28]+("0"+values[27]).Substring(("0"+values[27]).Length-2)+("0"+values[26]).Substring(("0"+values[26]).Length-2);
//					postString+="&RESY_DATETO="+values[31]+("0"+values[30]).Substring(("0"+values[30]).Length-2)+("0"+values[29]).Substring(("0"+values[29]).Length-2);
					postString+="&RESY_DATEFROM_CCYY="+values[28];
					postString+="&RESY_DATEFROM_MM="+("0"+values[27]).Substring(("0"+values[27]).Length-2);
					postString+="&RESY_DATEFROM_DD="+("0"+values[26]).Substring(("0"+values[26]).Length-2);
					postString+="&RESY_DATETO_CCYY="+values[31];
					postString+="&RESY_DATETO_MM="+("0"+values[30]).Substring(("0"+values[30]).Length-2);
					postString+="&RESY_DATETO_DD="+("0"+values[29]).Substring(("0"+values[29]).Length-2);

					// Previous address
					if(values[39]!="")
					{
						postString+="&ADDR_FLAT="+values[34];
						postString+="&ADDR_HOUSENAME="+values[33];
						postString+="&ADDR_HOUSENUMBER="+values[32];
						postString+="&ADDR_STREET="+values[35];
						postString+="&ADDR_DISTRICT="+values[36];
						postString+="&ADDR_TOWN="+values[37];
						postString+="&ADDR_COUNTY="+values[38];
						postString+="&ADDR_POSTCODE="+values[39];
						postString+="&RESY_DATEFROM_CCYY="+values[47];
						postString+="&RESY_DATEFROM_MM="+("0"+values[46]).Substring(("0"+values[46]).Length-2);
						postString+="&RESY_DATEFROM_DD="+("0"+values[45]).Substring(("0"+values[45]).Length-2);
						postString+="&RESY_DATETO_CCYY="+values[50];
						postString+="&RESY_DATETO_MM="+("0"+values[49]).Substring(("0"+values[49]).Length-2);
						postString+="&RESY_DATETO_DD="+("0"+values[48]).Substring(("0"+values[48]).Length-2);
						postString+="&RESY_DATEFROM_CCYY="+values[47];
						postString+="&RESY_DATEFROM_MM="+("0"+values[46]).Substring(("0"+values[46]).Length-2);
						postString+="&RESY_DATEFROM_DD="+("0"+values[45]).Substring(("0"+values[45]).Length-2);
						postString+="&RESY_DATETO_CCYY="+values[50];
						postString+="&RESY_DATETO_MM="+("0"+values[49]).Substring(("0"+values[49]).Length-2);
						postString+="&RESY_DATETO_DD="+("0"+values[48]).Substring(("0"+values[48]).Length-2);
					}

					txtReturn.Lines = values;

					if (rdoPost.Checked == true)
						method = "POST";
					else
						method = "GET";
            

					returnString = webRequest(txtAddress.Text, method, "HTML", postString);
					txtReturn.Text = returnString;
					txtReturn.Refresh();

					returnString = Regex.Replace(returnString,@"&[^(amp;)]","&amp;");

					//returnString = returnString.Replace(" & "," &amp; ");

					xDoc.LoadXml(returnString);

					if(xDoc.SelectNodes("//ERR1").Count>0)
					{
						// Error, can't do much here
						xlRange = xlWorkSheet.get_Range(xlWorkSheet.Cells[i,68],xlWorkSheet.Cells[i,68]);
						xlRange.Value="Error! - " + xDoc.SelectSingleNode("//ERR1").InnerText;
					}
					else
					{
						int cellPos;
						if("CHAM"==xDoc.SelectSingleNode("//AU3E/TEST_GROUP").InnerText)
						{
							cellPos=54;
						}
						else
						{
							cellPos=61;
						}

						xlRange = xlWorkSheet.get_Range(xlWorkSheet.Cells[i,cellPos],xlWorkSheet.Cells[i,cellPos++]);
						xlRange.Value=xDoc.SelectSingleNode("//AU3E/AUTH_INDEX").InnerText;
						xlRange = xlWorkSheet.get_Range(xlWorkSheet.Cells[i,cellPos],xlWorkSheet.Cells[i,cellPos++]);
						xlRange.Value=xDoc.SelectSingleNode("//AU3E/PST_OUTCOME").InnerText;
						if("0"==xDoc.SelectSingleNode("//AU3E/POLICY_RULE_COUNT").InnerText)
						{
							xlRange = xlWorkSheet.get_Range(xlWorkSheet.Cells[i,cellPos],xlWorkSheet.Cells[i,cellPos++]);
							xlRange.Value="No Rules Hit!";
						}
						else
						{
							int counter=1;
							foreach(XmlNode node in xDoc.SelectNodes("//AU3E/POLICYRULES/POLICY_RULE"))
							{
								xlRange = xlWorkSheet.get_Range(xlWorkSheet.Cells[i,cellPos],xlWorkSheet.Cells[i,cellPos++]);
								xlRange.Value=node.InnerText;
								if(counter++>5)break;
								
							}
						}
					}
				}
				xlApp.Quit();
			}
			catch( Exception ex ) 
			{
				String errorMessage;
				errorMessage = "Error: ";
				errorMessage = String.Concat( errorMessage, ex.Message );
				errorMessage = String.Concat( errorMessage, " Line: " );
				errorMessage = String.Concat( errorMessage, ex.Source );

				MessageBox.Show( errorMessage, "Error" );
			}

		}

Any Ideas?

WorkbookEvents_SheetChangeEventHandler excel delegate

NarVish24-Aug-09 2:16

NarVish

24-Aug-09 2:16

Hello,

I have a C# program that uses the Excel interop (Microsoft.Office.Interop.Excel) to monitor an Excel 2007 spreadsheet.

I use the delegate named WorkbookEvents_SheetChangeEventHandler which runs my custom code when any cell on the spreadsheet is updated. But the following code is not working..
I think I didn't use the delegate WorkbookEvents_SheetChangeEventHandler,correctly.Please let me know how to raise the event whenever the cell in excel file gets changed.
Thanks in advance.
using excel=Microsoft.Office.Interop.Excel;

public event excel.WorkbookEvents_SheetChangeEventHandler SheetChange;

private void WorkbookSheetChange()
{
this.SheetChange += new excel.WorkbookEvents_SheetChangeEventHandler(workSheet_SheetChange);
}

void workSheet_SheetChange(object Sh, excel.Range Target)
{
Target = range;
string changedRange = Target.get_Address(1, 1,
excel.XlReferenceStyle.xlA1, 1, 1);

MessageBox.Show("The value of " + workSheet.Name + ":" +
changedRange + " was changed.");
}

Collection properties should be readonly.

deep724-Aug-09 1:47

deep7

24-Aug-09 1:47

Hi,
According to FXCop, i must have arraylist property as read only (not setter).

i tried below method as was mentioned in msdn site(http://msdn.microsoft.com/en-us/library/ms182327(VS.80).aspx):

public ArrayList SomeStrings
{
get { return strings; }
// Violates the rule.
// set { strings = value; }
}

ArrayList newCollection = new ArrayList();
WritableCollection collection = new WritableCollection();
collection.SomeStrings = newCollection;
collection.SomeStrings.Clear();
collection.SomeStrings.AddRange(newCollection);

But at the point marked bold italic, i get error saying that the property is readonly.

I'm really stuck here, can anyone plz give m solution?
I need to set data to the arraylist, but its not FXCop compliant.

Re: Collection properties should be readonly.

Henry Minute24-Aug-09 2:07

Henry Minute

24-Aug-09 2:07

I do not see your problem.

The error line functionality is achieved in the two lines below it. Same effect, just slightly longer to code, and possibly slightly slower to run.

More to the point, do you have to use an ArrayList? You would be better off using List<string>. Smile | :)

Re: Collection properties should be readonly.

Luc Pattyn24-Aug-09 3:26

Luc Pattyn

24-Aug-09 3:26

Henry Minute wrote:
do you have to use an ArrayList?

Sure, however the referenced MSDN page[^], although part of VS8, gave an example with ArrayList (which probably dated back from .NET 1.x)

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Collection properties should be readonly.

harold aptroot24-Aug-09 2:08

harold aptroot

24-Aug-09 2:08

Why are you using an ArrayList anyway? Are you using .NET 1?

Some things you could do:
- Create the new collection in the ctor of the containing class
- Make a method that takes an ArrayList and assigns that to the field/property which can then have a private setter (or no setter, if it's a field). This is not actually a good way though, it just sidesteps the problem and may generate an other warning
- Make a method that takes items to add to the ArrayList which may then not have to be exposed to the outside anymore
- Stop caring about FXCop (hey it's possible), what it says are not rules, but just guidelines. If you have good reason to ignore its advice then do it - or at least do not blindly follow its advice, following a mere guideline can cause an actual error (as is the case now).
Following the guidelines can lead to a good design, but also to hacking around just to follow guidelines while actually making the design worse.

Re: Collection properties should be readonly.

Luc Pattyn24-Aug-09 3:27

Luc Pattyn

24-Aug-09 3:27

harold aptroot wrote:
Why are you using an ArrayList anyway?

Right, however the referenced MSDN page[^], although part of VS8, gave an example with ArrayList (which probably dated back from .NET 1.x)

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Collection properties should be readonly.

harold aptroot24-Aug-09 3:38

harold aptroot

24-Aug-09 3:38

Alright, so that site has an excuse, but he could/should have changed it IMO

Re: Collection properties should be readonly. [modified]

Luc Pattyn24-Aug-09 2:11

Luc Pattyn

24-Aug-09 2:11

Hi,

FYI: cops aren't always right, and you can change the rules if you don't like them.

The MSDN example looks OK.

You must choose between 2 possibilities:

1. SomeStrings has no setter, and collection.SomeStrings = newCollection; does not compile,
however you can use Clear() and AddRange() instead, as suggested by the MSDN page.

2. SomeStrings has a setter, collection.SomeStrings = newCollection; works, and unmodified FXCop complains, however FXCop with a new or modified rule could be made to agree

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

modified on Monday, August 24, 2009 9:23 AM

Re: Collection properties should be readonly.

Super Lloyd24-Aug-09 3:40

Super Lloyd

24-Aug-09 3:40

I suggest:

public List<string> SomeStrings { get; private set; }

A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.

.NET Remoting...how to?

DIPAK@EMSYS24-Aug-09 1:13

DIPAK@EMSYS

24-Aug-09 1:13

Hi all
I've a class which gets all the customers from an SQL database and puts them in a class object "Customers"
I've managed to get those customers inside a remoting server application as a singleton object.
But my main problem is to get the client application connected to this server and make it possible to change the database but still keep the singleton object intact. It should create a new object on the server preferably on the same port (tcp) but get the customers from the other database.
The reason for this is that users will have te possibility to use multiple databases while connected to 1 server.
Maybe threading is an option?

please help me out

dipak

problem in adding rows to datagrid

myinstincts24-Aug-09 1:07

myinstincts

24-Aug-09 1:07

I am developing an asp.net web application.I want to add rows to data gridview.But Datagridview.Rows.Add() functionality is not there..It was working fine in my vb.net windows application.Can somebody help me to sort this out?

Re: problem in adding rows to datagrid

DIPAK@EMSYS24-Aug-09 1:56

DIPAK@EMSYS

24-Aug-09 1:56

u can try adding row to DataTable with which u r binding ur grid.

like

DataRow row = Datatable.NewRow();
DataTable.Rows.Add(row);

dipak

Re: problem in adding rows to datagrid

DIPAK@EMSYS24-Aug-09 1:59

DIPAK@EMSYS

24-Aug-09 1:59

//Add Default row to data table.
                        blankRow = dataSet.Tables[Constants.CLASSES].NewRow();
                        blankRow["ClassName"] = Constants.SELECT;
                        blankRow["ClassID"] = 0;
                        dataSet.Tables[Constants.CLASSES].Rows.Add(blankRow);

dipak

MS-Charts

hhazan24-Aug-09 0:32

hhazan

24-Aug-09 0:32

Hello all

are it possible to run MS-Chart on Linux mono?
if yes, how to do it?

Thanks
H

Re: MS-Charts

Dave Kreskowiak24-Aug-09 3:46

Dave Kreskowiak

24-Aug-09 3:46

No, it's not.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

delete

nhqlbaislwfiikqraqnm24-Aug-09 0:08

nhqlbaislwfiikqraqnm

24-Aug-09 0:08

delete

modified 2-Apr-21 5:25am.

Re: Firefox Password Backup program!

harold aptroot24-Aug-09 0:29

harold aptroot

24-Aug-09 0:29

This is just speculation, but maybe it doesn't like the dot? Does it work without it? (shouldn't the * take care of the dot anyway?)

~~Anyway, on my computer there is only 1 directory in Firefox\Profiles\, and no files, would it be bad to just copy all of it?~~

edit: yea that made no sense, sorry! Better look at stancrm's post

Re: Firefox Password Backup program!

stancrm24-Aug-09 0:30

stancrm

24-Aug-09 0:30

string appData = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + @"\Mozilla\Firefox\Profiles\";
string[] dirs = Directory.GetDirectories(appData, "*.default");

Message Closed

24-Aug-09 0:56

nhqlbaislwfiikqraqnm

24-Aug-09 0:56

Message Closed

modified 2-Apr-21 5:25am.

Re: Firefox Password Backup program!

nhqlbaislwfiikqraqnm24-Aug-09 1:02

nhqlbaislwfiikqraqnm

24-Aug-09 1:02

Hey and when i want to see the Password which he saved in a textbox of the backup Prog, who does that work?
That i can see which Pw´s i have saved!

Re: Firefox Password Backup program!