NagaB's Q&A profile

• SQL Server Fetch text from HTML [URGENT]

  Hello everybody, I have data in my sql server table that is entered with a rich text editor so it contains html formatting. I need to show this data on the form with the formatting user has specified while entering the data. On the crystal report, I need to show the data not in the html format but simple text. I created a stored procedure to fetch the data and binded the report with the stored procedure. When data is printed on the report, it shows HTML tags with the data. Is there a way to fetch text in SQL so that report will only show text without HTML formatting Thanks. You can use the following code to replace all the HTML tags.... CREATE Function dbo.Html2Text(@HtmlString As Varchar(8000) ...Show All

• .NET Development String concatenation optimized for avg. incoming packet size

  Hi, I'm currently working on a socket server that handles incoming ASCII encoded strings and I want to optimize the concatenation and framing of the incoming strings. Messages are stored in a buffer until message boundary is detected and released for processing. So, what I'm basically wondering is, if it's of any benifit to use a StringBuilder for the concatenation of the incoming string or if I can simply concatenate strings with str += "incomingstring"; My thinking is that StringBuilder doesn't add much benefit because PPPoE MTU is at 1492 and my messages have varying lengths from 100 to 400 bytes, which "SHOULD" mean that I ususally get the whole message per incoming packet. Am I right with this assumption ...Show All

• .NET Development How to force web services not to omit null fields in response SOAP message?

  Hi, We use web services to expose data manipulation services to another system developed with a different technology. Unfortunately, that system cannot handle missing fields in SOAP message (By default, SOAP messages generated in web services do not include fields with null value). Any one know how to force web services to generate the field tag even the value is null Thank you! You need to use [XmlElement(IsNullable=true)] on your reference type members to achieve what you want. Unfortunately if you are using attributes (members marked with [XmlAttribute]), there is nothing you can do: you would have to initialize them in the ctor. Thanks, Elena ...Show All

• Visual C# Generating HTML or CHM files via XML Comments

  Is there an option in Visual Studio 2005 that allows me to export all of my XML comments into a CHM or HTML file visually similar to the online MSDN library I know that there is nDoc and DOxygen, and other third party tools (none of which work well with .NET 2.0 btw), but I would think that with VS 2005, MSoft would finally include their own way of doing something like this. don't shoot the messenger! I'm on your side. I totally agree with you. Until then we have to find another way to do the job. Unfortunately NDoc does not work with .NET 2 and will not propably ever work. The development of the project seems to have stopped. Anybody found any other tool to do this ...Show All

• Visual Studio Team System Runtime error

  I have been working on the same project for the last few months with degree of success. However, every few days the client produces a new build for the application that sometime requires a complete re-script. During the latest build I decided to install SP1 for VSTE. Since then I have re-recorded the process and am now unable to play it back without displaying a 'RUNTIME ERROR', this happens on the first post back to the server, i'm not sure if this is due to the new build or the SP. Prevoius tests did not disply this message, however the latest has. i've tried the obvious hidden fields by extracting the manually (not relying on the automated code generated) this has made no difference. Time scales are very tight, I need this to work as so ...Show All

• Windows Forms flexgrid again

  hi , i want to use in vb.net , something like flexgrid , not for database data , but a) to make a grid with randomize data to display (lottary data) b) to read a text file and to show the data in grid format with cols and rows (import data from other programm) i try to find a solution but i not find anything , i want to make addrow , romoverow , and all the other commands from flexgrid i dont want to import the control from vb6 , except if is the only way to work i am new in .net , and i want to begin from easy things Thanx Makfor hi , yes i agree with you and you have absolute right , i just afraid , because the microsoft stop to support the visual studio 6 !!! that i learn and read in magazines here in greece , before so ...Show All

• Visual Basic running winrar in vb

  how can i run a winrar from vb by giving a input to it........... Nope ... but if you seek out the sdk or head on over to some winrar forums you should find people that can help. You probably need to investigate the com interfaces it exposes (assuming it does). Good luck Richard ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is this right for me?

  I think this is a good question that could benefit many new developers from a waste of $99. Hi everyone. I've worked with a small program called Gamemaker (how original) that some people may have heard of for the past 2 years. I've made small 2D games and recently took my first leap into 3D games, and I have been using the in game coding system for about a year. This coding system is similar to a very simplified version of a normal developing codeing system. I've never really used real code before, but I really love making games, and with my new Xbox 360, I think this would be a great tool I'd really enjoy. What I'd really like to know, is this something I'd be able to grasp I'd really appreciate any feedback! Thanks everyone! ...Show All

• Software Development for Windows Vista MS Access 2003 Queries

  Hi I have a product working fine under XP written in VB (access 2003 SP2). Most of the program works fine on Vista business but displaying graphs throws up errors. I think i may have narrowed it down to the SQL in the queries. I used the simple query wizard as a test, the SQL produced automatically caused an error message saying that the function is not available. Here is the automated SQL: SELECT DISTINCTROW Format$([MonthlyHoursInit].[Date], 'mmmm yyyy') AS [Date By Month], Sum(MonthlyHoursInit.DayCapDec) AS [Sum Of DayCapDec] FROM MonthlyHoursInit GROUP BY Format$([MonthlyHoursInit].[Date], 'mmmm yyyy'), Year([MonthlyHoursInit].[Date])*12+DatePart('m',[MonthlyHoursInit].[Date])-1; Any help would be great. ...Show All

• .NET Development the reference of the sleep function or the sample program for the sleep function?

  In javascript, I want to the function sleep for a while, can you tell me the reference of the sleep function or the sample program for the sleep function I appreciate your help. setTimeout - this function can be used to sleep for an amount of time specified by the milliseconds parameter and then call the function specified in the function parameter. setInterval - this function can be used to call the specified function every time the specified interval elapses. ...Show All

• Visual C# Connect to database on another computer

  Hello. I am making an application that is reading and editing database. I make a copy of the database while developing and woked on it. It was easy to connect and work with it. But I now need to connect to teh real database that is on another computer on our network. Connect wizard , as far as I can se only helps me to connct to lacal database file, not on the network. Could anyone help me here I've had the exact same problem a few weeks back. with a similar setup as you... WinXP for development and Win2k3 for Server with SQL 2005 I was certain my connection string is OK, so I did some research. turns out my Win2k3 machine wasn't setup properly after installing SQL2005 you have to ...Show All

• SQL Server Flat File and uneven number of columns

  Please leave feedback for Microsoft regarding this problem at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=126493 Ok I'm sure it just me, SSIS has been great so far....but how can you import a straight CSV file with and uneven column count. For example: (assume CR LF row delimiter) The,Quick,Brown,Fox,Jumps Hello,World This,is,a,test "Normally" I'd expect this | Col1 | | Col2 | | Col3 | | Col4 | | Col5 | The Quick Brown Fox Jumps Hello World NULL NULL NULL This is a test NULL Ok but what we get is the row delimiter is ignored in preference for the column delimiter and the row delimiter gets sucked in ...Show All

• Visual Studio 2008 (Pre-release) DoubleClick on FrameworkElement

  Hi, all. Is there any way to discover legacy doubleclick event on objects inherited from UIComponent or FrameworkElement, rather then from Control or I have to implement it myself AFAIK, the MouseDoubleClick routed event is only exposed by the Control class, actually I only have two methods to implement this routed event on FrameworkElement derivatives, one method is to re-implement every thing you need for the MouseDoubleClick event, you can use the reflector to examine the code for Control class to get the idea of how to do it, and the second method which I think probably is the most convenient is to add new owner for the MouseDoubleClick event exposed by Control type, for instance: public class DoubleClickElement : Fram ...Show All

• Visual Basic How do I determine how much ram a program will use?

  -Visual Basic Express 2005- I'm working on a very large accounting program that requires a few hundred variables. I'm declaring most of them publicly. Is there any information that tells how much ram strings, decimals, int16 and others take Also is there a limit to how many variables I can publicly declare in a module Thanks in advance A few hundred variables !!!! , With this figure you are unlikely to encounter anywhere near the limitations of that exists. No real world limits to the number of variables you can declare in a module, I'm sure that there is a number but its probably such a large figure that its really not a limitation and the limitation is probably not on the module but rather at the process level. As far as ...Show All

• Visual Studio Tools for Office Determine the location of the template

  Hi, I have started to create an add-in that will interact with a SharePoint list when the a new document is created from a SharePoint document library. The add-in is created and reacts on the NewDocument event, but I can not find any property on the Word application object (or in ActiveDocument) that tells me from which location the template was loaded/started. What I want to know is: Which document library have the user used for creating this new document Regards, // Henrik yes! That did the trick, now I get the template path and fullname in the "New document" event! Many thanks for this help, it was great // Henrik ...Show All