su45937's Q&A profile

• SQL Server return value of empty list

  Hi, I'm trying check the records which satisfies the following condn. select @p1 = su1 from RER where (no=10 and atp ='N') It returns empty list . bcos no match found.that's ok. But i need to write the logic if record is not there. i tried to do as follows if ((@p1 =null) or (p1=' ')) ...some logic else .. other logic It's always executing else case. How do i catch empty value using sql query. Is there any command there like null I tried in SQL query analyzer. Using SQL 2000. Thank You   ar_pad wrote: Hi, I'm trying check the records which satisfies the following condn. select @p1 = su1 from RER where (no=10 and atp ='N') It returns empty list . b ...Show All

• SQL Server T-SQL to copy stored procedures

  Hello, I'm using SQL Server 7 I have stored procedures in one database, I want to copy them to another database on same server. I want to overwrite the existing one, if it is there. What is the best way Thank you. You can overwrite existing stored procedures by "ALTER PROC <proc name>..." statement. Note though, for ALTER PROC to work, that <proc name> has to exist already. So you could do something like this: IF OBJECT_ID('procName') IS NOT NULL ALTER PROC procName... ELSE CREATE PROC procName... Comparing to what you did (delete and re-create), your way is probably easier and faster :). ...Show All

• Visual C++ problems in rebuilding msdn/sample/1566 (win32 hooks) sample application using makefile

  has anyone tried to build the sample file 1566 (about win32 hooks by Kyle Marsh) using make file I encountered LIBCMTD.lib(crt0.obj) : error LNK2019: unresolved external symbol _main referenc ed in function ___tmainCRTStartup hooksdll.dll : fatal error LNK1120: 1 unresolved externals NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual Studio 8\VC\BIN\l ink.EXE"' : return code '0x460' Stop. does anyone know the problem thanks I am not familiar with the sample but if the sample is a DLL then your project is incorrect. If you don't know what I mean then you should become more familiar with VC before trying something that advanced. Doesn't the article say that you should ...Show All

• Visual Studio Team System Data not inserted into Web application dB on parameterizing

  I am testing a JAVA web application. when I am recording an insert action, the data is inserted into the Database. When I parameterize that same web test and run it with the setting "ONE RUN PER DATA SOURCE", the test is runing for 'n' number of times. But, the corresponding Data is not inserted into Database. Please let me know where I am going wrong..... Hi, so the first thing I would do, is trace the database. I would create a simple load test that will run for couple of minutes. You can set the test to trace a database and a table. Once the test has completed you will be able to see what queries were executed against that table. Maybe then you will have more understanding and you will be able to se ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creators club problems

  HI all. I have got the creators club of Marketplace and XNA on my PC. But I cant get the 2 to connect. I am useing ethernet ports to connect both my PC and 360 to by BT home hub but they cant seam to connect. Do I need to change any fire wall settings to allow the Creators club axcess. I have all ready tried with no luck. It would be much easer if you didnt need to be on live at the same time. Thanks mat Did you follow the directions on this page (and the page it links to at the bottom) ...Show All

• Windows Live Developer Forums Live Messenger installer Bug

  when ever I open messenger it will sign me in then an installer box pops up tries to install somthing (I don't know what it just says windows live messenger with a green loading bar) then closes and closes messenger with it. This is a clean install of xp sp2 with IE7 rc1 and media player 11 beta if that helps at all. Has anyone elese run in to this problem and how do you fix it We have a user with the exact same issue. No beta software running on this PC, though. We found that if you add the user to the local Administrators group, the Intstaller does not run, and there is no problem. However, if you remove him from the Admin group, the problem reocurrs. Uninstalling/reinstalling does nothing to correct the problem. Live Messeng ...Show All

• Visual Studio 2008 (Pre-release) Multithreaded

  i have 2 threads in client and i call simultaneously from 2 threads to  service. i define the service as  ConcurrencyMode .Multiple [ ServiceBehavior (InstanceContextMode = InstanceContextMode .PerSession, ConcurrencyMode = ConcurrencyMode .Multiple)] i call from thread 1 and thread  2 (from client )  to service simultaneously. untill the thread 1 finish to work  thread 2 is stacked and   only after thread 1 return,thread 2 start to work.  this function like   reentrant despite i define the service   ConcurrencyMode .Multiple btw i use in feb version . i found the problem but i don't understanding why is not work ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. create a terraim from scattert points

  Hi.. I have such a problem: I have a 2D Array (A) which keeps the Height of a terrain. In my array I have just the height of a few point which are scattert. For example I have 100x100 Arrax and I know just the height of ~50 points. How can I create a smooth terrain from this points The height of other points have to be calculated. And I dont know how. Is the " Interpolation " keyword Iy yes can you please give the algorithm for a surface interpolation. Or is there an other way to do this Please help me.... There's many ways to solve this problem. In fact, books have been written on the topic. Simplest approach is to lay a grid over your heightpoints and do a weighted interpolation for ...Show All

• Visual Studio "Version not found" using SS GET!

  Hello there and thank you in advance for any help. I've read some other threads about similar problems but my issue seems to be unique. We had a VSS 6.0d database and we migrated to VSS 2005 (server and client). The database import went fine and all has been working quite well overall. I create a sidestream of several projects by sharing them over but when we use our automated build script which calls "ss get" on those projects, it appears that files that havn't been changed since before the migration are coming back with "Version not found". Using SS Explorer works fine but the command line utility fails. Any help would be much appreciated! Regards, Phil Sorry for the delay in responding here...deadlines, etc. As ...Show All

• Visual Studio 2008 (Pre-release) .Net Remoting two times faster than WCF!

  In our healthcare enterprise multitier application the .Net Remoting transports are two times faster then WCF(we have plugable client/server transports): Measuring results for the same couple of client server requests: -> Tcp Remoting: 3.4 seconds -> Http Remoting (IIS-Hosted): 3.5 seconds -> Tcp WCF: 6.5 seconds -> Http WCF (IIS-Hosted): 7.3 seconds -> Http WCF (IIS-Hosted) with MTOM: 10.3 seconds Security: We just use authentication by NTLM Serialization: We use the NetDataContractSerializer, and not the DataContractSerializer (RPC style) Can WCF be tuned to be as fast as remoting The use of MTOM which replaces text by binary data makes the communication slower. Why ...Show All

• Windows Forms DataGridView Connect Multi Tables

  i have connect DataGridView With Multi table the Table is BillBuys and the Second is BillBuysDetails and the Last is Storage The Colmnu in BillBuys BillNo PK SuppNo FK BillDate The Column in BillBuysDetails BillNo FK TrdNO Fk (like ItemNo) BuyPrice SalePrice Qty Unit The Colum in the Storage i TrdNo FK PatchNO ExpDate MinSalePrice MaxSalePrice the Question 1- How to Dispaly all Columns in the DataGridView Note the SuppNo is DataGridViewComboBoxColumn and TrdNo DataGridViewComboBoxColumn 2- in the insert Operation how to Fill BillNo in the BillBuysDetails Table The JoinView class is a class written in VB for joining 2 tables together for data binding. Basically you load 2 or more tables into a dataset and set up some data re ...Show All

• .NET Development The underlying connection was closed: The proxy name could not be resolved

  Hi, Can someone help me with the error i am receiving: The underlying connection was closed: Unable to connect to the remote server. The underlying connection was closed: The proxy name could not be resolved, verify correct proxy configuration. I can get the service working on localhost but when i promote the service to my production server i receive this message. Any ideas Thanks in adnvance. Hi, You may have to specify your proxy server. Please take a look at this link, this may help you: http://support.microsoft.com/default.aspx/kb/318140 Rgds, Rodrigo ...Show All

• .NET Development Reading XMLWriter with XMLReader

  Hiya everyone, Quick query for you: I have the following code generating an XML file. ' Write XML data. writer.WriteStartElement( "university" ) writer.WriteAttributeString( "name" , txtName.Text) writer.WriteElementString( "address" , txtAddress.Text) writer.WriteEndElement() writer.Flush() writer.Close() Which gives an output like the following: < xml version="1.0" encoding="utf-8" > <university name="Swinburne">  <address>http://allocate.swin.edu.au/aplus/apstudent</address> </university> It would follow then (to me) that you would read this document back in as follows: ' Read XML data. reader.ReadStartElement( "university" ) tempName = reader.GetAttribute( "name" ) tempA ...Show All

• .NET Development Application Cached HTTP Connections

  I have an HTML scrape DLL that is called concurrently to gather info. The DLL uses the following code to fetch a login page : Uri UriCon = new Uri("https://someloginpage.com"); HttpWebRequest Request = (HttpWebRequest) WebRequest.Create(UriCon); Request.Timeout = 20000; Request.CookieContainer = new CookieContainer(); Request.Accept = "image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */*"; Request.UserAgent = "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)"; Request.Headers.Add("Accept-Language:en- au"); ...Show All

• Visual C# Prevent Application from exiting...

  Besides using e.Cancel for FormClosingEventArgs, is there another way to prevent the Application from exiting, and keep it running I mean, instead of clicking the close button and having the app close, can I have it close the window but keep the app open in the system tray using a notifyIcon In case you are wondering, I am using the KryptonForm from http://componentfactory.com to redesign my application, but it doesn't have a compatible FormClosing Event to use e.Cancel. Thank you, not sure but thought I would run this by you, you can implement the Application.ApplicationExit event, which will fire when the app is about to shutdown. But from here, not sure how you would cancel the application from actually shutting down. ...Show All