How to pass a text to crystal report from the code[video]

Note: It is advised to read the previous article before watching this video 

good luck

How to create a crystal report based on a custom SQL statement

Welcome everybody

In this article i will show you how to create a crystal report that based on a custom SQL statement; you have to follow these steps after creating a new project and a sample database :

1. Add a data set item.
2. Customize the data set to fit the data that will be retrieved from the database. 
3. Add a crystal reports item and link it to the previous added data set.
4. Add a crystal report viewer component to the form which you want to view the report and link it to the previous added crystal report.
5. Find a way to program a function that returns a data table, and be sure that the columns names and the columns data types in the data table are same as these in the data set .
6. Bind the data table with the data set, and the crystal report viewer with a report document by using this code

            ReportDocument rpt = new ReportDocument();
            DataSet1 ds = new DataSet1();
            ds.Tables[0].Merge(datattable1);
            rpt.Load(/*CrystalReport1.rpt path*/);
            rpt.SetDataSource(ds);
            crystalReportViewer1.ReportSource = rpt;

note: put the previous code in form load region.

And for more details watch this video

good luck

Simple Compiler in C# [source code]

This is a simple compiler programmed in C# that accept arithmetic operations with integers, "/", "^" and parenthesis symbols.

The project passes through three phases:

1. Scanning phase: this stage check the code from syntax errors and unacceptable symbols
2. Parsing phase: this stage do the semantic rules over the code and detect logical errors, rules are steted in parsing table.
3. Evaluating phase: after two previous phases are checked and completed successfully the evaluating process complete its work and return the result.

Sample snapshots

Download the source code

How To Retrieve an image SQL Server Data type into Picture Box Using C#

Note: Before reading this blog,  you need to know (How To Store an Image to image SQL Server Data type Using C#)

Images are stored in SQL Server database as series of bytes; to retrieve an image into Picture Box follow these steps

1- Crete a stored procedure that do select command on an image
2- In C# code get the array byte retrieved from the database and convert it to Image 
        
        public static Image byteArrayToImage(byte[] byteArrayIn)
        {
            MemoryStream ms = new MemoryStream(byteArrayIn);
            Image returnImage = Image.FromStream(ms);
            return returnImage;
        }

3- Set the converted image to the picture box 


For more details watch this video

and download the source code for experiment purposes

How To Store an Image to image SQL Server Data type Using C#

Note: It is not recommended to use this method if you want to store a large amount of images (ex. gallery). Instead, try storing images in an external file and use image path as an [nvarchar] data type.

Image in real is a set of color points arranged a certain way to form a picture, in computer language color point called Pixel, each pixel is a combination of different values of Red, Green & Blue (RGB), computer dealing with image as a series of bytes, each byte represent an image pixel, image data type in SQL Server can store up to  (2,147,483,647) bytes.

In this example i used a Picture Box as an image input way, then converted the input image to array byte

        private static byte[] imagetoByte(Image img)
        {
            MemoryStream ms = new MemoryStream();
            img.Save(ms, System.Drawing.Imaging.ImageFormat.Gif);
            return ms.ToArray();
        }

       Byte[] img = imagetoByte(PictureBox1.Image);

For more details watch this video

and download the source code for experiment purposes 

 

How to Create and Publish a Data Cube using SQL Server Analysis Services

For data mining purposes, Microsoft developed a tool called  SQL Server Analysis Services,

with this tool you can analyze a large number of data, which is characterized as the accumulation of several years,and most large companies use data analysis tools for decision-making service

This video explain how to:

• Create Data Cube using businesses intelligence development studio (BIDS)
• Publish the project & Deploy it to SQL Server with analysis services tool
• Doing some OLAP operation like (Slice, Dice, Pivot..)

welcome

MessageBox.show("Hello Word");

                        like a dot net code 

welcome everybody 

   I will post in this blog a technical subjects
   And I will dedicate a large portion of the threads in the Dot Net 
   I wish you interest