Beyond Blue's Q&A profile
Visual Basic Infopath and Visual Basic 2005
I'm new to infopath, but i haveto say i like it. Is very simple to use to run queries rom sql data bases. But i was wondering if i could implemented on my visual basic application. Can I use infopath with visual basic Is there a way to open a form desgined by infopath within a visaul basic application Will I need to have infopath installed on the computers that open this form through visual basic im not an expert on this but perhaps try using the InfoPath SDK http://www.microsoft.com/downloads/details.aspx FamilyId=351F0616-93AA-4FE8-9238-D702F1BFBAB4&displaylang=en Implement this and use it into your solution. I believe the destination computers may well require the InfoPath app to be installed but do not quote me on ...Show All
Windows Live Developer Forums VEMap.AttachEvent("oncontextmenu", function) firing twice
I am trying to add a pushpin to the map by right clicking on it. I am using AttachEvent with oncontextmenu event. I notice the event fires twice for any function. Am i doing something wrong Here is the code sample. (the map is created as a response to a XHR request) var VEControls = Class.create(); VEControls.prototype = { initialize: function(){ var url = "/maps/defaultLatLong"; var opt = { // Use GET method: 'get', // Handle successful response onSuccess: function(req) { var latLong = req.responseText.parseJSON(); if(latLong){ map = new VEMap('mapHolder'); map.LoadMap(new VELatLong(latLong["lat"], latLong["long"]), 15 ,'r' ,false); map.AttachEvent("oncontextmenu" ...Show All
SQL Server Installing SSIS on 2k5 SP2 Instance?
I'm working on an SQL 2k5 / SP2 server and need to install SSIS. Can this be done without uninstalling SQL Thanks. ...Show All
SQL Server Multitable Select
I have 2 tables involved in a select statement that I cannot figure out quite how to do. Table 1- GroupedItems int SharedId int GroupId Table 2- SharedItems int SharedId int ItemId In Table 1 SharedId is unique In Table 2 ItemId is unique Table 1 represents all of a group's shared Items Table 2 matches a group of Items to a common sharedId Example Table 1 1 - 1 2 - 1 3 - 2 Table 2 1 - 1 1 - 2 2 - 3 2 - 4 3 - 5 What I am trying to do is have a select command where you would pass in a GroupId and it would select just one Item from table 2 for each SharedId If you were to specify Group 1 you would Get ItemIds 1 and 3 from Table 2, although its not needed that the results are the top items. You can use s ...Show All
SQL Server Job To Execute A SSIS Package Fails - The Command Line Parameters Are Invalid
I have created a job to execute a SSIS package located in the SSIS Package Store. When starting the job I receive an error. The history log reports: Message Executed as user: DOMHARRPROMAST\SQLMAIL. The command line parameters are invalid. The step failed. This is the command line: /DTS "/File System/DataWarehouse/AgencySCD" /SERVER ntharrsqlt500 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF What am I doing wrong I will add the additonal information to the bug report. I will also put a post on the agent forum. Just for your information, the domain account that is running the SQL Server Agent Service is the same account that the step is running under (I only have a choice to select "SQL A ...Show All
SQL Server XML Data Type - Illegal Characters
In my SQL app, I am converting a varchar(max) type, passed to a stored procedure, to an XML data type in the stored proc. I've noticed that if the contents of the varchar(max) string contains illegal XML characters (such as '&'), the conversion will fail. This doesn't surprise me, and I would expect that. My question is this. Is there any SQL function I can call, or some other method, that will convert all illegal XML characters to legal equivalents Thanks - Amos. Here's how I do it: create function encodeXml( @txt nvarchar(4000) ) returns nvarchar(4000) as begin declare @xml nvarchar(4000) set @xml = replace(@txt, '&', '&') set @xml = replace(@xml, '<', '<') set @xml = ...Show All
SharePoint Products and Technologies RollBackTask
Hi Ok, so i posted this on the wrong forum originally, i hope this is the right one... I am currently creating custom workflows for sharepoint using VS 2005 extensions for windows workflow foundation. I see there is a RollBackTask which indicates that one can roll back on a task that was previously done. Im looking for some documentation how this task should be used and what it is meant to do. I have searched around and have not been able to find any documentation on this. Any help would be appreciated. I really do need to know how this works as I need a way to roll back any tasks that have occured. Thanks for any help Neil ...Show All
Customer Care Framework Cannot open sample source code files in VS.NET 2003
I cannot load Microsoft.Ccf.Samples.Csr.AgentDesktop.sln solution . none of the projects given below are available in the my CCF setup .. Microsoft Visual Studio Solution File, Format Version 8.00 Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Microsoft.Ccf.Common.Logging", "..\..\Private\SourceCode\Microsoft.Ccf\Common\Logging\Microsoft.Ccf.Common.Logging.csproj", "{C5E18276-1F86-4357-B9F9-F1CF27E4265F}" ProjectSection(ProjectDependencies) = postProject EndProjectSection EndProject Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Microsoft.Ccf.Csr.Win32Api", "..\..\Private\SourceCode\Microsoft.Ccf\Csr\Win32API\Microsoft.Ccf.Csr.Win32Api.csproj", &quo ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Problems on resize
Hi, I’m the coordinator of Jad Engine, a MDX 1.1 open source 3d engine. We have had one bug around for several months that we are unable to solve related to resizing the device. At the start, we used SetAutoDepthStencil = true when creating the device, and there was nor problems with the resize. But nowadays we do it manually and SetAutoDepthStencil is false. But when we reset the device, the D3D debug tells us that one surface has not being liberated. That surface is the DepthStencil we just created, because if we don’t create it, the reset works. The Microsoft.DirectX.Direct3D.Device.IsUsingEventHandlers is set to false as we create ourselves the VertexBuffers in DEFAULT mode and that’s the only way that they don’t give us an error on th ...Show All
.NET Development Context menu shell extensions causing Explorer crash on Vista..help please..
Hi everybody, Upon developing a .net application which has to have support for Vista and , at some point plays with some context menu shell extensions, i experienced a very very weird problem..Here is the situation: The application was developed for .net framework v1.1.4322. It has to dinamycally create some context menu extensions for folders so, the class responsible with the context menu logic implements IShellExtInit interface, IContextMenu interface and offers implementation for all the methods of the interfaces..All the rules are correctly respected (like keywords for "mirroring" the COM interface by the .NET one, the interface and the implementing class GUIDS, the assembly registered for COM upon instalation, assembly stro ...Show All
SQL Server Subscriber database MUCH larger than publisher
I have replication setup between our main site and a remote one, and have recently noticed that the database at the remote site's .MDF file is about 3 times as large as the main site's. This doesn't seem to make sense since essentially all of our data is replicated between the two servers. Can anyone suggest why this might be happening and what is safe to do to shrink the remote file TIA Ron L Raymond and Greg Thanks for the responses. I will take a hack at shrinking it, probably tomorrow. Raymond - I took a look at the KB article, and the question that comes to mind is why would one database grow so much faster than the other when they are being replicated I think that is the part that makes the least sense to me. ...Show All
SQL Server EXECUTE AS , fatal exception
Hi There If i add a new sysadmin login and that login is a user in a DB. If i execute the command EXECUTE AS 'LoginName': I get the following error: SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process WHats up with this If my dbo for this db is linked to a sysadmin login i have no problem with EXECUTE as 'dbo'. WHy do i get fatal errors when trying to execute as a a login name that is sysadmin On the net all referencing to the fatal error have nothing to do with EXECUTE AS Thanx Hi Raul As luck would have it i am having trouble re-creating the problem. I am running MS WInder Server 2003 ...Show All
SQL Server SQLServer Performance to Queries
Hi, During my working with SQL Server 2000 sometime back in a enterprise application development, we found some performance bottlenecks and tried to resolve the same by following some rules. 1.Having GUIDs as objectIds(primary key) was slowing the queries so we used int datatype instead. 2. Limit the joins in a query to 3 or 4 and denormalise the table if it needed more joins 3.Stop using Dynamic queries and use Stored procedures instead. Are they still valid in SqlServer 2005 too Should I follow the same rules here also Is there any improvement in these rules oj wrote: You can use newsequentialid() instead of newid() to generate a sequential guid. This will reduce page contention and ...Show All
Game Technologies: DirectX, XNA, XACT, etc. using the XmlImporter w/Content Pipeline
I have all my game objects defined in XML files and I would like to use the Content Pipeline to load them. Looking at the available importers, it seems like the XmlImporter is the right choice, but it appears to want the XML in a certain format (a reasonable requirement). So far I haven't found any documentation on the correct way to format the file. It seems like this would use the XML serialization in C# to serialize/deserialize the object. When you pick XmlImporter in the properties, however, it appears to want a particular root element. Also, I would assume that you would use the No Processing Required for the Content Processor. If that is the case, then I think it is just a matter of formatting the XML file correctly, selecting the XM ...Show All
.NET Development What method can be used to get the list of all the attributes present in a class in C#
What method can be used to get the list of all the attributes present in a class in C# You can use Type.GetCustomAttributes(). For example: object[] attrs = typeof(Form).GetCustomAttributes(true); foreach (object attr in attrs) { Attribute atb = (Attribute)attr; Console.WriteLine(atb.TypeId.ToString()); } ...Show All