Sarosh79's Q&A profile

• SQL Server Query performance during incremental processing

  We're doing some testing, and finding that query performance goes to hell while performing incremental processing on the partition (ProcessAdd). Specifically during the partition merge part of the processing, queries take from 3 to 30 times longer. I guess it's not totally surprising that this would be the case, but can anyone confirm that this is the expected behavior Is there anything that we can do to improve the situation We have the same issue, same problem with Process Index as well. MS never gave us any solutions, so all processing is done off hours. ...Show All

• .NET Development To run a C# Application Without Oracle Client Software.

  Hi, I have created an application using Visual C# and Oracle 9i. Am using System.Data.OracleClient as Provider. I want to run this application(.exe) in the machines,which are not oracle client installed. I tried this, It showing error " System.Data.OracleClient requires Oracle client software version 8.1.7 or greater .". Thanks in Advance, Regards Nataraj.C You're completely right. If you want to read any data from the database you need to have the oracle client software installed. My idea was to deploy the application on a bunch of machines, but only selected machines will have the oracle client installed so that the application will reveal some extra functionality if it detects the in ...Show All

• .NET Development deleting dataset.table[0] row

  Is there a way to delete a row in the dataset and it actually removes the row and shifts the others down: DataSet looks like: dsTemp.Tables[0].Rows[0][0] dsTemp.Tables[0].Rows[1][0] dsTemp.Tables[0].Rows[2][0] dsTemp.Tables[0].Rows[3][0] Remove a row dsTemp.Tables[0].Rows.Remove(1); DataSet should look like: dsTemp.Tables[0].Rows[0][0] dsTemp.Tables[0].Rows[1][0] dsTemp.Tables[0].Rows[2][0] hi try the datarow.Delete method http://msdn2.microsoft.com/en-us/library/system.data.datarow.delete.aspx Hope this helps you out, please close the thread if it does ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Present.DoNotWait

  I thought I would post this code in case it might be useful to someone. This is a modification of the Draw function from the "Your First XNA Game" section of the XNA documentation. An earlier thread about input polling with a low frame rate got me thinking about using the Present.DoNotWait flag to allow more Update calls to happen while the device is still drawing. This way you don't have to create a separate thread to get more resolution on the input polling. On my machine, the Update function was called about 11000 times per second with 85 frames drawn per second. This is with vsync and fullscreen on (this doesn't work in windowed mode). Also, if anyone can think of a problem with this scheme, I'd love to hear about it. ...Show All

• Visual Studio 2008 (Pre-release) displaying rectangle on <InkCanvas> with xaml

  Hi, I am developing an application in which i have a button labeled as rectangle. When user clicks on button and when he moves the mouse cursor onto the inkcanvas of xaml, the rectangle should be displayed on the canvas till the user release the mouse.How could i do this in Xaml. Any help would be appreciated. Thanks in advance. Regards. Hello spshah, Can you clarify what you're trying to do (Allow the user to click-and-drag to define a rectangle ) This should be pretty easy, but it's not possible to do this in pure XAML -- you'll need to subscribe to the MouseDown, MouseMove, and MouseUp events. (Note: These events will be fired regardless if the user uses an actual mouse, or a Tablet ...Show All

• .NET Development using xmldocument

  Hi, How can i append elements to the root of a xmldocument using a method This was my previous method: public void WritingToXMLDoc(string elementString, string writeToXMLDoc) { this.writer.WriteElementString(elementString, writeToXMLDoc); } But now, im coverting everything to xmldocument. Thanks in advance! If you really want to use the DOM/XmlDocument to build and save your XML then what you need to do is use the approach already described in my earlier answer and at the end when you have created and inserted all nodes you need to call the Save method of the XmlDocument instance passing in the file name. But using XmlDocument/DOM in the .NET framework (where XmlTextWriter/XmlWriter exist to create ...Show All

• Visual C++ problems creating c++ browser applet

  hi, i'm trying to create an internet explorer applet like in managed c++ in .net 1.1. i read that this may be achieved creating a user control and linking it inside the html page. I tried this from csharp and seems to work fine enough, but if i follow the same steps creating an empty c++ user control and try to open the applet i see only a rectangle. I think this is some kind of security issue, may be due to the fact that the c++ applet try to link to system libraries, because the same procedure works with csharp. I tried to create a user control in csharp and move some of the code in a c++ assembly that i linked to the csharp control, but when i try only to declare some of the type are in the c++ assembly, an exception is reaised telling ...Show All

• .NET Development Quick way of determining a date from a string?

  Hi all, I have a .NET 1.1 application that needs to be able to very quickly determine if a string is a date. I can not use Exception handling here (i.e. as you would using DateTime.Parse) as it is expensive and there is only a 1% chance that the string will be a date with potentially tens of thousands of strings being checked. Do you guys have any suggestions Regards, Stephen. Unfortunately upgrading isn't an option. Also, we found that getting into regular expressions has been too complicated so we are taking a completely different approach now that doesn't involve checking dates. Thanks for the help though people. It has been much appreciated! Regards, Stephen. ...Show All

• Windows Networking Development Winsock2 API - receiving data

  Hi, all! I know it is a simple question, but I assure that have searched in maaaany places for an answer for it and haven't found yet. I've looked even at HTTP RFC and Transmission Control Protocol RFC, but didn't find at first sight, not so deep. I also don't know if here at WSK Forum is the real place to take this question, but I didn't find any better. I just want to know how can I know if one side of the connection has ended up sending data. I am trying to connect to an IIS webserver, for example. I am the client and send to the server any GET command. Then, I enter in a loop of recv(), like this: char buffer[1024]; int bytesRecv=0, totalBytes=0; while(bytesRecv!=SOCKET_ERROR) { bytesRecv=recv(ConnectSocket, buffer, 1024, 0) ...Show All

• Visual FoxPro Deleting records

  Hi, I need to delete some records from a table that has the same values for some attributes. Some attributes are part of the primary key while others not. Thanks, I am sorry, but you are not giving us enough information here. How is this delete to be done In an application, or in development environment . Is this a one-off operation, or is it something you will have to run again and again Basically it sounds like you need to use a SCAN to traverese the table one row at a time and decide whether to delete the record or not. But without more information it is impossible to be precise.... ...Show All

• SQL Server connecting to remote server

  Hi friends we've C# app that connects a sql server 2005. we've new requests from client that when users go offsite they still want use our app and connect to sql server. my question is how can we connect to sql server remotely is it using TCP/IP protocol if so how do we do that Thanks for ur help. Hi prk, DNS is the Domain Name System -- essentially the directory service that translates your hostnames into IP address. Your network probably has one and your network admin should be able to give you more info. Regardless of the geography, if your server is configured to listen to a remote protocol and the firewall (if any) is configured properly, you should be able to connect from your client app. The BOL contains some great info ...Show All

• Visual C# ReportGeneration Application

  I have to create a web app. that prints out the statistics for student applicants in a .txt file. The data in form of Tables resides in a SQL server. Now, the user provides a date range(for eg. from 12/1/2006 to 1/1/2007) and the outputted text file will have the following: - The Number of applications received - The number of applications approved - Number of students with a criminal background and the type of background - Number of applicants who applied last year. I was wondering that from a design standpoint, what would be an elegant and effecient way to extract the data from the server, store it in some kind of data structure and output the contents in a text file. I was looking at Enterprise library and interfaces but ...Show All

• SharePoint Products and Technologies VSeWSS Debugging has just stopped working????

  Hi All, when I did my clean install, I created a simple "hello World" web part. Pressed F5 and it deployed and debugged - Hooray. (VS2005, SP1, VSEWSS, SQL Server 2005) Now I am starting to work on the real web part, I have run into two problems. The first is the most worrying: Pressing F5, fires up the build, and the deployment, BUT never fires the browser or the debugger. It just says deploy successful. Now I do have ASP debugging enabled in IIS, and it DID work at first. Can anyone tell me how to get this working again please The second is that after one or two succesful deployments, it suddenly stops deploying with a weird error of: "Object reference not set to an instance of an object". So I then ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Math 101: Lerp() vs SmoothStep() ?

  For all practicle purposes, what's the difference between VectorN.Lerp() and VectorN.SmoothStep() Is one more efficient (speedy) than the other Will I get radically different results at given percentages Under what circumstances would you want to use one rather than the other Yes, the SDK docs tells me one uses linear interpolation and the other uses a cubic equation, but let's assume that doesn't mean anything to me :) (I believe I understand linear interpolation from the docs... looks like what I probably would've come up with on my own. Hoever, the docs really don't shed any light on SmoothStep.) Matt Lerp is the simple method that interpolates along a straight line, according to the distance ...Show All

• SQL Server multiple dataset fields in one table

  How to use multiple dataset fields in one table. Example: I have one table --Table1. Two DataSets --DataSet1,DataSet2 Table1 refers DataSet1.I want to use DataSet2 field in Table1.It is taking SUM if did this but I don't need sum. you could do something like this =Sum(Fields!fieldnam.Value, "Dataset Name") and it would get the value from the specified dataset ...Show All