Simple Steps to create an excel worksheet using VB.NET

In this tutorial I’m going to show you how to parse a text from Text Box to Microsoft Office Excel with Visual Basic .NET.I hope that the reader is a beginner and know the basics of .NET. Our aim is to automate an Excel Work Book. This is very useful for the developers of business based applications. If we are using MS Excel for reporting, that will be very handy because Excel has a lot of features for formatting both text and numbers.

How to solve mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead?

This error or warning is occurred when we use the latest version of wamp or lamp servers. Normally we use the function mysql_connect() in order to establish the connection with the MySql Database server in PHP. We can call this function if the mysql extension is enabled by the PHP.

         The problem with the latest version of PHP and wamp , they forces us to use latest and improved version of mysql database connectivity function that is mysqli (MySql Improved).

How to return a value from stored procedure to Visual Basic.NET

Here I am going to show you how to return a value from a stored procedure written in SQL Server. As the first step we need to create a stored procedure that returns a value. In my case, I have a database called car and a table in it called tblCar. For counting the number  of row I used the following stored procedure.

If you don’t know how to create a stored procedure in SQL Server, please read this tutorial before we start.

http://tutz4u.blogspot.in/2014/03/how-to-make-stored-procedure-in-sqlserver.html

Visual Basic .net for beginners - Part 1 : Introduction to Visual basic

This is the first chapter of the tutorial series “Visual Basic .net for beginners” . This series is for absolute beginners in programming . So no previous experience is required.  At the end of this series you will be able to build your own windows, web application in with professional quality standards. This is the introduction part of the series. In this tutorial we will take look at the features of visual basic , .net frame work, visual basic IDE (Integrated Development Environment) and many other things that a visual basic beginner should know.

Simple steps to create stored procedure in SQL Server : Using SQL Server Management Studio Or Visual Studio

Here is a simple tutorial on how to create and use stored procedure in SQL server with Visual Studio IDE or  SQL Server Management Studio. Stored procedures are the most secured, structured, efficient method to access data from SQL server.

Step 1 :

(If you have SQL Server Management Studio)

Open  SQL Server Management Studio and  choose the server to connect and provide username and password if necessary and

What is pass by reference in c++

This is my first tutorial about c++ and in this I’m going to show you how the pass an argument by reference in a function. While using pass by reference in a function we have to use pointers. Passing parameters by reference has the functionality of pass by pointer and the syntax of the pass value. The function body and call to it is identical to that of pass by value, but has the effect of pass by pointer. To pass parameters by reference,

Easy way to access database with Visual Basic.NET by simple steps

   This tutorial is about how to connect to an MS Access database and retrieve and insert values to that. We’ll talk about a simple example that is Sign Up a user and allow the user to login to a system. That is we’ll create a Sign Up form and a Login form. Also we need to create corresponding tables in the database. Please note that this tutorial is not for very beginners. But it’s aimed at beginners in “Database Programming”. Here we need to know about another language called Structured Query Language (SQL).  But here it is not necessary that you should be expert in SQL.