Naveed's Blog

    1. Open Microsoft SQL Server Management Studio.

 2.  In this tutorial we are going to use database “mydatabase1″ . Right click on database and select properties .

3.  Properties dialog box will appear :

4. Select View connection properties :

5.  As connection properties dialogue appear check for instance name :

6 . Now its time to define your connection string :

it should be like

<add name="MyDbConn"        connectionString="Data Source=(localdb)\SQLEXPRESS;Initial Catalog=mydatabase1;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"        providerName="System.Data.SqlClient" />

7. As we have defined our connection string now we can access this connection is our C# code as :

SqlConnection cn = new SqlConnection (ConfigurationManager.ConnectionStrings["MyDbConn"].ToString());

and we want to write a query that lists the names of the movies whose title contains the word “space” in descending order by rank. 

so here is a php solution written in php :

/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package filetest;

import java.io.File; import java.net.MalformedURLException; import java.util.logging.Level; import java.util.logging.Logger; import javafx.application.Application; import javafx.event.ActionEvent; import javafx.event.EventHandler; import javafx.scene.Scene; import javafx.scene.control.Button; import javafx.scene.layout.HBox; import javafx.scene.layout.StackPane; import javafx.scene.media.Media; import javafx.scene.media.MediaPlayer; import javafx.stage.FileChooser; import javafx.stage.Stage;

/** * * @author Waheed */ public class FileTest extends Application {    File f;    MediaPlayer mp ;    Media m ;    String path ;    @Override    public void start(Stage primaryStage) {        FileChooser chooser = new FileChooser();        Button btn = new Button();        Button play = new Button(">");        Button pause = new Button("||");        chooser.getExtensionFilters().addAll(new FileChooser.ExtensionFilter("Audio File", "*.mp3"));

       btn.setOnAction(new EventHandler<ActionEvent>() {

           @Override            public void handle(ActionEvent event) {                f = chooser.showOpenDialog(primaryStage);                try {                    m = new Media(f.toURL().toExternalForm());                } catch (MalformedURLException ex) {                    Logger.getLogger(FileTest.class.getName()).log(Level.SEVERE, null, ex);                }                mp = new MediaPlayer(m);                           }        });       play.setOnAction( new EventHandler<ActionEvent>() {

           @Override            public void handle(ActionEvent event) {                mp.play();            }        });       pause.setOnAction(new EventHandler<ActionEvent>() {

           @Override            public void handle(ActionEvent event) {                mp.pause();            }        });        btn.setText("Open Dialogue Box");        chooser.setTitle("Hi There Choose some file");        HBox root = new HBox();        root.getChildren().add(btn);        root.getChildren().add(play);        root.getChildren().add(pause);        Scene scene = new Scene(root, 300, 250);

       primaryStage.setTitle("File Choosed: ");        primaryStage.setScene(scene);        primaryStage.show();    }

   /**     * @param args the command line arguments     */    public static void main(String[] args) {        launch(args);    }

import javafx.application.Application;

import javafx.beans.property.IntegerProperty;

import javafx.beans.property.SimpleIntegerProperty;

import javafx.scene.Group;

import javafx.scene.GroupBuilder;

import javafx.scene.Scene;

import javafx.scene.control.Slider;

import javafx.scene.control.SliderBuilder;

import javafx.scene.control.Tooltip;

import javafx.scene.paint.Color;

import javafx.scene.text.Font;

import javafx.scene.text.FontWeight;

import javafx.scene.text.Text;import javafx.scene.text.TextBuilder;

import javafx.stage.Stage;

public class SliderSample extends Application

{

 int defaultValue = 10;

IntegerProperty sliderValue = new SimpleIntegerProperty(defaultSliderValue);  

static void main(String[] args)

{

       launch(args);

}

@Override

   public void start(Stage primaryStage)

{       

       Slider s1 = new Slider();        s1.setShowTickMarks(true);        s1.setShowTickLabels(true);

       s1.setLayoutX(300);        s1.setLayoutY(200);

       s1.setMin(1);        s1.setMax(500);        s1.setMajorTickUnit(40);        s1.setMinorTickCount(5);        s1.valueProperty().bindBidirectional(sliderValue);

      TextArea t = new TextArea();

       t.textProperty().bind(sliderValue.asString());

Group root = new Group();

root.getChildren().addAll(s1, t);

Scene scene = new Scene(root);

primaryStage.setScene(scene);

primaryStage.show();

}

}

Syntax for SFC is:

sfc [/scannow] [/verifyonly] [/scanfile=file] [/verifyfile=file] [/offbootdir=boot] [/offwindir=win] [/?]

/scannow : "This switch check and repair various system files".

/verifyonly : "This switch only verifies the integrity of system files".

/scanfile=file   : "This solely check the file name assigned to it, and repairs it".

/verifyfile=file : "Works like /scanfile=file but does not repair".

/offbootdir=boot : "Used to define the boot directory in case its running from outside of window".

/offwindir=win : "Used with /offbootdir=boot to define the windows directory".

/? : "Help Switch".

Examples of SFC Command:

sfc /scannow

type

wlan and it will show like 

netsh wlan>

now type the commands :

show drivers

if it say's yes on 

supported hosted network , then you're ready to move next.

type:

set hostednetwork mode=allow

set hostednetwork ssid = myssid

set hostednetwork key=mypassword

and then start the network

start hostednetwork

 and its up....

nano /etc/mysql/my.cnf

comment line saying

bind-address = 127.0.0.1

like

#bind-address = 127.0.0.1

restart the service

service mysql restart

Now check that networking is enabled.

Run

netstat -tap | grep mysql

The output should look like this:

root@server1:~# netstat -tap | grep mysql tcp 0 0 *:mysql *:* LISTEN 6724/mysqld

root@server1:~#

Installing PowerDNS:

apt-get install pdns-server pdns-backend-mysql

Download the PowerDNS SQL and import it:

wget http://files.soluslabs.com/solusvm/pdns/pdns.sql mysql --user=root --password=MYNEWPASSOWRD < pdns.sql Edit /etc/pdns/pdns.conf with your database details: launch=gmysql gmysql-host=127.0.0.1 gmysql-user=root gmysql-password=MYNEWPASSWORD gmysql-dbname=powerdns now login in to mysql through username / password and enter below line:

GRANT ALL ON powerdns.* TO 'root'@'YOUR_SOLUSVM_MASTERS_IP' IDENTIFIED BY 'MYNEWPASSWORD';

exit my sql and start powerdns