continue if loop if failed - C# Discussion Boards

Re: How to Change Image for the last level(Child) in Treeview in C#?

20-Sep-14 19:56

Sorry, Ahmed, I don't yet understand your question.

The Microsoft supplied TreeView Control has two ImageList Properties: ImageList, and StateImageList. ImageList is used to specify the image shown when the TreeNode is selected, or not selected. StateImageList is used to control the image shown for the Node when shown with a CheckBox, and the CheckBox checked or unchecked.

Each TreeNode in the TreeView can have its current image changed at any time by setting either the Index or Key of the ImageList assigned to the TreeView.

treeView1.Nodes[3].ImageIndex = 2; // set the Image for the Node when it's not selected
treeView1.Nodes[3].SelectedImageIndex = 3;; // set the Image for the Node when it's selected

See the Microsoft documentation for ImageList: [^]

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

aahamdan22-Sep-14 7:56

aahamdan

22-Sep-14 7:56

Thank you sir,

Your suggestions about TreeNode.Level and treeView1.Nodes[3].ImageIndex = 2 , will help me.

Re: How to Change Image for the last level(Child) in Treeview in C#?

BillWoodruff22-Sep-14 22:29

Re: How to Change Image for the last level(Child) in Treeview in C#?

22-Sep-14 22:29

You can, of course, post other questions here, or in the QA forums.

Keep in mind that for any TreeNode you have several possible 'dynamic visual state' factors that may determine your choice of images to be used in displaying the node:

1. has child nodes, or has no child nodes

2. if has child nodes: is expanded, or collapsed

3. is selected, or is not selected: unfortunately unless you owner-draw the TreeView you have no control over the selection highlight color, and every scheme I have seen to work-around this (using the TreeView as is: i.e., not owner-drawn) has been not useful (impaired performance, etc.).

4. the current level: this could be a dynamic factor if you are implementing drag-drop in the TreeView

To assist you in determining the node's current state at run-time there are four boolean properties which are read-only:

IsEditing
IsExpanded
IsSelected
IsVisible

cheers, Bill

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

Eddy Vluggen22-Sep-14 8:27

Re: How to Change Image for the last level(Child) in Treeview in C#?

22-Sep-14 8:27

..'tis was downvoted, but I cannot think of any valid reason why. So, I upvoted it.

If anyone thinks this is NOT a good way to answer, please do explain it to me, using ~~small~~ short* sentences and simple words.

*edit

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

BillWoodruff22-Sep-14 8:34

continue if loop if failed

22-Sep-14 8:34

Thanks, Eddy, I appreciate your concern for "technical justice" !

cheers, Bill

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

Jassim Rahma19-Sep-14 11:27

Jassim Rahma

19-Sep-14 11:27

Hi,

I am using the following to loop through date range and import into a database from text files. I want to know how can I tell the code IF FILE DOES NOT EXITS THEN CONTINUE TO NEXT FILE?

for (DateTime date = last_date; date.Date <= DateTime.Today; date = date.AddDays(1))
{
  string file_name = "H" + date.ToString("yyyy-MM-dd") + ".TXT";

  MySqlBulkLoader bl = new MySqlBulkLoader(sql_connection);
  bl.TableName = "processing_table";
  bl.FieldTerminator = ",";
  bl.LineTerminator = "\n";
  bl.FileName = @"C:\Temp\Attendence\" + file_name;
  bl.NumberOfLinesToSkip = 0;

  int count = bl.Load();

  string sql = "SELECT source, created_date, created_time, company, action, employee_number, employee_name, outlet, field_1, field_2, field_3, field_4 FROM processing_table";
  MySqlCommand cmd = new MySqlCommand(sql, sql_connection);
  MySqlDataReader rdr = cmd.ExecuteReader();

  while (rdr.Read())
  {
      SplashScreenManager.Default.SetWaitFormDescription(rdr[1] + " - " + rdr[2]);
  }
                
  rdr.Close();
}

Technology News @ www.JassimRahma.com

V.19-Sep-14 11:36

19-Sep-14 11:36

I´m not sure where it´s failing, but try creating a FileInfo object (System.IO.FileInfo) that object has an exists method that will return true/false if a file exists.

V.

(MQOTD rules and previous solutions)

Eddy Vluggen19-Sep-14 11:56

http://msdn.microsoft.com/en-us/library/system.io.file.exists(v=vs.110).aspx[^]

19-Sep-14 11:56

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Message Closed

19-Sep-14 23:36

Raushank03

19-Sep-14 23:36

Message Closed

Eddy Vluggen20-Sep-14 0:18

20-Sep-14 0:18

Aight, I'd accept it if you posted it once, but it the URL is NOT a valid question to "all" answers.

You have been promoted to spammer.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

c# unable to coonect with xls file using LinqToExcel Please help

Dominic Burford22-Sep-14 0:03

Dominic Burford

22-Sep-14 0:03

string file_name = "H" + date.ToString("yyyy-MM-dd") + ".TXT";

If (!File.Exists(file_name))
{
  continue;
}
else
{
 MySqlBulkLoader bl = new MySqlBulkLoader(sql_connection);
 //rest of your code to go here
}

Something similar to this should be what you're looking for.

Member 1105342019-Sep-14 5:11

Member 11053420

19-Sep-14 5:11

string filepath = @"C:\\"+"Search.xls";
string sheetName = "general_report";
var excelFile = new LinqToExcel.ExcelQueryFactory(filepath);
excelFile.DatabaseEngine = DatabaseEngine.Ace;

Re: c# unable to coonect with xls file using LinqToExcel Please help

PIEBALDconsult19-Sep-14 5:20

PIEBALDconsult

19-Sep-14 5:20

Please don't double-post, you can edit the first post if you need to.

Re: c# unable to coonect with xls file using LinqToExcel Please help

ZurdoDev19-Sep-14 10:55

ZurdoDev

19-Sep-14 10:55

What's your question?

There are only 10 types of people in the world, those who understand binary and those who don't.

c# LinqToExcel is not connecting to XLS in 64bit system but it is connecting xlsx file, tried DatabaseEngine.ace but didn't worked out.

Member 1105342019-Sep-14 5:08

Member 11053420

19-Sep-14 5:08

Code is string filepath = @"C:\\"+"k.xls";

string sheetName = "general_report";
var excelFile = new LinqToExcel.ExcelQueryFactory(filepath);
excelFile.DatabaseEngine = DatabaseEngine.Ace;

Re: c# LinqToExcel is not connecting to XLS in 64bit system but it is connecting xlsx file, tried DatabaseEngine.ace but didn't worked out.

PIEBALDconsult19-Sep-14 5:22

PIEBALDconsult

19-Sep-14 5:22

Member 11053420 wrote:
@"C:\\"

Use either @ (verbatim string) or escape the backslash, not both. And why concatenate?

string filepath = @"C:\k.xls";

ought to do it.

Re: c# LinqToExcel is not connecting to XLS in 64bit system but it is connecting xlsx file, tried DatabaseEngine.ace but didn't worked out.

Eddy Vluggen19-Sep-14 7:16

19-Sep-14 7:16

Only works if the entire process is 64-bit.

"Didn't work out", what does that mean? Did it throw an exception, did it explode?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Resize Control

AmbiguousName18-Sep-14 21:09

AmbiguousName

18-Sep-14 21:09

Hello. I have started a process using Process.Start. Now when I resize my panel, I also resize this control. But the problem is, it stops resizing after I drag its border just a little bit. It does, though, resize for that little bit drag of form border. So question is why can not I resize my external program along with panel, just like I resize my panel along with form? Thanks for any pointer.

UPDATE

I have a process that I have started using Process.Start() and placed it on the panel, on my form. Now in order to resize it, I put this code

C++

private void Form1_SizeChanged(object sender, EventArgs e)
{
   // "panel1" is docked to TOP
   SetWindowPos(m_hHandle, 0, 0, 0, panel1.Width, panel1.Height, SWP_SHOWWINDOW);
}

I put a breakpoint on this function and noticed that as soon as I resize my form, this breakpoint gets hit. How do I resize this control on my form using Resize or SizeChanged events?

This world is going to explode due to international politics, SOON.

modified 19-Sep-14 3:52am.

OriginalGriff18-Sep-14 21:41

OriginalGriff

18-Sep-14 21:41

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Edit your question and provide better information.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

AmbiguousName18-Sep-14 21:48

AmbiguousName

18-Sep-14 21:48

I have a process that I have started using Process.Start() and placed it on the panel, on my form. Now in order to resize it, I put this code

C++

private void Form1_SizeChanged(object sender, EventArgs e)
{
   // "panel1" is docked to TOP
   SetWindowPos(m_hHandle, 0, 0, 0, panel1.Width, panel1.Height, SWP_SHOWWINDOW);
}

I put a breakpoint on this function and noticed that as soon as I resize my form, this breakpoint gets hit. How do I resize this control on my form using Resize or SizeChanged events?

This world is going to explode due to international politics, SOON.

BillWoodruff18-Sep-14 21:41

18-Sep-14 21:41

I note you use the word 'Control to describe what you are working with, but using Process.Start runs an Application that then puts up a window(s).

1. what is the Application you start using Process.Start ?

2. what are you doing to make that Application's Window(s) a child Control of the Panel (added to the Panel's ControlCollection) ? or, is it (more likely), that the application window is not a child of the Panel ?

3. is it possible that whatever application you start's window has a fixed window size maximum ?

4. if you make the Panel size smaller: what happens to the hosted whatever ?

More specific details, please.

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

modified 19-Sep-14 4:56am.

AmbiguousName18-Sep-14 21:52

AmbiguousName

18-Sep-14 21:52

1 - I am hosting media player classic. I start this application using Process.Start.
2 - Don't know what to say.
3 - NO
4 - nothing

This world is going to explode due to international politics, SOON.