Samer Selo's Q&A profile

• SQL Server Updating a View

  Can someone direct me to information (DML on a view) I created a view and wanted to know if it is possible to run an update, delete, etc... on the view.... thanks, Jonathan Yes, this is possible, but you have some restrictions on the view if you use several commands. Then you will have to use instead of triggers to make the DML operations work. Updatable Views You can modify the data of an underlying base table through a view, as long as the following conditions are true: Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table. (more in ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/aecc2f73-2ab5-4db9-b1e6-2f9e3c601fb9.htm ) HTH, Jens K. Suessmeyer. --- ...Show All

• Visual Studio ActiveDocument.Selection.Text Error when editing c++ files

  I created and used this macro with Visual Studio 2003 but with Visual Studio 2005 it does not work. I have removed most of the macros contents to show the bug with ActiveDocuement.Selection.Text Macro Contents Line 1 Sub Upgrade_File_To_ACE_TEXT() Line 2 Dim lOriginal As String Line 3 Dim lNew As String Line 4 DTE.ActiveDocument.Selection.SelectAll() Line 5 lNew = ActiveDocument.Selection.Text Line 6 ActiveDocument.Selection.Text = lNew Line 7 End Sub C++ File Contents // This software contains confidential information, trade secret information // and/or know-how which is the property of xxx Corp. The problem is with line 6. When it encounters a c++ comment line with a comma in it crashes with error 0x80004 ...Show All

• Visual C++ Convert LRESULT to LPCWSTR in c++

  I am working on windows mobile 5.0 ,compact framework I want's to show a LRESULT in the message box. But as message box can only show LPCWSTR. So please provide me a routine to convert LRESULT to LPCWSTR so that I can show it in the message box. LONG lr = RegSetValueEx(hKey, NULL, 0, REG_SZ, (LPBYTE) wszValue, (lstrlen(wszValue) + 1) * sizeof(TCHAR)); wchar_t buf[20]; _itow_s(lr, buf, 20, 10); MessageBox(0, buf, L"Register 2", 0); ...Show All

• .NET Development Best way to update a MS Access database

  Hi, I`m using a MS Access 2003 database to connect from within my csharp code. I`m using the default design-time generated TableAdapter. Is there any way to understand if an update was successful When I insert a new record into one my tables in access database, how can I be sure that it is correctly inserted Is there any possibility that the record can not be inserted or updated, or the operation can be broken after some of the values are correctly inserted or updated but NOT all and no exception occures in the try catch block of my code where I execute these update or insert statements Shortly, what is the best way to update a database especially when you are using multiple linked tables and you need a return value from ...Show All

• Smart Device Development Hide the start menu

  Is it possible to hide the start menu. I don't mean the button but the actual menu. On IPAQ PDA's there's a Windows key which opens the start menu. I don't want it to function, but I do not want to capture the key event. I just want tot diable the whole startmenu altogether. Maybe I can somehow tap into a system WndProc and stop the start menu message from occuring I hope anyone has a solution. Thank you, greetings, Marc Selman Is the SHFullScreen Win32 API call of some use to you http://msdn2.microsoft.com/en-us/library/aa453694.aspx http://www.experts-exchange.com/Operating_Systems/WinCE/Q_21147450.html http://forums.devbuzz.com/Hide_Start_Button_-_help/m_33718/tm.htm http://www.pcreview. ...Show All

• SQL Server trapping Package Validation Error

  Hello, I created a new SSIS Package. I want to send an e-mail when an error occurrs. I set the OnError event to send an e-mail. I then decided to test this so I dropped my input SQL table. When I drop the import SQL table I get a Package Validation Error and I don't get my e-mail. Am I making a mistake. I want to always send an e-mail when an error occurrs in my SSIS package. By the way I did add an e-mail at the end of my SSIS package to verify my SMTP is working - it did. Thanks, Michael Steven Scholl wrote: Jamie, We have been using SSIS now for 6 months in a production environment to load our data warehouse. We have converted 40 of 120 DTS packages from SQL Server 2000 to SQ ...Show All

• Windows Forms BindingSource, DatagridView and Regional Settings

  Hi everybody, I would like to know how I can change display on my datagridview according to the regional settings of the computer I'm looking for the equivalent of this dataTable.Locale = CultureInfo.CurrentCulture but for a datagridview. Here's a piece of code : Public Overridable Sub DisplayData(ByRef ObjectList As Object) bsParam.DataSource = ObjectList dgvParam.DataSource = bsParam bsParam is the bindingsource, dgvParam is the datagridview. Any idea Not exactly; I want to change display in the datagridview so that it applies current culture info. I.e., I've set culture to "en-GB", so numbers should be displayed like 123 456.00, but are displayed 123456.00 (it's trimed and ...Show All

• Visual Studio Express Editions Play audio files "vbExpress"

  Hi how can I play audio files with (.mp3 or .wma) extensions without WindowsMediaPlayer Control for example: open file from specific location and clicking on button, that must play the Selected file. Even now I only can do this with (.wav) files. If someone knows how to do this, I would appreciate. Thanks Is there any reason why you dont want the media player control you can simply hide the UI of this control and still use the functionality ...Show All

• Visual Studio Reporting Services Culture

  Hey Guys I'm using VS2005 to build an RDL report in Reporting Services, and set it's language to en-US, my browser language setting is US, and when I run it from Report Manager it works fine with US date formatted parameters. When it's run with report viewer from an aspx/c# app, it only accepts en-UK date parameters. The params are setup within the report as datetime. When running the app, the browser language shows as US. Ultimately I'd like to set the report's language to user!language to allow globalization. Any ideas what I've missed here Thanks in advance Martin The viewer uses the thread culture to display and parse parameters. Report Manager sets System.Threading.Thread.CurrentThre ...Show All

• Visual Studio 2008 (Pre-release) Why LINQ will succeed

  1. LINQ syntax beats SQL syntax. SQL is flawed in that queries become exponentially difficult to write as their complexity grows. LINQ scales much better in this regard. Once you get used to it, it's hard to go back. 2. Database queries are easily composable. You can conditionally add an ORDER BY or WHERE predicate without discovering at run-time that a certain string combination generates a syntax error. 3. More bugs are picked up at compile-time. 4. Parameterization is automatic and type-safe. 5. LINQ queries can directly populate an object hierarchy. 6. LINQ to SQL provides a model for provider independence that might really work. 7. LINQ significantly cuts plumbing code and clutter. Without sweeping stuff under the carpet, like Workflo ...Show All

• Visual Studio Need help developing a COM Add-in for Word(Office XP)

  Hi all, I created a "Shared Add-in" project in Visual Studio .NET 2005 and tried to develop a simple hello world COM add-in for Word. After created the project, it automatically generated another setup project and this is good. Then I added a reference to the Word Interop Assembly in the Add-in project and confirmed that the DLL file actually references to assembly in windows\assembly folder. Since I just want to make sure that Word can connect to this COM Add-in, I simply added a statement MsgBox("hello world.") to every event that appears in the default Connect class. Then I built both the add-in project and the setup project and right-clicked on the setup project and selected "Install" to install the add ...Show All

• Visual C# Variant in C# ?

  I’m coding in C# and I am working with a COM object that I earlier in C++ made this call: COleVariant varBeforeEnd(DISP_E_MEMBERNOTFOUND, VT_ERROR); hresult = pTemp->Add(knownObject, &varBeforeEnd ); How do I make the call in C# The IDE in VisualStudio say that the Add(…) function should have parameters like this: Add(KownObject, ref object); Any tip what to do with the second parameter I’ve tried to block some primitive types like int and bool to an object, but I only get exceptions… All tips are welcomed! Have you tried the IntPtr type it has been designed specifically for interop. ...Show All

• Windows Forms render a bitmap DC works but displayed image is in monochrome?

  Render image to DC works but it is displayed as monochrome I do not understand why the DC is not being set to a compatable bitmap. It seems like the DC is retaining its original monochrome aspect Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim document As IHTMLDocument2 = CType(Me.AxWebBrowser1.Document, IHTMLDocument2) Dim element As IHTMLElement = CType(document.body, IHTMLElement) Dim render As IHTMLElementRender = CType(element, IHTMLElementRender) Dim PointerToDC As IntPtr = CreateCompatibleDC(PointerToDC) Dim PointerToBitmap As IntPtr = CreateCompatibleBitmap(PointerToDC, Me.AxWebBrowser1.Width, Me.AxWebBrowser1.Height) SelectObject(PointerT ...Show All

• SQL Server Trouble upgrading an MSDE 1.0 engine to SQL Express 2005

  I am creating an install for our product and as part of the changes I am making, I want to upgrade a user's DB engine, if they are still using MSDE 1.0, to SQL Express 2005. The upgrade path we have chosen is the following..... MSDE 1.0 --> MSDE 1.0 sp4 --> SQL Express 2005 I believe this should work, yes Anywho, I am trying to run a "passive" install of SQL Express and I am using the following parameter list: /qb UPGRADE=SQL_Engine INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SQLAUTOSTART=1 SQLBROWSERAUTOSTART=1 SQLACCOUNT="NT AUTHORITY\SYSTEM" SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM" When SQL Express is installing, everything installs ...Show All

• Visual C# HELP - How to Read/Write a text file at the same time?

  How can I read and write a text file(same file) at the same time I'm getting an error of "this file is being used by another program".. I have a text log file and logs being written to it, simultaneously I want to read its concent and show them on a RichTextBox. How can I achieve this Thanks you can't... The best you can do is try to make your writes/reads as fast as possible so that there are no collisions - but it might be dangerous (your app may be prevented from writing by your reading). You'd have to create an alternative scheme - like writing logs to database, use TraceListeners or periodically changing your log file. ...Show All