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.
How to restrict user to enter first character as alphabet in textbox in c# windows forms not asp.net
thanks
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 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 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...
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...
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,
How do i write test cases for an vb.net application ...an example will be of great help..
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 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 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...
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...
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 an ASPNet 2.0 gridview with a single hyperlink field.
The gridview is bound to a database table where there is a name field and url field. The desired effect is to display in ea...
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 am working \ struggling with a school prjoect and am stuck. I have an HTML form generated with an .aspx file (attached) that asks a user to fill in text boxes to insert a new SALE record in ...
Could someone please tell me how to connect a WPF Browser Application to a web service. I am trying to do this in .NET 3.0. In a .Net 2.0 Web Site I would connect to a web service by using ...
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 developed my Project with vb.net on Sql server and made reports on crystal reports VS 2005
Please tell me the steps of making a setup project of my crystal reports to be run on the clients
...
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...
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
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...
