VB.Net or C#.Net which is best and when?
VB.Net and C#.Net both works similar in functionality as well as usage.
Depends on the application, makes difference in action. VB.Net is more helpful in all application and C# makes some difference in Component (DLL/EXE) creation/handling the same without CLR knowledge and C# works good with .Net advanced techniques such as Remoting and Web services.
Sunday, November 04, 2007
SQL Loader in .Net
SQL Loader is used in order to bulk insert the data from the DataSet to Database in .Net and Oracle.
Since it is executed in the command prompt of the application path, it works faster and more securable. The point needs to remember is, the Database order columns and .dat file order columns should be same. Otherwise, the entire set of insertion is going to be cancelled while inserting.
sqlldr username/password
username - name of the schema database
password - password of the schema database
schemaname - name of the schema, which need to get insert using sql loader
control file name - control file which calls the data (.dat) file, which has the collection of records needs to be updated in the database
.Dat file is delimited with any specified character, for maintaining the data separation.
log file name - log file which is going to be created by run time, with the details of number of inserted records, rejected records, and reason for rejecting.
SQL Loader is used in order to bulk insert the data from the DataSet to Database in .Net and Oracle.
Since it is executed in the command prompt of the application path, it works faster and more securable. The point needs to remember is, the Database order columns and .dat file order columns should be same. Otherwise, the entire set of insertion is going to be cancelled while inserting.
sqlldr username/password
username - name of the schema database
password - password of the schema database
schemaname - name of the schema, which need to get insert using sql loader
control file name - control file which calls the data (.dat) file, which has the collection of records needs to be updated in the database
.Dat file is delimited with any specified character, for maintaining the data separation.
log file name - log file which is going to be created by run time, with the details of number of inserted records, rejected records, and reason for rejecting.
Excel in .Net
Excel sheets can be uploaded into the Database using Excel DSN in .Net.
This can be implemented using Excel DSN.
1. Create connection string using OLE provider to get the data from Excel.
Add the following along with that.
extended properties = true;
2. Now your entire excel is converted to Dataset.
This is the simplest way to contact with the Excel. This copies the entire set of records into the DataSet in the same order.
This helps to bulk upload from Excel to Database.
Excel sheets can be uploaded into the Database using Excel DSN in .Net.
This can be implemented using Excel DSN.
1. Create connection string using OLE provider to get the data from Excel.
Add the following along with that.
extended properties = true;
2. Now your entire excel is converted to Dataset.
This is the simplest way to contact with the Excel. This copies the entire set of records into the DataSet in the same order.
This helps to bulk upload from Excel to Database.
Tuesday, May 16, 2006
Installation procedures and requirements of .Net 2003 and older
Install the Web application on any system, the followings need to be installed.
- Windows 2000 Server (SP2 or later) / Windows 2003 Server (SP3 or later)
- MS .Net Framework v1.1
- MDAC (MS-Data Access Components)
- SQL Server 2000 SP3 or later with the MSSQLServer and SQLServeragent services set to “Automatic start”. (Open the Microsoft Management Console (MMC) Computer Management snap-in-Compmgmt.msc. Select Services and Applications, then select Services. Right-click the service, select Properties, and set “Startup type” to Automatic.)
*SP3 is required to support in Server OS system.
5. IIS v 5.0 or later
Subscribe to:
Comments (Atom)