Denis Pitcher's Q&A profile

• SQL Server Loading excel file(.xls) into sqlserver (ASP.net web application)(ASP.net framework 1.0)

  I am using framework 1.0 to do the above tasks. Since there is no fileupload function in .net 1.0, i will be using the html control tools (file field) to do the upload option. i have totally no idea of how to start coding it...can anyone guide me through the steps thanks i found the following codes, hardcoding the datasource file for the excel file seems to worked... but i couldn't select and upload random files...(random means through the file selection screen...) 'Import by using OPENDATASOURCE. strSQL = "SELECT * INTO XLImport6 FROM " & _ "OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', " & _ "'Data Source=C:\test\xltest.xls;" & _ &quo ...Show All

• Windows Forms Adding image/icon to context menu

  I tried, and this sounds extremely simple but I couldn't find any information on the net. Is there a way to add an icon to a context menu in VS .NET 2003 You will have to OwnerDraw the menu in VS2003. You should find lots of examples of ownerdraw menuitems on the web. http://msdn.microsoft.com/msdnmag/issues/04/02/CuttingEdge/ There is a MenuSkinner component on my site which will extend all menuitems with an Image property and automatically ownerdraw them. http://www.dotnetrix.co.uk/controls.html ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Requires Visual C# 2005 Express

  Every machine I own has a copy of Visual Studio 2005 Team Developer or Professional on it. Do I have to remove VS2005 Pro in order to get C# express and GSE installed, or can I install express side-by-side with VS2005 Pro/Team so I can work on GSE on one of my machines I didn't see this addressed in the FAQ. Can you let me know if it worked for you. It nerfed my configurations in 2005 pro. Ah. No worries. I got my problem solved. Jamie ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to detect version of D3DX installed?

  With the newer versions of DirectX there are several different D3DX dlls that exist. Just checking for DirectX version 9.0c is not sufficent as that version contains several revisions of the D3DX dlls. If a game ships with the April release the earlier versions of DirectX 9.0c will not work. How can the exact installed version be determined So, apparently there is no way to determine the version using DxDiag What about file version of d3d9.dll I was thinking of checking that. I guess there is no harm in just looking for the D3DX9_30.dll but it just seems like the DxDiag should support this. ...Show All

• Internet Explorer Development IE7 HP Director Problem

  I also tried the HP software workaround for my sj4570c. It did not work for me. I tried everything I could, I had both versions of HP software(v1.2 & 7.0 ) installed, tried all the patches, got the "HP Solutions" to open the HP Director, then I still got error messages prompting me to re-install the software. The basic scanner functions worked ok. I could not get the scanner to work thru the HP Director with IE 7. I need my HP director to work and it does after I uninstalled IE 7. I like the features on IE 7. I I like the featuresof the HP Director. I am stuck between HP and MS lack of support. I am getting tired of the lack of support and uncompatable upgrades from MS. I may give FireFox a try. Anyone know of an other s ...Show All

• Visual Studio Express Editions Can't connect to database when trying to create report

  I am trying to create a report for a program I wrote in VB Express using a SQL Express database. I go into Visual Studio and Create New project. I give the project a name. I go to Project, Add New Item, and select Data Source. I select the current computer as server. I use Windows Authentication and I try to attach the database. When I test the connection string I get the error "An Error has occured while establishing a connection to the Server. When connection to SQL Server 2005 , this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, Error 40-Could not open a connection to SQL Server)" I can connect in Visual Basic and SQL Server Man ...Show All

• SQL Server MultiFile Connection Manager

  Hi, how can i use a MultiFile Connection Manager Thanks, Willfried When using it, you can set the ConnectionString property to something like: C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\CaptureDataLineage Sample\DataFiles\*.txt. Then, it'll loop through each file in the directory and load the file and perform your function. You can see an example here in this directory: C:\program files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\CaptureDataLineage Sample. -- Brian ...Show All

• SQL Server Report Manager toolbar question...

  Hi everyone, I just inquiring if the 'My subscription' toolbar at the upper right portion of the report manager can be removed or shall we say hide... If possible, how to remove please help... Another question is when you click the show details button, the option to delete and move appears but it is initially disabled...is there a way also to hide the move button thank you very much...hope to have any response or advice as soon as possible...thanks hi Thanks for the info, as i browsed it it did help me understand but my concern is i guess not the focus of the disscussion of link you sent. to have a clearer view of my problem, ill try to insert a screenshot here...hope you have more infos to share...thanks dude! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MouseState.ScrollWheelValue always 0

  Hi, I want to use the mouse scroll wheel to zoom. In the tutorials I have tried, MouseState.ScrollWheelValue works fine, but in my own test program it always returns 0. The main difference I can think of in my test program is that I am not using the Game class. Instead I create my own GraphicsDevice and use a standard System.Windows.Form. Is there any initialization I have to do for MouseState.ScrollWheelValue to work This is the code for reading mouse state. All of it works, except mouseState.ScrollWheelValue which always returns 0. MouseState mouseState = Mouse.GetState(); myMouseLocation = new Point(mouseState.X, mouseState.Y); myIsLeftButtonPressed = mouseState.LeftButton == ButtonState.Pressed; int currScrollWheelValue = m ...Show All

• Windows Forms host usercontrol on a modal child form?

  I just set the Mainform's 'IsMdiContainer' property to true but when adding the following code to a tab controls selectedIndex changed event, the form does not appear. Any ideas Can I do this (successfully) Can I simply change this formerly NonMDI app to on that supports modal forms thank you. -greg NewMDIChild.Controls.Add( Me .UserControl) NewMDIChild.Location = New System.Drawing.Point(100, 100) NewMDIChild.Size = New System.Drawing.Size(400, 200) NewMDIChild.Visible = True NewMDIChild.TopMost = True NewMDIChild.Show() Just an idea... MDIChild form opens inside its parent form... Does the parent form have any controls put on it so it couldn't show the child form Opened child f ...Show All

• Visual C++ check image

  How to know there is an image in a given .doc file I think this question is not in the scope of the forum. Please post the same at Office Solutions Discussion groups. http://msdn.microsoft.com/newsgroups/topic.aspx url=/MSDN-FILES/028/201/008/topic.xml ...Show All

• Visual Studio Express Editions Can I................

  Here's the deal, one of the features of the program that I am creating is that it will (or should) have the ability to send a page out (to a pager). Again I am not asking how (at this point), just want to make sure that I can do this. And while I have everyone's attention, my program is coming along quite nicely, have the user interface done, database is connected, will have the database completely setup by Friday (hopefully, if my four year old doesn't make me do another all day "daddy come watch power rangers with me"), so looks like my first (and I do mean very first functional) program will be completed by the end of the month (go new guy, its your birthday). Thanks in advance for all the help. Well we do already use a w ...Show All

• Visual Studio Express Editions Getting an Error when I use the Backspace to clear a textbox

  Hey all, When I test my code out, enter a number then backspace all the way back to the beginning i get an InnerException error. Here is the code that is throwing the error: Private Sub txtSequenceNumber_TextChanged( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles txtSequenceNumber.TextChanged Dim SequenceNumberSelect As Integer = CInt (txtSequenceNumber.Text) Sequence2 = SequenceNumberSelect End Sub Above this I have a keypress event that spots the backspace....but I still get an exception when I backspace and lcear out all the numbers. Thoughts, Ideas, Links Thanks ahmedilyas wrote: ye ...Show All

• SQL Server 2005 SP1 select @@Version

  I applied SQL Server 2005 SP1, everything appeared to run successfully but if I run select @@version, the version number did not update. I still see 1399 not 2047. Here is the last part of the hotfix log: 10/09/2006 22:50:05.646 Product Status Summary: 10/09/2006 22:50:05.677 Product: SQL Server Native Client 10/09/2006 22:50:05.693 SQL Server Native Client (RTM ) - Success 10/09/2006 22:50:05.708 10/09/2006 22:50:05.739 Product: Setup Support Files 10/09/2006 22:50:05.771 Setup Support Files (RTM ) - Success 10/09/2006 22:50:05.786 10/09/2006 22:50:05.818 Product: Database Services 10/09/2006 22:50:05.849 Database Services (RTM 1399 ENU ANNCL02DB01) - Success 10/09/2006 22:50:05.864 10/09/2006 22:50:05.989 Product: Notificati ...Show All

• SQL Server Blocked transaction problem

  Hello, I am trying to execute next query, but when doing it, TABLE1 locks and it does not finish. SERVER2 is a linked server. BEGIN TRAN INSERT INTO TABLE1 SELECT * FROM SERVER2.DATABASE2.DBO.TABLE2 WHERE TAB_F1 IS NULL COMMIT TRAN I have same configuration in other 2 computers and it works ok. What is the problem Thank you!! Hello, if I run it without any transaction it finishes very fast. But I want to know the reason of the problem, because I have one place that runs it this way, and I can not install a new one with same queries. Thank you. ...Show All