The problem ( or my be not ) is that you need administrator right to perform hard or soft maintenance in XP SO. and I want avoid that maintenance team have access to the databases. As we know BUILTIN\Administrator is derived from windows access rights. I've created a Sql login account with sysadmin rights but i can't to change permissions of BUILTIN\Administrator( for ex. avoid to init session). I don't know how do that..... thanks.

I have a Sql Express instaled at XP Prof. I need to avoid to the BUILTIN\Administrator to init session. Thanks

Does exist in C# a way to open a port ( LPT, COM ) like C++ fopen method?. f = fOpen( "LPT1", "w") I tried with... TextWriter tw = new StreamWriter("myFile.txt") but if I change myFile.txt with LPT1 I have this error, "filestream can't open win32 devices, like partitions or tape uniteds" why? thank you very much

JA!, Thank you for the postulation, ..have hard fingers...

Ohh, yes, excuse me about the mistake. Thank you very much

simple, mydataset.mydatatable[0].mycolumnName....

How to centre a datarowview column heather? thanks

Ok, thanks. I looking the way to have a low cost at the network traffic, and refill method isn't help me. I need the users have the real product amount if others make an invoice....

Yes Dave. This is the question. and sorry if it was ununderstandable. Thank you very much....

If I have 2 datasets in which an updating to a table at dataset1 perform changes to the other table at dataset2... How to update this changes at Dataset2?. Must use tableadapter.fill( dataset2.mytable); does exist other way than refill?. thanks...

At VC++ I've used the pretranslateMessage to change tab key by enter key to move between the controls. How to do it in c# windows form? thanks

I solved it that way... mydataSet.mytable[myBindingSource.Position].SetmyIntFieldNull(); Thank you very much...

yes, when compile have this error: "cannot implicitly convert type 'System.DBNull.value' to int"

How can assign a null value to a field that is integer but allows null value.? int? nullval = null; mydataSet.mytable[myBindingSource.Position].myIntField = nullval ; isn't found.....

Which is the elemental code for searching in a datagridview column?. How to give the focus at the row with the value found?

The following code is an ATL OLEDB Consumer Assesor. I need to Add to it the IRowsetIndex::Seek to perform a Seek. How I must to modify my code to permform it?. Thanks a lot. #ifndef __DBOITEMPROV_H_ #define __DBOITEMPROV_H_ class CdboItemProvAccessor { public: TCHAR m_Articulo[7]; double m_Cantidad; double m_Gravado; BEGIN_COLUMN_MAP(CdboItemProvAccessor) COLUMN_ENTRY(1, m_Articulo) COLUMN_ENTRY(2, m_Cantidad) COLUMN_ENTRY(3, m_Gravado) END_COLUMN_MAP() void ClearRecord() { memset(this, 0, sizeof(*this)); } }; class CdboItemProv : public CCommand > { public: HRESULT Open( char* mySql ) { HRESULT hr; hr = OpenDataSource(); if (FAILED(hr)) return hr; return OpenRowset( mySql ); } HRESULT OpenDataSource() { HRESULT hr; CDataSource db; CDBPropSet dbinit(DBPROPSET_DBINIT); dbinit.AddProperty(DBPROP_AUTH_CACHE_AUTHINFO, true); dbinit.AddProperty(DBPROP_AUTH_ENCRYPT_PASSWORD, false); dbinit.AddProperty(DBPROP_AUTH_MASK_PASSWORD, false); dbinit.AddProperty(DBPROP_AUTH_PASSWORD, ""); dbinit.AddProperty(DBPROP_AUTH_USERID, "Admin"); dbinit.AddProperty(DBPROP_INIT_DATASOURCE, OLESTR("S:\\NuevoSis\\Principal\\Principal.mdb")); dbinit.AddProperty(DBPROP_INIT_MODE, (long)16); dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)4); dbinit.AddProperty(DBPROP_INIT_PROVIDERSTRING, ""); dbinit.AddProperty(DBPROP_INIT_LCID, (long)1033); binit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false); //hr = db.Open(_T("Microsoft.Jet.OLEDB.4.0"), &dbinit); hr = db.OpenWithServiceComponents("Microsoft.Jet.OLEDB.4.0", &dbinit); if (FAILED(hr)) return hr; m_session.Close(); return m_session.Open(db); } HRESULT OpenRowset( char* mySql ) { // Set properties for open CDBPropSet propset(DBPROPSET_ROWSET); propset.AddProperty(DBPROP_CANSCROLLBACKWARDS, true); propset.AddProperty(DBPROP_IRowsetChange, true); propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE); propset.AddProperty(DBPROP_IMMOBILEROWS, true); return CCommand >::Open(m_session, mySql, &propset); } CSession m_session; }; #endif // __DBOITEMPROV_H_

Thank you very much!

I'm working in VC++6. How can i do to set the cursor in a row position of CLisCtrl? That way, if the user press down or up arroy the movement starts from the designated position. I can use the CListCtrl.EnsureVisible( iPos, TRUE) to ensure visibility but the movement starts from the begin. Thanks a lot.

Thank for your reply. The SUBCLASS change the background color by the mouse movement. I need to change the color when it was focused by mouse or tab order. Could you help me? Thanks

Does exist a simple way to change the background color of edit and button ctrls when has the focus? thanks VC6++