tag:blogger.com,1999:blog-85362215492177534322024-02-20T09:01:49.872-08:00Dataseppäjuanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.comBlogger86125tag:blogger.com,1999:blog-8536221549217753432.post-63707002549854219572021-04-27T02:23:00.001-07:002021-04-27T02:23:10.245-07:00SQL kielen niksejä: Tupla arvojen löytäminen taulusta<p> </p><h3 style="background-color: #fffefd; box-sizing: inherit; clear: both; color: #404040; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; margin: 0px 0px 0.5em; overflow-wrap: break-word; padding: 0px;">Tuplien etsiminen</h3><p style="background-color: #fffefd; box-sizing: inherit; color: #404040; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 16px; margin-bottom: 1.5em; margin-top: 0px; overflow-wrap: break-word;">Löydät taulusta rivit, joissa on joku kenttä tuplana näin:</p><p style="background-color: #fffefd; box-sizing: inherit; color: #404040; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 16px; margin-bottom: 1.5em; margin-top: 0px; overflow-wrap: break-word; padding-left: 30px;">SELECT kenttä, COUNT(kenttä) AS NumOccurrences FROM taulu GROUP BY kenttä HAVING ( COUNT(kenttä) > 1 )</p><p style="background-color: #fffefd; box-sizing: inherit; color: #404040; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 16px; margin-bottom: 1.5em; margin-top: 0px; overflow-wrap: break-word;">Tämä tuottaa listan kentän arvoista, jotka esiintyvät taulussa useampaan kertaan.</p>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-51011514632159187552018-12-16T23:56:00.002-08:002018-12-16T23:56:25.035-08:00#1146 table doesn't existTörmäsin tähän virheeseen asiakkaan järjestelmän ylläpidossa. Taustalla oli webhotellin palvelimen kaatuminen tekniseen ongelmaan. Palvelimen uudelleenkäynnistymisen jälkeen asiakkaan sivusto antoi virheilmoitusta sellaisesta kohtaa koodia, joka ei ollut edes käytössä. Lähemmän tutkiskelun kautta alkoi paljastua, että taulujen luontiscriptin ajo tökkäsi tietyssä kohtaa. Pääsin PHP_ADMIN:lla MySQL-kantaan käsiksi ja yritin avata sitä taulua, johon luontisripti tökkäsi. Ei avautunut taulu, vaan tuli virhe: #1146 table doesn't exist.<br />
<br />
Googlettamalla löytyy selitys tuolle virheelle. Omassa tapauksessani yhden taulun luonti oli mennyt jossain vaiheessa pieleen ja taulun kirjanpito sekaisin. Taulun poistaminen DROP-käskyllä palautti tilan, josta luontiscriptin pystyi taas ajamaan uudelleen!juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-33388638091936323812018-09-26T23:33:00.001-07:002018-09-26T23:33:26.391-07:00Kuinka konvertoida VB6.0 projekti Visual Studio 2017 versioon<h2 class="title icon" style="background-color: #fafafa; border-bottom: 1px solid rgb(200, 200, 200); color: #333333; font-family: Tahoma, Calibri, Verdana, Geneva, sans-serif; font-size: 14px; font-stretch: normal; font-variant-east-asian: normal; font-variant-numeric: normal; line-height: normal; margin: 0px 0px 5px; padding: 10px 10px 5px 0px;">
1) Open in VB6.<span style="font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px;"> </span></h2>
<div class="content" style="background-color: #fafafa; color: #333333; font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px; margin: 0px; padding: 0px;">
<div id="post_message_5171295" style="margin: 0px; padding: 0px;">
<blockquote class="postcontent restore " style="margin: 0px; overflow-wrap: break-word; overflow: hidden; padding: 0px;">
Run project to make sure everything works and is updated.<br /><br />2) Open that project in VB Express 2008. Migrate!<br /><br />3) Open the .vbproj in VS 2013. Permanent migration. Never look back!<br /><br />4) Open VS2013 project in VS2017 / VSCommunity<br /><br />WOW. This is unreal, but that it actually worked.</blockquote>
</div>
</div>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-62669313780404205412018-01-24T02:15:00.000-08:002018-01-24T02:15:03.850-08:00Kuinka kysyä SQL Server Jobin tila esim. c# koodista käsinTässä yksi tapa:<br /><a href="https://gallery.technet.microsoft.com/scriptcenter/34df4534-b43c-41e7-ac7c-dfee31f135a2">https://gallery.technet.microsoft.com/scriptcenter/34df4534-b43c-41e7-ac7c-dfee31f135a2</a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-29393665083700326622017-11-07T05:11:00.002-08:002017-11-07T05:12:07.325-08:00Visual Studio 2015 - Read XML data into a datasetEsimerkiksi C# sovelluksessa tarvitaan useasti ominaisuutta, jolla helposti lukea xml-tiedoston sisältö tietokantaan. Tässä siihen vinkkejä:<br />
<a href="https://msdn.microsoft.com/en-us/library/ekw4dh3f.aspx">https://msdn.microsoft.com/en-us/library/ekw4dh3f.aspx</a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-31900405130995908802017-11-03T05:17:00.003-07:002017-11-03T05:17:28.408-07:00SSIS:Send Email from Event handlerSSIS paketissa voi käyttää Event handleria esim. emailin lähettämiseen virhetilanteessa.<br />Tässä ohjeet:<br /><a href="https://dwhanalytics.wordpress.com/2011/04/05/ssissend-email-from-event-handler/">https://dwhanalytics.wordpress.com/2011/04/05/ssissend-email-from-event-handler/</a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-1230082598718071062017-11-02T06:42:00.004-07:002017-11-02T06:42:59.630-07:00XML:stä voi generoida XSD:nTästä löytyy ilmainen generaattori:<br />
<a href="https://www.freeformatter.com/xsd-generator.html">https://www.freeformatter.com/xsd-generator.html</a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-29867465130435174352017-09-21T01:16:00.002-07:002017-09-21T01:16:45.452-07:00Javascript debuggaus selaimessaTässä on hyvää tietoa otsikon aiheeseen: <a href="https://developers.google.com/web/tools/chrome-devtools/javascript/">https://developers.google.com/web/tools/chrome-devtools/javascript/</a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-2845467418099874552017-04-20T03:41:00.002-07:002017-04-20T03:41:45.444-07:00"Pilkunviilausta" - JavascriptOlet varmasti törmännyt Javasriptillä koodatessasi tähän virheeseen: <span class="pln" style="background-color: #eff0f1; border: 0px; color: #303336; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif; font-size: 13px; margin: 0px; padding: 0px; white-space: inherit;">missing </span><span class="pun" style="background-color: #eff0f1; border: 0px; color: #303336; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif; font-size: 13px; margin: 0px; padding: 0px; white-space: inherit;">)</span><span class="pln" style="background-color: #eff0f1; border: 0px; color: #303336; font-family: "consolas" , "menlo" , "monaco" , "lucida console" , "liberation mono" , "dejavu sans mono" , "bitstream vera sans mono" , "courier new" , monospace , sans-serif; font-size: 13px; margin: 0px; padding: 0px; white-space: inherit;"> after argument list</span><br />
... ja mahdollisesti repinyt hiuksia päästäsi sen takia.<br />
<br />
Helposti olla syynä, että pilkut ja hipsut on kirjoitettu väärin. Nehän määritettävä tietyllä tavalla Javascript- syntaksissa..<br />
<br />
Esim virheestä:<br />
<pre class="default prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">photoHTMLString </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;">'<li class = "SliderPhoto"><img src = "'</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">+</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">ImageArray</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">[</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">x</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">].</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">src_small </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">+</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;">'" size = "thumb" onclick = "ShowImagePopUP('</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">+</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">ImageArray</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">[</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">x</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">].</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">src_big </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">+</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;">')" class = "FacebookSliderPhoto"/></li>'</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">;</span></code></pre>
Korjaus virheeseen:<br />
<pre class="default prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;">"ShowImagePopUp(\'' + ImageArray[x].src_big + '\')"</span></code></pre>
<br />
Tämä vinkki löytyy kokonaisuudessaan <a href="http://stackoverflow.com/questions/5982834/javascript-error-missing-after-argument-list" target="_blank">täältä.</a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-36407406458769822282017-04-07T06:18:00.000-07:002017-04-07T06:24:18.480-07:00Miten lisätä Chat omalle nettisivustolle?Muutamalla rivillä javascriptiä saat helposti Chatin sivullesi. Tawk.to avulla se onnistuu, esimerkiksi.<br />
<br />
Tawk.to tarjoaa Chat-sovellusta sivustollaan: <a href="https://www.tawk.to/">https://www.tawk.to/</a><br />
Vaatii palveluun rekisteröitymisen. Palvelusta löytyy kattavat ohjeet Chatin käyttöönottoon ja rajapinnan käyttöön!<br />
<br />
Ilmaisversiossakin pääset muuttamaan mm. Chatin kielen Suomeksi. Ja rajapinnan kautta voit välittää palveluusi kirjautuneen Chattajan käyttäjätunnuksen ja sähköpostin yms. tietoa Chattiin.<br />
Jos nettisivullasi ei ole kirjautumista käytössä, niin javascriptin lisääminen sivustolle riittää ja asiakkaat pääset Chattaamaan sinulle :)<br />
<br />
Jos tarviit apuja Chatin javascriptin lisäämiseen omalle sivullesi, niin otappa yhteyttä !!!<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbph0pJd681cZ0sGnRPLs7w6laoAcEkd8ZRJDBDyr8tIYhoGLAvOxqqABUb2bYgYHOxRkGHM1GBIxTJZwL6YRomibCh_y-dhBQEWL5miqxTpV5sis1VqmnDFhz0-kdo05rK5jwHtSimSxY/s1600/chatin+kuva.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbph0pJd681cZ0sGnRPLs7w6laoAcEkd8ZRJDBDyr8tIYhoGLAvOxqqABUb2bYgYHOxRkGHM1GBIxTJZwL6YRomibCh_y-dhBQEWL5miqxTpV5sis1VqmnDFhz0-kdo05rK5jwHtSimSxY/s320/chatin+kuva.PNG" width="320" /></a></div>
<br />
<br />
<!--Start of Tawk.to Script-->
<script type="text/javascript">
var Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();
(function(){
var s1=document.createElement("script"),s0=document.getElementsByTagName("script")[0];
s1.async=true;
s1.src='https://embed.tawk.to/58e792d130ab263079b5ef3c/default';
s1.charset='UTF-8';
s1.setAttribute('crossorigin','*');
s0.parentNode.insertBefore(s1,s0);
})();
</script>
<!--End of Tawk.to Script-->juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-28646340413363402992017-02-28T23:32:00.000-08:002017-02-28T23:48:56.251-08:00Datasepän koodikoulu haluaa edistää ohjelmoinnin oppimista ja opettamista peruskoulussa<a href="https://dataseppa.wordpress.com/" target="_blank">Datasepän koodikoulu</a> jakaa tietoutta ohjelmoinnin opettamisesta blogi-kirjoituksilla. Sivusto on perustettu 2014, kun oli jo tiedossa ohjelmoinnin opetuksen tulevan peruskoulun opetussuunnitelmaan.<br />
<br />
Tämän koodikoulun takana on Dataseppä-yrittäjä Jaana Seppälä, jolla on ohjelmoinnista käytännön työkokemusta n. 20 vuotta. Hän on ollut mukana erilaisissa projekteissa ohjelmoimassa erilaisia kohteita mm. intranet palvelu, internet palvelut, tietokanta, matkapuhelin, tukiasema, mobiilisovellus, pilvipalvelu, toiminnanohjaus, laskutus, tuotannonohjaus, PC...<br />
Nämä antavat vankan tietämyksen siitä, mistä ohjelmoinnissa on kyse. Ohjelmointia voidaan tehdä laitteille, mutta paljon tarvitaan erilaista koodia mm. internetin palveluihin, yritysten päivittäisten toimintojen hoitamiseen ja julkishallinnon palvelujen hoitamiseen. Ohjelmoijan työ on harvoin robottien ohjaamista ja uuden koodin kirjoittamista alusta lähtien. Työssä korostuu koodin "lukeminen", olemassa olevan koodin hyödyntäminen, kokonaisuuden hahmottaminen ja järjestelmällisyys. Myös maalaisjärjellä on paljon käyttöä. Ja tietysti ohjelmistoprojekteissa on hyvin paljon muutakin työtä, kuin itse koodaus. Ennenkuin koodaamaan päästään on tehtävä paljon erilaisia määrittelyjä ja suunnitelmia... muita näistä toisella kertaa enemmän.<br />
<br />
Datasepän koodikoulu on järjestänyt useita koulutuksia peruskouluikäisille ja opettajille. Opetusta annetaan lapsentasoisesti, ja palaute koulutuksista onkin ollut erinomainen. Myös kerho- ja leiritoiminta on kuulunut koodikoulun ohjelmaan parin viime vuoden ajan. Näiden kerhojen ja koulutusten myötä on karttunut paljon tietoa siitä, millaisia asioita ja miten on eri ikäisten helppo omaksua. Ja tätä tietoa jaetaan sivustolla <a href="https://dataseppa.wordpress.com/">https://dataseppa.wordpress.com/</a><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcrfa0ynoZMjMgfUj6zqgoWBiA5scsBodtzp8bbXHUTFyoJejap3J-T66eJ5vKIRybZvsPkFRYzeTl8QxDCLnNb69jZFy7ImsdS21mlLmITFYZNyeQU-uViIHP-K5pSZ_7L4b5ZFV2eube/s1600/00001649.jpg" imageanchor="1"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcrfa0ynoZMjMgfUj6zqgoWBiA5scsBodtzp8bbXHUTFyoJejap3J-T66eJ5vKIRybZvsPkFRYzeTl8QxDCLnNb69jZFy7ImsdS21mlLmITFYZNyeQU-uViIHP-K5pSZ_7L4b5ZFV2eube/s320/00001649.jpg" width="320" /></a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-42653808863128313952017-02-15T03:19:00.002-08:002017-02-15T03:19:57.887-08:00PHP - file_contents()<div style="background-color: white; border: 0px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin-bottom: 1em; padding: 0px;">
Joskus pitää käsitellä HTML-sivulle tuotua XML- koodia. File_contents osaa purkaa xml:n sisällön HTML:n sekaan, mutta voi olla, että haluat nähdä myös XML-rakenteen. <br /><a href="http://stackoverflow.com/questions/16544960/php-file-get-contents-and-xml-files" target="_blank">Se onnistuu tällä vinkillä:</a></div>
<div style="background-color: white; border: 0px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin-bottom: 1em; padding: 0px;">
When you print XML in an HTML page, the XML is assimilated to HTML, so you do not see the tags.</div>
<div style="background-color: white; border: 0px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin-bottom: 1em; padding: 0px;">
To see the tags as text, you should replace them with the HTML corresponding entity:</div>
<pre class="default prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">$myxmlfilecontent </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> file_get_contents</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">(</span><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;">'./myfile.xml'</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">);</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">
echo str_replace</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">(</span><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;">'<'</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;">'&lt;'</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> $myxmlfilecontent</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">);</span></code></pre>
<div style="background-color: white; border: 0px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin-bottom: 1em; padding: 0px;">
that should do the trick</div>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-30821055305144351032016-12-28T01:33:00.000-08:002016-12-28T01:33:15.450-08:00Visual Studio 2015 warning: Could not find schema information for the attribute...<div style="background-color: white; border: 0px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin-bottom: 1em; padding: 0px;">
Otsikon mukaisesta virheilmoituksesta pääsee eroon näin:</div>
<div style="background-color: white; border: 0px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin-bottom: 1em; padding: 0px;">
Quickest, easiest laziest way to solve the problem:</div>
<ol style="background-color: white; border: 0px; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin: 0px 0px 1em 30px; padding: 0px;">
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Right-click on the project icon in Solution Explorer and choose "Properties".</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Go to the "Application" tab and choose an earlier .NET target framework.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Save changes.</li>
<li style="border: 0px; margin: 0px 0px 0.5em; padding: 0px; word-wrap: break-word;">Go to the "Application" tab and choose the initial .NET target framework.</li>
<li style="border: 0px; margin: 0px; padding: 0px; word-wrap: break-word;">Save changes => problem solved!</li>
</ol>
<div>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="font-size: 15px;">Tässä linkissä selitetty syitä ilmoituksen taustalta:</span><br /><span style="font-size: 15px;"><a href="http://stackoverflow.com/questions/5303476/how-to-fix-error-could-not-find-schema-information-for-the-attribute-element">http://stackoverflow.com/questions/5303476/how-to-fix-error-could-not-find-schema-information-for-the-attribute-element</a></span></span></div>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-68559154206386666082016-12-27T02:47:00.001-08:002016-12-27T02:47:44.929-08:00ASP.NET MVC5 - Linq kyselyn Inner join syntaksiVälillä tarvitsen SQL-kyselyjä, joissa yhdistetään eri taulujen tietoja. Tässä INNER JOIN kyselyn syntaksi Linq-koodilla:<br />
<br />
<br />
<table style="background-color: white; border-collapse: collapse; border-spacing: 0px; border: 0px; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 13px; margin: 0px; padding: 0px;"><tbody style="border: 0px; margin: 0px; padding: 0px;">
<tr style="border: 0px; margin: 0px; padding: 0px;"><td class="votecell" style="border: 0px; margin: 0px; padding: 0px 15px 0px 0px; vertical-align: top;"><div class="vote" style="border: 0px; margin: 0px; min-width: 46px; padding: 0px; text-align: center;">
<a class="vote-down-off" href="https://www.blogger.com/null" style="background-image: url("img/sprites.svg?v=8c1c8cba242e"), none; background-position: 0px -220px; background-repeat: no-repeat; background-size: initial; border: 0px; color: #0077cc; cursor: pointer; display: block; font-size: 1px; height: 30px; margin: 0px auto 10px; overflow: hidden; padding: 0px; text-indent: -9999em; width: 40px;" title="This answer is not useful">down vote</a></div>
</td><td class="answercell" style="border: 0px; margin: 0px; padding: 0px; vertical-align: top;"><div class="post-text" itemprop="text" style="border: 0px; font-size: 15px; line-height: 1.3; margin: 0px 0px 5px; padding: 0px; width: 660px; word-wrap: break-word;">
<pre class="default prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">var</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> results </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">from</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c </span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">in</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> db</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Companies</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">
join cn </span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">in</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> db</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Countries</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> on c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">CountryID</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> equals cn</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">ID
join ct </span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">in</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> db</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Cities</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> on c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">CityID</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> equals ct</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">ID
join sect </span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">in</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> db</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Sectors</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> on c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">SectorID</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> equals sect</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">ID
</span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">where</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">(</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">CountryID</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">==</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> cn</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">ID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">)</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">&&</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">(</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">CityID</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">==</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> ct</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">ID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">)</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">&&</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">(</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">SectorID</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">==</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> company</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">SectorID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">)</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">&&</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">(</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">company</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">SectorID</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">==</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> sect</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">ID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">)</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">
</span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">select</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">new</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">{</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> country </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> cn</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Name</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> city </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> ct</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Name</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">ID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Name</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Address1</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Address2</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Address3</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">CountryID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">CityID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Region</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">PostCode</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Telephone</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Website</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">SectorID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Status</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">(</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">ContactStatus</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">)</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">c</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">StatusID</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">,</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> sector </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> sect</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">Name</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">};</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">
</span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">return</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> results</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">ToList</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">();</span></code></pre>
</div>
</td></tr>
</tbody></table>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-62864840499080545712016-12-27T01:00:00.000-08:002016-12-27T01:14:19.508-08:00ASP.NET MVC5 - ViewBag arvon lukeminen JavascriptissäMVC5 view:llä halutaan usein näyttää jokin ViewBag- arvo.<br />
Javascriptissä ViewBag on luettava näin:<br />
<div>
<br /></div>
<div>
<pre class="lang-cs prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;"><script></span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">
</span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">var</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> someStringValue </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="str" style="border: 0px; color: #7d2727; margin: 0px; padding: 0px;">'@(ViewBag.someStringValue)'</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">;</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">
</span><span class="kwd" style="border: 0px; color: #101094; margin: 0px; padding: 0px;">var</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> someNumericValue </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">=</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"> </span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">@(</span><span class="typ" style="border: 0px; color: #2b91af; margin: 0px; padding: 0px;">ViewBag</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">.</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">someNumericValue</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">);</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">
</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;"></</span><span class="pln" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">script</span><span class="pun" style="border: 0px; color: #303336; margin: 0px; padding: 0px;">></span></code></pre>
</div>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-23059749036108891542016-12-20T06:15:00.004-08:002016-12-20T06:15:55.795-08:00Joulutervehdys<span id="ext-gen2266" style="background-color: white; box-sizing: border-box; color: #994dce; font-family: "Segoe UI", Ubuntu, "lucida grande", tahoma, sans-serif; font-size: 13px;">Dataseppä toivottaa kaikille Hyvää Joulua ja Menestyksekästä Uutta Vuotta !!</span><br />
<div id="ext-gen2265" style="background-color: white; box-sizing: border-box; color: #222222; font-family: "Segoe UI", Ubuntu, "lucida grande", tahoma, sans-serif; font-size: 13px; margin: 0px; padding: 0px;">
<span style="box-sizing: border-box; color: #994dce;"><br style="box-sizing: border-box;" /></span></div>
<div id="ext-gen2263" style="background-color: white; box-sizing: border-box; color: #222222; font-family: "Segoe UI", Ubuntu, "lucida grande", tahoma, sans-serif; font-size: 13px; margin: 0px; padding: 0px;">
<span style="box-sizing: border-box; color: #994dce;"><b style="box-sizing: border-box;"><span id="ext-gen2264" style="border: 0px; box-sizing: border-box; margin: 0px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;">Enkelten laulu, kellojen kaiku,<br style="box-sizing: border-box;" />joulusta ilmoittavat.</span><br style="box-sizing: border-box; text-align: center;" /><span id="ext-gen2243" style="border: 0px; box-sizing: border-box; margin: 0px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;">Rauhoittuu mielet, päättyvät kiireet,<br style="box-sizing: border-box;" />joulu on tullut taas.</span></b></span></div>
<div>
<span style="box-sizing: border-box; color: #994dce;"><b style="box-sizing: border-box;"><span style="border: 0px; box-sizing: border-box; margin: 0px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;"><br /></span></b></span></div>
<div>
<span style="box-sizing: border-box; color: #994dce;"><b style="box-sizing: border-box;"><span style="border: 0px; box-sizing: border-box; margin: 0px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;"><br /></span></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3mB20PfGc05GoHjiWonyoFs05z_LAYib0qQrZXZNH7GKiCymXEV3Wp4J9_gdVQ8msfXp1Rt7nZLn4lyeBcJr2qI9nMOv8rK6YynsmlaskwJJM40hSY5DraF7n5ZkyyJXqYzqmlrpTmLfs/s1600/JouluKellot.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3mB20PfGc05GoHjiWonyoFs05z_LAYib0qQrZXZNH7GKiCymXEV3Wp4J9_gdVQ8msfXp1Rt7nZLn4lyeBcJr2qI9nMOv8rK6YynsmlaskwJJM40hSY5DraF7n5ZkyyJXqYzqmlrpTmLfs/s1600/JouluKellot.gif" /></a></div>
<div style="text-align: left;">
<span style="box-sizing: border-box; color: #994dce;"><b style="box-sizing: border-box;"><span style="border: 0px; box-sizing: border-box; margin: 0px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;"><br /></span></b></span></div>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-88105043342689264942016-12-11T23:45:00.000-08:002016-12-11T23:48:45.055-08:00XAMPP - Apachen porttien muuttaminenAsensin XAMPP- kehitysympäristöä koneelleni. Aiemmin asennetut ohjelmat olivat ottaneet jo käyttöönsä portteja, jotka Apache oletuksena olisi halunnut käyttää. Tämä luonnollisesti esti Apachen käynnistämisen.<br />
<div>
<br /></div>
<div>
Jos sinulle tapahtuu tämä sama XAMPP-asennuksen jälkeen: </div>
<div>
<div>
"You need to uninstall/disable/reconfigure the blocking application or reconfigure Apache and the Control Panel to listen on a different port.."</div>
</div>
<div>
<br /></div>
<div>
<a href="https://www.youtube.com/watch?v=_cu7KM0NsUA" target="_blank">Niin tässäpä on hyvät ohjeet Apachen porttien conffaamiseen:</a></div>
<div>
https://www.youtube.com/watch?v=_cu7KM0NsUA<br />
<br />
<br /></div>
<div>
<br /></div>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-33362946601695756832016-11-03T01:07:00.000-07:002016-11-03T01:07:25.079-07:00Responsiivinen PopUp- ikkuna - ASP.NET<a href="https://stanhub.com/create-responsive-popup-modal-window-jquery-no-plugin/">https://stanhub.com/create-responsive-popup-modal-window-jquery-no-plugin/</a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-24572160849514892892016-11-02T03:56:00.002-07:002016-11-02T03:56:24.154-07:00 Google Maps API error - MissingKeyMapError<span style="background-color: white; font-size: 15px;"><span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><a href="http://stackoverflow.com/questions/37991340/error-google-maps-api-error-missingkeymaperror">http://stackoverflow.com/questions/37991340/error-google-maps-api-error-missingkeymaperror</a></span></span><br />
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;"><br /></span></span>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;">Tämä ongelma voi tulla eteen, jos html-sivulle on upotettu Google:n kartta. Javascipt antaa otsikon mukaisen virheen. <br /><br /><b>Syy on tässä:</b></span></span><br />
<span style="background-color: white; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px;">As per </span><a href="http://googlegeodevelopers.blogspot.com.au/2016/06/building-for-scale-updates-to-google.html" style="background-color: white; border: 0px; color: #005999; cursor: pointer; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin: 0px; padding: 0px; text-decoration: none;"><strong style="border: 0px; margin: 0px; padding: 0px;">Google recent announcement</strong></a><span style="background-color: white; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px;">, usage of the Google Maps APIs now requires a key. If you are using the Google Maps API on localhost or your domain was not active prior to June 22nd, 2016, it will require a key going forward. Please see the Google Maps APIs documentation to get a key and add it to your application.</span><br />
<span style="background-color: white; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px;"><br /></span>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;"><br /></span></span>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;"><b>Korjaus tässä:</b></span></span><br />
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;"><br /></span></span>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;">Vika korjaantuu helposti hankkimalla ilmaisen Key:n Google Maps API:a varten ja kertomalla siitä koodissa.</span></span><br />
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;"><br /></span></span>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;">Eli muuta tämä:</span></span><br />
<pre style="background-color: #eff0f1; border: 0px; color: #242729; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><script src="https://maps.googleapis.com/maps/api/js"></script></code></pre>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;"><br /></span></span>
<span style="color: #242729; font-family: Arial, Helvetica Neue, Helvetica, sans-serif;"><span style="background-color: white; font-size: 15px;">Tällaiseksi:</span></span><br />
<pre style="background-color: #eff0f1; border: 0px; color: #242729; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><script src="https://maps.googleapis.com/maps/api/js?libraries=places&key=your_api_key_here"></script></code></pre>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-71604230885811682272016-10-06T23:38:00.000-07:002016-10-06T23:38:05.754-07:00ReportViewer ja VS2015<a href="http://stackoverflow.com/questions/31581432/missing-microsoft-rdlc-report-designer-in-visual-studio" target="_blank">ReportViewer ei ole mukana VS2015 oletus asennuksessa. </a>Saat sen mukana Custom- asennuksena, kun valitset mukaan Microsoft SQL server data tools.<br />
<br />
Tässä linkkejä ReportViewerin NuGet- paketteihin:<br />
<a href="https://www.nuget.org/packages?q=ReportViewer" target="_blank">ReportViewer asennuspaketit / Visual Studio 2015</a><br />
<br />
<br />juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-68941177171702254202016-10-06T03:13:00.000-07:002016-10-06T03:15:48.432-07:00VS2010 bugi<div class="separator" style="clear: both; text-align: left;">
VS2010:ssa on eräs bugi, joka ilmestyy yhtäkkiä kuin tyhjästä..</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Eli teet projektillesi Rebuild, ja VS ilmoittaakin yllättäen, ettei pysty kopioimaan tiedostaja, koska ne ovat toisen prosessin käytössä. <br />Esim.</div>
<em style="background-color: white; border: 0px; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; margin: 0px; padding: 0px;">Error 9 Unable to copy file "obj\x86\Debug\Arrowgrass Reports.exe" to "bin\Debug\Arrowgrass Reports.exe". The process cannot access the file 'bin\Debug\Arrowgrass Reports.exe' because it is being used by another process.</em><br />
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Ratkaisuja tähän löytyy monia, tässä se, joka oli minun kohdallani toimiva. <br />Laitan sen muistiksi tänne blogiini, jos joskus tulee sama ongelma eteen uudelleen.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Avaa Project properties - Debug: Ota pois ruksi kohdasta Enable the Visual Studio hosting process.</div>
<div class="separator" style="clear: both; text-align: left;">
Ja taas onnistuu Rebuild. Lisäksi palautettuani ruksi takaisin, niin Rebuild toimi edelleen. <br />Että sellaista tänään!</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtM3pKsP_ErgN8T360ry6-rgmtRqDV6rIUpLPv7zTg2TG-uKRT9zZuFIX2LFtPd8P8z-o-pW_NXmxNlK1Ioqmbei0ri7S3tJy9ghsa8-mOPElf6VHEI6hTIF3-b9ldoyDmQJ7INXTRxH6a/s1600/VS2010_bugi.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="420" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtM3pKsP_ErgN8T360ry6-rgmtRqDV6rIUpLPv7zTg2TG-uKRT9zZuFIX2LFtPd8P8z-o-pW_NXmxNlK1Ioqmbei0ri7S3tJy9ghsa8-mOPElf6VHEI6hTIF3-b9ldoyDmQJ7INXTRxH6a/s640/VS2010_bugi.png" width="640" /></a></div>
<br />juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-77672062585006836352016-10-04T02:27:00.000-07:002016-10-04T02:27:11.019-07:00Windows Image Acquisition DriversTällä hetkellä työtehtäväni on siirtää Visual Studio 2010 versiolla tehty järjestelmä VS2015 kehitysympäristöön. Päivitän juuri projektin viittauksia eri kirjastoihin. Otan uudemmat kirjastot käyttöön, jos mahdollista.<div>
<br /></div>
<div>
Yllätys oli, että tekniikkana Window ME:lle ja XP:lle kehitetty "Windows Image Acquisition Drivers" on edelleen käyttökelpoinen:</div>
<div>
<a href="https://msdn.microsoft.com/en-us/windows/hardware/drivers/image/windows-image-acquisition-drivers">https://msdn.microsoft.com/en-us/windows/hardware/drivers/image/windows-image-acquisition-drivers</a></div>
<div>
<br /></div>
<div>
<strong style="background-color: white; color: #29527c; font-family: "Trebuchet MS", Verdana, Arial; font-size: large;">Microsoft Windows Image Acquisition Library v2.0 </strong></div>
<div>
Tämä kirjastohan mahdollistaa esim. skannerin ohjauksen VB.net WinForms- sovelluksesta.</div>
juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-49733352196091139042016-10-03T00:28:00.005-07:002016-10-03T07:31:40.550-07:00Ohjelmoinnin verkkokurssi alakoulun opettajille<a href="https://www.campwire.com/buy/706c0c8c-a683-4fc0-b3fb-1034eac1fbe0" target="_blank">VERKKOKURSSILLE TÄSTÄ</a><br />
<br />
Dataseppä järjesti Raudaskylän Kristillisellä Opistolla alkusyksystä kurssin Ohjelmoinnin opetus alakoulussa. Koulutus oli työpaja- tyyppinen, jossa opettajat pääsivät kokeilemaan asioita.Tämä nyt järjestetty verkkokurssi perustuu samoihin sisältöihin, ja sisältää myös valmiin tuntisuunnitelman 10 oppitunnille:<br />
<br />
<ol>
<li><b>Motivointi ohjelmointiin:</b><br />Mitä ohjelmointi on?<br />Aloitus leikkien ja pelaten.<br />Tuntisuunnitelmat 1-5.</li>
<li><b>Ohjelmoinnin alkeet visuaalisesti:</b><br />Visuaalinen ohjelmointi.<br />Ohjelmoinnin perusrakenteet.<br />Tuntisuunnitelmat 6-8.</li>
<li><b>Ohjelmointi eri alustoilla:</b><br />Robotit<br />Internet.<br />Tuntisuunnitelmat 9-10.</li>
<li><b>Mitä OPS2016 sanoo ohjelmoinnista.</b></li>
<li><b>Mitä eri-ikäiset helposti omaksuvat ohjelmoinnista.</b></li>
</ol>
<div>
Verkkokurssin teoriaosuus on niin lyhyt, että opettaja voi opiskella sen omien opetustuntiensa valmistelun ohessa. Pääpainona kurssilla ovat valmiit tuntisuunnitelmat, jotka antavat mallin aloittaa ohjelmoinnin opetuksen alakoulussa. Kaikki kurssin mukana tulevat tuntitsuunnitelmat on käytännön luokkatilanteessa testattu 1-6 luokkaisillla.</div>
<div>
<br />
Verkkokurssin sisältö ei tee kenestäkään vielä koodaria, mutta jokainen saa hyvän käsityksen siitä, miten ohjelmoinnin opetus kannattaisi aloittaa!!</div>
<a href="https://www.campwire.com/buy/706c0c8c-a683-4fc0-b3fb-1034eac1fbe0" target="_blank"><br /></a>
<br />
<a href="https://www.campwire.com/buy/706c0c8c-a683-4fc0-b3fb-1034eac1fbe0" target="_blank">VERKKOKURSSILLE TÄSTÄ</a><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit6TD6l6FMXncyAy4a9SFeIfERfPYA9r-AE4v3e6CamK7czyyaec-a2uxai8WqGka7YfSbB8lXE5LcxLjaK1Dg9xvbJQvD4shRRoAYC5m9L52QGirXHen6KClq3pvoIH3Ys4YsMTsKvLXJ/s1600/IMGP8522.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="211" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit6TD6l6FMXncyAy4a9SFeIfERfPYA9r-AE4v3e6CamK7czyyaec-a2uxai8WqGka7YfSbB8lXE5LcxLjaK1Dg9xvbJQvD4shRRoAYC5m9L52QGirXHen6KClq3pvoIH3Ys4YsMTsKvLXJ/s320/IMGP8522.JPG" width="320" /></a></div>
<br />juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-70215313878369204782016-09-28T06:57:00.001-07:002016-09-28T06:57:14.975-07:00Datasepän koodikoulu nyt Facebookissa<a href="https://www.facebook.com/dataseppa/" target="_blank">Vinkkejä ohjelmoinnin ymmärtämiseen </a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhakroBMmqn8B0BEO1O43yVLY-q4V9edJMaxmhzaRvf-fAI-okyFHZsExxh0ScQ37mqDwAGC-81lr_pA5FqCVImQzZVA17zqAHQ3E22Zt0MtC-RBwKpLwNm_VKaunuFvKHXKOtUIliBVLZr/s1600/datasep%25C3%25A4n+koodikoulu.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="263" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhakroBMmqn8B0BEO1O43yVLY-q4V9edJMaxmhzaRvf-fAI-okyFHZsExxh0ScQ37mqDwAGC-81lr_pA5FqCVImQzZVA17zqAHQ3E22Zt0MtC-RBwKpLwNm_VKaunuFvKHXKOtUIliBVLZr/s400/datasep%25C3%25A4n+koodikoulu.JPG" width="400" /></a></div>
<div style="text-align: left;">
<br /></div>
<br />juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0tag:blogger.com,1999:blog-8536221549217753432.post-49184635423824418372016-09-28T05:22:00.002-07:002016-09-28T05:26:44.271-07:00Datasepän Netti-klinikalla aiheena netti-tv<b>Senioreiden Netti-klinikka 17.10. <a href="http://www.tuokiotupa.fi/" target="_blank">Tuokiotuvalla</a></b><br /><br />Meillä toimii Senioreiden Netti-klinikka Jaana Seppälän (Dataseppä tmi) johdolla. Klinikan aluksi on yhteinen osuus, lokakuussa pääsemme tutustumaan erilaisiin netti-tv palveluihin. Näissä palveluissa voit katsoa tv-ohjelmia tietokoneeltasi tai tabletiltasi. Palveluista löytyy myös ohjelmia, joita ei televisiossa näytetä. Yhteinen osio on ilmainen. Lisäksi Netti-klinikalle on mahdollista varata henkilökohtaista aikaa omien tarpeiden mukaan. Voit tulla esimerkiksi opettelemaan puhelimen tai tietokoneen käyttöä, kysyä päivityksistä tai muusta itselle haasteita tuottavasta asiasta. 30 minuutin henkilökohtainen opastus maksaa jäsenille 10€, muille 15€. Varaathan ajan etukäteen Tuokiotuvalta! <br />
<br />
<a href="https://drive.google.com/file/d/0B9NBzNK8wX3jS3NYb1V1QmI1OGs/view?usp=sharing" target="_blank">Tässä koko ohjelma!</a>juanahttp://www.blogger.com/profile/13268457310448806296noreply@blogger.com0