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
4 Comments
Question 3 years 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
6 years ago
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.
Reply 6 years ago
Yes thank you very much
6 years ago
all files needed in this link below
https://drive.google.com/open?id=0B-4UOKhoBplpY0FqRzZsS3JyTEU