C# Discussion Boards - CodeProject

12-Jul-08 9:48

How Can i create mdb file, create some table in it(columns..), and add some rows?(in C#)

after it, i want to show the file in DataGridView.. But i dont know how to do it..How to open mdb file and show it in the grid?

Someone can help me plz?
it is for my huge Project?
Thank you!

Giorgi Dalakishvili12-Jul-08 10:04

Giorgi Dalakishvili

12-Jul-08 10:04

Issue a script that creates a database.
Issue a script that creates a table.
Issue a script that inserts some data.
Read the data from the table and show on a grid.

Giorgi Dalakishvili

#region signature
my articles
#endregion

Admin88712-Jul-08 10:08

12-Jul-08 10:08

i think that it was not necessary Frown | :(

paas12-Jul-08 11:42

paas

12-Jul-08 11:42

Unfortunately you can not create Access MDBs using ADO.Net, but you can use COM and ADOX to create the database and tables, and then access the created MDB and tables via ADO.Net and OleDB. The link below, although a VB.Net example, should help you get started.

Create Access MDB and Tables in .NET

Admin88712-Jul-08 12:02

Re: How to create mdb File? [modified]

12-Jul-08 12:02

thank you but..
It it for Visual Basic... Frown | :(

.
and i am programming in C#.
the catalog object do not exist

What i need to do?

DaveyM6912-Jul-08 20:47

12-Jul-08 20:47

Add a reference to the Microsoft ADO Ext (it's a COM object) to your project.
In the version I have (2.8) the Catalog is actually called CatalogClass.

To test it, I converted the first part of the code to this which works.

ADOX.CatalogClass cat = new CatalogClass();
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" +
     @"Data Source=C:\NewMDB.mdb;" +
     "Jet OLEDB:Engine Type=5");
Console.WriteLine("Database Created Successfully");
cat = null;

Now you should be able to convert the rest and ammend it to suit your needs.

Dave

modified on Sunday, July 13, 2008 2:59 AM

Admin88712-Jul-08 21:34

12-Jul-08 21:34

Thank you!!
i have another question, and sorry for my foolishness,

How can i add reference to the Microsoft ADO Ext???

DaveyM6913-Jul-08 7:23

simulating sql server fetch data

13-Jul-08 7:23

Right click on References in Solution Explorer and choose Add Reference. Click the COM tab and you'll find it in the list.

Dave

nima_api12-Jul-08 9:23

nima_api

12-Jul-08 9:23

Hi all
How I can Simulating fetching data on sql server by c#?
When we do an "Open Table" data fetch from database with a wonderful speed.
I design a form with a button and a datagrid.I use background worker to fetch data.It work but it's Speed is not so good.
Any ones has Code about this?
thanx

Future

Re: simulating sql server fetch data

Vimalsoft(Pty) Ltd12-Jul-08 16:16

Vimalsoft(Pty) Ltd

12-Jul-08 16:16

HI
Your Technical English is not good, i cant understand what you want, if you can explain step by step, i think i will be better.

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: simulating sql server fetch data

nima_api14-Jul-08 3:19

nima_api

14-Jul-08 3:19

Hi I want to fetch data from database asynchronously.Sql server opens table with a perfect speed(when use SQL managment Studio).I write a program that fetch data from sql server asynchronously but its speed is 0,1 speed sql server.
what is the best way to fetching data asynchronously?

rgege

close button

half-life12-Jul-08 8:44

12-Jul-08 8:44

Hi,
is there any built in component as the close button in the from
or it is just a button control with Style and color?

Smile | :)

Have Fun
Never forget it

Pete O'Hanlon12-Jul-08 9:31

Pete O'Hanlon

12-Jul-08 9:31

Set your forms Cancel button to be the button you want to act as the close. If it's a dialog, the form will close when you click this - if it's a standard window then you need to close the form explicitly.

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

My blog | My articles

half-life12-Jul-08 22:32

12-Jul-08 22:32

THANKS

Have Fun
Never forget it

Luis Alonso Ramos12-Jul-08 20:13

Luis Alonso Ramos

12-Jul-08 20:13

Let's see if I understand: you want to add another button to the title bar of your window? Otherwise, why would you want a button with the same style?

To add a button to the title bar (other than the built-in close, maximize, minimize and help) is not trivial. You would need to do some non-client area painting to draw the button, and also handle click messages to draw the button in a pressed state.

It is not too hard, but it will take its time.

Luis Alonso Ramos
Intelectix
Chihuahua, Mexico

My Blog!

half-life12-Jul-08 22:36

Hexadecimal and Binary structs/types/classes

12-Jul-08 22:36

I did'nt meant that,but thanks u saved me next Q Smile | :)

Have Fun
Never forget it

DaveyM6912-Jul-08 8:40

12-Jul-08 8:40

As we all know, computers use binary - which can be represented easily using hexadecimal, but for some reason (?) Microsoft havent included any binary or hexadecimal types in .NET - only 'human friendly' base 10 types.

I've created some extension methods for all the built in types that handle the conversions/boolean functions/math functions fine but it would be MUCH better if there were built in types, structs or classes for these.

I know some of the string functions can handle base 2,8 and 16 but all this converting to and from strings just to do some simple math seems very pointless.

Before I 'roll my own', does anyone know of any available? Google has turned up nothing.

Dave

half-life12-Jul-08 8:47

12-Jul-08 8:47

u do have the bit Array and the byte struct / class
the Hexadecimal is just a presentation u can use the string class
to display the format u like of the value Smile | :)

Have Fun
Never forget it

DaveyM6912-Jul-08 8:58

12-Jul-08 8:58

I've never come accross the BitArray, thanks for that. Whilst searching for that in the Object Browser I also came accross the BitConverter which could be useful.

Dave

Guffa12-Jul-08 13:06

Guffa

12-Jul-08 13:06

DaveyM69 wrote:
I know some of the string functions can handle base 2,8 and 16 but all this converting to and from strings just to do some simple math seems very pointless.

I think that you are missing the point entirely.

There are no binary, octal, decimal or hexadecimal data types, all those are string representations of numbers. The data types are just numbers, they don't have any base at all.

A Byte, for example, is just a number that uses 8 bits for storage, it's not an 8 digit binary number or a 3 digit decimal number. The default way of formatting the number into a string is to use base 10, but that doesn't mean that the data type itself uses base 10.

Despite everything, the person most likely to be fooling you next is yourself.

DaveyM6912-Jul-08 21:15