datareader

[amaneet]

Sir, I was trying to retrieve some data from the database , It is successfully retrieved. The problem is , there are two terms and i don't know the difference between them. 1.dr.Item(0) or dr.item("columnnmane") 2.dr.GetValue(dr.GetOrdinal("columnname")) Please explain the difference , I mean in which condition i should use dr.Item("") or dr.Item(0) and In which condiion I should use dr.GetValue(dr.GetOrdinal("columnname")) Thanks

[Jim Conigliaro]

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.

Jim Conigliaro jconigliaro@ieee.org
http://www.jimconigliaro.com

[Guffa]

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; }

[amaneet]

Sir, I just wanted to know he difference between them. Thanks