C# Discussion Boards - CodeProject

Get Value of Arbitrary ListBox Item

12-Sep-07 21:59

Why do you need a list for 3 tier architecture? This is by no means a requirement of good n-tier design.

Deja View - the feeling that you've seen this post before.

[C#] PageBreak in Excel

kurisutofuJP12-Sep-07 19:22

kurisutofuJP

12-Sep-07 19:22

Hello everyone,

With a C# made software, I create an Excel file with many sheets. Everything
goes well until I tried to remove PageBreaks.

I can add them but I can't delete them so I still have the automatic one
appearing there ...

I tried a lot of things such as:

Range AutoVPageBreaks=ExcelWorksheet1.VPagesBreaks[1].Location;<br />
AutoVPageBreaks.PageBreaks=XlPageBreaks.XlPageBreakNone;

VPageBreak VPB1= ExcelWorksheet1.VPagesBreaks[1];<br />
VPB1.Delete();

--> This one raised an error

I also tried to add before ResetPageBreaks() or DisplayPageBreaks=false but
nothing worked ... I still have the automatic pagebreaks ...

Does someone know howw to remove those pagebreaks? Do I need to set the
sheet to printpreview? If so, how? (I tried but that raised an error)

I hope you can help me.

Thank you.

Sukhjinder_K12-Sep-07 18:55

12-Sep-07 18:55

My ListBox Contents are in the form
index. itemName

1. Jack
2. Jane
3. Joe
4. Bill
5. Tim
6. Sid

On removing say Jane I need to get the index of others in proper numerical order. Now ListBox Control only allows me access to the currently selectedItem via its selectedItem property but I need access to all the Items so that I can change them...

Any Advice...
Thanks
Please excuse if this is a very basic question. I'm pretty new to C#.
After Removal the above should become
1. Jack
2. Joe
3. Bill
4. tim
5. Sid

Pete O'Hanlon12-Sep-07 22:12

12-Sep-07 22:12

If you iterate through the Items collection, you get the zero based index of the item.

Deja View - the feeling that you've seen this post before.

Sukhjinder_K12-Sep-07 22:29

12-Sep-07 22:29

Yes I can do that as
IEnumerator enm = this.list.Items.GetEnumerator();

int i = 0;

//Get to The Desired Location
for(i = 0; i < index; i ++ )
{
enm.MoveNext();
}

//Here I can Get Individual Items
for(i = index; i < list.Items.Count; i ++)
{
String entry = enm.Current.ToString();
String newData = doSomething(entry);
// Now Here I Need to Set the Changed Data to ith Position in the List
// cannot Do enm.Current = newData as Current is a readonly Property of IEnumerator
}

Any More Advice...

Pete O'Hanlon12-Sep-07 22:39

SET Value of Arbitrary ListBox Item

12-Sep-07 22:39

I'm sorry, but I'm not sure what you are trying to achieve here. This has gone beyond the scope of your original query. Perhaps you could elaborate a bit.

Deja View - the feeling that you've seen this post before.

Sukhjinder_K12-Sep-07 23:33

12-Sep-07 23:33

Sorry about confusing anybody. Here is what I want

My Playlist is displayed in ListBox named list
with contents
1. SongABc
2. Song Dev
3. Vid34
4. Clip5
5. ABC and so on

I need to delete an item from that
for that I'm doing

this.list.Items.RemoveAt(index);

Now I need to update the IndexNumber of each entry in the Playlist so that after deleting "Vid34"

My list shows

1. SongABc
2. Song Dev
3. Clip5
4. ABC and so on

I can READ ALL items of list as
IEnumerator enm = this.list.Items.GetEnumerator();

int i = 0;
for(i = 0; i < index; i ++ )
enm.MoveNext();

//Now I'm at the place where I Delete the Entry
//all the Following Items need to update their Numerical Index Decremented by one
for(i = index; i < list.Items.Count; i ++)
{
String entry = enm.Current.ToString();
String newVal = getNewVal(entry); // Strip Index Value so that "4. Clip5 becomes just Clip5"

//Here I need to set the Current Entry with new Val something like

this.list.itemAt(i) = newVal; // But no such method exists
neither can I do
enm.Current = newVal; // Because it is a readonly property
}

I can clear my playlist and readd everything but that would be waste of resources

Pete O'Hanlon12-Sep-07 23:55

12-Sep-07 23:55

Aah. I see what you're getting at. Well, the simple way to do it would be to use list.Items[i] = newVal; in the loop. You can simplify the logic quite a lot:

for (int i = 0; i < list.Items.Count; i++)
{
  string entry = enm.Current.ToString();
  list.Items[i] = getNewVal(entry);
}

Deja View - the feeling that you've seen this post before.

Sukhjinder_K13-Sep-07 0:13

13-Sep-07 0:13

Thanks Man. You Saved Me...

After reading your last post I'm looking like an idiot. Wink | ;-)

well I'm new to C#

Thanks...

Pete O'Hanlon13-Sep-07 0:33

13-Sep-07 0:33

Sukhjinder_K wrote:
After reading your last post I'm looking like an idiot.

Nope, not at all. Don't put yourself down - at least you had a go before posting. There are too many who would just have asked without trying anything themself.

Deja View - the feeling that you've seen this post before.

Sukhjinder_K13-Sep-07 1:59

13-Sep-07 1:59

Yup this is how we All Evolve by Being a Community...

All the Best..

pmarfleet12-Sep-07 22:15

pmarfleet

12-Sep-07 22:15

Use the Items collection of your ListBox to modify the contents of the list.

Paul

Plz help me to go to a particular node in xml file

Luc Pattyn13-Sep-07 1:19

Luc Pattyn

13-Sep-07 1:19

Hi,

there is a different and better way to achieve a numbered list: ListBox (and ComboBox) support
"OwnerDraw" mode, which means you paint the items yourself in any way you like, instead
of their string value being shown as is. So what you could do is add a DrawItem handler
that does a Graphics.DrawString(itemIndex.ToString()+". "+item.ToString());

Doing this will automatically show the text with its number, whatever happens to the list.
You would have to get the itemIndex from DrawItemEventArgs.Index, and item from
myListBox.Items[itemIndex].

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google

P_Elza12-Sep-07 17:15

P_Elza

12-Sep-07 17:15

am trying to develop one aplication to read a particular node in an xml file. but somewhere i goes wrong and not working.......
plz help me to find out the error.....
In the following xml file i want to find out the last name.

This is the xml
<?xml version="1.0" encoding="UTF-8" ?>
<family>
<name gender="male">
<firstname>Tom</firstname>
<lastname>Smith</lastname>
</name>
</family>

and the code is --------

FileStream fs = new FileStream("D:\\Myfolder\\gender.xml", FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
xmldoc.Load(fs);
XmlNodeList xmlnode = xmldoc.GetElementsByTagName("name");
for (int a = 0; a < xmlnode.Count; a++)
{
if (xmlnode[a].Attributes[0].Value == "gender")
// match your attributes
{ //codes
lblcnt.Text=a.ToString();
String firstNameValue = reader.ReadElementString("gender");
Lblmsg.Text=" FirstName: "+firstNameValue;
}
I tried this one also=======
XmlTextReader reader = new XmlTextReader ("D:\\Myfolder\\gender.xml");
XmlDocument xmldoc = new XmlDocument();
XmlTextReader reader = new XmlTextReader ("C:\\gender.xml");
try
{
while (!reader.EOF)
{
reader.Read();
if(reader.IsStartElement() )
{
reader.Read();
xmldoc.SelectSingleNode("family/name/firstname");
XmlNode xmlnode1=xmldoc.GetElementsByTagName("firstname");
String firstNameValue = reader.ReadElementString("firstname");
xmldoc.SelectSingleNode("lastname");
String lastNameValue = reader.ReadElementString("lastname");
Lblmsg.Text=" FirstName: "+firstNameValue + " LastName: " + lastNameValue;
}
}
reader.Close();
}
catch (Exception err )
{
Lblmsg.Text="Error: " + err.ToString();
}

Confused | :confused:

-- modified at 23:25 Wednesday 12th September, 2007

Re: Plz help me to go to a particular node in xml file

Christian Graus12-Sep-07 18:39

Re: Plz help me to go to a particular node in xml file

12-Sep-07 18:39

This is a disaster

princymg wrote:
xmldoc.SelectSingleNode("family/name/firstname");

This would work if

a - you loaded your xml into xmldoc, and
b - you grabbed the return value from the call

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Jintal Patel12-Sep-07 19:15

Jintal Patel

12-Sep-07 19:15

I think this will help U

DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("gender.xml"));
DataTable dt = ds.Tables["family"];
DataRow dr;
for (int i = 0; dt.Rows.Count > i; i++)
{

dr = dt.Rows[i];

String firstNameValue = dr["firstname"].ToString();
String lastNameValue =dr["lastname"].ToString();
Lblmsg.Text=" FirstName: "+firstNameValue + " LastName: " + lastNameValue;

}

Jintal Patel

Re: Plz help me to go to a particular node in xml file

Nouman Bhatti12-Sep-07 19:27

Nouman Bhatti

12-Sep-07 19:27

i think XQuery will help u out
XQuery is to XML what SQL is to database tables.

http://www.w3schools.com/xquery/xquery_intro.asp

Re: Plz help me to go to a particular node in xml file

P_Elza12-Sep-07 21:52

P_Elza

12-Sep-07 21:52

I got the code......
string str;
XmlTextReader reader = new XmlTextReader ("D:\\Foldername\\tx1.xml");
try
{
while (reader.Read())
{
if(reader.IsStartElement() )
{
if (reader.NodeType == XmlNodeType.Element && reader.Name == "jid")
{
str=reader.ReadString();
//Lblmsg.Text="Article Title is : "+ reader.Name+ " : "+reader.ReadString();
Lblmsg.Text="Article Title is : "+ reader.Name+ " : "+str;
lblcnt.Text=str;
}
}
}
reader.Close();
}
catch (Exception err )
{
Lblmsg.Text="Error: " + err.ToString();
}

Thanks for the help....................
Blush | :O

Saving username and password

C#Coudou12-Sep-07 15:33

C#Coudou

12-Sep-07 15:33

Dudez,

Is there a way to save the username and password when user login.
Example:
I will access computer name \\ROBO then username and password form pop up.Think on computer neighborhood. When that user input his/her username and password. It will save on temporary file. Is it possible? How to do that? Much better if you can give a link or an existing application that can be downloaded (3rd party).

Thanks in advance,
jeof

******************************
I just want to
know everything

Re: Saving username and password

Christian Graus12-Sep-07 15:50

Reading data from a dataset with a checkedlistbox

12-Sep-07 15:50

You can store any info you like, whereever you like. Storing passwords is obviously sensitive, however.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

falles0112-Sep-07 15:28

falles01

12-Sep-07 15:28

Hi I'm posting a new question in case Malcolm doesn't read my reply in time.

Basically what is wrong with this code? I want to automatically check the checklistbox items depending on if the items match the employees TechnicalSkillsID in the database table. Malcolm gave me a web form example which was a great response except I forgot to tell him I was using a winform.
can you help at all?

int i;<br />
<br />
                    for (i = 0; i <= (techSkillsCheckListBox2.Items.Count - 1); i++)<br />
                    {<br />
                       // SqlDataReader MyDataReader = adoCmd.ExecuteReader(CommandBehavior.CloseConnection);<br />
                        while (adoDR.Read())<br />
                        {<br />
                            sql = "Select em.TechnicalSkillsID,t.ProgLanguagesDatabase from EmpSkills em,TechnicalSkills t where EmployeeID = '" + FirstnameText.Text + "' and em.TechnicalSkillsID = t.TechnicalSkillsID";<br />
                            //populate a datatable with the result set<br />
<br />
                            DataRow[] rows = dataSet1.TechnicalSkills.Select();<br />
                            foreach (DataRow row in rows)<br />
                            {<br />
                                string techID = row["TechnicalSkillsID"].ToString();<br />
                                techSkillsCheckListBox2.SetItemChecked(i, true);<br />
                            }<br />
                        }<br />
                    }

Sianny aka Sharny

Re: Reading data from a dataset with a checkedlistbox

Christian Graus12-Sep-07 18:52

Re: Reading data from a dataset with a checkedlistbox

12-Sep-07 18:52

falles01 wrote:
for (i = 0; i <= (techSkillsCheckListBox2.Items.Count - 1); i++)

Why not

i < techSkillsCheckListBox2.Items.Count ?

Or even

foreach (CheckBox box in techSkillsCheckListBox2.Items) ?

This code is really broken. What you want to do, is fill a list with the items that are selected, then go through each check box and do something like

checkbox.Checked = (myListOfItems.Contains(theKEyForThisCheckbox));

Of course, I just invented some variables, assume the Tag of the checkbox contains the key value, so you can look it up. The code you're presenting does a nested loop, and just sets each box to be checked, over and over again.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

falles0112-Sep-07 19:00

falles01

12-Sep-07 19:00

Thanks but the part you are talking about that is wrong, is actually the part that is correct and gives the correct value. I got that off msdn. Yes I want to fill a list with items but as i said, I can't use listitems as I'm using a winform so I would like to know how I do that exactly. How do you check the items against the ID's against an empID in the database?

Sianny aka Sharny

Re: Reading data from a dataset with a checkedlistbox

Christian Graus13-Sep-07 3:10