BilalShouman's Q&A profile

• SQL Server Union problem

  I have follow query declare @z int select id from table1 union select id from table2 i want after union in @z save value 0, 1 or 2. 2 - when first and second select returns any results 1- when one of selects return any result, and another return nothing 0 when both selects returns nothing Can you help me. How i solve this problem 10x this is a good idea. Now I have another problem. I have ntext field in table and when select table, who include him, it execute very slowly. Do you know options to improve this. I want preview onli first 256 characters of field. Thank you ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Create a river suggestion?

  Hi all, I want tocreate a river in my game, Hope somebody can propose good example to me or method. Best Regards, A simple way is to scroll a texture see http://www.c-unit.com/tutorials/mdirectx/ t=52 (I think Chad's tutorials used the now expired MDX 2.0 - so if you want to see them working you might have to install the august sdk and change your date back a few months - or of course change the code to work with MDX 1.1) ...Show All

• Visual Studio Visual Studio 2005 SP1 for which edition ?

  I erroneously posted this in the .Net setup forum so I am reposting it here. There is a Visual Studio 2005 Service Pack 1 at http://www.microsoft.com/downloads/details.aspx FamilyID=bb4a75ab-e2d4-4c96-b39d-37baf6b5b1dc&DisplayLang=en. The brief description says: "This download installs Service Pack 1 for MicrosoftR Visual StudioR 2005 Standard, Professional, Team Editions." but then I read:under Overview: " This download installs Service Pack 1 for MicrosoftR Visual StudioR 2005 Team Suite." This is confusing. Is this service pack only for the Team Edition or is it for the standard, professional, and team editions Gabriel Lozano-Moran wrote: It is the service pack fo ...Show All

• SQL Server format issue

  I've created a new calculate member in (SQL Server Business Intelligence Studio 2005) with the following format string: "#,#0.00". This measure is displayed like this: 22,250.22 Then I created a Measure in the Cube structure menue and used the same format string:"#,#0.00" and this measure is displayed like this:0,66 --> Comma and decimal point are changed in the display of the measures!!!! Can anyone help me with this I just like every measure to use a decimal point for the decimal place or the other way round. But I want every measure to be displayed in the same format! Thanks a lot! If I understood your question correctly you get the expected format for regular measures and the wrong format for calculated ...Show All

• SQL Server Splitting Data in two columns

  Hi, I am working on SQL Server Reporting Services, and I want to fit a long column on one page by splitting the data in two columns side by side so that I can make more use of my space. How can I do it, please help... Thanks, -Rohit Hi, could you please provide a sample code of doing this in the backend and on reporting services side with instr function I am really interested to know as I have an identical problem... Thanks... ...Show All

• Smart Device Development Deploying to Pocket PC 2003

  I have been following the example to deploy a simple form from VS2005 to a Pocket PC 2003 ver 2. I can deploy straight to the device but if I try to save the CAB and explode it in the device, nothing happens. Anyone know why Are you using VS2005 Smart Device CAB Project to build your CAB file If this is the case , you have to point out the projects, which should be included in the CAB file. Check if the following links may help: http://msdn2.microsoft.com/en-us/library/zcebx8f8.aspx http://www.devx.com/wireless/Article/31198/0/page/1 ...Show All

• SQL Server ddl trigger question

  I made a ddl trigger on database for event group which is ddl_table_events. The question is: can I know inside the trigger logic (after "as" keyword) which event type of this event group has fired the trigger my code: use AdventureWorks go create trigger TableEvents on database for ddl_table_events as select * from sys.trigger_events go I found nothing in sys.trigger_events has changed inside the trigger. So finally, I want to know which of "create table" , "alter table" or "drop table" has fired the trigger Please take a look at the EVENTDATA function. This returns the event that was fired, the command that raised the event and so on. See below topi ...Show All

• .NET Development NegotiateStream...Server rejecting client credentials

  I have some networking code that I have modified to allow for using the NegotiateStream to authenticate clients when they connect. I am having a strange problem where the authentication is failing with " The server has rejected the client credentials " (Logon failure internally). The weird thing is that the same exact code works on another machine. On the machine where it isn't working I can pass the CredentialCache.DefaultNetworkCredential and it works but using a username/password/domain for an account on the very same machine doesn't work. I am running on XP not connected to a domain (both computers). I have tried using several accounts in the credential for the client auth but no matter what account is used it fails wi ...Show All

• Windows Forms AcceptButton problem

  I have a dialog window with some buttons. Button2 is my CancelButton and have the DialogResult set to Cancel. Button1 is my AcceptButton but I have set the DialogResult to None because I don't want this button to close the form. I only want it to be affected every time I hit the ENTER or RETURN key. When I click another button on the form and after that hit the ENTER key, the AcceptButton is not affected. How do I get it to allways be affected when I hit the ENTER key I read something about using eventhandlers for keyUp events for other buttons to "guide" the keystroke back to button1_click event handler. Do I have to make keyup eventhandler for every other button on the form to make ENTER key allways affect button1 or ...Show All

• Windows Forms How to automatically resize toolstripcombobox when form is resized?

  Hi! I have a combo box on a toolstrip - toolstripcombobox - how can I automatically resize the combobox when the form is resized Matt You can see the combobox resizing when you drag the corner of the form but once you stop, the combobox is back in place Matt ...Show All

• Visual Studio Any Idea On Crystal Report Connection???

  Hi All, I Changed My Server from SQL 2000 To SQL 2005 Server. I Also change my ServerName and Database name... When My applications Running From SQL 2000 Server i have not set ConnectionString on my Page. But when I migrate Server From 2000 to 2005 and also change servername and databasename It ask for ConnectionInfo...... You can find my code on http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=879486&SiteID=1 First I Try to setup following code for Connection Info rpt.DataSourceConnections[0].SetConnection( "Server1" , "MYDB1" , "sa" , "db" ); My Report Data will not refreshed.... Then I tried following code. rpt.SetDatabaseLogon( "sa" , "xys06" , "Server2" , "MyDB2" ); Then i will get Mis ...Show All

• Visual Studio Team System Unlock TFS after failled install SP1

  Hi, I am trying to install SP1 for TFS (workgroup version). Before installing the setup I installed the TfsQuiescence tool (KB919156). During the installation of this tool I got the error 28002. After searching the net i saw the problem was the number of registered licenced users. I removed some users, and the installation of this tool was OK. So I added the users again to the TFS Licencesed Users group. Then I started to install SP1. This installation also ended with error 28002. So I thought, lets remove the users again and retry to install SP1. Unfortunatly I couldn't access the TFS server anymore (error 403, forbidden). I think the TfsQuiescence tool has locked my server. How can i unlock the server now Thanks, Perry ...Show All

• SQL Server Calling Stored Procedures using plain ADO in C#

  Hello All, We are trying to figure out how to make a stored procedure call and pass some inputs using C# and plain ADO. We are able to call an empty stored procedure but cannot pass parameters into a stored procedure. Does anyone have sample code in C# whereby we can open a connection and pass inputs into a stored procedure The following is a sample code we are using: ADODB.Parameter param = new ADODB.Parameter(); param=cmd.CreateParameter("@StoreID", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamInput,sizeof(int) , 9); cmd.Parameters.Append(param);           ADODB.Recordset rsInv = cmd.Execute(out objAffected, ref objAffected,-1 ); In the ...Show All

• .NET Development Directory.Copy

  Title is pretty Self explanatory. There is a static File.Copy method. Why is there not a static Directory.Copy method Why does attempting to copy a directory using the File.Copy method result in an error saying access is denied while using Directory.Move on the same directory works fine Directory.Move isn't really a move method, it's a rename method. You'll notice there are restrictions like it can only be 'moved' onto the same drive which means there's not actualy data copying just a bit of fixing up of file system links. The reason there is no proper Directory.Move which can move to anywhere, or Directory.Copy which does a copy, it because it's not possible to know how you want it to behave. Sure, ...Show All

• Visual C# Need P/Invoke help

  Hello everyone, I've been struggling to get a C++ Dll (which itself is using a static C library) to become accessible to my C# project. Consider the following simple case: A C++ function called AddMatrices takes the form "void AddMatrices(float* Matrix1, float* Matrix2, int size, float* Result)" and is located in a Dll called MatrixDll.dll. I would like to use float* arrays in C# via stackalloc (for performance), but how do I marshall these arrays to the C++ function I've tried a variety of things but I'm just trying things and hoping they'll work - I'd like to know the correct way to do this. I can get my app to compile but I keep getting a runtime error (which may not be related to the above issue) claiming "cannot loca ...Show All