Axe22's Q&A profile

• SQL Server Help with generating a password with non repeating characters

  hello all, I have to write a query to generate a password which should have not have any repeated characters. The only far that I was able to go is : SELECT SUBSTRING(CONVERT(varchar(10),@member_id),1,1) + CHAR(((ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),2,1))-47)*2)+64) + SUBSTRING(CONVERT(varchar(10),@member_id),3,1) + CHAR(ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),4,1))+32) + SUBSTRING(CONVERT(varchar(10),@member_id),5,2) + CHAR(ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),7,1))+33) + SUBSTRING(CONVERT(varchar(10),@member_id),8,3) but this does generate repetitve character code. Please help. Thanks, Yep, that was my concern also. A "truel ...Show All

• Visual Studio Express Editions Temporary Files

  I made a program to get rid of the temperorary files, who are located in for example: "C:\Documents and Settings\Local Settings\Temp\", where C:\ could be any drive where windows is installed. The program is deleting all the files, exempt the files who are used by some processes, services or programs. Now how can i find who is using some file, who don't like to be deleted. Now when my program delete all the files and then i want a form to apear, with an listbox with the programs or processes that are using certain files, then a button to kill the program, or ask you to shutdown the selected program manually. Now how can i find the program name of that program who is made a permiss ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How much of a 3D engine will be included in the XNA Framework?

  In the DX samples there are the samples framework. Will that be built upon or will there be a separate 3D engine included or downloadable - What I am looking for is some kind of scene graph - Lighting and materials - Shader loader, constant setter etc. I am guessing since Torque are releasing their engine for this we will not see a full featured engine included but will there be an embryo that is more than the DX sample framework Regards Joachim exal wrote: - It would be great with a white paper regarding scen graphs and other structural information to help out with the implementation We have plans for a lot of white papers, and will be continually adding more after lau ...Show All

• Visual C# Quick Find in visual studio 2005 disappeared

  I used to be able to hit control key and F key, it pops up the Quick Find window, now this does not work anymore. All the options listed under pulldown menu Edit and Find and Replace do not display any window. it just did nothing. could anyone please let me know how to get those functions back. I finally solved it. The Find window was hidden way to the left of the monitor beyound frame. I can't see it. But I moved my mouse along the left edge of the monitor slowly, at one point,the cursor changed into a resize two ended arrow shap. so I clicked and dragged. The window came out! I don't know how that happened. But It was tricky to get it back! ...Show All

• Visual C# are using statements nestable?

  using ( SqlConnection connName1 = new SqlConnection ( "....... <database1> { .............. using ( SqlConnection connName2 = new SqlConnection ( "....... <database2> { ............. } } Can I nest using statement blocks Thanks. You can also do this: using ( SqlConnection connName1 = new SqlConnection ( "....... <database1>")) using ( SqlConnection connName2 = new SqlConnection ( "....... <database2>")) { //block of code for using two objects } ...Show All

• Smart Device Development Subject: VS2003 Controls in VS2005

  I've got some 3rd party controls that I can get into the VS2003 IDE toolbox, but I can't get them onto the VS2005 toolbox (if I do "Show All" they show as disabled in the toolbox). Is it impossible to use the VS2003 controls in VS2005 I figured there might be a way since you can use old ActiveX/COM controls in .NET, right Thanks for any help, Steve Indeed you can not as custom control model has been changed for VS 2005. But you can add reference to custom control DLL and use these controls them programmatically without designers. ...Show All

• .NET Development Not able to use GetDataTableSchema

  hi, .Net 2.0 has added a new method to the DataTable class, GetDataTableSchema ( ). Not able to use it though. Even msdn docs dont provide an example. I will really appreciate if you can provide me with any simple example. Thank You. This method returns a XmlSchemaSet instance containing the WSDL that describes the DataTable for Web Services. Namespace: System.Data Assembly: System.Data (in system.data.dll) Syntax Visual Basic (Declaration) Public Shared Function GetDataTableSchema ( _ schemaSet As XmlSchemaSet _ ) As XmlSchemaComplexType Visual Basic (Usage) Dim schemaSet As XmlSchemaSet Dim returnValue As XmlSchema ...Show All

• Windows Forms override copy command

  Is there a way to over ride the CTRL+C Command and also override a context menu "copy" command The reason I ask this is because in work I have 2 pc's KVM'ed and I would like to share one clipboard with the other and vice versa, I have the app working but I would like it to possibly hook the copy command completly. any way of doing it Khalid is correct as far as the Clipboard goes. Transferring the data over a KVM switch is a no-go, it is just an electrical switch, not a data switch. Instead of a KVM, consider using a remote access program such as RealVNC or TightVNC. They are capable of transferring not just keyboard, video and mouse but also the clipboard contents. ...Show All

• SQL Server The Cross Join Operator (*) Can be Very Slow

  Has anybody else seen cases where replacing the * operator with the CrossJoin() function will dramatically improves performance In a support case I have open with MS, they asked me to change my syntax in that way and I was very surprised by the improvement. I was also surprised because previously I've heard that CrossJoin() and the * operator " are completely equivalent from the functional and performance standpoint". The kicker is that the time intelligence wizard uses the * operater by default. The part of the sentence that I quoted came from this guy's blog: http://www.sqljunkies.com/WebLog/mosha/archive/2007/02/20/crossjoin_syntax.aspx Also, I'm not sure why a static optimization couldn't be appli ...Show All

• Visual Studio Express Editions Classic ASP with VWD: why is JScript default language?

  Hi all, Thankfully, I can use Visual Web Developer to edit Classic ASP scripts. But there's an annoying problem I'd like a solution for!... As long as I have the "@LANGUAGE=VBSCRIPT" directive at the top of a page, it will correctly format VBScript scripts (keywords in blue, comments in green, strings in red, full intellisense for functions etc.). However, I have to use multiple Include files for each full page, which means not all page chunks can have the @LANGUAGE directive at the top. Here's the problem. Without the @LANGUAGE directive, VWD assumes the default scripting language to be JSCRIPT , and formats all script blocks accordingly. How do I change VWD's default scripting language to VBScript I am having th ...Show All

• Software Development for Windows Vista call external method activity disappeared from my toolbox

  I don't know why, but the call external method activity is no longer visible. My workaround will be to use wca, but is there something I've tripped over to make it disappear I can actually view previews flows that use the activity without a problem. ...Show All

• Visual Studio Express Editions how can i make my VC++.Net application Expire in 30 days

  hello, Please get me some samples or articles related to these. I have tried and still trying to get the articles from web, but it was not much helpful. Few days before i got an article which was about how to be programatically cautious about header files not getting included more than once in our application. I am doing this in VC++.Net and windows XP and want make it a windows service. Can anybody help me of this. Thank you Anoo Check out the Shareware Starter Kit for ideas. ...Show All

• Visual C# accessing custom entity objects throughtout the project

  Hi, When we define a ProductEntity class for example. If I want to use the class object myProduct in a form1 and form2 and access the properties from different forms. Let s say, first I load an mdi form  mymdiForm, then I click a button that loads form1 and in form1 i click a button that loads form2 and so on.. My concern: 1- where do I instatiate myProduct object. In the mdi, or in form1 or in form2 knowing that myProduct  properties are assigned from controls located in the form form2. Also I want to make sure that I can access those properties in the mdi and form1 forms and all the project Do I declare myProduct  as public or friend or what Also how can I access the object myProduct  and ...Show All

• SQL Server Cannot Connect Remotely to HTTP EndPoint

  Dear all, I appologise that incarnations of this topic have been posted several times on this forum, however I cannot find a scenario that is the same as my own so I've resorted to starting a new thread. I can successfully create and connect remotely to an HTTP EndPoint on my Windows 2003 machine using Integrated security, the administrator username and password via my static IP address. I have read that Windows XP SP2 supports HTTP EndPoints, and it would be much more convenient for me to be able to create EndPoints in XP, and connect remotely. I have created the endpoint like so... CREATE ENDPOINT sql_tvr10 STATE = STARTED AS HTTP( PATH = '/sql/tvr10', AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR)) FOR SOAP ( WEBMETHOD 'Stor ...Show All

• Windows Forms Determine if List is displayed for ComboBox

  I have a situtation where I need to not let the mouse roller change a value in a drop down list. I was able to accomplish this by trapping the 'MouseRoller' event and canceling it for a ComboBox. However, now my users want the mouse roller to be enabled if the list is displayed for a ComboBox so they can scroll through the items. So I was wondering if there is a way to know if the list is being displayed for a ComboBox editor I am hoping to use it in the 'MouseRoller' event and not cancel the event if the list is in fact being displayed. Thanks in advance. Thanks for the reply...Yes, logically that is what I am looking for, but there is no such property 'droppedown' for combo that can give me what I am loo ...Show All