Rahul Singla's Q&A profile

• SQL Server SQL server connecting problem....

  Hello friends,    I am very new to SQL server 2005, but I have a huge experience of Visual Foxpro. Using of  commands and queries in the SQL server are mostly  same. I have a problem to connect or starting SQL server. I don't know how I start SQL server. I installed it with Visual Studio 2005 Express and the installation was successfull. A:- When I am going to attach any *.mdf or *.mdb file in Visual Basic the following error messege occurs. An error has occurred while establishing a connectin to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. (provider: Named Pipes Provider, error: 40 ...Show All

• Visual Studio Team System Customize the Email format for Build Completes Notification

  Hi all, I need to know how i can approach to customize the email format for the build completes or any other event.... Please help me in this regard. Thansk in advance, Kathir Hi U could add the following mail task to any target on the execution of which you want a mail to be sent. As DQM said, override the AfterDropBuild to send out the email <MSBuild.Community.Tasks.Mail Condition="'$(SkipEmail)'!='true'" IsBodyHtml="true" Body="specify the body of the email here" Subject="subject" To=" xxx@xxx.com " From=" yyyy@yyy.com " SmtpServer="smtpservername" /> Thanks, Ramya ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Question about texture resource sharing

  If I call Texture2D.FromFile twice on the same file does the second call return the texture resource from the first call Does XNA manage and share resources SpriteTexture = Texture2D.FromFile(graphics.GraphicsDevice, "Ball.dds"); SpriteTexture2 = Texture2D.FromFile(graphics.GraphicsDevice, "Ball.dds"); Thanks No every time you use FromFile you get a new texture. If you need some texture management you have to implement it by your own. ...Show All

• Visual Studio 2008 (Pre-release) problem during deserialization.

  using XSD.exe I've generated .cs file and added that generated file to the Server side. I've created a proxy file using add service reference option and added the proxy file in the client side. The below code is there in the client side private DSCRQuery dscrQuery; XmlSerializer serializer = new XmlSerializer(typeof(DSCRQuery )); TextReader textReader = new StreamReader(opendFileDialog.FileName); dscrQuery = (DSCRQuery)serializer.Deseriali ze(textReader); DSCRQuery class is there in the proxy file. The above code snippet is not working with the DSCRQuery class in the proxy file but works well with the DSCRQuery class in the generated class file from XSD. The problem is dscrQuery is not getting populated with the opendFileDia ...Show All

• Visual Studio 2008 (Pre-release) HostingWpfUserControlInWf example crashes

  I have Spetember CTP I need to host a XAML form in my Winforms Application ;I have found the sample application from the 6.0 SDK ..WPF\MigrationInterop\HostingWpfUserControlInWf I compile the appliction and every thing is fine ; I run the applicationfrom VS2005 and the application crashes ; I run the application and step through the code ElementHost host = new ElementHost (); host.Dock = DockStyle .Fill; // Create the WPF UserControl. HostingWpfUserControlInWf. UserControl1 uc = new HostingWpfUserControlInWf. UserControl1 (); // Assign the WPF UserControl to the ElementHost control's // Child property. host.Child = uc; // Add the ElementHost control to the form's // collecti ...Show All

• .NET Development HTTP POST using tcpclient

  Hello, can anybody show me how to request an HTTP POST using tcpclient I need to use only tcpclient ... thanks for any help Hello thank you for your answers... I tried many samples but unfortunately without success... it is the first time i do this kind of thing if anybody can provide me an URL or a small sample code thanks a lot ...Show All

• SQL Server SQL Cluster Fails every 2nd week

  I have SQL Server 2000 SP4 Cluster Services running data on SAN I have two groups SQL1 owner SQLCL1, SQL2 owner SQLCL2 Active resources SQLCL1 owner SQLCL1 group SQL1 SQLCL2 ower SQLCL2 group SQL2 Every 2 weeks at 1:30 on a friday of all days The active resources for SQL1CL1 switch to SQLCL2 so under active resources i have all of SQL1 in there. I then decided to flip flop everything SQL1 to SQLCL2 Then again 2 weeks later again SQL1 fails over ..... I cannot figure out why that every 2 weeks this is failing over to the other nodes. Any advice is appreciated Hi Traceyms, Do you have any regularly scheduled activities during that time Are the groups set with a failback policy and preferred n ...Show All

• .NET Development SQLDataAdapter update to multiple tables through a single stored procedure

  Is this at all possible I've got a dataset with 5 related tables, and an elegant solution would be to make one call to update and write to all the tables through a single stored procedure. The problem seems to be mapping the sourceColumn parameter in the slqparameter - it would be great if the column could be defined as <tablename>.<columnname>, or the parameter could be associated with a table directly. Is anyone aware of a solution to this abrewerton wrote: Is this at all possible I've got a dataset with 5 related tables, and an elegant solution would be to make one call to update and write to all the tables through a single stored procedure. The pr ...Show All

• Visual Studio Express Editions Update notification to other running copies of software

  i have a stand alone prgm that talks to an access db, would like to let other people running the same software know that the db has been updated and cause their prgm to refresh data from the db. any help would be greatly appreciated. Generally, you will not know which computers are running your software, or how many, so trying to broadcast some signal to all other copies of your software is nearly impossible. For the most part, the software itself will need to determine or guess when updates are made. Your solution depends on how much control you have over that Access DB, and if you add fields to it, etc. The simplest way to do things is to set a Timer and do a full refresh each time it goes off. The Ti ...Show All

• Visual Basic Enter Button for a Field

  I read in another thread about this but I didnt get what was said...so ill reask this: I have a form. I want the form to activate a button after the user has typed some text and pressed enter. Geek Squad wrote: 1) I recall reading about key up and key down. What are they for Apparently they are for when a person presses a key The events fire in this order KeyDown, KeyPress, KeyUp... And what event you use depends upon a couple of factors: 1. What key(s) you are trying to trap, If trapping for non-characters...such as the enter key or control key you must use the key up or key down...the key press arguements do not contain non-character keys 2. What you are trying to accomplish with the trap Geek Squad wro ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Alpha Blending (deferred)?

  Is there a way using the sprite batch object that you can render several rectangles, but when alpha blended, it looks like the entire object was rendered first as a single opaque image, and then that image was alpha blended, such that you would never have known it was several smaller pieces assembling the final object Instead of normally seeing each rectangle blended as it overlays another rectangle. You can do it without the rendertarget, using either the stencil buffer, or using "equals" depth testing. For stencil, render each object to the buffer using a separate stencil value, but without writing to the color buffer. Then render again, using stencil test, each object using the appropriate va ...Show All

• SQL Server Query datetime and its performance

  Hi all, I know I miss something very obvious here, but I can see it at the moment - I am very appreciated if someone could help. Why am I have a table scan when I run the query below - note created_date is indexed. DECLARE @LastDate datetime SET @lastDate = (SELECT DATEADD(hh,-1,getdate()) SELECT * FROM Report WHERE Created_Date >@lastDate However, I don't have table scan when I do the following query SELECT * FROM Report WHERE Created_Date > (Getdate()-1) Thanks in advance Thanks all for replying, I guess this is one case that query optimizer try to out smart us, which is not a bad idea in some case. The problem I have is the table I am query from is very large, several million records, so ta ...Show All

• Visual Studio Express Editions concerning media player

  renee where do I post pause button code   I think if you have Word, you should cut and paste your code into Word, and then cut and paste that onto the board. If you don't have Word, you have Wordpad. I really don't like reading code that not's formatted and if you noticed, I never answer questions where people don't format their code and I always format mine. ...Show All

• Visual Studio Express Editions Ejecting removable media and activating a program from an outside operation

  Hi everyone, I was wondering if there's any way you can eject removable media (i.e. CD/DVD drives) at the click of a button in a program, like in windows explorer. And to activate a feature because of an outside operation (i.e. the opening of another program). Thnx in advance There are things that require changinf for Dot Net 'This is an API called mcisendstring,a readymade function from the winmm.dll available in windows. Declare Function mciSendString Lib "winmm.dll" Alias "mciSendStringA" _ ( ByVal lpszCommand As String , ByVal lpszReturnString As String , _ ByVal cchReturnLength As Long , ByVal hwndCallback As Long ) As Long Private Sub opencd() mciSendString("set CDAudio door o ...Show All

• Visual C# Math: Round up number. eg 1234 / 50 = 6

  I have a dataGrid and i wish to produce page buttons for next and back. Therfore i need to know how many pages i will need to for my data Eg, i have 1234 rows of data and each page will contain 50 rows. So 1234 / 50 = 24.68. So I need 25 pages How do i round up a number so 1234 / 50 = 25 . Thanks. Paul Everyone here is missing the fact that 1234/50 will be executed as an integer divide, automatically truncating to the lower integer. Now, what we really want is the next higher integer, which is always just the lower plus one. So given int Rows = 1234; in RowsInPg = 50; then int Pages = (Rows / RowsInPg) +1; will given you the number you want --- with the one exception. If t ...Show All