|
cyber-drugs wrote: The slow page, is it making use of the GridView?
Yes it is making use of Gridview
cyber-drugs wrote: Where is the data from the GridView coming from?
SQL Server
cyber-drugs wrote: It SQL Server, which version?
2003
cyber-drugs wrote: Is the data coming from a query, stored procedure, or where?
Both, Im also running checks on the rows when the page loads
cyber-drugs wrote: Is the GridView making use of Paging?
yes
|
|
|
|
|
ICT,
There is no SQL Server 2003, there is 2000 and 2005, so can I presume you are on 2000? If so, that would be why your page is slow, or at least my presumption without in deptch analysis!
SQL Server 2000 cannot handle "real paging", it gives you the effect of paging, when in fact it pulls down every single record from your query, and then when all the data from the database hits the .NET web server, this will cut up the data and make it appear as if you are getting paging.
In SQL Server 2005, they added the feature "Row Numbering", which allows you to get true paging, so when you ask for the first 100 records in a table, starting from record 101, it gives you just 100 records, where-as 2000 would of given you every single record.
The way to confirm this, if you run query analyser and run a trace on the database being used, and find the query being fired to the database by your GridView. After you have this query, try running it manually in query analyser. If this query runs as slow as your page takes to load, we have identified your problem.
The easiest solution would be to upgrade to SQL Server 2005 or above.
|
|
|
|
|
cyber-drugs wrote: The way to confirm this, if you run query analyser and run a trace on the database being used, and find the query being fired to the database by your GridView. After you have this query, try running it manually in query analyser. If this query runs as slow as your page takes to load, we have identified your problem.
How do I do this then?
thanks
|
|
|
|
|
eyeseetee wrote: One of the pages in my application is taking a lot longer then another page to load
If you are getting the data from a database it could be a database problem.
Try running the same query on the database to see how long it takes to run.
If it is slow, the table indexes may not be setup correctly.
eyeseetee wrote: apart from the last row in the page
Do you mean last data row or footer row?
|
|
|
|
|
Last data row for the current page, so say there is 3 pages, the last row on each is not the same as the others in formatting.
|
|
|
|
|
How are you formatting the rows?
|
|
|
|
|
hi there,
i have developed a site and use Javascript ActiveXObject. when i make it's vIRUALdirectory in IIS, then the code will work fine on my machine only.
But if i try to run from another machine then browser will block and can not auto install the ActiveXObject
what can i do ???
i have also allow all the security permissions but still i face same error
thankx in advance
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
You can't do anything, its the browser security settings taking control. The user shoudl get the option to install, but you cannot force it to happen.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi All,
i am getting following web config parser error when i run my web application.
Parser Error Message : Unrecognized attribute 'cookiename'
|
|
|
|
|
In your VS tool just check for "cookiename" by pressing (Ctrl+Shift f )
search it. as you have given very less information
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
He..
I am working on an ASP.net application, that has been running in 2 different languages, danish and english for 4 years.
The customer needs now to include the japanesse language.
Is there something, that I should be aware off!
Like SQL statements, convertion of (dates,strings) and so on. I am using SQL server, ASP.net and C# code.
Some of the text used in the application is placed in the database and some in ressource files.
What about the server, IIS is there any settings needed?
I hope somebody out there have done such implementation and can share some of the experienced issues.
Regards Juliette 
|
|
|
|
|
I'm not 100% certain if this is the case, but if Japanese is read in a different direction (e.g. right to left), then you'll have to have a good look at the design of your site to ensure that it can be supported.
You'll also need to make sure that your DB is using wide text types (e.g. nvarchar) to allow the saving of the Japanese characters.
|
|
|
|
|
I have seen, some applications with the Japanesse language, but the text looks like it's writen from left to right. But I am not sure exactly.
|
|
|
|
|
|
Hi All
I am getting problem in putting text at the cursor location in freetext box which is place in a Place holder and .
My code is as follows:
<select name="ddlPlaceHolders" onchange="FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml<br mode=" hold=" />(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);">
<option value="<!FN>">First Name</option>
<option value="<!LN>">Last Name</option>
<option value="<!EM>">Email</option>
</select>
the statement
"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"
is working fine but when i change it to get value instead of text as
"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"
its not showing any thing in the freetext box. Please help me
Thanks
wajans
|
|
|
|
|
Hi All
I am getting problem in putting text at the cursor location in freetext box which is place in a Place holder and .
My code is as follows:
<select name="ddlPlaceHolders" önchange="FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml<br mode=" hold=" />(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);">
<option value="<!FN>">First Name</option>
<option value="<!LN>">Last Name</option>
<option value="<!EM>">Email</option>
</select>
the statement
"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"
is working fine but when i change it to get value instead of text as
"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].value);"
its not showing any thing in the freetext box. Please help me
Thanks
wajans
|
|
|
|
|
hi
I have same problem. I have a freetextbox, a button and a hidden field
I want to insert the hidden field value at cursor position in freetextbox by pressing the buttion. How I can do it using the
"FTB_API['FreeTextBox1'].InsertHtml(HiddenField1.value);"
Please send me complete code.
Code that you used in Code behind file, Javascript and html
I am stucked from last week
Thanks
|
|
|
|
|
Hi..
I want to send multiple http request (eg. to google.com, codeproject.com, yahoo.com,....) & recieve their responses. I want to minimize the time so want to send these requests in parallel. I am making ajax enabled web site. At present i m using async task to send multiple requests but they r nt executing in parallel. Is their ne other way to do this ...
|
|
|
|
|
Is the Function keys(F1,F2....) will work on web application(at run time)?if yes please can i know how it works?
Thanks
|
|
|
|
|
What do you mean?
Do you mean whilst a page is loading?
|
|
|
|
|
...
Blog link to be reinstated at a later date.
|
|
|
|
|
hi, Its my first time for ASP.NET, therefore this question can look strange. I want a big poster image in front page of website. So I splitted that image in some pieces and added same sized ImageBoxes. But problem is that those ImageBoxes are overlapping each other(very small) thats why i can clearly see its parts. Here is screenshot
http://img220.imageshack.us/my.php?image=overlappingdx7.png
any idea to solve this ?
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
iam having a long page to view.now how can i get the page up and page down when a button is clicked so no need of going for the page scroll.please heip in this reard
|
|
|
|
|
|
i have uploaded the image file using asp fileupload control.
i am uploading files to this folder:
F:\MySite\FileManager\MyUserName
saved the file name and file path to database.
in my database i have DocumetName
TestImage.JPG
and Path
F:\MySite\FileManager\MyUserName\TestImage.JPG
<asp:TemplateField headertext="picture">
<ItemTemplate>
<asp:Image ID="Image2" width="40" runat="server" imageurl='<%# Eval("DocumentName") %>' /> <br/>
</itemtemplate>
</asp:TemplateField>
i tried like this(use Path instead of DocumentName) aslo but it doesn't show any image and no error also
<asp:TemplateField headertext="picture">
<ItemTemplate>
<asp:Image ID="Image2" width="40" runat="server" imageurl='<%# Eval("Path") %>' /> <br/>
</itemtemplate>
</asp:TemplateField>
i am using this to get all file details
Private Sub GetAllTheImages()
' Declare objects...
Dim objConnection As SqlConnection = New _
SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDB;Data Source=MY\SQLEXPRESS")
objConnection.Open()
Dim myCommand As New System.Data.SqlClient.SqlCommand()
myCommand.Connection = objConnection
myCommand.CommandText = "GetAllTheImages"
myCommand.CommandType = CommandType.StoredProcedure
Dim param As New System.Data.SqlClient.SqlParameter()
Dim myAdapter As New SqlDataAdapter(myCommand)
myAdapter.Fill(GetAllTheImages)
Dim reader As SqlDataReader = myCommand.ExecuteReader()
GV1.DataSource = GetAllTheImages
GV1.DataBind()
objConnection.Close()
End Sub
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
