netCharting in asp.net

Use netCharting, produced by the canadians team developpers, to generate and display
the advanced charts in ASP.NET application.



The code source here under in vb.net displays a bar chart which displays the
unit stock for each product.

<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
script runat="server"

Sub Page_Load()
Dim objSeries As New Series()
objSeries.ConnectionString = "server=localhost;uid=sa;pwd=secret;database=Northwind"
objSeries.SqlStatement = "SELECT ProductName, UnitsInStock FROM Products"
myChart.SeriesCollection.Add( objSeries )
myChart.Title = "Units in Stock"
End Sub

/script

dotnet:Chart id="myChart" runat="Server" /

ASP NET articles from Steve C. Orr

Such as :
- Export to excel ***
- Bar graphs to go
- Streaming media

http://steveorr.net/articles/

Index On rtRefTitres & CTRL codeFival

Only 2 indexes are created on the table :

CREATE INDEX [Ndx1_rtRefTitres] ON [dbo].[rtRefTitres]([rtCodeValeur], [rtDate]) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
CREATE INDEX [Ndx2_rtRefTitres] ON [dbo].[rtRefTitres]([rtDate])
WITH FILLFACTOR = 90 ON [PRIMARY]
GO

---

- Generate the table/View with DateMax ONLY for '2004%' :

Create View v_rtRefT_DateMax
As
select rtCodeValeur,DateMax=max(rtdate) from dbo.rtRefTitres
where rtCodeFival ='99999'
and rtDate like '2004%'
group by rtCodeValeur --order by 1

Then compare it with the original table :

select r.rtCodeValeur, rtLibelleValeur, rtcodeFival, DateMax
From rtRefTitres as r, v_rtRefT_DateMax as v
where r.rtCodeValeur = v.rtCodeValeur
and rtdate = DateMax
order by 1

- Generate another table/view with DateMax ony for year 2004
where rtCodeFival !='99999' :

Create view v_rtRefT_DateMax_DiffCdeFival
As
select rtCodeValeur, rtCodeFival, Max(rtDate) from rtRefTitres
where rtCodeFival != '99999'
group by rtCodeValeur, rtCodeFival

- Update the original table by using these 2 views as conditions.

Howto accelerate the SP for the currency conversion

-Export the APRT table to the fastest server.
-Modify the structure of SP currencies conversion as follow :

---

declare @idtar varchar (20)
declare @Mont int
declare curseur cursor for
select idt_ar, Montant_ar * 1.35
From test where ...
Open curseur
Fetch next from curseur into @idtar, @Mont
While @@fetch_status = 0
Begin
Update test
set Montant_ar = @Mont
where idt_ar = @idtar and ...
Fetch next from curseur into @idtar, @Mont
End
Close curseur
Deallocate curseur

---

-After the execution of the SP with success, re-export the APRT table back to its server.

The major databases servers on the market

This is to inform all news, tips concerning the DB2 v82, Oracle 10g, and SQL Server 2005.