http://www.fixya.com/[^]

The above method is to add user login to the database. But the OP is asking to set user id and password to the .MDF file as we can do it for MS Access files. AFAIK, We cannot set user id and password to the database files(.MDF and .LDF).

Refer this link. http://www32.brinkster.com/srisamp/sqlArticles/article_41.htm

ER/Studio[^]

What if I need to create a GridView with dynamic template columns based on the user preference or search conditions? The controls values cannot be accessed in Page_Init event. Therefore you cannot create dynamic controls in Page_Init event based on the values entered in controls such as Textboxe. Also in Page_Init, if the current request is a postback, the postback data has not yet been loaded and control property values have not been restored to the values from view state. But during load, if the current request is a postback, control properties are loaded with information recovered from view state and control state. Therefore, Page Load is also good place to create dynamic controls.

Put your CheckBoxList inside a Panel control and set the Panel's ScrollBars property. Also fix the Height and Width of the CheckBoxList.

So you are using Windows Authentication. ASP.NET application will be running under ASPNET account if you open your site from local IIS. Therefore the ASPNET may not have access to the database. Try to use SQL authentication. Also the database path should look like C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\TestData.mdf. I am not sure ADO.NET will accept / in a path specification.

What type of application did you connect with SQL Server? ASP.NET or Windows application? What type of authentication are you using to connect?

Are you able to connect with SQL Server Management Studio?

Use Session[^]object.

Use Oracle Data Provider for .NET[^] to connect with Oracle from .NET. Also refer this link: http://download.oracle.com/docs/html/E10927_01/OracleBulkCopyClass.htm[^]

If you want to populate a DataGrid or GridView, You can do it using System.Data.OleDb namespace in ADO.NET. Refer this link for reading and writing Excel using C#. Read the Excel sheet into a DataSet and bind the GridView.

It seems that Passport authenticaiton no longer supported in Windows 2008 and Vista. Customers using passport should consider moving to its replacement Active Directory Federation Services (ADFS). Check these links. http://learn.iis.net/page.aspx/381/aspnet-20-breaking-changes-on-iis-70/[^] http://learn.iis.net/page.aspx/110/changes-between-iis6-and-iis7-security/[^]

I think the value of the DecimalPlaces property is not stored in ViewState. You need to override LoadViewState and SaveViewState methods in the Custom Control.

modified on Wednesday, September 2, 2009 12:37 PM

Do you want to cache information locally using your windows application or web application? You cannot cache replica of server database tables locally using web appliction. You can use SQL Server 2005 Express Edition if you want to do it using Windows application.

'Any path' means will the user select the path from his local PC? How does the user select the path, using a browser window? You can open a file open dialogbox using activex in javascript. But it will work in IE only. Also you cannot display images from a folder from the client PC. It should be available in the location of your web site.

I would suggest to develop the process as a windows application and run it from asp.net if it is a bigger one. Because if you run the process from asp.net itself, then it will run within the context of IIS and also the the memory allocated to IIS is limited. This will broke the execution of the process if it is big. If the memory occupied by the process is exceed the IIS memory limit, then the session will be broken. So if you create the process as a windows application, you can start the executable in the server side and pass some parameters as command line aruguments(if required) from asp.net. In this scenario, the process will not run under IIS context. But your asp.net application will need access rights to run the application. You can watch whether the process is completed asynchronously using client side timers.

As you said, when you export/import data from the application, comma is specified as delimiter by default. Why don't you change the delimiter to some other charaters like ~ or # for export/import functionality?

ViewState cannot be shared between pages. It is specific to a page. Use Session object to share data between pages.

You can also use ASP.NET Panel control. Fix the height and width of the Panel control and use Panel.ScrollBars property to enable Horizontal/Vertical scroll bars. It is actually rendered as a DIV tag.