VIKRAM SINGH RANA

VB.NET MessageBox.Show By: Vikram Singh Rana MessageBox.Show displays a dialog box. It interrupts the user. It immediately blocks further interaction. It requires only one Function call. We specify buttons, default buttons, an icon, and some other properties of the dialog. Example First, we look at an event handler that will show the message boxes in the screenshot sequentially when the program executes. The MessageBox.Show function is a Public Shared Function type. It can be called without an instance reference. Shared You can directly invoke MessageBox.Show. The method receives different numbers of parameters, and by specifying certain arguments and the right number of arguments, you can get the desired dialog box. Event handler function that uses MessageBox.Show: VB.NET Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles MyBase.Load ' ' First show a single-argument dialog box

Crystal Reports Display Images From Database Asp.Net Posted by Vikram Singh Rana This example explains how to Add Show Display Logo Pictures Images In Crystal Reports Dynamically From Sql Server DataBase In Asp.Net 2.0,3.5,4.0. There are two scenarios to achieve this task. 1. When images are saved in sql server database. 2. When pictures are saved on server and name or path is saved in database. I'll explain both cases one by one. 1. Displaying From Database Step 1. Upload And Save Images In SqlServer DB Using FileUpload Control by following the link. Step 2. Right click on solution explorer and select add new item >Add DataSet and name it DataSet1. Step 3. Right click on dataset designer window and select Add DataTable and rename it as reportTable . Step 4. Right click on DataTable and select Add > Column . Add 3 columns ID,Name,Image and define datatype in properties windows as System.

In this example i am going to describe how to Create SubReports in Crystal Reports or Crystal Reports SubReport in ASP.NET Using C# And VB.NET . For this i have used two tables from MS SQL database named Employees and Projects. Main Crystal Report is fetching data from both the tables and is grouped by Project Name SubReport is used to display information about respective project and fetching data from Projects Table. Schema for both the tables in shown below in images, create tables accordingly and add relevant data in it to start. You can click on Images to Enlarge        To start , Create a new website in VS and right click on Solution Explorer and select Add new Item > Crystal Report. In the wizard window choose Using the Report Wizard radio button and Standard type in Choose an Expert section.   In next screen select Expand OLEDB(ADO) and Choose create new connection    Select Microsoft OLEDB Provider for SQL server and cli

This answer has 2 parts. The first one has mathematical facts and the 2nd covers the rest. Mathematical Facts Diversity  - India has almost as many Muslims as Pakistan. It has more Christians than the population of Australia, more Buddhists than Tibet, more Sikhs, Jains, and Parsis than any country in the world. And all of these are peacefully coexisting, modulo the clashes that were/are fanned by politics Belgian Jains were once common people originating from the Gujarati city of Palanpur. They control roughly 60% of the diamond trade As of February 1 2012, India's common men account for more than 43 million users on Facebook, giving her the 2nd spot after US. The largest traffic on Quora is from India. This is when less than 10% of people have internet access. More than a million common men are millionaires, yet most Indians live on less than two dollars a day. A third of the world's poorest are in India. Innovation:  The

Crystal Report Filtering Using Selection Parameters By:Vikram Singh Rana Background Selection parameters allow you to filter Data returned from datasource ( Table in our case). Of course, it's better and faster to use Stored Procedure Step 1: Database Run the script to create the database and table. You should now have the following schema. (I tried to use variations of data types, text , datetime , float , etc.) Step 2: Form We'll build the user input form, nothing fancy, textbox, datetimepicker and a customized numeric updown control. (T he numeric updown is augmented to have a Checked property, we'll need that later. ) Step 3: Report Step 4: Report's Parameters Very well, we have our report created; next, we want to create the parameters to be passed and searched with. In addition to the 6 parameters on the user form, we need a Boolean parameter for each fiel