{"id":1374,"date":"2009-04-26T22:46:59","date_gmt":"2009-04-26T21:46:59","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/?p=1374"},"modified":"2009-04-26T22:46:59","modified_gmt":"2009-04-26T21:46:59","slug":"a-silverlight-database-application-with-image-upload","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/1374-a-silverlight-database-application-with-image-upload.html","title":{"rendered":"A Silverlight database application with image upload"},"content":{"rendered":"<p>I\u2019ve been amusing myself creating a simple online database application using <a href=\"http:\/\/silverlight.net\/default.aspx\" target=\"_blank\">Silverlight<\/a>. I had this mostly working a while back, but needed to finish off some pieces in order to get it fully functional.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.itwriting.com\/images\/silverlightdata.jpg\" \/><\/p>\n<p>This is created using Silverlight 2.0 and demonstrates the following:<\/p>\n<ul>\n<li>A bound DataGrid (as you can see, work is still needed to get the dates formatted sensibly). <\/li>\n<li>Integration with ASP.NET authentication. You have to log in to see the data, and you have to log in with admin rights to be able to update it. <\/li>\n<li>Create,Retrieve,Update,Delete using ASP.NET web services. <\/li>\n<li>Image upload using Silverlight and an ASP.NET handler. <\/li>\n<li>Filter a DataGrid (idea taken from <a href=\"http:\/\/www.mostlydevelopers.com\/mostlydevelopers\/blog\/post\/2009\/02\/19\/Silverlight-DataGrid-ItemsSource-Filter.aspx\" target=\"_blank\">here<\/a>). <\/li>\n<li>Written in Visual Studio 2008, and hosted on this site, which runs Debian Linux, hence <a href=\"http:\/\/www.mono-project.com\/Main_Page\" target=\"_blank\">Mono<\/a> and <a href=\"http:\/\/www.mysql.com\/\" target=\"_blank\">MySQL<\/a>. Would you have known if I had not told you? <\/li>\n<\/ul>\n<p>You can try it <a href=\"http:\/\/www.itwriting.com\/silverlightdata\/\" target=\"_blank\">here<\/a>. I\u2019ll post the code eventually, but it will be a couple of months as it links in with another article.<\/p>\n<p>MVP Ken Cox <a href=\"http:\/\/silverlight.net\/blogs\/jesseliberty\/archive\/2008\/10\/19\/silverlight-and-data.aspx#113546\" target=\"_blank\">notes<\/a> in a comment to Jesse Liberty\u2019s blog:<\/p>\n<blockquote>\n<p>Hundreds of us are scouring the Internet for a realistic (but manageable and not over-engineered) sample of manipulating data (CRUD operations) in a Silverlight 2 application. There are promising pieces of the puzzle scattered all over the place. Unfortunately, after investing time in a sample, we discover it lacks a key element &#8211; like actually saving changed data back to the database.<\/p>\n<\/blockquote>\n<p>I can safely say that mine is not over-engineered, and that yes, it does write data.<\/p>\n<\/p>\n<div style=\"padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px\" id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:e5172167-ba67-4fd1-8180-d355a2217295\" class=\"wlWriterEditableSmartContent\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/silverlight\" rel=\"tag\">silverlight<\/a>,<a href=\"http:\/\/technorati.com\/tags\/database\" rel=\"tag\">database<\/a>,<a href=\"http:\/\/technorati.com\/tags\/mono\" rel=\"tag\">mono<\/a>,<a href=\"http:\/\/technorati.com\/tags\/mysql\" rel=\"tag\">mysql<\/a>,<a href=\"http:\/\/technorati.com\/tags\/asp.net\" rel=\"tag\">asp.net<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019ve been amusing myself creating a simple online database application using Silverlight. I had this mostly working a while back, but needed to finish off some pieces in order to get it fully functional. This is created using Silverlight 2.0 and demonstrates the following: A bound DataGrid (as you can see, work is still needed &hellip; <a href=\"https:\/\/www.itwriting.com\/blog\/1374-a-silverlight-database-application-with-image-upload.html\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">A Silverlight database application with image upload<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,77,80,83,1,94,96,97],"tags":[],"class_list":["post-1374","post","type-post","status-publish","format-standard","hentry","category-database","category-silverlight","category-software-development","category-sql","category-uncategorized","category-visual-studio","category-web-authoring","category-windows"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/1374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=1374"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/1374\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=1374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=1374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=1374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}