Search results for query: *

Hi all. Can anyone tell me how, using VB.NET, to format an SQL Server Money datatype to display the value in 1000s? So that 678900 would be 679 and 98 would be 0 etc. Thank you. Stephen.

Hi all. When I am debugging an application that has quite a long running process (i.e. a large data extract process), and I stop debugging the application before the process is finished, the process keeps on running, despite me having ended the debugging session. The only way I can stop this...

Hi all. I am extracting information from an MSSQL DB and using VB to manipulate it and output it to text. The problem is that what should appear as 'Gebrüder' is output as 'Gebr?der'. Any ideas on what could cause this? Thanks. Stephen.

Hi all. I am new to Crystal Reports (we have purchased CR XI Developer) and have been asked to produce a PDF document that firstly contains a cover page detailing the contents of the PDF document, then follows a heavily formatted directory style report that is split into 2 columns (information...

Hi all. If I have a telephone number like '01623...', how can I efficiently format it to look like '(01) 623...'? I would like to this to be simple and quick, so I would like to avoid hacking the string up with Substring etc, if possible. Thank you in advance. Stephen.

Hi all. I would like to store a single whitespace at the end of a value in Access so that when I fetch it using VB, I get something like 'value '. How can I achieve this? Thank you in advance. Stephen.

Hi all. We have recently installed a Windows 2003 Server as a domain controller (we have moved from a work group) and have found that we are no longer able to access eachothers development machines via HTTP (We can get to them accross the network though). Previously, for testing purposes, we...

Hi all. I have the following DataSet: <xs:element name="Structure" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="INF_COMP"> <xs:complexType> <xs:sequence> <xs:element name="PK" type="xs:int" /> <xs:element...

Hi all. So, is it possible to rename the fields in XML created from a DataSet. For example, I have a Table called Company and its fields are named using the convention F001, F002, F999, etc (Don't ask why, as it was outside of my control). I would like to give these fields more meaningful names...

Hi all. I am building an application that will be based on the n-tier architecture (Presentation/BLL/DAL[NHibernate]/SQLServer). The purpose of this application is to produce compressed (zipped) Text, PDF and XML documents from the datasource, based on criteria entered into the presentation...

Hi all. I thought this would have been a very simple task, but it has become a bit of a nightmare. How do I dynamically change the header text of a DataGrid column at runtime? I have the following codeIf (objShop.deliveryCalculationMode = Entities.Shop.deliveryCalculationModeType.orderPrice)...

Hi all. Today, VS.NET's debugger has decided to go a bit mental. For some unkown reason, none of the breakpoints were hitting because of the dreaded Breakpoint will not currently be hit... symbols... etc" message. So, as this has happened several times before, I managed to fix it, by selecting...

Hi all. Can anyone translate the following bit of C# code to VB.NET for me? public event EventHandler MyEvent; private void OnMyEvent() { if (MyEvent!= null) MyEvent(this, EventArgs.Empty); } Thank you. Stephen.

Hi all. I am modifying a CMS app for a client and need to know if, using JavaScript and the MSHTML WYSIWYG editor, it would be possible to write some code to allow my client to highlight a piece of text in the MSHTML iFrame box and select a link from a listbox to be applied to the selected...

Hi all. I am preparing to start a project which will require the outputting of a specific data extract to Word, then HTML, then PDF. We have decided to go with a reporting tool, such as Active Reports .NET, that can output PDF and HTML (most can these days), but I haven't found one that can...

Hi all. I'm trying to locate a problem in a web app that, under certain circumstances (such as when accessing the app when logged in) is causing very slow execution times. I went ahead and placed timers for the main page events for each of the controls that load during a prticular request. I...

Hi all. After years of hiding behind OR/Mapping tools I'm finally being forced to re-learn SQL for a heavily report-based application. One of the key issues that has arisen is the need to output report data to XML in a structured format. I've been told time and time again that DataSets are the...

Hi all. Don't know where else to post this, but I have run into a bit of a dilemma. A client has asked of the possibility of exporting their reports to XML. I have been searching and searching but can not find a VB.NET compatible reporting solution, with the exception of Reporting Services...

Hi all. I am tring to find out about reporting packages for .NET and SQL Server (but not SQL Server Reporting Services as we have tried ordering the CD weeks ago and still it hasn't shown up and we don't have time at present to wait for another possible 3-4 weeks). I have looked at Active...

Hi all. I've just spent the last three days copying a massive SQL Server DB from one server to another using DTS and none of the indexes or PKs have copied accross. This process was such a huge drain on resources that we really want to avoid repeating it, and as there are around 200-odd indexes...