Tutorial by Examples: sim

This simple function will execute the specified Select SQL command and return the result as data set. Public Function ReadFromDatabase(ByVal DBConnectionString As String, ByVal SQL As String) As DataTable Dim dtReturn As New DataTable Try 'Open the connection using the connection...

As an example of writing input & output, we'll take in a real value and return the value and its square until the user enters a negative number. As specified below, the read command takes two arguments: the unit number and the format specifier. In the example below, we use * for the unit number...

from selenium import webdriver # Create a new chromedriver driver = webdriver.Chrome() # Go to www.google.com driver.get("https://www.google.com") # Get the webelement of the text input box search_box = driver.find_element_by_name("q") # Send the string "Selen...

Classes implement an interface to meet the interface's contract. For example, a C# class may implement IDisposable, public class Resource : IDisposable { private MustBeDisposed internalResource; public Resource() { internalResource = new MustBeDisposed(); } ...

Since Qt 5.5 we have a new wonderful TreeView, a control we've all been waiting for. A TreeView implements a tree representation of items from a model. In general it looks like other QML views - ListView or TableView. But data structure of TreeView is more complex. A data in ListView or TableView...

from flask import Flask, render_template, redirect, url_for app = Flask(__name__) @app.route('/') def main_page(): return render_template('main.html') @app.route('/main') def go_to_main(): return redirect(url_for('main_page'))

First lets get some data into a temp table named #systables and ad a incrementing row number so we can query one record at a time select o.name, row_number() over (order by o.name) as rn into #systables from sys.objects as o where o.type = 'S' Next we declare some var...

Authorization in asp.net core is simply AuthorizeAttribute [Authorize] public class SomeController : Controller { public IActionResult Get() { } public IActionResult Post() { } } This will only allow a logged in user to access these actions. or use the followi...

A linked list is either: the empty list, represented by None, or a node that contains a cargo object and a reference to a linked list. #! /usr/bin/env python class Node: def __init__(self, cargo=None, next=None): self.car = cargo self.cdr = next d...

Sometimes there are sections of code that are difficult to test, such as accessing a database, or interacting with the user. You can stub out those sections of code, allowing the rest of the code to be tested. Let's start with a class that prompts the user. For simplicity, it has only two methods...

Assuming you have a handle on the Hibernate Session object, in this case named session: List<Object[]> result = session.createNativeQuery("SELECT * FROM some_table").list(); for (Object[] row : result) { for (Object col : row) { System.out.print(col); } } Thi...

JavaFX has a binding API, which provides ways of binding one property to the other. This means that whenever one property's value is changed, the value of the bound property is updated automatically. An example of simple binding: SimpleIntegerProperty first =new SimpleIntegerProperty(5); //create a...

Spring Boot is a bootstrapping framework for Spring applications. It has seamless support for integrating with Jersey also. One of the advantages of this (from the perspective of a Jersey user), is that you have access to Spring's vast ecosystem. To get started, create a new standalone (non-wepapp)...

What happens when we execute python -m SimpleHTTPServer 9000? To answer this question we should understand the construct of SimpleHTTPServer (https://hg.python.org/cpython/file/2.7/Lib/SimpleHTTPServer.py) and BaseHTTPServer(https://hg.python.org/cpython/file/2.7/Lib/BaseHTTPServer.py). Firstly, P...

CREATE PROCEDURE SprocWithSimpleLoop ( @SayThis VARCHAR(30), @ThisManyTimes INT ) AS BEGIN WHILE @ThisManyTimes > 0 BEGIN PRINT @SayThis; SET @ThisManyTimes = @ThisManyTimes - 1; END RETURN; END GO

Simple The Simple Products type should be used for that generally have a single configuration (one-size-fits-all). This might include items such as: A Box of Crayons, Small (24 Colors) A Box of Crayons, Large (64 Colors) SuperHighTech 26” HD Computer Monitor Barrack Obama Action Figure (6”) ...

Add the Gtk dependecy to your Cargo.toml: [dependencies] gtk = { git = "https://github.com/gtk-rs/gtk.git" } Create a simple window with the following: extern crate gtk; use gtk::prelude::*; // Import all the basic things use gtk::{Window, WindowType, Label}; fn main() { ...

Regular expression support for tust is provided by the regex crate, add it to your Cargo.toml: [dependencies] regex = "0.1" The main interface of the regex crate is regex::Regex: extern crate regex; use regex::Regex; fn main() { //"r" stands for "raw" str...

Add the following code to your app.js file: var express = require('express') var morgan = require('morgan') var app = express() app.use(morgan('combined')) app.get('/', function (req, res) { res.send('hello, world!') }) Now when you access your website you will see in the console y...

Deref has a simple rule: if you have a type T and it implements Deref<Target=F>, then &T coerces to &F, compiler will repeat this as many times as needed to get F, for example: fn f(x: &str) -> &str { x } fn main() { // Compiler will coerce &&&&&&a...