copy part of table from one DB to table in another DB don't work - C# Discussion Boards

Giorgi Dalakishvili2-Mar-08 10:22

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

Re: Opening multiple files

Jacob Dixon2-Mar-08 10:24

Jacob Dixon

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

Re: Opening multiple files

Jacob Dixon2-Mar-08 10:28

Jacob Dixon

2-Mar-08 10:28

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

Re: Opening multiple files

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

Re: Opening multiple files

pmarfleet2-Mar-08 10:39

pmarfleet

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

how to save an office file to database?

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

pmarfleet

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

How can I Allow focus for multiple controls?

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

pmarfleet

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

Re: How can I Allow focus for multiple controls?

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

pmarfleet

2-Mar-08 6:02

Get a reference to the item(s) that are selected from the SelectedItems property of the control. Then set the BackColor property of each item to an appropriate colour.

Paul Marfleet

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

How can i store path of zipfile in DataBase MS-SQL Using C# 2.0

Member 43708982-Mar-08 4:09

Member 4370898

2-Mar-08 4:09

How can i store path name of zip file in DataBase Sql Server so user can download it easily with out effecting on database.

Re: How can i store path of zipfile in DataBase MS-SQL Using C# 2.0

pmarfleet2-Mar-08 4:44

pmarfleet

2-Mar-08 4:44

Member 4370898 wrote:
How can i store path name of zip file in DataBase Sql Server so user can download it easily with out effecting on database.

Your question doesn't really make sense.

You want to store a file path in your SQL database? So, just stick it in a table.

What do you mean, 'with out effecting...'?

Paul Marfleet

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

Re: How can i store path of zipfile in DataBase MS-SQL Using C# 2.0

Christian Graus2-Mar-08 10:58

Christian Graus

2-Mar-08 10:58

It's just a string, so just store it.

Either you really shouldn't be working on a database app until you learn some basics or ( more likely ) you've not asked what you meant to ask. Is the issue that you don't know how to store the zip files logically in your file system ? There's a Path.GetTemporaryFileName ( or similar ) method you can use to create meaningless unique file names if you're worried about collisions.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: How can i store path of zipfile in DataBase MS-SQL Using C# 2.0

Member 43708983-Mar-08 7:33

Member 4370898

3-Mar-08 7:33

Actually i want to store physical path of file in database.so help me.

Calling WebMethods using Request XML?

geekfromindia2-Mar-08 4:03

geekfromindia

2-Mar-08 4:03

Hi All,

I need to consume a XML and I have Request XML and some C# code to consume response.

Now as far as I have seen we can directly call webmethods, by adding web reference.
Not sure if we can use Request XML to call web method. If we can, is there a sample or article discussing this?? Whats the ideal way of doing this??

Re: Calling WebMethods using Request XML?

pmarfleet2-Mar-08 4:43

pmarfleet

2-Mar-08 4:43

You could write a simple web service that returns XML by using a HttpHandler. More information on this topic can be found here[^].

Paul Marfleet

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

Re: Calling WebMethods using Request XML?

geekfromindia2-Mar-08 5:03

geekfromindia

2-Mar-08 5:03

Thanks Paul...I dont have control over creating that service. I need to consume that service which accepts and return XMl using Soap. Now the question is "Can I make a request to that Service using Soap XML instead of directly calling those web methods from codebehind??

Keep DotNetting!!

GeekFromIndia

Re: Calling WebMethods using Request XML?

pmarfleet2-Mar-08 5:18

pmarfleet

2-Mar-08 5:18

Yes, although I haven't tried to do it myself. The following Google[^] search threw up some useful information though.

Paul Marfleet

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

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