Agreed SqldataReader is forward only.... But how can i achieve this...without any grid I have a no of data for a record so i am not using datagrid. I am showing it in different textboxes and dropdowns. On the click of next or previous button the respected textboxes and dropdowns shd be filled automatically with the correct data. Ajay Kumar

May I have the URL for the same and whether its free or it costs something...

Sir I m giving the stacktrace and message of my exception object which generates when i m trying to access my web site from the public IP.. StackTrace:---- at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportClass.Load(String reportName, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportDocument.EnsureLoadReport() at CrystalDecisions.CrystalReports.Engine.ReportDocument.get_FormatEngine() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Refresh() at Mktg_Artwork.frmDisplayRpt.ShowReport() in C:\Inetpub\wwwroot\Mktg-Artwork\frmDisplayRpt.aspx.vb:line Message:--- Load Report Failed. However i have already installed crystal reports for .net framework2.0 on web server Infact I have installed VS2005 on my web server. Still facing the above problem.. Please Sir,help me out.... Ajay Kumar

MissionSuccess wrote: I want to run the batch file stored on the server being on a client. It won't be possible since it's a security violation. You can't execute any scripts on client browser. If your client allows to install activex, you can create on that runs this batch file. All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

Pretty sure you need to enable xp_cmdShell. Something like this: USE master GO EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE WITH OVERRIDE GO EXEC sp_configure 'xp_cmdshell', 1 GO RECONFIGURE WITH OVERRIDE GO EXEC sp_configure 'show advanced options', 0 GO Check out this link about half way down the article: http://sqlserver2000.databases.aspfaq.com/how-do-i-prevent-linked-server-errors.html[^] Ben

You might want to read this[^] article and convert this to a parameterized query. Any user can screw this statement up just by entering a "'" character into one of your textboxes that you blindly throw into your SQL statement. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

It's not supported by the old DataGrid, or by the DataGridView controls. You'd have to add this yourself, either by using cleverly placed and defined label controls above the DGV, possibly in your own UserControl, or by creating your own version of the DGV control and adding this functionality to the existing control using custom properties and painting code. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

i have done that also.... SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE usp_ImportData AS begin DECLARE @DTSRUNCommand as varchar(255) SET @DTSRUNCommand = 'DTSRUN /N ' + 'PackageName /E /S ' + '@@ServerName' EXEC master..xp_cmdshell @DTSRUNCommand end GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO it gives me some permission problem. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 NULL what to do.. i am system admin on the Server. And i have all the rights.

check it "http://www.codeproject.com/aspnet/DAtaGridExportToExcel.asp"

Thanks sir resolve it was a permission issue. given the rights and now working smoothly.

:doh: You cant use a datagrid meant for Mobile app on a Windows Application. SG

I had this same problem a few months back, I had to reinstall visual studio as well as the framework. Try both. It worked for me.

Set a class-scope flag (A boolean variable) to true just before you set the datasource of the ComboBox. In the SelectedIndexChanged event, check that flag. It it's set, reset the flag to false and don't do anything in the event handler. If it's false, then you do what you need to accomplish. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

If i understand you correctly, you expect your localhost to work even if IIS is stopped? To my knowledge i do not think you can run a localhost site if IIS is stopped. Please correct me if I am wrong...