Important changes to forums and questions
All forums and questions are now archived. To start a new conversation or read the latest updates go to forums.mbed.com.
mbed to MSSQL database example
Topic last updated 18 Jan 2012, by 
Theo Ekelmans.
7
replies
Theo Ekelmans.
7
replies
Hi
Just put together some code to get an mbed to populate an sql database.
the mbed access the website with a querystring and website uses the vb function Request.QueryString to write to the database.
here is the vb at the webserver
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Get the values from Query string
'TextBox1.Text = Request.QueryString("ID")
'TextBox2.Text = Request.QueryString("TIME")
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
myConnection = New SqlConnection("server=localhost\SQLEXPRESS;Trusted_Connection=True;database=accesscontrol")
'establishing connection
Try
myConnection.Open()
'opening the connection
myCommand = New SqlCommand("INSERT INTO log VALUES ('" + Request.QueryString("ID") + "', " + Request.QueryString("TIME") + ", " + Request.QueryString("DOOR") + ")", myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close()
Catch ex As Exception
TextBox1.Text = ex.ToString
End Try
End Sub
End Class
and the moded code from the ethernet example
#include "mbed.h"
#include "HTTPClient.h"
DigitalOut led(LED1);
HTTPClient http;
/**
* Request a google search for HelloWorld and display the first 2000 characters
* of the page source on the serial terminal.
*/
int main(void) {
char url[256];
char result[2000];
// Insert the search term into the URL
sprintf(url, "http://xxx.xxx.xxx.xxx/default.aspx?id=mbed&time=35&door=12");
// Request 2000 characters from the result. Default is 64.
http.get(url, result, 2000);
// Display the result
printf("%s\n", result);
// Work is done!
while(1) {
led = !led;
wait(0.2);
}
}