MSFlex Grid Operation in VB6.0

MS Flex Grid is a data grid which is use to retrieve records from database.It is very
Flexible, It Accept data run time from vb coding.It is useful for users who
interact database with coding . Coding is more powerful and flexible
than database controls (Data,ADODC).With the help of coding you can
run SQL statement in its original from as we use at command prompt
in oracle.Because Flex grid doesn't configure with database controls .You have
to configure it manually with the help of coding.There is not any row or columns
are predefine its programmer responsibility to make it. take a look on following
example.

 Controls

•  MSFlexGrid1

Adding  Module

• Click Project menu and Add a module

How to make setup in C# and VB.Net

Setup enable us to make our project run on real environment.

• Open Visual studio click create project
• Highlight Other project type tree and select Setup and Deployment
• Select location provide name click ok
• Now there are three option
  
  1. Application folder which comprise files when your software will install make a folder where your software will install
  2. User's Desktop comprise files which take place of user desktop after installation
  3. user's program menu comprise files which goes into start menu after installation
   
• Now right click on folder where you want to put your files, Add > Files
• Browse project folder find the exe file which is mostly reside in debug folder
• Now Press F6
• Now your setup is ready

CSS Tutorial

CSS stands for cascading style sheet. Which is used today to develop web
pages.CSS is useful to make style rule because HTML provides a limited
option for formatting CSS provide a rich amount of formatting
option.. you can implement CSS rule in many way...

• Call by class
• Call by id
• Inline style
• By HTML Tag

Call by class
In this type of CSS implementation we make a function type description like
C language. The name of rule start . in this type of rule. You can call
these rule more one time or any valid HTML tag using CLASS keywords
<style type="text/css">
        .border1
        {
            border:outset 5px red;
        }
    </style>
 <input type="button" value="Click me" class="border1" />
        <input type="text" class="border1" />
Call by ID
In this type of CSS rule we call CSS Using id of a HTML control because rule
name start with # symbol which is a ID of a HTML tag's id. This Rule call automatically when browser load
a page.

Store Procedure for SQL Server Using C# and VB.Net

Store Procedure
Stored procedures can make managing your database and displaying information about that database much easier. Stored procedures are a recompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit. Stored procedures are stored within a database, can be executed with one call from an application, and allow user-declared variables, conditional execution, and other powerful programming features.
Stored procedures can contain program flow, logic, and queries against the database. They can accept parameters, output parameters, return single or multiple result sets, and return values.
You can use stored procedures for any purpose for which you would use SQL statements, with these advantages:
You can execute a series of SQL statements in a single stored procedure.
You can reference other stored procedures from within your stored procedure, which can simplify a series of complex statements.
The stored procedure is compiled on the server when it is created, so it executes faster than individual SQL statements.
The functionality of a stored procedure is dependent on the features offered by your database. For more details about what a stored procedure can accomplish for you, see your database documentation.