You searched for the word(s): userid:668700

More Search Options

RSS Available

• Re: Stringing fields of data with SQL

  Hi raghav Thanks a lot, works terrific

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by yairt on 10/28/2008

• Re: Line Chart Report

  Hello everybody and thanks for your replies. Eventually, I wrote a SP that created a dataset especially for the report (like you suggested), the SP inserted a new row between each two rows that included the new row's timestamp and the old row's temperature, so it displayed a horizontal change and not a diagonal change.

  Posted to SQL Server Reporting Services (Forum) by yairt on 10/28/2008

• Re: Stringing fields of data with SQL

  Hi raghav Thanks for your reply, however, in my post i forgot to mention that the current DB is located on SQL Server 2000. When I used your answer in SQL Server 2005 it worked fine, however in my DB ( SQL Server 2000) it did'nt work and resulted an error message as followed: " Incorrect syntax near 'xml'." Any ideas how to make it work on SQL Server 2000.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by yairt on 10/28/2008

• Stringing fields of data with SQL

  Hello I have a table of 3 fields, the first two are integers and the third is a string, what I need to do is to display a unite string for each two integers (like in GROUP BY). Example: record 1 : 1,1, "a" record 2 : 1,1, "b" record 3 : 1,1, "c" record 4 : 1,2, "d" record 5 : 1,2, "e" record 6 : 1,2, "f" what I want is a query that its outcome will be: record 1: 1,1,"abc" record 2: 1,2,"def" Does anybody have an idea

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by yairt on 10/27/2008

• Line Chart Report

  Hello I have an annoying problem and hope someone can help me. I wrote an air-conditioning control system and I want to display temperature changes during time. For that I use a line chart but I want to display the changes exactly in the time they occur and not leveled, for instance let's say the temperature was set to 20C on 10:00 AM and on 12:00 PM someone changed it to 21C, what I see in the chart is a diagonal line connecting the two dots, and what I want to see is a horizontal line on the

  Posted to SQL Server Reporting Services (Forum) by yairt on 9/7/2008

• Problems using IComparer implementation

  Hello I'm trying to sort an array of objects by one of its properties using IComparer: Here's the code inside the object's class: Public Class Unit_Display_Control Inherits System.Web.UI.WebControls.WebControl Private Class SortUnitIdAscendingHelper Implements IComparer Function Compare( ByVal a As Object , ByVal b As Object ) As Integer Implements IComparer.Compare Dim U1 As Unit_Display_Control = CType (a, Unit_Display_Control) Dim U2 As Unit_Display_Control = CType (b, Unit_Display_Control

  Posted to Visual Basic .NET (Forum) by yairt on 12/4/2007
  Filed under: vb.net, arraylist, collections, compare

• Random NullReferenceException on server

  Hello everybody I developed a web app (asp.net 2.0) using dnn portal (version 4.0.2), on the development machine and a test server everything worked OK. When I deployed the app to another server I suddenly started to get random NullReferenceException, the exception are random , happen on all the portal pages and without any relation to the user's actions, usually refreshing the page restores the page back to its original status. Here is the error message I recieve: [NullReferenceException: Object

  Posted to Configuration and Deployment (Forum) by yairt on 5/14/2007

• How to limit a menu width \ number of items shown

  Hello I'm using a menu control (horizontal) in my app in order to create tabs so whenever the user clicks a menuitem he gets a different view, the number of menuitems is determined by the user's input so I add the menuitems in the vb code while running. However, the fact that the number of items is unknown in advance causes me a problem because the menu can exceed the view width and even the entire page width. I tried to find a way to build another "floor" of items or to dynamicaly hide exceeding

  Posted to Master Pages, Themes and Navigation Controls (Forum) by yairt on 2/22/2007

• Re: Problems connectiong to a remote DB

  hi Iori jay thanks for your reply. The problem was solved (or better said was by-passed), apparently it has nothing to do with SQLSERVER or connection strings. We connected the server to the internet via ADSL line (`and not through a router that probably concealed its address) and everything worked just fine.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by yairt on 12/26/2006

• Re: Problems connectiong to a remote DB

  Hello Firstly thanks for all of your replies. Now, I've succeeded to connect my app to a remote DB but only in my company's network, the DB is located on a different machine in the company's network and I can connect to it using this connection string: connectionString = " Data Source= Inner network IP address \ SQLEXPRESS ;Database= DBName ;Uid= xxx ;Pwd= yyy ; " providerName = " System.Data.SqlClient " > However I have no success connecting it to an outer IP address, although the machine is

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by yairt on 12/25/2006