|
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);
|
|
|
|
|
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.
|
|
|
|
|
Ray, I tried it but it did not work. Thanks for the suggestion.
Khang;)
|
|
|
|
|
|
I want to be ables to set int's to null but I can set Int32 to null
|
|
|
|
|
|
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
|
|
|
|
|
|
I try to place a file into the clipboard so I can later paste them in Explorer. I can place text, bitmap etc using Clipboard.SetData, but how can I place a file into the clipboard?
Thanks
|
|
|
|
|
|
can you give more detail? I want to do the following.
If I click a button, a file (its name) is place on clipboard, then go to Explorer and hit CtrlV
thanks
|
|
|
|
|
How can I make it so that the vertical pointing icons appear in my ListView after the user has clicked on a header to sort it????? I have been trying to figure this out for a bit now and I dont have a clue.
|
|
|
|
|
Hi. I created a dataAdapter and a typed dataset, which refers to a stored procedure that takes an input value. How would I use this dataSet, or fill the dataAdapter, as I dont know how to tell it what the input value must be (which happens to be an int).
|
|
|
|
|
I am writing a function that checks whether the same program already started. In case the same program is lready started, the control will be moved to the opened program, and the program is closed.
PMN
|
|
|
|
|
|
i created a table with 9 columns using datatable and tablestyles.
Also i got a DataRelation.
How can i tell my childcolumn to change if the parentcolumn changes?
e.g. in column "number" is 10 the value,
if I change the value to 17 in parenttable,the value in childttable should also change
|
|
|
|
|
Hey i am using a hashtable, and i am adding my fields collection to it.
when i iterate through them they found to be not in the order in which i added them. how do i maintain the sequence in which the elements are added.
thanks
Cheers,
Venkatraman Kalyanam
Bangalore - India
"Being Excellent is not a skill, it is an attitude"
Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
|
|
|
|
|
You don't. Hashtables do not store the sequence that you added the items.
You should use an arraylist.
|
|
|
|
|
Indeed.
If you want your data to be always sorted, ArrayList is probably better than Hashtable.
If you use Hashtable because most of the times you don't care about sorted data, but
you'd rather have a near-O(1) access time, then Hashtable is better.
Note, however, that you can use an Hashtable and, when needed, sort the values as needed and live happily ever-after.
Frank
|
|
|
|
|
You might consider the System.Collections.Specialized.ListDictionary . It implements the IDictionary interface with a linked list. It would be my guess (just a guess) that the order of addition is maintained. Be aware, according to the documentation, ListDictionary is superior to hashtable performance-wise up to about ten items. If your list is longer, consider another strategy.
α.γεεκ Fortune passes everywhere. Duke Leto Atreides
|
|
|
|
|
For me, the best solution tends to be maintaining two data structures, an array or arraylist with the keys in the desired order, and a hashtable with the key-value pairs.
You could easily devise data structures that combine the two, such as a hashtable where the list of keys is a linked list.
|
|
|
|
|
I have a set of 8 buttons, named "button0, 1, 2,... 7" their text also coresponds with their names, such as "0, 1, 2,... 7".
for each button I have this code..
private void button1_Click(object sender, System.EventArgs e)
{
int nOutNum;
string NUM="1";
nOutNum=short.Parse(NUM, NumberStyles.AllowHexSpecifier);
NTPort.Outport(nAddress, (short)nOutNum);
}
for each button I have string NUM equal what ever the text of the button is, 0-7.
That's kinda' ghetto looking and to manage...
here's the question...
how can I make NUM equal whatever the text of the button says...?
/\ |_ E X E GG
|
|
|
|
|
Hi eggie5,
1. set each button's Tag property to the appropriate number
2. create only one callback method for all button's click event and assign it
3. use the sender object to get the Tag property's value
this.button1.Tag = 1;
this.button2.Tag = 2;
this.button3.Tag = 3;
this.button4.Tag = 4;
this.button5.Tag = 5;
this.button6.Tag = 6;
this.button7.Tag = 7;
this.button0.Click += new System.EventHandler(ClickHandler);
this.button1.Click += new System.EventHandler(ClickHandler);
this.button2.Click += new System.EventHandler(ClickHandler);
this.button3.Click += new System.EventHandler(ClickHandler);
this.button4.Click += new System.EventHandler(ClickHandler);
this.button5.Click += new System.EventHandler(ClickHandler);
this.button6.Click += new System.EventHandler(ClickHandler);
this.button7.Click += new System.EventHandler(ClickHandler);
private void ClickHandler(object sender, EventArgs ea)
{
short nOutNum = (short) ((Control)sender).Tag;
NTPort.Outport(nAddress, (short)nOutNum);
}
Have fun,
Dave
|
|
|
|
|
Thanks man. you rule.
/\ |_ E X E GG
|
|
|
|
|
Hi Guys..
I've been going crazy for two days now, and I feel I'm very close. I've got a 3rd party DLL that returns a HANDLE to a DIB (GDI). I've retrieved the BITMAPINFO structure, created a Bitmap and locked the bits. However, when I try and copy the data in, I always get an unhandled exception. Here's my code:
<br />
IntPtr lpArray = CaptureAndFetch();
IntPtr pDib = GlobalLock(lpArray);<br />
BITMAPINFO pbmi = (BITMAPINFO)Marshal.PtrToStructure(pDib, typeof(BITMAPINFO));
<br />
bitmap = new Bitmap(pbmi.bmiHeader.biWidth, pbmi.bmiHeader.biHeight, PixelFormat.Format24bppRgb);<br />
<br />
BitmapData bmData; <br />
Rectangle rect = new Rectangle(0, 0, pbmi.bmiHeader.biWidth, pbmi.bmiHeader.biHeight );<br />
bmData = bitmap.LockBits(rect, ImageLockMode.ReadWrite, PixelFormat.Format24bppRgb );<br />
<br />
GCHandle hSrc = GCHandle.Alloc(pDib, GCHandleType.Pinned );
IntPtr pBits = hSrc.AddrOfPinnedObject();<br />
<br />
Int32 pAddress = (Int32)pBits;<br />
pAddress += Marshal.SizeOf(pbmi);<br />
pBits = (IntPtr)pAddress;<br />
<br />
GCHandle hDest = GCHandle.Alloc(bmData.Scan0, GCHandleType.Pinned);<br />
IntPtr pDest = hDest.AddrOfPinnedObject();<br />
<br />
int length = pbmi.bmiHeader.biHeight * bmData.Stride;<br />
<br />
byte databyte;<br />
for (int idx = 0; idx <= length; idx++)<br />
{<br />
databyte = Marshal.ReadByte(pBits, idx);
Marshal.WriteByte(pDest, idx, databyte);<br />
}<br />
<br />
bitmap.UnlockBits( bmData );<br />
hSrc.Free();<br />
hDest.Free();<br />
GlobalUnlock(lpArray);<br />
|
|
|
|