Naveed's Blog

Today 19-12-2014 , at the end of this year . I am creating this blog just to share some hard things in easy way. I am feed up with that long tutorials and now it's time do things in easier way.

[dotech]

ASP.NET connecting to MSSQL database step by step

Here is a complete tutorial to connect to MS-SQL server database.

    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());

Remember the name we defined in  connection string  . It should be same in C# code .

[dotech]

Working with like in mysql

let’s say we have mysql table :

movies(id, name, year, rank)

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 :

$conn = mysqli_connect('localhost', 'myusername', 'mypassword', 'mydatabase', '3306');        if (!$conn) {            die('Could not connect to MySQL: ' . mysqli_connect_error());        }        echo '<table>';        echo '<tr>';        echo '<th>id</th>';        echo '<th>name</th>';        echo '<th>year</th>';        echo '<th>rank</th>';        echo '</tr>';        $sql = "SELECT * FROM `movies` WHERE name LIKE '%space%' ORDER BY name ASC";        $result = mysqli_query($conn, $sql);        echo mysqli_error($conn);        while (($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) != NULL) {            echo '<tr>';            echo '<td>' . $row['id'] . '</td>';            echo '<td>' . $row['name'] . '</td>';            echo '<td>' . $row['year'] . '</td>';            echo '<td>' . $row['rank'] . '</td>';            echo '</tr>';        }        mysqli_free_result($result);        echo '</table>';        mysqli_close($conn);        ?>

[dotech]

MP3 Player - JavaFX

[dotech]

dotech:

Here is the sample code for mp3 player :)

Keep reading

[dotech]

MP3 Player - JavaFX

Here is the sample code for mp3 player :)

/* * 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);    }

}

[dotech]

Binding Slider Value to Text or Text Field - JavaFX

So here is quick tutorial on how to do this .

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();

}

}

Hope it clears all :)

[dotech]

Checking system files  - CMD

SFC is a command that is used in Windows over CMD. The purpose of command is to check the various system files integrity. There are different switches that are used with SFC.

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

sfc /verifyonly

[dotech]

Turning Wifi to HotSpot via CMD

It's easy to do it via CMD

open cmd from start menu . and change its mode to netsh.

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....

Enjoy

[dotech]

Thought of the day 🔰

[dotech]

Reverse DNS - Ubuntu Part -1

Install PowerDNS and MySQL

login to your ssh terminal and

type:

apt-get install mysql-server mysql-client

Use Any text editor to edit:

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

/etc/init.d/pdns start