MMDG's Q&A profile

• SQL Server Variable values containing dashes

  Ok. Here is a weird problem. I have a package which contains a variable with the value of a UNC sharename. The hostname in the share contains dashes. I am trying to create a SQL Agent entry to execute said package. Because the package is now in production I want to pass in a new value for the sharename variable. I use the SQL @@SERVERNAME variable to build the package command. (Notice the BlotterUploadFolder variable at the end.) SELECT @command = N '/FILE "\\' + @@SERVERNAME + '\Packages\MiddleOffice\Reconcilliation\ImportManualBlotter_AccountTransfers.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /CONNECTION MiddleOfficeDb;"Data Source=' + @@SERVERNAME + ';Initial Cata ...Show All

• SQL Server Howto retrieve Access HyperlinkBase property from ADO?

  I'm inserting records into an Access database using ADO. One of the fields is defined as a hyperlink. I figured out the #displayname#path#subpath# formatting, but at issue is how to describe a relative path (to a filename) - I'd like to programmatically retrieve the database property 'HyperlinkBase' so I can properly specify the relative path. Is there some provider-specific schema that I can use to get this info for the Access file the Connection object references I find example code for getting hyperlink base and other builtin document properties for Word, PowerPoint, Visio, but can't seem to find this for Access. Access 2003/Microsoft.Jet.OLEDB.4.0 Thanks, Dave ...Show All

• Visual Studio Express Editions Convert hex byte to decimal?

  Here is the code I am using. I would like to convert 1 byte that is in hex to a decimal value. //==define a buffer array to load a save game file into. private byte[] mBuffer; // File data buffer //==in click open event. // *********************************************** // Select filename and load file into mBuffer // *********************************************** if (openFileDialog1.ShowDialog(this) != DialogResult.OK) return; using (FileStream fs = new FileStream(openFileDialog1.FileName, FileMode.Open)) { mBuffer = new byte[fs.Length]; fs.Read(mBuffer, 0, (int)fs.Length); fs.Close(); } //==find strBkName in mBuffer. this gives the starting location aa ...Show All

• Visual Basic Create database on install

  Hi Everyone I'm a bit new on the whole database side within a program. Want i want to know is when you install your program. How does one go about creating the database on that system when installing your program. Any responses will be great. Thanks in advance I think that the way to instal a db is when you run your program for the first time. however, you need to know: 1 - you have to know which kind of db are you going to use ( Access or Sql Server or ....) 2 - you have to see if that database does not exist in that system. if it does not exist then activate those instruction specific for creating the db. Each kind of db has a specific set of instruction for creation. ( see 1) 3 - you will have to create the table ...Show All

• Visual Studio can I disable the SourceControlProvider in VC 8.0?

  Hi, I transfered from VC 7.1 to 8.0 just now when I worked on VC7.1, I change the reg HKLM\SOFTWARE\SourceCodeControlProvider\ProviderRegKey to emtpy to avoid the the VC binding my local file to the version control software without changing any local project file to remove these information. but in VC8.0, I remove the key as before, also, I remove HKCU\Software\Microsoft\VisualStudio\8.0\CurrentSourceControlProvider but it seems VC80 can always find the version control software when i open the solution and open the version control software to ask me login and binding... I just really don't like VC do the checkout automaticly, and I wander is there a way to disable it easily. any suggestion will be apprieated and thank you very much in adv ...Show All

• .NET Development Microsoft.JScript.Vsa.VsaEngine

  I have a simple function: public static string EvalJScript( string JScript) {       return Microsoft.JScript. Eval .JScriptEvaluate(JScript, Microsoft.JScript.Vsa. VsaEngine .CreateEngine()).ToString(); } that is used all over my .NET 1.1 application and am currently porting over to .NET 2.0.  What is the working replacement for this code   I found the following code on the net: [ PermissionSet ( SecurityAction .LinkDemand, Name = "FullTrust" )] [ PermissionSet ( SecurityAction .Demand, Name= "FullTrust" )] [ PermissionSet ( SecurityAction .InheritanceDemand, Name = "FullTrust" )] public static string EvalJScript( string JScript) {    string result = string .Emp ...Show All

• .NET Development Help for JobEventHandler

  Dear Members, Help me on this topic.. I'm implementing job project presented in .net remoting, I'm trying to create a dll of JobServerLib but it doesnt build as it gives error for JobEventHandler... I need to incorporate one assembly to handle events for JobEventHandler.. but im not able to find it out which.. please help me on this... here is my code... using System; using System.Collections; using System.Runtime.Remoting; using System.Runtime.Remoting.Lifetime; using System.Runtime.CompilerServices; public interface IJobServer { event JobEventHandler JobEvent; void CreateJob( string sDescription); void UpdateJobState( int nJobID, string sUser, string sStatus); ArrayL ...Show All

• Windows Forms Remove rows in datagridview and save the dataset xml file

  Hi, I made an even handler for removed rows in the datagridview. The datagridview gets its data from an xml file. When a row is removed in the datagridview, the row should be removed in the dataset as well. This is my event handler in constructor: this.grdTest.RowsRemoved += new DataGridViewRowsRemovedEventHandler(grdTest_RowsRemoved); This is the code in that event handler: void grdTest_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e) { DataSet ds = new DataSet(); ds.ReadXml("Test.xml"); foreach (DataRow dr in ds.Tables[0].Rows) { string remove = dr["Row"].ToString(); DataRow[] temprows = ds.Tables[0].Select("Row = " + remove); if (temprows[0].RowStat ...Show All

• Audio and Video Development Animating Width and Height

  My guess is that to animate and images width and height (as in shrink or grow the image), I need to display it as an object and then manipulate contentWidth/contentHeight. Is that correct Are there other ways to do this Thanks. No; set contentWidth="scale-to-fit" and contentHeight="scale-to-fit" . Then whatever you set width and height to, the backgroundImage will stretch / shrink to fit it. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3D Mesh Object does not exist...and Spacewar is using new "swm" format?

  Looking at the SpaceWar sample...I am wondering if there is somewhere a converter from .X or .XBF to the SWM format. Looking at the loader in the Simplemesh.cs class, it looks like the SWM is using a propriatary header and than the binary .X format.. Can anybody help with this format I would love to use 3D Max and export to .X than read it into my game...but without a code converter to SWM...hard:-) Alright, heres a new version: Updates: .swm now contains vertex format string more verbose error descriptions Get it here: http://astaroth.beatbuggy.net:8080/Downloads/x2swm_1_0_0_1.zip ...Show All

• Visual Studio Express Editions UI freezes when sending Ping (even from a separate thread)

  I’m writing an application that displays information about my home network. The network is a few Windows PCs behind a NAT router that communicate via NetBIOS over TCP/IP, the PCs are all members of the same Workgroup (not a Domain). I use the NetServerEnum API function to get the names of all the PCs in the Workgroup, and I want to Ping each of them to check that they are reachable and record the roundtrip time. Because I don’t want to slow down the UI while the Ping processes, I used an asynchronous Ping: Dim pingSender As New Ping() AddHandler pingSender.PingCompleted, AddressOf Me .ReceivePing pingSender.SendAsync(computerName, 1000) This works OK most of the time, but if one of the PCs recently ...Show All

• SQL Server Urgent: SSIS data Convertion ??

  Hello all Ho can i convert Integer to String in SSIS Derived column. Thanks in Advance Raj Lakamana I am assuming that you have already tried casting etc. I can suggest some workaround... What is the source of the Integer If it is coming from a table, you can change the "Data access mode" from "table or view" to "Sql command" and format your command like "SELECT col1, col2, convert(nvarchar(20), my_integer) as col3 from src_table..."  If it is coming via lookup, do the same by modifying the query in the advanced tab. HTH, Nitesh ...Show All

• Software Development for Windows Vista how to declare variables used by different activities

  I just have a conceptual question regarding workflow. In my workflow, i declare are the varaibles used by different activites as the instance variable of the workflow class. In this way there are many variables declared as each variable may be altered by one activity while used by another. Is it the right way to declare variable, i.e. declare them as instance variables and use them in different activities or is there some other more efficient way to do it. when you only use code activities, this works; the problem is when you create& use Custom activities : then you should define dependency properties ; by binding the dependency properties you can share their value between the different activities (an ...Show All

• Software Development for Windows Vista Rules Driven UI sample--- ExternalRuleSetToolkit

  Hi, This is about setting up the database for Rules Driven UI sample : In the ReadMe file about setting up the sample database: Run the setup.cmd provided with the ExternalRuleSetToolkit sample here . This setup batch file will create Rules database on SQL Express and setup the Ruleset Table. This is a prerequisite to use this sample Where can I get ExternalRuleSetToolkit the link provided links to: http://wf.netfx3.com/ I searched and couldn't find it anywhere. Does ExternalRuleSetToolkit come with SDK Please help. You can find it here: http://wf.netfx3.com/files/folders/rules_samples/entry309.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where to find the Default shader for a base?

  Hey Guys, Is there somewhere I can find the default shader code that XNA uses Id like to use this as a base as I only need to make minor changes to the shader... Cheers Shawn Hargreaves - MSFT wrote: We aren't currently shipping the source for BasicEffect. If you think this would be useful, please file a suggestion over on the Connect site. Where is the connect site cheers :) ...Show All