 |
Object Oriented features in VB.net (Part-2)
|
| Total Hit (10895) |
In the previous article we discussed the basic concepts of Object Oriented Programming. Now let's implement all this in our favorite language - VB.net.
«big»Creating Classes in VB.net«/big»
As we discussed earlier, objects are instances of a specific template – called a Class. A "Class" contai
....Read More |
Rating
 |
|
|
|
Object Oriented features in VB.net (Part-3)
|
| Total Hit (8567) |
«big»Inheritance«/big»
Now that VB.Net supports many object oriented features, lets discuss about Inheritance. Inheritance is the cornerstone of Object Oriented programming. VB.net supports inheritance and I am sure VB6 programmers will welcome this step. Inheritance gives us an ability to define
....Read More |
Rating
 |
|
|
|
Working with DateTime and TimeSpan Object in VB.net
|
| Total Hit (34724) |
In this article we will explore some key language features which are frequently used by VB programmers.
«big»DateTimes in VB.net«/big»
VB.net provides many new features for DateTime datatype. Unlike VB6 in VB.net you can initialize DateTime variable with verity of initial values. In VB.net you
....Read More |
Rating
 |
|
 |
How to force file download using code in ASP.net.
|
| Total Hit (8200) |
Many times we have requirement to popup file download dialogbox instead of user clicking on a link. This little code you can use in your ASPX page. Call the following method from your ASP.net code which should prompt a file download dialogbox in user's browser.
«code LangId=2»Public Sub DownloadF
....Read More |
| Rating
|
|
 |
SQL Server 2005 Full-Text Search: Internals and Enhancements
|
| Total Hit (991) |
The full-text search feature of Microsoft SQL Server 2005 delivers enterprise search functionality integrated into the database. Significant enhancements in the areas of performance, manageability, and functionality deliver best-of-breed search capabilities for applications of any size.
This pap
....Read More |
Rating
 |
|
|
|
|
|
Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
|
| Total Hit (699) |
Describes what data is collected, where it is stored, and which commands create, update, and delete statistics about indexes and column data stored in the Microsoft SQL Server 2000 database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving
....Read More |
| Rating
|
|
|
|
|
|
Reading Text Files Into Tables with line numbers.
|
| Total Hit (2373) |
Some times we need to read text file line by line or read a specific line using T-SQL. This article will explain a simple technique using xp_CmdShell stored proc.
Let's first create a sample file which we will import into SQL Server table.
<b>test.txt</b>
«code LangId=999»<Pre>Hello this is a
....Read More |
| Rating
|
|
|
|
Language features - Variables and types
|
| Total Hit (2605) |
The Microsoft .NET Framework provides a robust system of primitive types to store and represent data in your application. Data primitives represent integer numbers, floating-point numbers, Boolean values, characters, and strings.
In VB.net you can declare variable using Dim statement as shown be
....Read More |
| Rating
|
|
|
|
Importing and Exporting Data with SQL Server
|
| Total Hit (1273) |
Transferring data, whether into or out of a database, can be a complex process. SQL Server provides several tools that help you in a variety of situations, including the Bulk Copy Program, the Select statement, the Transfer Manager, and Query results. This chapter examines those options, and times w
....Read More |
| Rating
|
|
|
|
Tutorial - Language and Syntax changes in VB.Net for VB6 Programmers
|
| Total Hit (11289) |
If you are a VB6 programmer and want to learn VB.net then it will be easier for you but still you need to learn new language and syntax changes in VB.net. This article is for VB6 programmers who are moving to VB.net. New programmers can skip this article, we will cover each language feature in detai
....Read More |
Rating
 |
|
|
|
A general benchmarking class
|
| Total Hit (2908) |
Many times we need to benchmark some routine or a block of code. This class will help you to benchmark a routine or a block of code.
«code LangId=2»Public Class BenchMark
Delegate Sub BenchmarkDelegate()
Enum BenchmarkModes
DontShow
Console
MessageBox
End
....Read More |
| Rating
|
|
|
|
Tutorial - Getting familiar with Visual Studio.net IDE
|
| Total Hit (12492) |
In this article we will look at the new exciting features of Visual Studio.net 2003 IDE.
«a name=#L1»«/a»
«big»Main window«/big»
Visual Studio.net IDE provides several layout options to provide simulated environment from previous versions. You can select different profile for keyboard or window
....Read More |
| Rating
|
|
|
|
 |
How to read data from Excel file
|
| Total Hit (3626) |
Many times we have requirements to load data from CSV file, text file or Excel file...
In this article I will show a sample code which reads a specified rows and columns from excel file.
«code LangId=1»Private Sub Command1_Click()
ImportExcelToSQL "c:\temp\diamond_upload.xls", 0, 20, True
....Read More |
| Rating
|
|
|
|
Tutorial - Assembly
|
| Total Hit (24298) |
«a name=#L1»«/a»
«big»What is Assembly?«/big»
An assembly is the primary building block of a .NET Framework application. It is a collection of functionality that is built, versioned, and deployed as a single implementation unit (as one or more files). All managed types and resources are marked e
....Read More |
| Rating
|
|
|
|
Implementing Error Handling with Stored Procedures
|
| Total Hit (634) |
This is one of two articles about error handling in SQL Server. This article gives you recommendations for how you should implement error handling when you write stored procedures, including when you call them from ADO.
|
| Rating
|
|
|
|
The Curse and Blessings of Dynamic SQL
|
| Total Hit (764) |
In this article I will discuss the of use dynamic SQL in stored procedures in MS SQL Server, and I will show that this is a powerful feature that you should use with care.
|
| Rating
|
|
|
|
How to share data between stored procedures
|
| Total Hit (702) |
Questions you often see in newsgroups about MS SQL Server are: How can I use the result set from one stored procedure in another or How can I use the result set from a stored procedure in a SELECT statement?
|
| Rating
|
|
|
|
Connecting to MS SQL Server from Unix
|
| Total Hit (1052) |
I've written this page as I keep getting questions on how to access MS SQL Server from Unix. I have never had any reason talk to SQL Server from Unix myself, but since people kept asking me how to do it, I decided to compile an web page with the tiny fragments of information and I have. The main foc
....Read More |
| Rating
|
|
|
|
Arrays and Lists in SQL Server
|
| Total Hit (769) |
In the public forums for SQL Server, you often see people asking How do I use arrays in SQL Server? Or Why does SELECT * FROM tbl WHERE col IN (@list) not work? This text describes several methods to do this, both good and bad ones. I also present data from performance tests of the various methods.
....Read More |
| Rating
|
|
|
|
Calling .Net Classes from Visual Basic 6
|
| Total Hit (1000) |
Despite all the power and features of Visual Studio.Net, lots of developers are sticking with good old Visual Basic 6 for at least some of their development projects. There's good reason for this. Tens of thousands of developers know VB6 from the inside out, and can create applications quickly and e
....Read More |
| Rating
|
|
|
|
|
|
How to send/receive XML document using HTTP POST ?
|
| Total Hit (10580) |
In my recent project we had a requirement to send a HTTP request in XML document format (e.g. request for a specific order detail). The response was also in XML format. So now question is how would you do that in .Net? Here is the code snippet which you can use to do the same thing.
«code LangId=
....Read More |
Rating
 |
|
|
|
How To Recursively Search Directories by Using Visual Basic .NET
|
| Total Hit (1559) |
This article demonstrates through code how to recursively search subdirectories for files, starting with a root directory. A search string is specified so that you can search for files that match a certain criteria. Each part of the code is explained as necessary. A working code sample is also provi
....Read More |
| Rating
|
|
|
|
How to move/resize window using API?
|
| Total Hit (5025) |
«code LangId=1»Private Const SWP_SHOWWINDOW = &H40
Private Const SW_HIDE = 0
Private Const SW_RESTORE = 9
Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameter
....Read More |
| Rating
|
|
|
|
 |
ISSUE : IIS6.0 prevents the upload of files more than +200 KB
|
| Total Hit (2956) |
IIS6.0 prevents the upload of files more than +200KB. So you need to make some changes in the default IIS settings first.
«b»Background«/b»
For IIS6.0 users, the AspMaxRequestEntityAllowed property specifies the maximum number of bytes allowed in the entity body of an ASP request. If a Conten
....Read More |
| Rating
|
|
|
|
Object Oriented features in VB.net (Part-1)
|
| Total Hit (5970) |
In this article we will discuss about Object Oriented Features available in VB.net
Let’s first understand the basic terminology used in Object Oriented Programming.
«big»Classes, Objects, Members and Abstraction«/big»
An object in programming is a construct that represents something from th
....Read More |
| Rating
|
|