C# Discussion Boards - CodeProject

Giorgi Dalakishvili12-Jul-08 10:04

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

Re: How to create mdb File?

Admin88712-Jul-08 10:08

Admin887

12-Jul-08 10:08

i think that it was not necessary Frown | :(

Re: How to create mdb File?

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

Re: How to create mdb File?

Admin88712-Jul-08 12:02

Admin887

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?

Re: How to create mdb File? [modified]

DaveyM6912-Jul-08 20:47

DaveyM69

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

Re: How to create mdb File?

Admin88712-Jul-08 21:34

Admin887

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???

Re: How to create mdb File?

DaveyM6913-Jul-08 7:23

DaveyM69

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

simulating sql server fetch data

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

half-life

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

Re: close button

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

Re: close button

half-life12-Jul-08 22:32

half-life

12-Jul-08 22:32

THANKS

Have Fun
Never forget it

Re: close button

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!

Re: close button

half-life12-Jul-08 22:36

half-life

12-Jul-08 22:36

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

Have Fun
Never forget it

Hexadecimal and Binary structs/types/classes

DaveyM6912-Jul-08 8:40

DaveyM69

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

Re: Hexadecimal and Binary structs/types/classes

half-life12-Jul-08 8:47

half-life

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

Re: Hexadecimal and Binary structs/types/classes

DaveyM6912-Jul-08 8:58

DaveyM69

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

Re: Hexadecimal and Binary structs/types/classes

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.

Re: Hexadecimal and Binary structs/types/classes

DaveyM6912-Jul-08 21:15

DaveyM69

12-Jul-08 21:15

Point taken.
Is there anyway to directly assign to, compare to or operate on a binary value using a built in data type like we can with a hex.

e.g. int x = 0xF0; //Hexadecimal assignment (240 decimal)
int y = ??11110000; //Binary assignment

Dave

Re: Hexadecimal and Binary structs/types/classes

Guffa13-Jul-08 9:04

Guffa

13-Jul-08 9:04

No, there is no binary literal in C#. The only literal formats for numbers are decimal and hexadecimal.

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

help in web service urgent ? ? ? ?

Amit Zala12-Jul-08 4:18

Amit Zala

12-Jul-08 4:18

help in web service urgent ? ? ? ?
help in web service urgent ? ? ? ?
help in web service urgent ? ? ? ?
help in web service urgent ? ? ? ?
help in web service urgent ? ? ? ?
help in web service urgent ? ? ? ?
help in web service urgent ? ? ? ?
help in web service urgent ? ? ? ?
help

Re: help in web service urgent ? ? ? ?

Luc Pattyn12-Jul-08 4:31

Luc Pattyn

12-Jul-08 4:31

Congrats. Your subject line very well summarizes your message.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Re: help in web service urgent ? ? ? ?

Mark Churchill12-Jul-08 5:20

Mark Churchill

12-Jul-08 5:20

The content was worse than I expected, and my expectations weren't all that high... :P

Mark Churchill
Director
Dunn & Churchill
Free Download:
Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio.

Re: help in web service urgent ? ? ? ?

Paul Conrad12-Jul-08 7:44

Paul Conrad

12-Jul-08 7:44

What a dumb post. How do you expect anyone to help you, when you don't even say what your damn problem is?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

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