Re: Dataset save as new .mdb - C# Discussion Boards

Gonzalo Cao15-Jun-10 22:49

15-Jun-10 22:49

I don't think you can do it. I've tried to before and didn't find a way to do it.

There's not much to handle mdb files in c#, for instance I needed to use reflection to compact database, so maybe you can do it the same way.

Anyhow there is a simpler way, you can store an empty mdb on you application as a resource and you deploy it when you need it. After that you can connect with it via OleDB andd then you can store handle it as any other database that you can connect to using OleDB.

Regards.

Re: Dataset save as new .mdb

Eddy Vluggen15-Jun-10 22:50

Eddy Vluggen

15-Jun-10 22:50

Hi,

First, you'd need to explain what kind of .mdb-file you want. The file-extension is used by Sql Server and Access, two different types of databases. I'd be assuming Access.

First part would be getting a new db on the target-system. The easiest way to do this with Access is by adding an empty db-file as an embedded resource.

Second part would be writing the data to the new database. That would be done using OleDb[^].

I are Troll Suspicious | :suss:

Re: Dataset save as new .mdb

shoubi15-Jun-10 22:58

shoubi

15-Jun-10 22:58

Hi Troll

Thank you for replying.

I have a datset filled with a table, and i need to export this table as a new access database.

Re: Dataset save as new .mdb

Eddy Vluggen15-Jun-10 23:17

Eddy Vluggen

15-Jun-10 23:17

shoubi wrote:
I have a datset filled with a table, and i need to export this table as a new access database.

Start by creating an empty Access database. Then try creating an OleDb connection as suggested, and write the dataset to the database.

You can always get help with specific questions here if you get stuck midway Smile | :)

I are Troll Suspicious | :suss:

Re: Dataset save as new .mdb

shoubi16-Jun-10 18:04

shoubi

16-Jun-10 18:04

Hi Troll

Thank you! i manage to do it! however i need to check for duplication of records. I have a dataset to insert into the database. How do i check for duplicate records. let say if the record has existed in the database then it will not be inserted.

Thanks for reading!

zheng

Re: Dataset save as new .mdb

Eddy Vluggen16-Jun-10 19:53

Eddy Vluggen

16-Jun-10 19:53

shoubi wrote:
Thank you! i manage to do it!

My pleasure, and good job Smile | :)

shoubi wrote:
let say if the record has existed in the database then it will not be inserted.

That's the job of the <ocde>Primary Key[^].

As an example, a single person would be uniquely identified by his/her social security number, so we could make that our primary key. That would make the database guard against duplicates in that table, based on the contents of the "social security number"-field.

Another way to prevent duplicates would be using the UNIQUE[^]-constraint.

I are Troll Suspicious | :suss:

Re: Dataset save as new .mdb

shoubi22-Jun-10 17:46

shoubi

22-Jun-10 17:46

hi troll

how to transfer values from one datatable to another datatable. For example there are 2 datatables Table A and Table B. If then column name in Table A is the same as Table B then all the values of that column will go into Table B of the same column name.

Hope you understand me.

Thank you
zheng

Re: Dataset save as new .mdb

Eddy Vluggen22-Jun-10 22:58

Eddy Vluggen

22-Jun-10 22:58

The easiest way to do so would be in Sql, combining a SELECT with an INSERT statement. The code below should work with the AdventureWorks database;

SQL

INSERT INTO Person.Contact (
  FirstName, 
  LastName, 
  Title, 
  PasswordHash, 
  PasswordSalt)
	SELECT FirstName, 
               LastName, 
               Title, 
               PasswordHash, 
               PasswordSalt
	  FROM Person.Contact

Hope this helps Smile | :)

I are Troll Suspicious | :suss:

Re: Dataset save as new .mdb

shoubi22-Jun-10 23:25

shoubi

22-Jun-10 23:25

hi troll

thank you for replying Smile | :)

i would like to copy values of a column in the dataset to another column in another dataset. the condition is: if the both column name is the same.

thank you!

Re: Dataset save as new .mdb

Eddy Vluggen23-Jun-10 0:38

Eddy Vluggen

23-Jun-10 0:38

shoubi wrote:
the condition is: if the both column name is the same

..and do you know how to check that?

I are Troll Suspicious | :suss:

Re: Dataset save as new .mdb

shoubi23-Jun-10 1:52

shoubi

23-Jun-10 1:52

hi troll

thank you for your help... i managed to do it!

thank you!

zheng

Re: Dataset save as new .mdb

Eddy Vluggen23-Jun-10 2:25

Eddy Vluggen

23-Jun-10 2:25

shoubi wrote:
thank you for your help... i managed to do it!

I wasn't much help, so the credit is yours - well done Smile | :)

I are Troll Suspicious | :suss:

Re: Dataset save as new .mdb

shoubi23-Jun-10 17:20

shoubi

23-Jun-10 17:20

hi troll

i need your help again. how do i insert the dataset into the database.

here is my code:
string SelectSchema = "SELECT * FROM [Package Data Range]";
DataSet ds = new DataSet();
OleDbDataAdapter adapterPkInfo = new OleDbDataAdapter(SelectSchema, ImportCon);
adapterPkInfo.FillSchema(ds, SchemaType.Source, "PackageDataRangeSchema");

DataSet ds2 = new DataSet();
string selectPkInfo = "SELECT * FROM [Package Data Range]";
OleDbDataAdapter adapter = new OleDbDataAdapter(selectPkInfo, connection);
adapter.Fill(ds2, "Package Data Range");
ds.Tables[0].Merge(ds2.Tables[0],true,MissingSchemaAction.Ignore);

i would like to insert the dataset ds into the database.

thank you
zheng

Re: Dataset save as new .mdb

shoubi19-Jul-10 20:46

shoubi

19-Jul-10 20:46

hi troll

I have another question, however it is not related to this. Hope you can give me your professional advice.

I have a C# dll, I want to call it from a C++ program. How do I import this dll into the C++.

thank you Smile | :)

Re: Dataset save as new .mdb

Eddy Vluggen20-Jul-10 0:05

Eddy Vluggen

20-Jul-10 0:05

shoubi wrote:
I have another question, however it is not related to this.

No problem, but you would have gotten more reactions if you created a new post.

shoubi wrote:
How do I import this dll into the C++

Using a Platform Invoke[^] would be the easy way to call unmanaged code. If you want to wrap an existing unmanaged type, then look here[^].

Enjoy Smile | :)

I are Troll Suspicious | :suss:

How to notify exception in worker thread to Main thread

Praveen Raghuvanshi15-Jun-10 22:17

Praveen Raghuvanshi

15-Jun-10 22:17

Hi,

I need to notify any exception in the worker thread to the main/ calling thread. How to achieve this and what is the best way to do it.
Googled around and came to know that the exceptions in the worker thread are not handled by the main thread.

Thanks,

Praveen Raghuvanshi
Software Engineer,

India.

Re: How to notify exception in worker thread to Main thread

Gonzalo Cao15-Jun-10 22:56

Gonzalo Cao

15-Jun-10 22:56

Hi,

You can use 'Application.ThreadException'. it will handle any unhandled exception that raises in a sub-thread, anyway this only allows you to have a application wide event for handling all your sub-threads. Maybe you can create an event yourself and call it on the catch block. This way you control the exceptions on the sub-thread and send it to UI thread.

Hope this helps.

Re: How to notify exception in worker thread to Main thread

Praveen Raghuvanshi16-Jun-10 19:08

Praveen Raghuvanshi

16-Jun-10 19:08

Thanks Gonzalo!

I have tried above mentioned event mechanism. Just thought of something better available. Smile | :)

Praveen Raghuvanshi
Software Engineer,

India.

Re: How to notify exception in worker thread to Main thread

Gonzalo Cao16-Jun-10 21:21

Gonzalo Cao

16-Jun-10 21:21

You welcome Smile | :)

.

I guess then the only way would be you taking care of picking the expcetion in the sub-thread and moving it to UI manually.

Regards.

Hello Can you help?

levan omadze15-Jun-10 21:40

levan omadze

15-Jun-10 21:40

Hello.
In the database tree structure of how to write?
After the move in the C#

Re: Hello Can you help?

OriginalGriff15-Jun-10 22:05

OriginalGriff

15-Jun-10 22:05

From your description of the problem, no.

Please clarify your question - in English it does not make a lot of sense...

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Hello

levan omadze15-Jun-10 21:39

levan omadze

15-Jun-10 21:39

Hello.
In the database tree structure of how to write?
After the move in the C#

Re: Hello

Peace ON15-Jun-10 21:44

Peace ON

15-Jun-10 21:44

Can you please give some detail, so that it is easier to answer your question.

And please don't cross post. Read this[^] guideline before you post your question.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Yahoo woeid based weather forecasts

faheemnadeem15-Jun-10 21:01

faheemnadeem

15-Jun-10 21:01

Hi,
I am building a GPS assisted application, which is to display a weather forecast for the closest location with reference to current location.

I am using yahoo weather forecasts.

What i have done:
1. I can successfully request a weather for a place if i know its WOEID (Note: only some places have weather forecasts).
2. In order to get a WOEID of the current location i can query "FLICKR" using YQL and passing current latitude and longitude and get a WOEID back for that place.

Problem:
Is there any way i can request a weather forecast for a nearest location to acquired WOEID of current location.

Thank you in advance,

Microsoft Word Viewer on C#

Mohammad.Elcharfa15-Jun-10 20:51

Mohammad.Elcharfa

15-Jun-10 20:51

Hi Guys,

I would appreciate it if someone has found/created an MS Word Viewer/Editor Control on Visual Studio.

Thanks,

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