Insert in SQL From Arduino Built in LattePanda With C# App

In this tutorial we will see how to send data directly from arduino to sql database through c# application

first start with arduino program

int pushButton1 = 2;
int pushButton2 = 3;

int pushButton3 = 4;

int pushButton4 = 5;

void setup() {

Serial.begin(57600);

pinMode(pushButton1, INPUT_PULLUP);

pinMode(pushButton2, INPUT_PULLUP);

pinMode(pushButton3, INPUT_PULLUP);

pinMode(pushButton4, INPUT_PULLUP);

}

void loop() {

int buttonState1 = digitalRead(pushButton1);

if (buttonState1 == LOW) {

Serial.println("Machine one on");

delay(1000); }

int buttonState2 = digitalRead(pushButton2);

if (buttonState2 == LOW) {

Serial.println("Machine two on");

delay(1000); }

int buttonState3 = digitalRead(pushButton3);

if (buttonState3 == LOW) {

Serial.println("Machine three on");

delay(1000); }

int buttonState4 = digitalRead(pushButton4);

if (buttonState4 == LOW) {

Serial.println("Machine four on");

delay(1000);

}

}

Second C# program in the attached file and last DB also included

you will also fined Arduino library in this files

Best Regards for all

Teacher Notes

Teachers! Did you use this instructable in your classroom?
Add a Teacher Note to share how you incorporated it into your lesson.

Be the First to Share

    Recommendations

    • Made with Math Contest

      Made with Math Contest
    • Multi-Discipline Contest

      Multi-Discipline Contest
    • Robotics Contest

      Robotics Contest

    3 Discussions

    0
    None

    Nice instructional video. You might think about about moving it to the top of the Instructable so that viewers can watching before going through the program.

    1 reply
    0
    None
    samirso

    2 years ago

    all files needed in this link below

    https://drive.google.com/open?id=0B-4UOKhoBplpY0FqRzZsS3JyTEU