Accessing pocket access CDB using .NET - Mobile Discussion Boards

João Paulo Figueira5-Jul-04 12:21

5-Jul-04 12:21

This may well be the source of this problem. To diagnose it, I would have to take a look at your entire project.

Regards,
João Paulo Figueira
Embedded MVP

Re: CArray makes me cry !!!!!!!

Hadi Rezaee5-Jul-04 12:33

Hadi Rezaee

5-Jul-04 12:33

Here's the story:

class OrderItems<br />
{<br />
public:<br />
  OrderItems(){}<br />
  OrderItems(int code, int count)<br />
  {<br />
    m_nCode = code;	<br />
    m_nCount = count;<br />
  }<br />
<br />
  int m_nCode;<br />
  int m_nCount;<br />
};<br />
<br />
class CMainPage : public CPropertyPage<br />
{<br />
.<br />
.<br />
.<br />
  void UseOrders();  // Where we should read items.<br />
<br />
public:<br />
  CArray < OrderItems, OrderItems& > m_OrderItems;<br />
}

And somewhere, in one of CMainPage methods I show another dialog and i add the items in that:

void COrderListDialog::OnOK() <br />
{<br />
  CMainPage* dlgMain = (CMainPage*) GetParent();<br />
	<br />
  OrderItems item(0, 0);<br />
  item = OrderItems( 10, 96 );<br />
  dlgMain->m_OrderItems.Add( item );<br />
  item = OrderItems( 5, 13 );<br />
  dlgMain->m_OrderItems.Add( item );<br />
<br />
  CDialog::OnOK();<br />
}

And then when i back to Main form i call UseOrders() to read the items but the problem occrues Frown | :(

I hope it's clear ...

Regards,
Hadi

Re: CArray makes me cry !!!!!!!

João Paulo Figueira5-Jul-04 22:50

João Paulo Figueira

5-Jul-04 22:50

Please make sure that this:

CMainPage* dlgMain = (CMainPage*) GetParent();

does return the pointer you want. If not, all is explained...

Regards,
João Paulo Figueira
Embedded MVP

Re: CArray makes me cry !!!!!!!

Hadi Rezaee6-Jul-04 1:39

Hadi Rezaee

6-Jul-04 1:39

Yessss, That's it Big Grin | :-D

You solved the problem ! Thank you very much ! Rose | [Rose]

I changed code to this:

CAppSheet *pAppSheet = (CAppSheet *) GetParent();<br />
CMainPage *dlgMain = (CMainPage *) pAppSheet->GetPage(0);

And now it works fine ...

Best Regards,
Hadi

Re: CArray makes me cry !!!!!!!

Hadi Rezaee5-Jul-04 21:00

Hadi Rezaee

5-Jul-04 21:00

I did some new tests on the code that the results are strange too.

1- I declared m_OrderItems as a pointer variable and then use new, when i want to add items it shows me an error: "Out Of Memory.", But the program doesn't crash.

2- I used vector instead of CArray and i get same result. (No Item !)

Regards,
Hadi

return value from a register write

Mel Feik5-Jul-04 9:19

Mel Feik

5-Jul-04 9:19

Hey all, I'm working with a Phillips LPC2129 chip using a Keil compiler. In viewing the example code supplied by Keil, I noticed that they returned an 'int' from a call to a function sending a char out a UART configured as ab RS232 port.

To write to the UART the following is requiredL U1THR = <the char="" to="" be="" written="">.

The problem I have is that in the sample code provided by Keil they return that value in the 'putchar' call and I have no clue how to determine the value of the return. Moreover the manner in which a byte is written to the UART is a register write, not a function call. For example:

return( U1THR = ch );

where ch is the char to be sent. Regardless of what value ch = the return value is 'H' (0x48). I reckon my question lies in how to determine the return value of an assignment?

-any got any input on this?

---------------------------------------------
Help... I'm embedded and I can't get out!

It's amazine how simeple life can be when one get's his head out of his ass...embly

If they don't get the basic research and learning skills down then they'll end up having a very hard life (Either that or they'll become managers) - Micheal P Butler

Free IDE

monn4-Jul-04 16:05

monn

4-Jul-04 16:05

is there any free IDE for the .net compact framework?

Accessing pocket access CDB using .NET

Gobananas2-Jul-04 23:21

Gobananas

2-Jul-04 23:21

Hi,
I'm developing an application using vb.net for PDA's. How should i store the data in the pocket PC access db. .NET CF does not have classes to support this.

Re: Accessing pocket access CDB using .NET

João Paulo Figueira3-Jul-04 0:00

João Paulo Figueira

3-Jul-04 0:00

Check out InTheHand's website[^].

Regards,
João Paulo Figueira
Embedded MVP

AfterCollapse in Compact Framework

ting66830-Jun-04 21:10

ting668

30-Jun-04 21:10

HI
I would like to add AfterCollapse handler to the treeView object using compact framework. However, it seems that CF does not support aftercollaspse event handle. Is there any other ways to add this event handler?

Thanks~

Changing the BackColor of a ListViewItem

George Papadopoulos30-Jun-04 7:00

George Papadopoulos

30-Jun-04 7:00

Hi folks,

How can I change the BackColor of a ListViewItem in a ListView Control in .NET Compact Framework? I know that the ListViewItem.BackColor Property is available on "Desktop" .NET.

Writing to Pocket PC File - Directory Structure?

j1e1g129-Jun-04 5:19

j1e1g1

29-Jun-04 5:19

I am trying to write/read from a .dat file as part of a much larger C# application. The application was written using the .Net Compact Framework, and everything runs fine on my WinXp desktop. However, I am having trouble writing to file on the Pocket Pc, because I know very little about their directory structure. I would like the file I am writing to to be someplace where multiple users can access it, so not in My Documents. So my question is: what should i change this line System.IO.StreamReader file = new System.IO.StreamReader("c:\\mobile.dat"); to, in order not to get this exception A managed DirectoryNotFoundException occurred at Application::Run+0xf. I tried using "\\mobile.dat", but to no avail.

Thanks,
Justin

Re: Writing to Pocket PC File - Directory Structure?

Richard Jones8-Jul-04 4:09

Richard Jones

8-Jul-04 4:09

The pocketpc does not use multiple user folders like windows.
The "\My Documents" folder is accessible by anyone using the PDA.
(Also, there are no drive letters)

"For all of our languages, we cannot communicate" - Christy Moore, Natives

How to store BLOB in SQLCE

Member 105289929-Jun-04 1:37

Member 1052899

29-Jun-04 1:37

Hi all,
I would like to store a BLOB ( signature item ) in SQLCE. I followed the steps given in MSDN sites. Application stops when I encounter the declaration of ISequentialStream interface. In the ssceoledb.h, there is no implemenation of ISequentialstream or Ilockbytes. I am using SQLCE 2.0 and PocketPc 2002 emulation as well as device.

Please help

I tried with the latest download of the header from Microsoft site. Yet it is the same as wht i have now. Please indicate me where do I fail.
Thanks in advance
Mallee

Re: How to store BLOB in SQLCE

João Paulo Figueira29-Jun-04 8:42

João Paulo Figueira

29-Jun-04 8:42

Please wait for my upcoming article about this subject. It should be published here in a couple of days.

Regards,
João Paulo Figueira
Embedded MVP

Re: How to store BLOB in SQLCE

Member 105289929-Jun-04 20:30

Member 1052899

29-Jun-04 20:30

Hi Paulo,

Thanks for ur interest in helping me. But since it is very urgent I am forced to ask you the help immediately.

Let me explain in brief as wht i have done.
1) I call GetSignature method which will return a single row with the BLOB item (IMAGE datatype) as the first and only column in the rowset. The input to this method is an object whose class definition is as follows:

public:
unsigned char m_SignatureData[8192];
unsigned int m_SignatureLength;

/********************************************************************/
This m_SignatureData array stores the activated pixels constituting the IMAGE drawn on the screen.

2) GetSignature after retrieving the rowset will call update signature. The empty BLOB item is now filled with this m_SignatureData array . m_SignatureData array is actually converted into ISequentialStream pointer and then only passed to the SetData method of the IRowsetChange.

I have few questions

1) Which HROW is to be used in the IROwsetChange::SetData method ?
2) Which Accessor interface is to be used ? (One associated with the IRowset or IRowsetChange)?

Please help. (although the mail is lengthy)

void CTransactionRec::GetSignature(CSignature *m_Signature)
{
HRESULT m_QueryResult= NOERROR;

CString szQuery=L"select Signature from tblTransaction where Type='"+ m_stType +"'";
m_QueryResult = m_DbConnection.m_pIDBCrtCmd->CreateCommand(NULL,IID_ICommandText,(IUnknown**)&m_pICmdTextForList);

m_QueryResult = m_pICmdTextForList->SetCommandText(DBGUID_SQL,szQuery);

if(!FAILED(m_QueryResult)) {
if(!FAILED(m_pICmdTextForList->Execute(NULL,IID_IRowset,NULL,NULL,(IUnknown**)&m_pIRowset))) {
UpdateSignature(m_Signature);
}
}
else {
MessageBox(GetActiveWindow(),L"Query not executed",L"Database Session",0);
}

return ;
}

/**********************************************************************/

HRESULT CTransactionRec::UpdateSignature(CSignature *m_Signature)
{

IRowsetChange * pIRowsetChange;
IAccessor * pIAccessor;
ISequentialStream *pISeqStr;
HROW hrow;
HROW *pRows = &hrow;
ULONG lNumRowsRetrieved = 0;

HACCESSOR hAccessor;

DBBINDSTATUS rgStatus[1];

DBOBJECT ObjectStruct;

ObjectStruct.dwFlags = STGM_READWRITE ;

ObjectStruct.iid = IID_ISequentialStream;

DBBINDING rgBinding[1] = {

1, // Column 1

0, // Offset to data

sizeof(IUnknown*), // obLength length field

0, // Ignore status field

NULL, // No type info

&ObjectStruct, // Object structure

NULL, // Ignore binding extension

DBPART_VALUE|DBPART_LENGTH, // Bind value and length

DBMEMOWNER_CLIENTOWNED, // Consumer owned memory

DBPARAMIO_NOTPARAM, // Not a parameter binding

0, // Ignore maxlength

0, // Reserved

DBTYPE_IUNKNOWN, // Type DBTYPE_IUNKNOWN

0, // Precision not applicable

0, // Scale not applicable

};

m_pIRowset->QueryInterface(IID_IAccessor, (void**) &pIAccessor);

pIAccessor->CreateAccessor(DBACCESSOR_ROWDATA, 1, rgBinding, sizeof(IUnknown *),&hAccessor,
NULL);

pIAccessor->Release();

m_pIRowset->GetNextRows(NULL,
0,
1,
&lNumRowsRetrieved,
&pRows);

BYTE* pData=(BYTE*)CoTaskMemAlloc(sizeof(IUnknown*)+sizeof(ULONG));

// Value - pass ISequentialStream pointer to the provider

pISeqStr = *(ISequentialStream **)(m_Signature->m_SignatureData);

*(ISequentialStream**)(pData+rgBinding[0].obValue)=pISeqStr;

// LENGTH - Some providers need to know the length of the

// stream ahead of time...

*(ULONG*)(pData+rgBinding[0].obLength)=(ULONG)m_Signature->m_SignatureLength;

// SetData - The provider will then do an ISequentialStream::Read

// on the pISeqStr pointer passed in...

pIRowsetChange->SetData(*pRows, hAccessor, pData);

CoTaskMemFree(pData);

return 0;

}

Thank You
Mallee

Re: How to store BLOB in SQLCE

João Paulo Figueira29-Jun-04 21:09

João Paulo Figueira

29-Jun-04 21:09

I may have a little bit more difficulty in helping you because I use the ATL OLE DB Consumer Templates, not "raw" OLE DB C++ code. But the priciples are the same, so let me explain these a little bit.

When you read a BLOB, the provider creates an ISequentialStream object and passes a pointer back to the consumer. You will have to choose if you use the object to read data, but must always release it.

When you write a BLOB (either inserting or updating), you have to do the exact reverse, meaning that you have to create an ISequentialStream object from which the provider will read the BLOB data. So, how do you create such a thing? I got help from this article:
SAMPLE: AOTBLOB Read/Writes BLOB Using OLE DB Consumer Template[^]. Note how the CISSHelper class is used to simulate a storage object.

I believe most of your problems will be solved when you implement this functionality.

Regards,
João Paulo Figueira
Embedded MVP

Re: How to store BLOB in SQLCE

João Paulo Figueira1-Jul-04 7:56

João Paulo Figueira

1-Jul-04 7:56

Managing Blobs Using The ATL OLE DB Consumer Templates on the Pocket PC
[^]

Regards,
João Paulo Figueira
Embedded MVP

Dynamic Menus

Member 113813628-Jun-04 23:41

Member 1138136

28-Jun-04 23:41

Hi,
I am using pocketpc 2003 SDK on wince platform.
In my application, i need to create menu at runtime without using any resource. I will be getting the top menu item and pop up menu items during run time. I am trying to create menu bar using commandbar, but it is creating the menu bar at the top of the client area instead of down. I know that we need to use CreateMenu, CreatePopupMenu and AppendMenu functions, but after creating and appending the menu items what we should do?. I am not supposed to use MFC.

Please give some suggestions.
Regards
harish

harishks@integramicro.com

I need to differentiate when a Pocket PC uses operating system 2002 of the 2003 in run-time!!!!

Escalopo28-Jun-04 6:24

Escalopo

28-Jun-04 6:24

Hello,
anybody know how to differente it? D'Oh! | :doh:

thanks

Re: I need to differentiate when a Pocket PC uses operating system 2002 of the 2003 in run-time!!!!

Member 57102128-Jun-04 6:37

Member 571021

28-Jun-04 6:37

Hi
Here is the solutin....

#ifdef WIN32_PLATFORM_PSPC
//Pocket PC
#if (WIN32_PLATFORM_PSPC == 400)
// Pocket PC 2003
#elif (WIN32_PLATFORM_PSPC == 310)
// Pocket PC 2002 code
#endif
#endif // WIN32_PLATFORM_PSPC

Re: I need to differentiate when a Pocket PC uses operating system 2002 of the 2003 in run-time!!!!

Escalopo28-Jun-04 21:29

Escalopo

28-Jun-04 21:29

thanks, but it´s not the solution that I´m looking for, i need to differentiate the operating system build or something similar, not the compilation platform. thank you. Smile | :)

Re: I need to differentiate when a Pocket PC uses operating system 2002 of the 2003 in run-time!!!!

João Paulo Figueira28-Jun-04 22:30

João Paulo Figueira

28-Jun-04 22:30

Look at the GetVersionEx API.

Regards,
João Paulo Figueira
Embedded MVP

How can i make my application support multiple language in PocketPC

Member 57102128-Jun-04 5:51

Member 571021

28-Jun-04 5:51

Hi All,
I'm developing an application in PocketPC which only supports for English language. I want to use all my resource as a different language. I put all string in a .rc file. How could i do it for PocketPC.

Any suggestion is most welcome.

Regards
Gopa

Re: How can i make my application support multiple language in PocketPC

João Paulo Figueira28-Jun-04 6:22

João Paulo Figueira

28-Jun-04 6:22

Put all the resources on a DLL that you will load dynamically at application startup. Each DLL will have its own language.

Regards,
João Paulo Figueira
Embedded MVP

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