Mirza Ashraf's Q&A profile

• SQL Server Inject SQL statement result in XML file.

  Hi I have the following situation while working with MSDE 2000 database. I send the following XML string to the procedure '<root> <customer> <custid>77777</custid> <custname>Ehab</custname> <city>AnyWhere</city> <country>Egypt</country> <Currency CurrencyID="1"/> </customer> </root>' BUT I have a small problem. ** I want to replace the value <Currency CurrencyID="1"/> with a SELECT statement result like this one : SELECT CurrencyID FROM Currencies WHERE CurrencySymbol ='' . .'' for XML raw Any help or suggestions thanks Hi Jinghao Liu - MS SQL Server thank you for ...Show All

• SQL Server CREATE SCHEMA fails Inside an If Block

  Hello All, The below "CREATE SCHEMA" sql statement fails if it is inside an IF block. It runs fine if i run it without the IF block... --------------------------------------------------------------------- IF NOT EXISTS ( SELECT * FROM sys.schemas WHERE name = N 'Customer' ) BEGIN CREATE SCHEMA Customer AUTHORIZATION [sys] END ---------------------------------------------------------------------- Did anyone encountered this issue before.... Thanks.. Thanks for the clarification.. ...Show All

• Visual C# Make characters into ASCII numbers

  Hi, I'm new to C# and I need help with some homework. I have this so far: using System; using System.Collections.Generic; using System.Text; namespace week3 { class Program { static void Main( string [] args) { char ch; int number; Console .Write( "Please enter a single character >" ); ch = char .Parse( Console .ReadLine()); Console .WriteLine( "The ASCII value of your character: " + ch + " is " + ( int )ch); } } } So how do I make to accept the character then output into a ascii value This will solve your problem... using System; class Program { static void Main(string[] args) ...Show All

• Visual Studio 2008 (Pre-release) Access to Template Controls

  Hello, here some xaml: < ResourceDictionary xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " xmlns:c = " clr-namespace:myTest " > < ResourceDictionary.MergedDictionaries > < ResourceDictionary Source = " Common.xaml " /> </ ResourceDictionary.MergedDictionaries > < Style x:Key = " DefaultLayout " TargetType = " {x:Type Page} " > < Style.Resources > < ObjectDataProvider x:Key = " LayoutData " ObjectType = " {x:Type c:DefaultLayoutData} " /> < ScaleTransform x:Key = " ScaleTransfo ...Show All

• SQL Server AcquireConnection error importing dBaseIV files using SQL Agent

  I've got an SSIS package that I've been testing all week and it runs fine in Visual Studio. The package uses an OLE DB connection manager to access the dBase files using the Jet Provider. The dBase files are stored on a remote file share. There are a series of identical files held in different dated folders. I use a ForEach loop to move through the folder list and import the data as I go. When I deploy it to the server and try to run it, I get the following: The AcquireConnection method call to the connection manager "Aloha" failed with error code 0xC0202009. Aloha is the ConncetionManager to the dBase files. I've searched everywhere I can for ideas on how to solve this. I've made the SQL Agent Service is running under the ...Show All

• SQL Server SQL Server Setup Fails

  I just upgraded ACT database and it needs SQL Server. I just keep getting "SQL Server Setup Failed". I downloaded SQL from Microsoft, went to install and get the same error. It then refers to a summary txt log which I have had a look at but to be quite honest means nothing to me. I only want to be able to use ACT!! Anyone help PLEASE!! Sam, I think I know what you mean. HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\New There is no \AppData in either. Only "New" Any help ...Show All

• SQL Server Resume execution after error

  Hi, I have a stored procedure containing iterating cursor in which iam inserting records in a table. My problem is that whenever any data mismatch occurs whole process gets stops. I want it should skip that error record and continue with next iteration. Like on error resume next in vb. Please suggest. Hi Sharma Rahul, Actually SQL Server only supports " On Error Resume Next " for runtime exception. But the behaviour on execution abortion is bit different here. In SQL there is 2 type of Exception. 1. RunTime Exception - aborts the Current Statement and Resume to next statement 2. RunTime Compliation Errors - aborts the Entire Batch Yes. Few exceptions are considered as ...Show All

• SQL Server Entering Notes/Comments/Remarks to Report

  Hi, there, We intended to create a report that allows users to enter remarks, comments or additional notes in supporting the report. Can it be done in SSRS FYI, we are using SQL Server 2005 Enterprise. Thank you. Regards, Yong Hwee You want to annotate within the report, or you want to add extended properties to the report If it is the first, then there is no way without changing the RDL or annotating the exported format. If it is the second, then you can use SetProperties/GetProperties to write/retrieve extended properties (including your annotations) programmatically. ...Show All

• SQL Server sqlcmd with trusted connection and IP address or fully qualified hostname

  The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example: sqlcmd -E -S nnn.nnn.nnn.nnn where nnn.nnn.nnn.nnn is the real IP address of the machine, or sqlcmd -E -S hostname.domain.com where hostname.domain.com is the fully qualified hostname of the machine, gives the error: Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1 Login failed for user ''. The user is not associated with a trusted SQL Server c onnection. On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433. This is on a clean machine, with SQL Server 2005 freshly installed as Administrator with mixed authentication, and t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. cloud of dust like in battlefield 2 : mc

  does anybody know how the developers from battlefield 2 : modern combat did the cloud of dust effects did you know what i mean it could be a billboard with sprite animation hmm... yes that is possible. i don't know what imposters are, so i will google for it.. thanks a lot guys! @Joel: i don't mean smoke granates. ...Show All

• Software Development for Windows Vista WMI Win32_NetworkAdapterConfiguration EnableStatic call fails with error 0x80070005

  Here is the code I am using: strComputer = "." Set objWMIService = GetObject( "winmgmts:\\" & strComputer & "\root\cimv2" ) Set colNetAdapters = objWMIService.ExecQuery ( "Select * from Win32_NetworkAdapterConfiguration where IPEnabled=TRUE" ) strIPAddress = Array ( "192.168.0.1" ) strSubnetMask = Array ( "255.255.255.0" ) For Each objNetAdapter in colNetAdapters WScript.Echo objNetAdapter.Caption If Left (objNetAdapter.Description, 15) = "Realtek RTL8150" Then errEnable = objNetAdapter.EnableStatic(strIPAddress, strSubnetMask) If errEnable = 0 Then WScript.Echo "The IP address has been changed." ...Show All

• Visual Studio 2008 (Pre-release) Dynamic conditions: How to achieve multiple "OR" conditions with LINQ?

  A common use for database querying in a page is to allow users to enter a list of keywords for searching. i.e. "Word1 Word2 Word3" along with some settings options where he can pick something like: [All words], [Any word], [Exact Phrase]. I used that approach to write a learning tool with LINQ. Exact Prase was easily achieved by something like: from q in context.MyView where q.MySearchField.Contains(TextBox.Text) select q which translated to select * from MyView where MySearchField like '%xxxxxxx%' IndexOf also worked and translated to CHARINDEX instead of LIKE. I also tested StartsWith() and EndsWith(). They all worked great. Likewise I was able to perform the [All words] and liked the way LINQ handled that: IQueryab ...Show All

• Visual Studio Team System Get command returns "server returned content type text/html, which is not supported"

  Hi Forum, We are currently experiencing the above error message on our test TFS enviroment. It seems only to manifest itself with binary files, such as .GIF & .PNG. We have checked the files for zero-length, and that is not the case, although one way to reproduce is to upload a file with zero-length. The result is that we cant get the files downloaded to the workspace, but we can add the files initially. The files are all marked as binary, when we look in their properties with the Source Control explorer. Any ideas TIA, GertCh Hi Mario, There was no errors in the Eventlog, but here is the snippets from the trace-log and IISLog. Please note that the recorded time in the two logs ar ...Show All

• .NET Development XSD.exe utility insights

  Hi, I used XSD utility in .NET framework 2.0 on a DLL, which has the following objects. class A { string name; string ID; } class B : A { int age; int year; } class C: A { int month; } and so on.. Now, when I create XSD, it includes class A as base object in both Class B and Class C, which is not, what I want. Is there any way that I could create XSD, so that the members of Class A are included in class B and class C Secondly, I couldn't figure out the logic behind "minoccurs" and "maxooccurs" numbers generated in XSD file. Thanks, -Brajesh Hi, - xsd.exe is designed to preserve the class hierarchy in XSD so you can't ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. In Game Movies

  Does anyone know whether the XNA Framework will allow for games to be written that have Cut-Scene videos, perhaps using non-Microsoft codecs such as divx or another codec that allows high-video compression to limit the size of the game. Will the game be able to use any audio/video codecs that Windows has installed on it, and will it be able to load pre-written non-managed code DLL's Thanks for the answer RE: DLL's, that is what I had assumed. I assume that DLL's written in managed C++ will be allowed on the Xbox 360. However, RE: videos, this will be very important for me and my group as we have recorded a lot of video back story and many of the cut-scene videos already. So far we have encoded these using DivX as this keeps the ...Show All