|
It is usually a best practice to reference your data by column name, so the dr.Item([ColumnName]) method is best. The reasoning behind this is that if your query changes and you add or remove columns, you won't need to modify the your code to adjust for the resulting changes in column indexes.
The GetOrdinal method returns the index of a column that can then be used to retrieve the data for the specified column. This method is often used if performance is a concern. Retrieving data by column index is faster than by nane, so if you are looping through a large number of columns, you will typically retrieve the column index by name using the GetOrdinal method and then use that index to retrieve the data.
|
|
|
|
|
dr.Item(0) and dr.GetValue(0) are the same.
dr.Item("columnname") and dr.GetValue(dr.GetOrdinal("columnname")) are the same.
---
b { font-weight: normal; }
|
|
|
|
|
Sir,
I just wanted to know he difference between them.
Thanks
|
|
|
|
|
i am inserting into a table from an aspx page and writing all the code in c# i need to rollback a transaction how to do that
please help
Regards
|
|
|
|
|
4guys[^]
MSDN[^]
Hope this two articles will be very much helpful regarding the rollback a transaction.
Regards,
Satips.
|
|
|
|
|
Thanks It was quite a usefull link i managed it from there
Regards
|
|
|
|
|
Welcome 
Regards,
Satips.
|
|
|
|
|
 Hi,
I have developed webshop application using asp.net 1.1. I'm using
DataGrid in one of the pages of my site. During the page load the
DataGrid will be binded by around 7500 products(rows). At the same time
i'm storing the DataSet object in the Session Variable for later
refinement. I'm using StateServer mode for storeing the session values.
But in my server the W3wp.exe is taking 90 - 100 % CPU
Utlilization. Also my pages are loading very slowly. So afterthat even
if i browse some static pages in my site, then the static pages are
also taking much time to load.
I know that session is making problem because of its size. But i
need the DataSet object for later refinement. This i have tested with
only one user. But i dont know what will happen if 1000 of users access
the site.
My Questions are:
1. So How can i store the large DataSet object in session
variable?
2. Is there anyother way to solve this problem instead of
storing it in the session expect in the database?
If anybody knows the solution please let me know.
Thanks and Regards,
Vinothkumar B
|
|
|
|
|
Surely you don't need to store the whole thing? 
You could change the code to only populate the dataset with those bits that you need for the current display and have some other dataset that stores changes, maybe...
|
|
|
|
|
|
Don't store large amounts of data in a session state variable.
Here's my take on your problem;
Refine your dataset to hold fewer items. Limit it only to that which the client machine has requested. If you save a dataset in the session variable you are in fact creating & saving in memory each time a different browser instance loads that page! Major waste of resources.
If your reasoning behind this is faster load times then rather consider cutting down on the number of items in the dataset when the page loads - noone needs to see all 7500 items at once. It may be more postbacks but it's a more usable page.
You could also look at caching[^] the data, though I still wouldn't recommend caching a dataset with 7500 rows.
I'm assuming you using a basket/shopping cart type thing, write the items that the client has selected to an XML file and store/retrieve that on the client machine when you need to do any processing. Why waste server side resources when you can save it on the client?
As a general rule of thumb when it comes to developing for the web, be cheap with your resources.
|
|
|
|
|
i want count the number of character in textbox in asp.net.i.e. user enter only 30 character in textbox. and when user enter Character in text box the number of character left in textbox shown in lable i.e. if he/she enter 20 character the lable show character left 10 in lable.
so how can i do this.
if you suggest javascript then plese provide complete code because i know very litter about javascript & how to implement in asp.net.
anuj
dcjoshi2
|
|
|
|
|
Javascript is the way to go:
<input type="text" onkeyup="countCharacters(this,'remaining',30)" maxlength="30" /><br />
Characters Remaining: <span id="remaining">30</span><br />
<script type="text/javascript"><br />
function countCharacters(source, outputId, maximum)<br />
{<br />
outputElement = document.getElementById(outputId);<br />
<br />
if(outputElement)<br />
{<br />
var length = source.value.length;<br />
outputElement.innerText= maximum - length;<br />
}<br />
<br />
<br />
}<br />
</script>
|
|
|
|
|
when there's an error the whole site stops responding and the server needs to be restarted. this doesn't happen on local
when the exception is caugth by "try catch" the site is redirectod to error.aspx, the redirection is succesful but still the server stops responding
|
|
|
|
|
What's leading up to the exception? Are you doing intensive processing? Are you disposing of resources that you no longer need?
|
|
|
|
|
What are you doing in the code on catching the error...?
|
|
|
|
|
|
Can that be from any reason excepting runtime(when the code compiling)
İ mean i am not see or use the server i only think that this problem can be happen after an error. When the server restarts my site runs perfectly but after an hour the site downs..
The promlem can not solve from the server side..they said we dont know why it happens..and restarts server for solving problem..
İf we can say the problem based on a error(runtime or compiling)..would it helpfull to set all of my variables to null and again settinng they with their original values after i caught the error.. all of my variables define in a module..
Can this solve the problem..or do you have any suggestion about this problem..why it happens..
Thanks…
|
|
|
|
|
Hi, Can u help me?
I have a problem with printing crystal report in asp.net?
when I write asp.net code using Printertoprinter(0,false,0,0) when I click on print button it work
but after host to web server(local intranet) I want to print again but it has no action
Thank u for your help
|
|
|
|
|
i need to code B2C site, but i donna where i have to start.
is there starter kit or any sample project on internet. i found on msdn but all links are picked up :'(
|
|
|
|
|
I've done a bit of searching around but cannot find any examples of someone retrieving an output parameter value after an ObjectDataSource.Insert() when it's invoked in codebehind.
objDS.InsertParameters["Name"].DefaultValue = txtContractorName.Text;
objDS.Insert();
how do I get the value of the parameter objDS.InsertParameter["myID"]....
Is this possible or do I need to create a control/form/profile etc parameter to access my output value?
thanks
s.
-- modified at 6:58 Wednesday 25th October, 2006
|
|
|
|
|
Hi everybody,
i create a website name Test in VS2005.When i run (ctrl+F5), it work
well.But when i open IE and type localhost/Test/default.aspx, it have
error:
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error
and then click the Refresh button, or try again later
A name was started with an invalid character. Error processing resource
'http://localhost/Test/default.aspx'. Line 1, Pos...
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
Anybody know, please help me.
Thank you
|
|
|
|
|
Have you created a virtual folder in IIS?
|
|
|
|
|
I already created virtual folder in IIS but it not run.
Thank for your help
|
|
|
|
|
suppose i will enter only recipient cell no and my short message and then a sms will be sent to the recipient
whatever is the cell no means i dont know where he is now and who is the service provide.so pls tell how could i
send this type of sms from my asp.net apps.is there any free webservice or library there which can be downloaded.
tbhattacharjee
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
