Red Milonga

Batch Commands to Disable Special Shared Resources

2008-04-19T00:07:00.004+03:00

By default all your folders are accessible from other computers in your network. If you want to simply disable this feature, you can execute the batch commands below. After the "Server" windows service is restarted these folders are shared again.

net share "C$" /delete
net share "ADMIN$" /delete

Cannot Generate SSPI Context Error

2008-04-08T12:24:00.004+03:00

If you are getting "Cannot generate SSPI context." error while trying to connect to an SQL server in your local area network, you should check your dns settings first. You can set or reset your dns settings using the batch commands in the following link:

http://redmilonga.blogspot.com/2008/03/batch-file-to-change-dns-servers.html

Hosting Multiple Web Sites On a Single Server

2008-04-04T19:53:00.002+03:00

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/596b9108-b1a7-494d-885d-f8941b07554c.mspx

Essential Programs

2008-03-26T20:15:00.009+02:00

Programming:

Tortoise SVN
Nunit
Reflector
Test Driven

Archive Management:

7zip
Daemon Tools

Web Browsers:

Firefox
Explorer

Gaming:

Steam
Hamachi
Hlsw
Teamspeak

Antivirus:

Spybot
Avast

Desktop Management:
Launchy

Password Management:

Keepass

Packages:

Google Pack
Windows Live

File System:

Unlocker

Video:

Vlc Player
Xvid

Word processor:

Notepad++
Adobe Reader

Download:

uTorrent
Orbit

Other:
Silverlight
Flash
Java

Declaring Cursors

2008-03-26T17:59:00.000+02:00

DECLARE @UserID int
DECLARE test_cursor CURSOR FOR

SELECT UserID FROM Users

OPEN test_cursor
FETCH NEXT FROM test_cursor INTO @UserID
WHILE @@FETCH_STATUS = 0
BEGIN

INSERT INTO Emails (UserID,Email) VALUES (@UserID, 'test@test.com')

FETCH NEXT FROM test_cursor INTO @UserID
END
CLOSE test_cursor
DEALLOCATE test_cursor

Batch Commands to Change Dns Servers Authomatically

2008-03-23T12:34:00.002+02:00

Setting primary and secondary dns addresses:

netsh interface ip set dns "Local Area Connection" static 208.67.222.222 primary

netsh interface ip add dns name="Local Area Connection" addr=208.67.220.220 index=2

Removing dns settings:

netsh interface ip delete dns "Local Area Connection" all

Configuring Http Access to Analysis Services

2008-03-21T14:41:00.001+02:00

http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

LLBLGen Code Snippets

2008-03-21T14:13:00.004+02:00

Deleting multiple rows:

UsersCollection c = new UsersCollection();
SD.LLBLGen.Pro.ORMSupportClasses.IPredicate p;
p = UsersFields.Usernumber == 1234;
c.DeleteMulti(p);

Executing stored procedures:

usersGrid.DataSource = RetrievalProcedures.SelUsers();
usersGrid.DataBind();

Using IDataReader:

TypedListDAO dao = new TypedListDAO();
IDataReader reader = dao.GetAsDataReader(null, RetrievalProcedures.GetSelUsersCallAsQuery(UserID), CommandBehavior.CloseConnection);
while (reader.Read())
{
String s = reader.GetValue(0);
}
reader.Close();

Deleting rows:

UsersEntity e = new UsersEntity(UserID);
e.Delete();

Inserting rows:

UsersEntity e = new UsersEntity();
e.Username = "milonguero";
e.UserNumber = 1234;
e.Save();

Transforming Dataset to Html with Xslt

2008-03-20T10:52:00.002+02:00

public static String Transform(DataSet ds)
{
String xml = ds.GetXml();

String xsl =
"<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?><xsl:stylesheet version=\"1.0\"
xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\"><xsl:template match=\"/\"><
html><body><table><tr><xsl:for-each select=\"NewDataSet/Table[1]/*\"
><td><xsl:value-of select=\"local-name()\"/></td></xsl:for-each>
</tr><xsl:for-each select=\"NewDataSet/Table\"><tr><xsl:for-each
select=\"./*\"><td><xsl:value-of select=\".\" /></td></xsl:for-each
></tr></xsl:for-each></table></body></html></xsl:template
></xsl:stylesheet>";

System.IO.StringWriter writer = new System.IO.StringWriter();
System.Xml.Xsl.XslCompiledTransform t = new System.Xml.Xsl.XslCompiledTransform();
XmlReaderSettings settings = new XmlReaderSettings();
XmlReader xmlReader = XmlReader.Create(new System.IO.StringReader(xml));
XmlReader xslReader = XmlReader.Create(new System.IO.StringReader(xsl));
t.Load(xslReader);
t.Transform(xmlReader, null, writer);
return writer.ToString();
}

Xslt to Convert Datasets With Dynamic Columns to Html

2008-03-19T23:47:00.002+02:00

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<body>
<table>
<tr>
<xsl:for-each select="NewDataSet/Table[1]/*">
<td>
<xsl:value-of select="local-name()"/>
</td>
</xsl:for-each>
</tr>
<xsl:for-each select="NewDataSet/Table">
<tr>
<xsl:for-each select="./*">
<td>
<xsl:value-of select="." />
</td>
</xsl:for-each>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

ASP.NET 2.0 IIS Registration (64 Bit)

2008-03-05T17:28:00.007+02:00

Console commands:

cd C:\Windows\Microsoft.NET\Framework64\v2.0.50727

aspnet_regiis -ua

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0

aspnet_regiis -i

iisreset

IIS settings:

Allow ASP.NET v2.0.50727 web service extension.

More information:

http://msdn2.microsoft.com/en-us/library/k6h9cz8h.aspx

Css Layout Example

2008-03-04T22:58:00.006+02:00

Html code:

<body>
<form id="form1" runat="server">

<div id="mainHeader">
</div>

<div id="mainContent">
</div>
</form>
</body>

Style sheet:

#mainHeader
{
background-color: #404040;
border-top: 4px solid #EB4C07;
position: relative;
margin: 0px auto;
height: 65px;
width: 100%;
min-width: 950px;
}

#mainContent
{
position: relative;
margin: 0 auto;
max-width: 950px;
min-width: 950px;
background-color: #FFFFFF;
border: solid 1px #99CCFF;
height: 900px;
}

body
{
background-color: #E8EEFA;
margin: 0px;
}