A file download sometimes may take several minutes, there is no way to display a progress message (ex: downloading.. please wait) to the user like that of Ajax loading (once save dialog displayed , it should be hidden). Read more
Excel spreadsheets can be imported into SQL server in various ways. The simple and quickest methods are with using Linked Servers and Distributed queries. The difference is how the connection is used. Linked servers uses a persistent configured connection where as Distributed queries uses a dynamic connection. Linked servers are not suitable when we want to import more than one document. For every document there a linked connection should be configured(painful).
You can configure Linked connection through Server Objects->Linked Servers-> New Linked Connection (See below image) from the Management studio object explorer. Use select statement with OPENQUERY to read excel data. Read more
A common question arises when working with .Net 3.5 data models.
A nice article explaining differences between LinQ to SQL and Entity Framework is at party libraries are available for supporting other databases(like LinQtoOracle etc..).
b) Entity Framework is an ORM DB and is based on application-oriented data model. Its a loosely coupled and may differs from existing DB schema. It represents many:many relations(flexible mapping) and provides different layers to your DB. Entity Framework works with both SQL Server and 3rd party Databases(.edmx files). If your thinking for a common layer for all the databases, loosely coupled(independent of DB Schema), Entity Framework is the best option.
Yesterday I have installed Visual Studio 2010 on my Windows 7. Wow. I am surprised with its new look & feel, performance, cool features. No doubt, I can tell now it will be my favorite. Its still in Beta version and will be releasing in March 2010. So many improvements around AJAX, Core services, WebForms, MVC, Designer, Deployment when compared to VS2008.
Last week, I received a complimentary signature copy of Windows 7 Ultimate from Microsoft. I think right now in Australia, it costs around AU $400-$470. I installed with x64 bit version replacing my erroneous Vista version. It has cool features, performance wise better than vista. The beauty is it will recommend with possible drivers and updates on install where as vista doesn’t(manual install). I haven’t encountered any errors and compatibility issues, loving it.
Today I have released a project WebLogViewer alpha version on CodePlex.
The url is. It uses LogParser 2.2 SDK and JQuery. It can be installed on any remote machine running IIS and event log can be viewed using any standard HTML browser.
The following will help in loading a web page faster.
- Always set cache-expire in the response header.
- Avoid viewstate for simple pages(by default view state enabled) or in pages where viewstate not needed.
- Use gzip(or deflate) compression.
Recently I constantly encountered ‘Failed to Enable constraints…’ error when working with DataTables. .Net doesn’t provide any detailed information for this error.
This error might be due to
a) Query columns and Fill method columns mismatch
b) Column maxlength exceeded
c) Duplicate rows(when some join)
d) some other when loading data into the DataTable.
“Reference” comment in the JS file allows you to see JScript functions and objects from any external file whether it could be an another JS file or a web page or a web service or even an embedded resource.
The common usage is
///<reference path=”path of webservice or jsfile or webpage” />
///<reference name=”resource-name” assembly=”assembly-name” />
To reference Ajax library
/// <reference name="MicrosoftAjax.js"/>
Welcome to my technical blog. Today I upgraded this site to BlogEngine.Net 1.4.5 with SQL Server as DB provider. What I noticed was BlogEngine.Net with roles will only run in medium trust or higher. I’m running this site on a shared hosting account, and custom overrides of trust configuration were not allowed.
Initially I tried with SQLite DB(thought it would be more faster ). My hosting provider doesn’t allow to change default directory permissions. At last I switched to SQL server, site was running up with in few minutes.