Re: Opening multiple files - C# Discussion Boards

Re: Listboxes ... finding certain numbers

2-Mar-08 14:54

It is a list box that my wife will enter an amount that the parents paid for daycare.. She will enter the amount next to the date in the list box like this: $75 3/2/2008

Then what I want to do is I have a text box below it that will add the amount (money) together and give a total amount. So I have to extract the second and third character (number) and convert it to a integer.

This was when there are multiple ones I can add them together.

dipak.dipak2-Mar-08 19:25

dipak.dipak

2-Mar-08 19:25

Hello, This is an example :

int intTotal = 0;
for (int i = 0; i < DropDownList1.Items.Count; i++)
{
intTotal += Convert.ToInt16(DropDownList1.Items[i].Text.Substring(1, 2));
}

It is OK.
I have tested it.
Best of Luck.

Dipak

How to load Kernel32.dll and use GetSystemInfo(...)

gshen2-Mar-08 12:59

gshen

2-Mar-08 12:59

Dear Friends:
I am using c# Interop/(Platform Invoke) to call Win32 function GetSystemInfo(...). My computer is Windows XP profession Service Pack 2. The declaration is as follows:
[DllImport("Kernel32.lib")]
static extern void GetSystemInfo(ref SYSTEM_INFO systInfo);

The Kernel32.dll is located in C:\WINDOWS\ServicePackFiles\i386. The original location might be in C:\WINDOWS\system32. I set the environmental variable Path = C:\WINDOWS\ServicePackFiles\i386. When I run my program, the error message says "Unable to load DLL 'Kernel32.lib': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". I then copied the Kernel32.dll to C:\WINDOWS\system32. The same error message popped out. I then copied Kernel32.dll to my prgram's subdirectory. The same message came out. I can use other Win32 functions without problem, such as NetWkstaGetInfo(..l) in Netapi32.dll. Anybody can help? I appreciate your kind help.

Sheng

Re: How to load Kernel32.dll and use GetSystemInfo(...)

Anthony Mushrow2-Mar-08 14:14

Anthony Mushrow

2-Mar-08 14:14

Its because your asking for Kernel32.lib rather than Kernel32.dll
Simple as that. I think.

My current favourite word is: Nipple!

-SK Genius

Re: How to load Kernel32.dll and use GetSystemInfo(...)

Luc Pattyn2-Mar-08 15:22

Luc Pattyn

2-Mar-08 15:22

Yep, SKGenius is right, a lib is not a dll.
And you should not worry too much about where the dll is, Windows typically will
find the standard dll's for you without you giving a path.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.

Opening multiple files

Jacob Dixon2-Mar-08 10:16

2-Mar-08 10:16

Source: mscorlib
Inner Exception:
Target: Void FileNotOpen()
Message: Cannot access a closed file.

I keep getting this error and can not figure it out.. I am actually opening a certain file and writing to it, then opening another one then writing to it and so on. Should I not be doing this? Is this causing maybe them not opening in time before it tries to write to them?

FileStream ChildFile = new FileStream(thepath + @"Child\Child.daycare", FileMode.Create);
StreamWriter Childsw = new StreamWriter(ChildFile);
                    Childsw.WriteLine(fullnameTextbox.Text);
                    Childsw.WriteLine(birthTextbox.Text);
                    Childsw.WriteLine(startTextbox.Text);
                    ChildFile.Close();
                    Childsw.Close();
                   
FileStream GuardianFile = new FileStream(thepath + @"Guardian\ParentGuardian.daycare", FileMode.Create);
StreamWriter Guardiansw = new StreamWriter(GuardianFile);
                    Guardiansw.WriteLine(guardNameTextbox.Text);
                    Guardiansw.WriteLine(relationTextbox.Text);
                    Guardiansw.WriteLine(textBox1.Text);
                    Guardiansw.WriteLine(CityStateZipTextbox.Text);
                    Guardiansw.WriteLine(EmployTextbox.Text);
                    Guardiansw.WriteLine(Guard2Textbox.Text);
                    Guardiansw.WriteLine(Relation2Textbox.Text);
                    Guardiansw.WriteLine(Address2Textbox.Text);
                    Guardiansw.WriteLine(CityStateZip2Textbox.Text);
                    Guardiansw.WriteLine(Employ2Textbox.Text);
                    GuardianFile.Close();
                    Guardiansw.Close();

There are more.. but should I be doing this a different way?

Giorgi Dalakishvili2-Mar-08 10:22

Giorgi Dalakishvili

2-Mar-08 10:22

When you create one stream from another you should first close the newly created one and then the base one. So this snippet

FileStream ChildFile = new FileStream(thepath + @"Child\Child.daycare", FileMode.Create);
StreamWriter Childsw = new StreamWriter(ChildFile);
Childsw.WriteLine(fullnameTextbox.Text);
Childsw.WriteLine(birthTextbox.Text);
Childsw.WriteLine(startTextbox.Text);
ChildFile.Close();
Childsw.Close();

should be like this:

FileStream ChildFile = new FileStream(thepath + @"Child\Child.daycare", FileMode.Create);
StreamWriter Childsw = new StreamWriter(ChildFile);
Childsw.WriteLine(fullnameTextbox.Text);
Childsw.WriteLine(birthTextbox.Text);
Childsw.WriteLine(startTextbox.Text);
Childsw.Close();
ChildFile.Close();

Also, use using block with streams so that they will be closed and disposed automatically

#region signature
my articles
#endregion

Jacob Dixon2-Mar-08 10:24

2-Mar-08 10:24

Ok I will try that and see if it works.. I was wondering if I should have included something that waited till it was open to start writing but I do not know how to do that and my book doesn't say anything about that.. let me try that and I will be right back.. thanks for the fast response

Jacob Dixon2-Mar-08 10:28

2-Mar-08 10:28

Awesome that worked.. thanks so much.. why would that affect it though?

Giorgi Dalakishvili2-Mar-08 10:50

Giorgi Dalakishvili

2-Mar-08 10:50

Glad to help you Smile | :)

When you tried to close the second stream, the base stream was already closed so that was causing a problem.

#region signature
my articles
#endregion

pmarfleet2-Mar-08 10:39

how to save an office file to database?

2-Mar-08 10:39

I think you should close the StreamWriter before you close the FileStream.

You might find it easier to use the static methods in System.IO.File to create and write text to a file.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

mahmoud wafy2-Mar-08 10:06

mahmoud wafy

2-Mar-08 10:06

hi,
I am working on projct to save an office file in database sqlserver 2000 I dont know how to do this thanks.

Wafy

Re: how to save an office file to database?

Giorgi Dalakishvili2-Mar-08 10:18

Giorgi Dalakishvili

2-Mar-08 10:18

Here you go: How To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET[^]

#region signature
my articles
#endregion

copy part of table from one DB to table in another DB don't work

evgenik2-Mar-08 8:44

evgenik

2-Mar-08 8:44

Hello.

I want copy part of table from one Database to table in another Database.

In this code in line adp.Fill(dsArchive, "Archives"); i have error of incorrect types of fields. When i removed condition"WHERE..." i haven't errors ,but nothing working. Data don't transfer.(Vial_Date - field of table,type DATATIME, contents - data, for example 22/02/2007; SelectedData - data for condition in SQL) Where i mistaked?

My email: evgenik@sysmop.com.

Thanks.Evgeni Kosakovski.

public void BackupArchivesDB(string SelectedData)
{
int tblArchiveCount, tblBackupCount;
adp = new System.Data.OleDb.OleDbDataAdapter();
DataSet dsArchive = new DataSet();
DataSet dsBackup = new DataSet();

conArchive.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Archives.mdb;Jet OLEDBatabase Password=abc";
conBackup.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Backup.mdb;Jet OLEDBatabase Password=abc";

try
{
conArchive.Open();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
try
{
conBackup.Open();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}

comArchive.Connection = conArchive;
comArchive.CommandText = "SELECT * FROM Archives WHERE Vial_Date < '" + SelectedData + "'";
comBackup.Connection = conBackup;
comBackup.CommandText = "SELECT * FROM Backup";

try
{
adp.SelectCommand = comArchive;
adp.Fill(dsArchive, "Archives");

adp.SelectCommand = comBackup;
adp.Fill(dsBackup, "Backup");

dsBackup.Merge(dsArchive);

}
catch (Exception Ex)
{

MessageBox.Show(Ex.Message);
}
finally
{
conArchive.Close();
conBackup.Close();
}
}

Re: copy part of table from one DB to table in another DB don't work

Paul Conrad27-Mar-08 12:27

Paul Conrad

27-Mar-08 12:27

Fix this?

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

need to open a spreadsheet document in a listView

Walaza2-Mar-08 7:03

Walaza

2-Mar-08 7:03

Hi,
I need to open a spreadsheet document in a listView. The code that I have opens the document, but only prints the first column's data. I need it to print all the data. I also need to add a new column in the spreadsheet as it loads. Please help!

Regards,

Mvelo Walaza
Developer
Telkom SA

Full Path to DOS Path

Ian Uy2-Mar-08 5:10

Ian Uy

2-Mar-08 5:10

Good Day,

How can I convert a Full path like C:\Documents and Settings\ to C:\Docum~1\

Regards,
Ian

Re: Full Path to DOS Path

DaveyM692-Mar-08 5:23

DaveyM69

2-Mar-08 5:23

GetShortPathName is what you need, theres an example here[^].

Dave

Re: Full Path to DOS Path

pmarfleet2-Mar-08 5:24

How can I Allow focus for multiple controls?

2-Mar-08 5:24

I don't think there is any built-in support for this in the Framework. However it can be achieved through the Windows API. See this article[^].

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

eyalbi0072-Mar-08 4:30

eyalbi007

2-Mar-08 4:30

Hi all,

My main application form occupies two listview controls.

Whenever I select a line in one of the listviews, I lose the selection of the selected line in the 2nd listview.

The solution of setting the 'HideSelection' property to 'true' is not good enough since I want the selected lines in both listviews to be colored blue, not grey.

Any suggestions?

Thanks a lot,
Eyal.

Re: How can I Allow focus for multiple controls?

pmarfleet2-Mar-08 4:46

Re: How can I Allow focus for multiple controls?

2-Mar-08 4:46

Write your own code to change the colour of the whole row when it is selected.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

eyalbi0072-Mar-08 5:17

eyalbi007

2-Mar-08 5:17

OK, I guess you mean I should select custom color for the line when the control is not in focus (in case 'HideSelection' property iquals 'true').

How do I do that?

Thanks!

Re: How can I Allow focus for multiple controls?

pmarfleet2-Mar-08 6:02