Mike Lapierre's Q&A profile

• SQL Server model databases

  Hi, When i create a new table in Model database how can i automatically create table in other user databeses. Thanks for your answers FYI, any object you create in the model databas will be automatically created in any user database you create in the future. So say, you create a table named Table1 in your model database, there will be a table named Table1 in all the user databases you create after that ...Show All

• Smart Device Development Type of file problem

  hi all, this might a simple question for u all, but i m not getting any way to find the solution. Actually i want to make it out whether the file is video file, audio file or simple image file. I dnt how i can get the type of the files. plz help needed. thanx in advance hye_heena wrote: hi all, this might a simple question for u all, but i m not getting any way to find the solution. Actually i want to make it out whether the file is video file, audio file or simple image file. I dnt how i can get the type of the files. plz help needed. thanx in advance you need to be a little more specific about your context ... do you already have a FileInfo object if so, get the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Ray - Mesh intersection

  Hi. Here i have some simple room and moving camera: Now I am searching for something like D3DXIntersect() to check intersection with mesh, not with simple b-boxes, but now all i can find is Intersects() with planes and bounding-things. Maybe i missed... or there are some other solution As you can see Boundingbox would not help a lot (i guess) , because there are a door hole, where camera should pass-through. I would try to check multiple ray to mesh intersections from camera's eyePos to 6 directions ( forward, back, left, right, up and down) for camera movement control, but not unless a principle is found Any ideas P.S. Thanks XNA Dev. team for Beta 2. ContentPipeline & X files rocks! The simplest way is perhaps to subdi ...Show All

• SQL Server how to delete object Data Source for local (rdlc) report?

  I've created a couple of data sources and now would like to remove one on a local (*.rdlc) report, how do I go about doing this Just to clarify, these data sources are for a local report in a smart client application (report made in VS2005 Report Designer, and not SQL Server 2005 Report Designer), they are found in the report's Data Sources window (not the applications) and can be accessed/assigned by the local report (Report > Data Sources...) - where you can remove the data source from being on the report, but not completely remove from the project. Any help is appreciated. Thanks. Peter Sorry, it was a newbie question. Found why I couldn't delete the extra data source, it was an XSD data source that ...Show All

• Windows Forms moving without border

  'Place this code anywhere on your form code # Region " ClientAreaMove Handling " Const WM_NCHITTEST As Integer = &H84 Const HTCLIENT As Integer = &H1 Const HTCAPTION As Integer = &H2 Protected Overrides Sub WndProc( ByRef m As System.Windows.Forms.Message) Select Case m.Msg Case WM_NCHITTEST MyBase .WndProc(m) If m.Result = HTCLIENT Then m.Result = HTCAPTION 'If m.Result.ToInt32 = HTCLIENT Then m.Result = IntPtr.op_Explicit(HTCAPTION) 'Try this in VS.NET 2002/2003 if the latter line of code doesn't do it... thx to Suhas for the tip. Case Else 'Make sure you pass unhandled messages back to the default message handler. MyBase .WndProc(m) End Select End Sub # End Region it move only if i click on form but i wan ...Show All

• .NET Development failure in reading updated app.config file from windows service

  i have a program which runs as a windows service under the local service account. it updates settings in a customized configuration section in its app.config (servicename.exe.config) file before shutting down. during the next startup, it is supposed to see the updated values from the config file but instead it still sees the default values. i noticed that files with extensions .newcfg and .tmp are being created in the exe root dir whenever the service shuts down. .newcfg does contain the updated values for the settings. however, the service process is not reading settings from these files. also, filemon shows that the service is trying to access servicename.exe.local dir which does not exist. what is causing the problem ms-help ...Show All

• .NET Development Trying to get access to Access DB from VB.Net application

  I am trying to get access to an Access database from within my VB.Net application with the following: Dim oAccess as Access.Application My problem is that Access is not recognized. When I try the above statement I generate the following error "Type 'Access.Application' is not defined." I am using Visual Studio 2005 (VB.Net) and have added the following references in my project: Microsoft Access11.0 Object Library Microsoft ADO Objects 2.5 Microsoft DAO 3.6 Obj Library Microsoft Office 11 Obj Library Microsoft Visual Basic for Applications Extensibility With the above added, I still get the same error. Thanks Hi, I have tried similar, but on a web page and it works fine. My code in ...Show All

• SQL Server call C++ ATL COM from C# SSIS

  Hi All, Is it possible to call methods of C++ COM ATL component from C# SSIS component I did try to call methods of C++ COM ATL component and C# library inside my SSIS but without success :-( Regards, Svilen Varbanov Sure, but you have to build the interop assembly with tlbimp.exe. http://msdn2.microsoft.com/en-us/library/1w557csx.aspx Kirk Haselden Author "SQL Server Integration Services" ...Show All

• .NET Development Are / Will Generic Type-less Conversions be supported?

  What i can do with non-generics is: object o = SomeFunctionReturningSomeObject(); if (o is ICollection) { ICollection c = (ICollection) o; object [] oArr = new object [ c.Count ]; c.CopyTo( oArr, 0 ); } This lets me access the functionality of the ICollection without knowing exactly what the object is. However, with Generics, i would like to do the same thing but without knowing the parameterized types: object o = SomeFunctionReturningSomeObject(); if (o is ICollection<>) { ICollection<> c = (ICollection<>) o; foreach ( object o in c ) // do something with "o" } but this is clearly not valid C#. How does one accomplish this type of activity in C# or is it ev ...Show All

• Visual Studio Does ReportViewer run in Medium trust ?

  Hi guys. Just wondering if this thing runs in Medium trust, haven't found anything about it anywhere on internet. If not , are there any workarounds Regards. ademar yeah, just tracked the culprit here : private ReportSnapshotBase Snapshot { [PermissionSet(SecurityAction.Demand, Unrestricted=true)] get { return this.__ReportSnapshot; } [PermissionSet(SecurityAction.Demand, Unrestricted=true)] set { this.__ReportSnapshot = value; } } ...Show All

• SQL Server Amateur :: Connections

  hi to you all... i need some help with SSIS... i need some examples to transfer data from one server to another via web ... can anyone help with this ' thx to all Start with this - build an extract process to pull the data into a flat file, run a FTP process to send the flat file to a new server, and then a load process on the remote server to load the data in the flat file. ...Show All

• Visual Studio Express Editions form.controlcollection?

  Hi.. I would like to know if it is possible to pass the value of the textbox created from form.controlcollection.add method to another form i mean... in main form textboxes are created accordingly in response with the user selection by using addcontrol() function. and i want to use those textboxes to use as reference value in next form. Is it possible or I just have to create textboxes manually Thank you. thank you. How can i set the name property uniquely those textboxes that i created programmatically, how i can set their name so that i can call for those textboxes in another form ...Show All

• Visual Studio 2008 (Pre-release) using an image as button content

  Hey guys i'm to display an image on a button using the following code but i get an IO exception. Uri uri = new Uri("pack://application:,,/410voefe.jpg"); BitmapImage bitmap = new BitmapImage(uri); Image img = new Image(); img.Source = bitmap; img.Stretch = Stretch.None; Button btn = new Button(); btn.Content = img; btn.HorizontalAlignment = HorizontalAlignment.Center; btn.VerticalAlignment = VerticalAlignment.Center; Content = btn; I've added the jpg to my project as an existing file and i've changed it's Build Action to "Embedded Resource". Thanks for any help! I've added the jpg as an existing file into the project and ...Show All

• Visual Studio Express Editions VB Express

  I am an owner of VB6 Pro but have not used the application in over 2 years. I develop mostly PHP and HTML applications today for my own personal business and my customers. I would like to develop applications using VB 2005 Express that I can sell and distribute. VB6 (if I remember correctly) contained an EXE compiler but a runtime file ( ) had to been included with the EXE file in order for it to function on a customer's PC. Does the free version of VB 2005 Express contain an EXE compiler and does a runtime file have to be included with the compiled EXE file in order to run on a customer's PC Thanks for any input on this topic. Terry VBC.exe is the command line compiler and it ships with t ...Show All

• .NET Development More on Multithreading and Sychronization

  Since Threads of a higher priority will normally preempt lower priority threads, Is there a means of guaranteeing that a section of code executes from beginning to end without preemption What if the higher priority thread wants to access the section of code which it preempted. You will have a deadlock situation. The higher priority thread will simply block, giving the lower priority thread enough CPU time to finish its job and release the synchronization object. The Windows thread scheduler uses temporary priority boosts to solve priority inversion problems that can occur when multiple threads interact with each other, you'll find it described in this KB article . ...Show All