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

Introduction: 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

Be the First to Share

    Recommendations

    • Make it Glow Contest

      Make it Glow Contest
    • First Time Author Contest

      First Time Author Contest
    • PCB Challenge

      PCB Challenge

    4 Discussions

    0
    wajihe
    wajihe

    Question 8 months ago on Introduction

    i try to install sql server express on my panda, i get this message

    SQL Server Setup has encountered the following error:
    The SQL Server license agreement cannot be located for the selected edition, EXPRESS. This could be a result of corrupted media or the edition being unsupported by the media.
    Error code 0x858C001B.

    can you help me plz
    thanks

    0
    DIY Hacks and How Tos

    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.

    0
    samirso
    samirso

    Reply 4 years ago

    Yes thank you very much

    0
    samirso
    samirso

    4 years ago

    all files needed in this link below

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