C# Discussion Boards - CodeProject

How to Create a new Access database using C#?

Xytme17-Jul-03 17:41

17-Jul-03 17:41

How to Create a new Access database using C#?
i want create a new access database.i don't kown how to write the SQL expression.
and i want to kown is there other way to create a new database not use SQL language.beacause i kown there is ADOX in ado2.5 and it can create database.but i can't find anything can create database in ado.net.
thanks.

Re: How to Create a new Access database using C#?

Kastro17-Jul-03 18:10

Kastro

17-Jul-03 18:10

I'm interested in knowing too.

The only other technique I know, and have used before, is to embed a blank database into the assembly and write it out to file using a binary stream whenever a new database is needed. I know, its ugly and bad, but it works. Though if you want to be able to create for different Access versions you'd need to embed each one, which is even more ugly and bad.

Also, you can use Interop to access ADOX from C#.

Re: How to Create a new Access database using C#?

Mazdak18-Jul-03 2:23

Mazdak

18-Jul-03 2:23

I think you have to send SQL statement to Access. (CREATE DATABASE) You can do it in this way with ado.net.

Mazy

No sig. available now.

background is not transparent !!

KETUINHA17-Jul-03 17:04

KETUINHA

17-Jul-03 17:04

Hallo all

I add some Image into ImageList , and Append it to ToolBar, but I can't remove Image background

somebody help me, please

Nho'c ti`

SML GHETTO STEEZ

eggie517-Jul-03 14:40

eggie5

17-Jul-03 14:40

Here's my ghetto xml (byteFile1.xml)...

<?xml version="1.0"?>
     <Bytes>
          <byte1>
               <one>00</one>
               <two>01</two>
               <three>02</three>
               <four>03</four>
               <five>04</five>
               <six>05</six>
               <seven>06</seven>
               <eight>07</eight>
          </byte1>
          <byte2>
               <one>21</one>
               <two>15</two>
               <three>12</three>
               <four>11</four>
               <five>05</five>
               <six>01</six>
               <seven>08</seven>
               <eight>04</eight>
          </byte2>
          <byte3>
               <one>02</one>
               <two>00</two>
               <three>10</three>
               <four>18</four>
               <five>81</five>
               <six>05</six>
               <seven>06</seven>
               <eight>07</eight>
          </byte3>
     </Bytes>

now here's the code I process it with...

int nOutNum;

XmlDocument xmlDoc=new XmlDataDocument();
XmlNode bit;
string NUM;
xmlDoc.Load("byteFile1.xml");
bit=xmlDoc.SelectSingleNode("//Bytes/byte1");
NUM=bit.InnerText;

this.labelCell.Text=NUM;


nOutNum=short.Parse(NUM, NumberStyles.AllowHexSpecifier);
NTPort.Outport(nAddress, (short)nOutNum);

Now, what I want to do is go though each node i.e. (one, two, three.... eight) one at a time, and on each one do the above code.

but make ....

bit=xmlDoc.SelectSingleNode("//Bytes/byte1");

unique to the specific node were on in the loop...

like if were on the one in bold...

<byte1>
     <one>00</one>
     <big><two>01</two></big>
     <three>02</three>
     <four>03</four>
     <five>04</five>
     <six>05</six>
     <seven>06</seven>
     <eight>07</eight>
</byte1>

then change it to...

bit=xmlDoc.SelectSingleNode("//Bytes/byte1/two");

so, it sounds reall confusing... I think all I need is a for loop or somthing... but the changing of the SelectSingleNode thing ruins me...

PLEASE HELP@!@!#@$K Blush | :O

/\ |_ E X E GG

Re: SML GHETTO STEEZ

eggie517-Jul-03 19:05

eggie5

17-Jul-03 19:05

Don't worry people... I think my question is too confusing to answer also...

/\ |_ E X E GG

Re: SML GHETTO STEEZ

eggie518-Jul-03 10:23

eggie5

18-Jul-03 10:23

HA, HAHA, I don't need you people... I did it my self.

for (b=1; b<=8; b++)
{
baseBytes="//Bytes";
basebyte1="/byte"+b2;
baseCell="/b"+b.ToString();
baseFULL=baseBytes+basebyte1+baseCell;

XmlDocument xmlDoc=new XmlDataDocument();
XmlNode bit;
string NUM;
xmlDoc.Load("byteFile1.xml");
bit=xmlDoc.SelectSingleNode(baseFULL); //Bytes/byte1/b2
NUM=bit.InnerText;
nOutNum=short.Parse(NUM, NumberStyles.AllowHexSpecifier);
NTPort.Outport(nAddress, (short)nOutNum);
MessageBox.Show("Cell: "+b.ToString()+" illuminated"+"\nByte #"+b2.ToString());

if(b==8)
b2++;
if(b==8)
b=0;

}
MessageBox.Show("LOOP ENDED");

/\ |_ E X E GG

Re: SML GHETTO STEEZ

eggie518-Jul-03 10:23

eggie5

18-Jul-03 10:23

HA, HAHA, I don't need you people... I did it my self.

for (b=1; b<=8; b++)
{
    baseBytes="//Bytes";
    basebyte1="/byte"+b2;
    baseCell="/b"+b.ToString();
    baseFULL=baseBytes+basebyte1+baseCell;

    XmlDocument xmlDoc=new XmlDataDocument();
    XmlNode bit;
    string NUM;
    xmlDoc.Load("byteFile1.xml");
    bit=xmlDoc.SelectSingleNode(baseFULL); //Bytes/byte1/b2
    NUM=bit.InnerText;
    nOutNum=short.Parse(NUM, NumberStyles.AllowHexSpecifier);
    NTPort.Outport(nAddress, (short)nOutNum);
    MessageBox.Show("Cell: "+b.ToString()+" illuminated"+"\nByte #"+b2.ToString());

    if(b==8)
        b2++;
    if(b==8)
        b=0;

}
MessageBox.Show("LOOP ENDED");

/\ |_ E X E GG

MD5 in C#

Zibar17-Jul-03 11:01

Zibar

17-Jul-03 11:01

do you know any free C# MD5 implementation (or I have to do it myself Wink | ;)

Re: MD5 in C#

Frank Rem17-Jul-03 11:30

Frank Rem

17-Jul-03 11:30

It is part of the .NET framework. Check for System.Security.Cryptography.MD5.

Re: MD5 in C#

Zibar17-Jul-03 20:13

Zibar

17-Jul-03 20:13

huh

can't be... I hope it can be used for testing data integrity

Progress Bar

eggie517-Jul-03 9:36

eggie5

17-Jul-03 9:36

Where can I get a quick turtorial on the progress bar?

/\ |_ E X E GG

visual studio designer

mdolby17-Jul-03 9:11

mdolby

17-Jul-03 9:11

Hi,

I've been trying to get the designer in visual studio to work for a class which isn't derived from "form".. It is a class derived directly from System..

I want the designer to work for my class so I can to drag the database connection from the "server explorer". And have it add all the code automatically to my class as is done for classes derived from "form"..

How can I do this??

Your help as always would be greatly appreciated!!

Re: visual studio designer

John Fisher17-Jul-03 9:25

John Fisher

17-Jul-03 9:25

There was a quick "tip" about just this in one of the recent MSDNTV items. (Go to www.msdn.com/msdntv[^], then look at the archive for the one by Juval Lowy.)

Anyway, you temporarily inherit your class from Control (I think), which then enables the designer to do the database work for you. Then you remove the control inheritance if needed.

John

John

"We want to be alone when we hear too many words and we feel alone when it has been a while since anyone has spoken to us." Paul David Tripp -- War of Words

Re: visual studio designer

Kastro17-Jul-03 11:07

Kastro

17-Jul-03 11:07

I'm doing something similar right now actually... Working on creating a GUI library and engine using DirectX that is designable.

You have to implement IComponent in your class (deriving from Component is a quick way to do this) because the DesignerHost (service provided and used by VS.NET) utilizes sites (ISite), which are the basis of components. Then you have to specify an IRootDesigner-implementing class in a DesignerAttribute for you IComponent class. You can try using ComponentDocumentDesigner for that if you don't need any custom designer stuff.

Also check out an article/sample named ShapeLibrary that gives a nice easy example of utilizing design-time services in .NET. You can find it here:

http://windowsforms.net/articles/shapedesigner.aspx[^]

Hope this helps...

locating a node in a treeview control?

misterbear17-Jul-03 8:54

misterbear

17-Jul-03 8:54

Does anyone know how to locate a specific node in a treeview control? I have the full path (string) to the element, but now i want to select the given node in the treeview.

Is there any easy way to do this?

i.e i have the string "folderlevel1\folderlevel2\child1", and i want to select the node with name "child1" in the structure...

i'd really appreciate some help.

Re: locating a node in a treeview control?

Nick Parker17-Jul-03 9:13

Nick Parker

17-Jul-03 9:13

Use a foreach loop to loop through the Node's within the treeview.

-Nick Parker

Can you have a space in Table Name & query it from C#

Khang Nguyen17-Jul-03 7:32

Khang Nguyen

17-Jul-03 7:32

Hello Gurus,

I inherited a MS Access database. One of the columns in a table happened to name with a SPACE in the middle, "FrameMaker Location". I know, it's not a smart way to name a column.

I was trying to insert some new records into the table. It only worked when I removed the SPACE from the column name (from my code and DB), like "FrameMakerLocation". Otherwise, I got an error like this "Syntax error in INSERT INTO statement".

Do you know any tricks so that I don't have to rename the column name???

Thanks so much in advance
Have a great Thur.
Khang Nguyen;)

Here is my draft of code (roughly)

===================================================================

DataRow row = dataSet.Tables[0].NewRow();

row["FrameMaker Location"] = sFrameMakerLoc;

dataSet.Tables[0].Rows.Add(row);

iNumOfAffectedRecs = adapter.Update(dataSet);

Re: Can you have a space in Table Name & query it from C#

Ray Cassick17-Jul-03 7:53

Ray Cassick

17-Jul-03 7:53

I am not sure but try enclosing the name in square brackets [ ].

Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.

Re: Can you have a space in Table Name & query it from C#

Khang Nguyen17-Jul-03 8:53

Khang Nguyen

17-Jul-03 8:53

Ray, I tried it but it did not work. Thanks for the suggestion.
Khang;)

Re: Can you have a space in Table Name & query it from C#

Uwe Keim17-Jul-03 22:47

Uwe Keim

17-Jul-03 22:47

It depends on the underlying database which characters can be used to quote special characters. For SQL Server and MS Access, '[' and ']' work.

--
- Free Windows-based CMS: www.zeta-software.de/enu/producer/freeware/download.html
- See me: www.magerquark.de

Where do i find an Object Int type

Anonymous17-Jul-03 6:34

Anonymous

17-Jul-03 6:34

I want to be ables to set int's to null but I can set Int32 to null

Re: Where do i find an Object Int type

leppie17-Jul-03 7:17

leppie

17-Jul-03 7:17

No you cant! A valuetype cannot be null, but a boxed valuetype can. This means you will have to cast the int to object ie:

object myint = (object) 5;

leppie ::AllocCPArticle(Generic DFA State Machine for .NET);

Saving Images

Johan Lombaard17-Jul-03 6:07

Johan Lombaard

17-Jul-03 6:07

I am trying to write a class to draw an image and then save it to a JPEG.
The drawing is easy, but the saving part is a female dog.
Can anyone help me with ideas on how to do this ?

Johan Lombaard

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein

Re: Saving Images

leppie17-Jul-03 7:13

leppie

17-Jul-03 7:13

Bitmap.Save()?

leppie ::AllocCPArticle(Generic DFA State Machine for .NET);

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