Sometimes during dot net development, you face this error while trying to open a web application project
Error Creating Control – control_Name
‘/LM/W3SVC/1/Root/Project_Name’ is not a valid IIS application. This error normally occurs if you have defined a sub folder as a virtual directory that is already within a virtual directory.
Solution
You can resolve this error by following the below steps , the root cause of this error is the incorrect mapping between web application project and the virtual directory in your IIS.
Follow these steps to resolve this issue:
1-Right click – you web application project and select Properties -> Web
2- In the server section choose Use IIS Web Server -> then click Create Virtual. If the URL is already provided but not correct one, modify it accordingly.
3- Clean your project and compile again.
You are done
admin .Net .Net, Application Solution, Control, Net Control, Net Development, Project Control, Root Project, Virtual Directory, Web Application Project, Web Control, Web Server
Data bulk insertion is a requirement often faced by developers. Using dot net 2 and sql server 2005, Microsoft has provided a nice feature for bulk insertion using SqlBulkCopy class. It is really fast and indeed no comparison of performing instead in transaction or row by row. Coupling SqlBulkCopy with Transaction is very nice. Here how it works:
using (SqlConnection lConnection = new SqlConnection(“connection_string goes here”))
{
connection.Open();
SqlTransaction lTransaction =lConnection.BeginTransaction();
try
{
// BulkUpload actually starts here
using (SqlBulkCopy lCopy = new SqlBulkCopy(lConnection,
SqlBulkCopyOptions.Default, lTransaction))
{
lCopy.DestinationTableName = targetTable; // the table to which data is to be written
lCopy.ColumnMappings.Add(New SqlBulkCopyColumnMapping(SourceColumnName, DestinationColumnName));
lCopy.BatchSize= BATCH_SIZE; // records to be written in one batch
lCopy.NotifyAfter = 200; // in number of records
lCopy.WriteToServer(SourceTable);
lTransaction.commit();
catch
{
lTransaction.Rollback();
throw;
}
The above code writes a source data table to destination database table on the basis of connection string and table name. We can set the batch sieze, we may also write an event so that after each batch we are notified of the success. Its easy and certainly very fast.
admin .Net .Net, bulk copy, bulk insert, sql server 2005, sqlbulkcopy
Recent Discussions