Display DB Table in ASP

Getting started with SQL Server

Index ‹ SQL Server
- Archive
  - VS 2008
  - Dotnet
  - Smart Device
  - VB
  - Visual Studio
  - SQL Server
  - VFP
  - VS Express
  - Visual C#
  - SharePoint
  - Windows Live
  - Windows Vista
  - Windows Forms
  - Game
  - IE
  - Office
  - Architecture
  - ISV
  - VC++

- Previous
  - 1
    - how can i get such a result set? For example I hv got a table 'Customer' like this: Customer_name Customer_phone Iverson 1234567 Kobe 2345678 Tmac 3456789 Wade 5678901 James 6789012 Bosh 7890123 Iverson 8901234 Wade 9012345 James 2987654 Iverson 3567890 . . . . And now I want to get a display like this: Customer_name Customer_phone1 Customer_phone2 Customer_phone3 Iverson 1234567 8901234 3567890 Wade 5678901 9012345 James 6789012 2987654 Kobe 2345678 Tmac 3456789 Bosh 7890123 Please note that I don't know how many columns (Customer_phone) would appear, i just want to display all. how can i do it thanks! Tag: Display DB Table in ASP
  - 2
    - Custom Object in SSIS Pooja B wrote: I also need the same. My code is in C# and that could not be converted in VB.NET. Did you find any way to invoke C# class Please let me know also If you find any solution. Thanks, Pooja Darren answered this question already (above). Is anythig not clear -Jamie Tag: Display DB Table in ASP
  - 3
    - Index Fragmenation Index fragementation caused by using GUIDs in indexed columns shouldn't be causing the issues you're seeing. While it is certainly true that you'll see very high index fragmentation for these columns (our production DB often has 95%+ fragmentation), this isn't necessarily going to kill your performance. We did extensive performance comparisons before decided to go with nearly 100% GUIDs are primary keys. There was certainly a perf difference, but it was negligible overall. In fact, INSERT performance may actually increase thanks to the fact that disk hot spots are far less common. I would examine the query plans before/after your defragmentation/rebuild your index. I think something else must be going on here. Tag: Display DB Table in ASP
  - 4
    - Error When Open Analysis Services From Management Studio I wouldnt recommend installing CTP of SP2 without trying it first on the production machine. But the problem looks like to be related to the SQL Management studio. Try installing CTP of SP2 on a client machine and then connecting to the server. See if the same error is happening. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. Tag: Display DB Table in ASP
  - 5
    - mobile phone and databases Can you please tell me what are the risks of customers using a mobile phone to send a request of information which will be automatically responded to as an entry is made into the database. How do I ensure that the data intergrity is maintained, as this 'Table' in the database will take in many request a day and repond based on what the customer has type in on the text message. Tag: Display DB Table in ASP
  - 6
    - Howto get the result from two columns? sorry, I mentioned 2 things but you just need to do that to fix this. Mannivan, why do we need a temp table only, this ran fine for me: Code Snippet create procedure spTest as select 'TestCol1' as Col1, 'TestCol2' as Col2 GO declare @tb table(ID int Identity(1,1), Col1 varchar(50), Col2 varchar(50)) Insert into @tb Execute spTest select * from @tb Tag: Display DB Table in ASP
  - 7
    - Change Flat File Source Dynamically tofferr wrote: One small oddity... I wanted to set the variable in a Script Component for testing (rather than command line). However, I couldn't set the Script Component as the first object on my Data Flow since the Flat File Source object will not take a predecessor. Instead I created another Data Flow, made my main one dependent on that, and then added a "Source" Script Component to the new Data Flow... then I populated the new variable in that Script Component. Thanks, Chris Why not use a Script Task immediately before your data flow task to set the variable Tag: Display DB Table in ASP
  - 8
    - How to check multiple records with one query I'm very very thankful to you for posting this code. I'm sure, i would have never thought of this. We are very close to what is required but I need little more help. I have revised the code which was posted and i'm pasting here. Kindly note I'm using SQL Server 2005. Code Snippet use orders go declare @x xml set @x = N ' <e size="S" pieces="1" sizeId="1" sizeCombId="1"/> <e size="M" pieces="3" sizeId="2" sizeCombId="1"/> <e size="L" pieces="3" sizeId="3" sizeCombId="1"/> <e size="XL" pieces="3" sizeId="4" sizeCombId="1"/> ' insert into Orders . SizeDet ( sizeCombId , [size] , pcsinthatsize ) select t . c . value ( '@sizeCombId' , 'int' ), t . c . value ( '@size' , 'varchar(10)' ), t . c . value ( '@pieces' , 'int' ) from @x . nodes ( '/e' ) t ( c ) where not exists ( select * from Orders . SizeDet as sc where sc . size = t . c . value ( '@size' , 'varchar(10)' ) and sc . pcsinthatsize = t . c . value ( '@pieces' , 'int' ) ) select top 1 t . c . value ( '@sizeCombId' , 'int' ) from @x . nodes ( '/e' ) t ( c ) go select * from Orders . SizeDet go --drop table dbo.sizeCombination go If you will notice, now I'm adding the records directly in my table instead of temp table. I changed the pieces information also in the XL size, so it can insert records. Plus I need to check if a similar size and similar pieces are entered by user (which I have already modified above). The problem with this code is that it is just inserting one record i.e. XL size with 3 pieces. Actually if all four records are already found in the table then it should not add any records. But if even one record is different (like above), then it should add all 4 records in the table as that is treated as 1 combination. Pls help. Tag: Display DB Table in ASP
  - 9
    - Cannot Deploy Report - Please Help Prash Many thanks for your reply. I had the check box for 'SharePoint' ticked. I unticked it and set a few permissions and it worked. I would like to ask the difference between writing a simple report with report builder and using the report model. I presume there is more to it than the fact it can be utilised on a web server. Thanks Tag: Display DB Table in ASP
  - 10
    - Query Performance - SQL Server 2005 Hi, The table script and the query is shown below. Table Script ------------------ CREATE TABLE [dbo].[ActivityDetailsWithPaymentReport]( [AFTID] [int] NOT NULL, [ActivityID] [int] NULL, [FacultyID] [int] NULL, [ActivityIdentity] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ActivityStatusKey] [int] NULL, [ActivityStatus] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ActivityTypeKey] [int] NULL, [ActivityType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ActivitydescriptionKey] [int] NULL, [Activitydescription] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BrandKey] [int] NULL, [BrandDiseaseState] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SupplierKey] [int] NULL, [SupplierName] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Occuredby] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Occuredwhen] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AddedBy] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AddedWhen] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Cancelledby] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Cancelledwhen] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AssignedTo] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BudgetApprovedWhen] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BudgetStatus] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CheckNumber] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CheckAmount] [money] NULL, [CheckDate] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CheckStatusKey] [int] NULL, [CheckStatus] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CheckTypeKey] [int] NULL, [CheckType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CostCentre] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CostElement] [int] NULL, [Country] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DocOnFileChecked] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DocOnFileCheckedWhen] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ActivityEndDate] [datetime] NULL, [ReportEndDate] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FacultyFirstName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FacultyLastName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FacultyName] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [IONumber] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LeadRepresentative] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LocationCity] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LocationName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LocationState] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CheckMailDate] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FacultyCount] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OusPayments] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PaymentType] [int] NULL, [ActivityStartDate] [datetime] NULL, [ReportStartDate] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TOPIC] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PWInternal] [int] NULL, [SBStatus] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Credentials1] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Speciality1] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TierLevel] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [W9OnFile] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Affiliation] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ContractOnFile] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LeadRepresentativeVoiceMail] [varchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SBEventNumber] [int] NULL, [ProductsListedFor] [varchar](8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AnnualContract] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Address] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [City] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [State] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SequenceID] [int] NULL, CONSTRAINT [PK_ActivityDetailsWithPaymentReport] PRIMARY KEY CLUSTERED ( [AFTID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] Query to retrieve the fields from the table ----------------------------------------------------------- SELECT ActivityIdentity AS ActivityNumber, ActivityType, ActivityDescription, ActivityStatus, ReportStartDate AS StartDate, ReportEndDate AS EndDate, LocationName, LocationCity, LocationState, Country, BrandDiseaseState, SupplierName, PaymentType, CheckNumber, CheckStatus, FacultyName, FacultyID AS FacultyKey, FacultyCount, CheckDate, CheckAmount, CostCentre AS CostCentres, CheckMailDate AS MailDate, CheckType, AddedBy, AddedWhen, Occuredby, Occuredwhen, Cancelledby, Cancelledwhen, DocOnFileChecked, DocOnFileCheckedWhen, AnnualContract, AssignedTo, OusPayments, LeadRepresentative, BudgetStatus, BudgetApprovedWhen, CostElement, IONumber, Topic FROM dbo.ActivityDetailsWithPaymentReport WHERE ActivityStartDate >= '01/01/2007' AND ActivityEndDate <= '12/31/2007' Thanks Dinesh Tag: Display DB Table in ASP
  - 11
    - Analysis Services Performance We have an Analysis Services server that freezes from time to time (processor is sometimes very high, memory is high, and then we can not even stop the service - as if it went in an infinite loop). I would like to know whether the following configuration overloads the service or not: 4Gb of RAM SQL Server and Analysis Services installed on the machine SQL Server limited to 1Gb of RAM Analysis Services stay below 1.5Gb Analysis services takes the rest We have 102 cubes, some of them up to 100Mb Apriori, is that configuration overloading the processor, or the problem is somewhere else Tag: Display DB Table in ASP
  - 12
    - 70-431 (MCTS - SQL 2005) Hi Gunny, is 700 scored. Tag: Display DB Table in ASP
  - 13
    - How do I not show a field if the field contains nothing? The IsNothing is to handle NULL fields. The "" takes out the fields that are just blank. BobP Tag: Display DB Table in ASP
  - 14
    - Remote Connections using SQL Server 2005 Developers Enterprise Edition Hi again, I have taken the following steps to see if ZoneAlarm was presenting a problem. Please note that I have not heard from ZoneAlarm yet. I removed my wireless network card that I am using to conect to the internet. I disabled my ZoneAlarm and Windows firewall. I followed the steps in the article that was more focused on SQL Server Developer since I am not using SQL Express. I executed the command I mentioned earlier to see if I could connect to SQL Server remotely with out any firewall interference. I could not,and I received the same error. I did look at the other article that was more SQLExpress focused, but I am not sure how I would apply some commands in that article to SQL Server Developer. I have used the SQL Server Surface Configration to enable local and remote settings and using TCP/IP and Name Pipes. It shows that the radio buttons for both are selected, so I know that those choices are selected. As far as selecting a port, I am asking you what would be the SQLCMD command version for SQL Developer The one for SQL Express is stated in the article, is there a similar one that I can use for SQL Developer I tried to set the port using clientconfig.exe but that doesn't seem to work. Tag: Display DB Table in ASP
  - 15
    - Non-queried Parameters The issue is with SQL, not with RS. http://www.eggheadcafe.com/software/aspnet/30883496/multi-value-parameter-hel.aspx etc on the web Tag: Display DB Table in ASP
  - 16
    - MS SQL installation error We are trying to install the SQL Server 2005 Enterprise 32Bit Edition in a clustered environment and keep receiveing the following error during the install: The installer has encountered an unexpected error. The error code is 2878. On the dialog ClusterGroupDlg the control DataPath has a possible value : y:\Microsoft SQL Server\. This is an invalid or duplicate value. Tag: Display DB Table in ASP
- Next
  - 1
    - SSIS Capacity I think it is not a problem .But , what problems would be Workload It is Integration Services Server that ca run a package and cooperate with SQL Engine.In plus this data inserting in many case is made nightly or after 5 pm. Anyway , in your package before and after data flow task change recovery model if you have once to insert 100 gb of data. Tag: Display DB Table in ASP
  - 2
    - Transaction log file disappearing without reason check SQL Log and application log for any clue Madhu Tag: Display DB Table in ASP
  - 3
    - Stored Proc NOT using Index? Here is some additional infomation concerning Parameter Sniffing. Stored Procedure �CParameter Sniffing http://blogs.msdn.com/queryoptteam/archive/2006/03/31/565991.aspx http://tinyurl.com/f9r2 http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/17/444.aspx Tag: Display DB Table in ASP
  - 4
    - Sample code to importing data from ODBC Qiuwei wrote: Yes, I am. The number of tables in ODBC source will change at any time. So I'd like to build SSIS package programatically using SSIS API. So what I want to do is to check to see if a table in ODBC source existing in SQL2005 first, if not, create a table first with same table name, schema... and then pump data. Thank you. Right, well this isn't a C# problem. Take C# out of the equation. How would you otherwise check to see if a table existed in your source Note that this depends on what sourt of source system you are accessing and seeing as you haven't provided that information, I can't help you. -Jamie Tag: Display DB Table in ASP
  - 5
    - Add column with fixed number of values (text) to the select statement I'm using ver. 2005. The select is very simple concerns the tables with historical rates for curves. So there are four columns: 1) Date 2) Name of the curve 3) DF 4) Implied rate there are 17 rows of data and I need to add column with fixed tenors O/N T/N S/N 1W 2W 1M 2M 3M 4M 5M 6M 7M 8M 9M 10M 11M 1Y Tag: Display DB Table in ASP
  - 6
    - SQL 2005 - Migration from SQL2000 / LEFT OUTER JOIN You should also run DBCC UPDATEUSAGE in the database, post-upgrade. Chris Tag: Display DB Table in ASP
  - 7
    - Editing Input Data in Script Component I can try that, but it seems to me that I will get the same resulting error Can you be more specific Tag: Display DB Table in ASP
  - 8
    - SQL Server Management Studio Express won't open but appears in task-bar When I first installed SQL Server Management Studio Express everything worked great The next day, when I try to open SQL Server Management Studio Express I get the Startup Screen then all that happens is SQL Server Management Studio Express appears in the taskbar but no window appears I think my problem has something to do with a SQL related product crashing one time when I shut down my computer Does anyone know a solution to this problem Tag: Display DB Table in ASP
  - 9
    - Pass parameter to SSIS Sorry, I answered my own question. There is a good overview of dtexec with examples at http://msdn2.microsoft.com/en-us/library/ms162810.aspx . Tag: Display DB Table in ASP
  - 10
    - SQL Server 2005 Express Edition Is SQL Server 2005 Express Edition, compatable with Visual Basic 2008 Express Edition Tag: Display DB Table in ASP
  - 11
    - Upgrading SQL Express: is it possible to restrict to which version upgrade is possible? i can add the 2% of the missing from my side. :-) Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Display DB Table in ASP
  - 12
    - Partitioned Tables and Parameters I think the problem is that when the value you are selecting by is a constant then the query planner can optimise based upon that value. However when it is a variable it cannot see (or ignores) the value of the variable when it is generating the query plan and so must generate a more general plan which will work for any value of the variable. This is how it works by design I believe and allows it to reuse the query plan for other invocations of the same query (changing the value of the variable does not change the query). Tag: Display DB Table in ASP
  - 13
    - Granting Permissions using SQL 2005 Schema... Thanks for catching that Raul...not even sure what I was thinking last night. Or not thinking at that moment. -Sue Tag: Display DB Table in ASP
  - 14
    - replication folder's didn't locate local publications,need help! Did you configure this server as a publisher What happens when you try to create a publication Local publications are more appropriate if you are creating a publication on the server. The local subscriber folder will display local subscriptions. Tag: Display DB Table in ASP
  - 15
    - Returning a value that has the smallest number of instances in a table Fantastic! Thank you so much to those who have helped me! Neil Johannesburg Tag: Display DB Table in ASP
  - 16
    - Error Casting String to Date I copied and pasted your code into my Expression Builder dialog box and received the following error: The expression "(DT_DBDATE)(SUBSTRING("200710221200_FileName_7001.log",1,4) + "-" + SUBSTRING("200710221200_FileName_7001.log",5,2) + "-" + SUBSTRING("200710221200_FileName_7001.log",7,2))" has a result type of "DT_DBDATE", which cannot be converted to a supported type. We are using: Microsoft Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Professional Microsoft Visual Studio 2005 Professional Edition - ENU Service Pack 1 (KB926601) I thought we were on the most recent SP. Is there a new one Thanks for your help Tag: Display DB Table in ASP

Prathap

hello forum friends,

i need to display the database table in ASP

page.how it is possible,can anyone explain me

with code.

Regards

Prathap

Top

Re: Display DB Table in ASP

Jens K. Suessmeyer

What about:

http://www.stardeveloper.com/articles/display.html article=2002061201&page=1

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---

Top