Joe_Elwell's Q&A profile

• SQL Server Importing data using WebService

  Hello, i'm searching a way to update data using a web service. For example, i want to store the temperature of cities in a database. I have a table with all the cities and an other table storing the temperature. I have access to a web service that give temperature for the cities... i hope you understand what i want to do... ;-) thanks a lot Hi all, I am using the web service task with XML source to insert data from a web service into an SQL Server database. But I have a problem with the XML output from the Web Service Task. It looks li this: < xml version="1.0" encoding="utf-16" > <ArrayOfBooking xmln ...Show All

• Visual Studio Tools for Office Conflict between Word and Outlook

  Hi, I hope you guys can help me with this problem: I have a couple of VSTO customized Word Templates that create Outlook objects as part of their normal functionality. When I close and reopen this templates, the logic in the document behaves in a really weird way: Some controls won't work, some initial events are skipped, basically the action pane becomes useless... I have seen this kind of problem before, caused by the Word instance that Outlook creates to edit mail, appointments, etc. It gets solved by closing the extra Word process in the Task Manager or by closing Outlook completely, but that's something that a normal user may n ...Show All

• SQL Server isnull() Problem

  Today we get a call from one of our customers. One of our Apps gets a time-out error from SQL Server 2000 (SP4). After searching we get the following result: This instruction becomes never finished (>30 Minutes waiting) select isnull(T025.C048, '') as [int. Vermerk] FROM T025 ... This statement is ok (1 Sek.) select T025.C048 as [int. Vermerk] FROM T025 ... C048 is varchar(10) nullable The value of the field was "WNO" - not null. After creating an index with the field C048 the problem was solved. What happend Thanks. Other columns did not had problems with isnull() and we did not test other fun ...Show All

• SQL Server deploy shared datasources

  Is there any way to deploy a report to the server and not have to reconfigure its reference to its shared data source For instance, if in the development environment my report is pointing to a data source called "MasterDB", and i deploy the RDL file to the server which has a data source called "MasterDB", it doesn't recognize the server-side data source. It informs me shockingly, inaccurately that " The data source connection information has been deleted. (rsInvalidDataSourceReference)" I have to go into the report properties and re-bind it manually. Any thoughts on how to avoid this unnecessary step - Ian I believe you're rig ...Show All

• Visual C# Enum question C# and VB

  Why this code in C# not work but in VB work Code C#: public enum eFilteringCode : ulong { None = 0, Gen = 1, BdF = 2 } static void Main( string [] args { int BitMask = 400; ulong uRes = BitMask & eFilteringCode. Gen; } Code VB: Public Enum eFilteringCode As ULong None = 0 Gen = 1 BdF = 2 End Enum Sub Main() Dim BitMask As ULong Dim uRes As ULong BitMask = 400 uRes = BitMask And eFilteringCode.Gen End Sub If i write in C#: ulong uRes = BitMask & (ulong) eFilteringCode. Gen; it work but i dont'want make a cast, buy ...Show All

• Visual Studio Express Editions the code has some problem

  Hi, I am using VB express 2005 to create an interface to retrieve data from Excel spreadsheet then store it into my Access database. I am able to retrieve data and store it in a dataset then display it in a dataGridView. But I am not sure how can i store the data into an Access database. I tried to connect VB to Access by opening a connection and then create a table in Access. I created a DataGridView and bind it to this table. I can do normal insertion, deletion to the table. But when i change the content of the dataGridView to my spreadsheet by writing some code then do the normal save as usual, the content in the ...Show All

• Visual Studio Help me ! VBControlsEvents

  I write my addin in Visual Basic 6.0 and use VBControlsEvents to handle the control when I at it to my form. (like CodeSmart for VB)(control spy) But where i create my addin in VS.NET 2003 i can't find the event that handle like it can any bodyhelp me. PS: if you use CodeSmart.NET, when you drag a control to your form, it display a dialog box. I want to make it, but with my dialog box. Thank ! Email me: vanphuoc1978@yahoo.com or vanphuoc@gmail.com I finally figured it out.... I was surfing through the various msdn references when I happened upon the IComponentChangeService interface.  This allowe ...Show All

• SQL Server Default Value of Parameter using expression - ERROR!

  Try to get the parameter from a query not an expression ...Show All

• Windows Forms extend combobox control

  I'm trying to write an application that uses a combobox to display a list of locations.  When the user selects a location from the list, I need to display a treeview of parent and children locations.  Does anyone know of a way to extend the combobox control to include the tree view control like this.  It would look similar to the DateTimePicker control as to when you click the drop down, the calendar pops up, but in this case I need to display a treeview in the list rather than a calendar. Thank you ...Show All

• Visual C++ Module handle in C++/CLI library

  How can I found current module handle (HMODULE) in C++/CLI Class Library. I need it to load data from Dll resources. My guess is that it is possible to do using Marshal::GetHINSTANCE(Module^) function, so I need to find Module of current Dll. Thanks, using Type class is much better, doesn't require module name: Module^ module = this->GetType()->Module; ...Show All

• Visual Basic Context Menu....

  OK, so I have a context menu that contains two options - a TextBox and a (Submit) option...it pops up when a user right clicks a radio button on my form. I want the user to be able to enter a string in the textbox, click the (Submit) option, and have the string replace the current text of the radio button. It works easy for one Radio Button, but I'd like to have this functionality available for several components. Aside from creating a separate context menue for each component (very time and space consuming), is there any way to refer to the object from which the context menu came from when writing the (Submit) option's code, so that I ...Show All

• SQL Server Database file and log

  Hi, I am just about to get familiar with SQL-Server 2005. Since I created a database and played a little with it I recognized that the database file has grown up to 150 MB as well as the log file. I used the shrink task to resize the database file. After doing so the .ldf remained as it was (150 MB). Since I would not need log information stored there, is it possible to shrink the ldf-file as well Thanks for your help! Thanks to both of you I could finally learn something about the log files and also resolve my problem. ...Show All

• Visual Studio 401 unauthorized. when selecting dropdownlist

  Hello, I am using reportviewer with impersonation according to this blog http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx I can see the reports, but some of the reports have many dropdownlist for filters, when I select one, the another one must be refreshed with the contents filtered depending on what the user selected on the first dropdownlist, it worked perfectly on reportmanager, but with reportviewer and impersonation it gives me again that error. 401 unauthorized. Thanks This is the actual code, but what I think is that I should send credentials on a reportviewer event, like load or refresh what do y ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XMA on windows?

  Now that the Feb SDK XACT is out, I see it now supports ADPCM. However, we would really like the Windows XACT to support XMA format on PC (like it does on Xbox360). We need the better compression rates that XMA gives over ADPCM. Is there any chance of this happening, or is XMA something Xbox-specific that will never be available on Windows Here's a more detailed response from Chuck Walbourn, one of our engineers, on the directx audio USENET newsgroup: The PC platform does not have the acceleration hardware present on the Xbox 360 for making XMA (a form of WMA) a practical solution for general sound e ...Show All

• Visual C# Foreach loop

  Dear All, I had this for each statement that used to grab the cell value for the column. But after I execute this statement, it give me an error Error 2 'System.Windows.Forms.DataGridViewRow.Cells' is a 'property' but is used like a 'method' Does anyone know what is the problem Thanks foreach (System.Windows.Forms. DataGridViewRow dgv in dataGridView1.SelectedRows) { MessageBox .Show(dgv.Cells( "Txn Time Stamp" )); } Hey, Yeah, () is a method notation in C#, [] is a property notation. () for properties is used in VB.NET. ...Show All