Visual WebGui Wiki - Recent changes [en]

Visual WebGui Wiki - Recent changes [en] http://wiki.visualwebgui.com/pages/index.php/Special:RecentChanges Track the most recent changes to the wiki in this feed. en MediaWiki 1.15.0 Thu, 17 May 2012 00:45:44 GMT Serialization - Setting up an SQL state database on SQLServer Express http://wiki.visualwebgui.com/pages/index.php?title=Serialization_-_Setting_up_an_SQL_state_database_on_SQLServer_Express&diff=4204&oldid=prev <p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 00:26, 16 May 2012</td> </tr> <tr><td colspan='4' align='center' class='diff-multi'>(One intermediate revision not shown)</td></tr><tr><td colspan="2" class="diff-lineno">Line 29:</td> <td colspan="2" class="diff-lineno">Line 29:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Create a SQL database<br>  ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Create a SQL database<br>  ==</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>[[Image:Serialization - Setting up an SQL - Create Database.png|thumb|right]]Using the Management Studio, create a new SQL database. The default database name for a stateserver in ASP.NET (and hence Visual WebGui) application is ASPState, but to break the defaults and show you how you set all the properties, we will name our database <del class="diffchange diffchange-inline">ASPSateDB</del>. <br>  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>[[Image:Serialization - Setting up an SQL - Create Database.png|thumb|right]]Using the Management Studio, create a new SQL database. The default database name for a stateserver in ASP.NET (and hence Visual WebGui) application is ASPState, but to break the defaults and show you how you set all the properties, we will name our database <ins class="diffchange diffchange-inline">ASPStateDB</ins>. <br>  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>When you create the database, the most easy way to grant enough security to the ASPStateUser, would be to designate that user as the database owner. Again, we will not do that, and we specifically grant the necessary rights later.  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>When you create the database, the most easy way to grant enough security to the ASPStateUser, would be to designate that user as the database owner. Again, we will not do that, and we specifically grant the necessary rights later.  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>For now, simply create the ASPStateDB, and leave the database owner at default.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>For now, simply create the ASPStateDB, and leave the database owner at default.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Adjust user settings  ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Adjust user settings  ==</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 70:</td> <td colspan="2" class="diff-lineno">Line 70:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>     mode="SQLServer"  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>     mode="SQLServer"  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>     allowCustomSqlDatabase ="true"  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>     allowCustomSqlDatabase ="true"  </div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>     sqlConnectionString="Data Source=.\SQLEXPRESS;Initial Catalog=ASPstateDB;User Id=ASPStateUser;Password=<del class="diffchange diffchange-inline">ASPSatePW</del>;"  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>     sqlConnectionString="Data Source=.\SQLEXPRESS;Initial Catalog=ASPstateDB;User Id=ASPStateUser;Password=<ins class="diffchange diffchange-inline">ASPStatePW</ins>;"  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>     stateNetworkTimeout="15" /></source>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>     stateNetworkTimeout="15" /></source>  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>  </table> Wed, 16 May 2012 00:26:38 GMT Palli http://wiki.visualwebgui.com/pages/index.php/Talk:Serialization_-_Setting_up_an_SQL_state_database_on_SQLServer_Express Programming tips and tricks http://wiki.visualwebgui.com/pages/index.php?title=Programming_tips_and_tricks&diff=4202&oldid=prev <p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 23:49, 14 May 2012</td> </tr> <tr><td colspan="2" class="diff-lineno">Line 35:</td> <td colspan="2" class="diff-lineno">Line 35:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>=== Conversion between C# and VB.NET  ===</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>=== Conversion between C# and VB.NET  ===</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">*[http://www.icsharpcode.net/OpenSource/SD/Download/ SharpDevelop IDE]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*[http://www.developerfusion.com/tools/convert/csharp-to-vb/ Free webpage to convert small code blocks]  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*[http://www.developerfusion.com/tools/convert/csharp-to-vb/ Free webpage to convert small code blocks]  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*[http://www.carlosag.net/Tools/CodeTranslator/ Another free webpage to convert small code blocks]  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*[http://www.carlosag.net/Tools/CodeTranslator/ Another free webpage to convert small code blocks]  </div></td></tr>  </table> Mon, 14 May 2012 23:49:52 GMT Palli http://wiki.visualwebgui.com/pages/index.php/Talk:Programming_tips_and_tricks