Tutorial by Examples: a

For querying all the data from table MachineName we can use the command like below one. $Query="Select * from MachineName" $Inst="ServerInstance" $DbName="DatabaseName $UID="User ID" $Password="Password" Invoke-Sqlcmd2 -Serverinstance $Inst -Databa...

Detailed instructions on getting vert.x set up or installed.

While using laravel pagination you are free to use your own custom views.So,when calling the links method on a paginator instance, pass the view name as the first argument to the method like : {{ $paginator->links('view.name') }} or You can customize the pagination views is by exporting the...

//fill column A with solid red color from hex worksheet.Column(1).Style.Fill.PatternType = ExcelFillStyle.Solid; worksheet.Column(1).Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml("#FF0000")); //fill row 4 with striped orange background worksheet.Row(4).Style.Fill.Patte...

//make column H wider and set the text align to the top and right worksheet.Column(8).Width = 25; worksheet.Column(8).Style.HorizontalAlignment = ExcelHorizontalAlignment.Right; worksheet.Column(8).Style.VerticalAlignment = ExcelVerticalAlignment.Top; //wrap text in the cells worksheet.Column...

//Make all text fit the cells worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns(); //Autofit with minimum size for the column. double minimumSize = 10; worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns(minimumSize); //Autofit with minimum and maximum size for the c...

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create the WorkSheet ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); //add some dummy data, note that row and column indexes start at 1 for (int i = 1;...

//get the image from disk using (System.Drawing.Image image = System.Drawing.Image.FromFile(HttpContext.Current.Server.MapPath("logo.jpg"))) { var excelImage = worksheet.Drawings.AddPicture("My Logo", image); //add the image to row 20, column E excelImage.SetPo...

<?php $visit = 1; if(file_exists("counter.txt")) { $fp = fopen("counter.txt", "r"); $visit = fread($fp, 4); $visit = $visit + 1; } $fp = fopen("counter.txt", "w"); fwrite($fp, $visit); echo "Total Site Visits: &qu...

Hazelcast runs inside a Java Virtual Machine (JVM). It is compatible with Java versions 1.6.x, 1.7.x, and 1.8.x. Installation and setup is as simple as downloading the zip (or tar) archive, copying the uncompressed directory to a desired installation directory, and adding the jar to your Java clas...

This example illustrates the basics of executing sections of code in parallel. As OpenMP is a built-in compiler feature, it works on any supported compilers without including any libraries. You may wish to include omp.h if you want to use any of the openMP API features. Sample Code std::cout <...

This example shows how to execute chunks of code in parallel std::cout << "begin "; // Start of parallel sections #pragma omp parallel sections { // Execute these sections in parallel #pragma omp section { ... do something ... std::cout <...

This example shows how to divide a loop into equal parts and execute them in parallel. // Splits element vector into element.size() / Thread Qty // and allocate that range for each thread. #pragma omp parallel for for (size_t i = 0; i < element.size(); ++i) element[i] = ... /...

This example illustrates a concept to perform reduction or gathering using std::vector and OpenMP. Supposed we have a scenario where we want multiple threads to help us generate a bunch of stuff, int is used here for simplicity and can be replaced with other data types. This is particularly useful...

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create a datatable DataTable dataTable = new DataTable(); //add three colums to the datatable dataTable.Columns.Add("ID", typeof(int)); dataTable.Columns.Add("Type"...

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //the query or stored procedure name for the database string sqlQuery = "SELECT * FROM myTable"; //create a datatable DataTable dataTable = loadExternalDataSet(sqlQuery); //c...

Fill some cells with text. worksheet.Cells["A1"].Value = "Lorem ipsum"; worksheet.Cells["B2"].Value = "dolor sit amet"; worksheet.Cells["C3"].Value = "consectetur adipiscing"; worksheet.Cells["D4"].Value = "elit sed do ei...

Install WebServer Role Install WebDeploy 3.6 from MSDN Activate ASP.NET 4.6 under Web Server (IIS) > Web Server > Application Development

Good video tutorials about Emacs can be found at emacsrocks.com.

//set the total value of cells in range A1 - A25 into A27 worksheet.Cells["A27"].Formula = "=SUM(A1:A25)"; //set the number of cells with content in range C1 - C25 into C27 worksheet.Cells["C27"].Formula = "=COUNT(C1:C25)"; //fill column K with the s...