Slow working of web application

[Girish481]

Hello, Using VS 2005 and ASP.NET One Update panel with following controls: sqldatasource. next and previous button to naviagate. 51 textboxes to show the data from orace table. This is select command of sqldatasource SELECT * FROM "SECM98" WHERE (("ROL" >= :ROL) AND ("ROL" <= :ROL2)) ORDER BY ROL

Public Sub showdata(ByVal r As Integer)
SqlDataSource1.EnableCaching = True
dv = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), System.Data.DataView)
TextBox1.Text = IIf(IsDBNull(dv.Table.Rows(r - 1)("rol")), "", dv.Table.Rows(r - 1)("rol"))
TextBox2.Text = IIf(IsDBNull(dv.Table.Rows(r - 1)("cen")), "", dv.Table.Rows(r - 1)("cen"))
TextBox3.Text = IIf(IsDBNull(dv.Table.Rows(r - 1)("dst")), "", dv.Table.Rows(r - 1)("dst"))
..
..
End Sub

It is taking lot of time to run dv = Ctype(SqlDataSource1....) Or How do i get the resultset returned by sqldatasource, so that i can show the data in the textboxes. Please guide and help me. Regards Girish Sharma

[Abhishek Sur]

I think the problem might be in the database. check how much time is required to fetch actual data from the database. If it is taking long then use of Index might cure the problem somehow. :cool:

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.

[Girish481]

Thanks for your reply and interest in the thread. I am using oracle 10G database with proper index on rol column. I cheked that oracle is returning the rows in only 1 second in sqlplus. It is returning the rows fast in the oracle; but taking lot of time to run dv=..... line. Please tell me what should i do to resolve the problem. Regards Girish Sharma