SQL Server 2005 (9.0)
How do we round 12.36547to two decimal places using T-SQL
12.37 NOT 12.37000
We tried select round( 12.36547, 2 )
Thank you for the help
I have some values that represent a floating point signed value converted to EBCDIC. Can anyone direct me to an example snippet that can convert the value back to ASCII ?
Thanks.
I have created a website using Visual Web Deveoper 2008 Express and SQL 2005 Express. It is coded in C#. The site is working fine on my local PC, but when I upload it, I get the following er...
I am working right now on writing a method to delete nodes out of a tree. I have written a method to find the node to be deleted. My issue is that i need to somehow point those child pointer...
I have a aspx form that i have created in visual studio 2005 that has a text box and a gridview control. The text box accepts a value that the user enters. A validation control ensures tha...
Because of the constraints with the size VARCHAR and the number of elements allowed in a WHERE IN clause, I need to create a temp_table that I insert ids into and then within my stored procedu...
Hi!
I need some help with a function that returns the IP of a machine using the computer hostname ot that machine:
So in a network I have a machine/server that have the hostname SRV and ...
I have created an application that uses SQL Express 2005 database in Visual Studio 2008 (C#, .Net framework 3.5)
Now I need to create a setup project that will install this application.
SQ...
Hi,
How do i write test cases for an vb.net application ...an example will be of great help..
In the code below I need for there to be an if statement...
IF <%#Eval("name")%> NOT EQ 16 or 51 the code below...
But if EQ to 16 0r 51 then <%#Eval("phone")%> and <%#Eval("type")%...
Hi,
I am having a problem opening a csproj given to us by one of our customers. Their IT guy is leaving them, so they are coming to us to manage their code. the whole project was transferre...
I'm using this to export a gridview to excel, the problem being that once i hit over 10000 records or so, it doesn't change and just displays the gridview. is there a different way to do this?...
I have a windows form application ( running on 15 desktops )that does the following...
1) Retrieve and display data ( data in XML format )
2) Communicate with windows services running on a...
Can any body suggest me a ready made source code for Image Compression in .net most preferably in C Sharp supporting a wide range of formats with high speed. I shall be greatful.
Thanks.
I get the following error message when attempting to load my project solution:
Package Load Failure
Package 'Visual Studio Data Package' has failed to load properly ( GUID = {E1AA7737-69...
Hi
Having some problem with Collection in Vb.net.
I have this
Dim test1 as string = "12345"
Dim test2 as string = "123456"
Dim test3 as string = "1234567"
Dim cTest as New Collec...
I am having problem Validating a Checkbox with custom validator in asp.net.
Could any one help me with code.
Thanks.
Hello Experts,
I would like, programaticaly, change the status of Outlook 2003 from Online mode to Cached mode.
I found some registry keys which probably worked with 98, but couldnt find any...
I have a dhtml window. What I need to do is when I click close I need the parent page
to refresh the parent page
this is done with asp.net vb codebehind.
When I click close from the f...
Hi
I have a text box that only numbers can be put into as represented by the following code. I also want to allow backspaces but am not sure what number this would be
Private Sub txt...
I am developing a application to send out mail buy using System.Net.Mail.SmtpClient class, but it seems to work with only those email servers which are hosted on Microsoft Exchange.
It runs...
Hi.
I have a datatable (not a database table just the object datatable in VS.Net) (Dim dt as Datatable)
this datatable has 10 columns call them C1, C2, C3 ... C10
I like to check if t...
Hi,
How can I determine if a number is odd or even? I am using the following code to determine my page numbers in a word document, but I need to know if the number is odd or even.
Dim l...
Hi
I am trying to add a reference to excel from .NET 2005. I have Excel 2000 installed on my machine.
But in the COM section of the Add a reference page in .NET i dont find the "Excel x.0...
We are running .net 2.0 on a windows server 2003 environment and receiving the noted error message. Does anyone know what could be causing this issue?
