I use datareader in datagrid but could not use file dsn in connectionstring DSN=mydata;....Could anybody help me out with small example ?
http://www.learnasp.com/freebook/learn/dbopen.aspxshows correct Access connection string.www.learnasp.com/freebook/learn/datareader.aspxis small datareader example.Just search for SQLClient replace with OLEDB.DSNs actually imply an ODBC connection which is slower than SQLClient or OLEDB. So avoid DSNs. A lot of Classic asp programmers using DSNs were getting worse pefrformance via ODBC instead of OLEDB and never knew it. ASP.net wants to end people accidentally using ODBC without knowing it.