Network Programming in .NET

This is a handly little C# function to convert a DataTable to CSV. Hope it’s useful..

 

public string DataTableToCSV(DataTable dt)
 {
 string strCSV = "";
 string strSeperator = "";
 foreach(DataColumn dc in dt.Columns)
 {
  strCSV += strSeperator + dc.ColumnName;
  strSeperator = ",";
 }
 strCSV += "rn";
 foreach(DataRow dr in dt.Rows)
 {
  strSeperator = "";
  foreach(DataColumn dc in dt.Columns)
  {
   strCSV += strSeperator + dr[dc.ColumnName].ToString();
   strSeperator = ",";
  }
  strCSV += "rn";
 }
 return strCSV;
 }

I’ve had SQL server 2005 installed on my server for some time now, and sucessfully running a few websites from it. I’ve had to work from the command line up to now, since, I couldn’t get any good GUI working.

 

I tried to download SQL server 2005 Management studio express, for which I had to upgrade the .NET framework on the server, upgrade MSXML, and then install the application.

 

Try to connect and….

 

===================================

Cannot connect to .SQLEXPRESS.

===================================

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)

——————————
Error Number: -1
Severity: 20
State: 0

——————————
Program Location:

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

 

 

Crap.

 

Any ideas?

 

I was looking to localize a classic ASP website, and was considering upgrading it to ASP.NET, but it seemed way too much work, so I decided to look to see if it was possible to create a localization framework for classic ASP. using the same type of resx files that are used for asp.net

 

So, given a simple piece of xml in semi-typical resx format:

 

<root>
 <data name="Hello!">
  Ciao!
 </data>
</root>

 

I then wrote an include file in classic asp, to handle translations in the form

 

<%=Translate("Hello!")%>

 

(Precursed by a initResources("strings-it.xml"))

 

 

 Dim xmlResx

 Function initResources(ResourceFile)
  Set xmlResx=Server.CreateObject("Microsoft.XMLDOM")
  xmlResx.async=false
  xmlResx.load(Server.MapPath(ResourceFile))
 End Function
 
 Function Translate(english)
  Set objLst = xmlResx.getElementsByTagName("data")
  For i = 0 to (objLst.length -1)
    EnglishText = objLst.item(i).attributes.getNamedItem("name").text
 If english=EnglishText Then
  Translate= objLst.item(i).text
  Exit For
 End If
  Next
 End Function

 

20 Lines of code, prevented an overhaul of my application to .NET.

 

Ultimately, I plan this to be used for a spanish version of www.openmerchantaccount.com

 

 

 

 

When debugging an ASP.NET application, I suddenly got an "Object Not Set to a reference of an object" error on OnBubbleEvent, which leads into unmanaged code in the .NET framework.

 

Simple solution, CTRL-ALT-DELETE, hit asp_wp.exe, and kill the process.

 

It works fine afterwards.

 

I previously wrote an application which captures a webcam in VB.NET (http://www.webtropy.com/articles/art7.asp) However, this only shows a webcam, and has no facilities to record. Therefore, I added a new function to save bitmaps

 

Public Sub SaveBitmap(ByVal filename As String)

SendMessage(lwndC, WM_CAP_FILE_SAVEDIB, 0&, filename)

End Sub

 

Where WM_CAP_FILE_SAVEDIB is defined as WM_USER+25

– It also requires an overloaded SendMessage declaration, which accepts a string as it’s final parameter.

 

I then found some CS code which converts BMP files to AVI (http://midget3d.com/gabe/AviLib.zip)

 

then used this to write bitmaps to disk, and build them into an AVI

 

saveFileDialog.Filter="*.avi|*.avi";

saveFileDialog.ShowDialog();

string strAVI = saveFileDialog.FileName;

string strBMP = saveFileDialog.FileName.Replace(".avi",".bmp");

AviWriter aviWriter =

new AviWriter(strAVI, AviCompression.None, 24, 320, 240);

isRecording =

true;

while(isRecording)

{

webcamControl1.SaveBitmap(strBMP);

aviWriter.WriteFrame(

new Bitmap(strBMP));

Application.DoEvents();

}

aviWriter.Close();

 

 

 

I was looking for a way to compress an AVI file down without loosing quality, and to do so programatically, in C#. All I found on the web, were commercial components. However, I just found out you can use QuickTime in C#, to compress the files down in size.

 

This is a handly little C# function to convert a DataTable to a HashTable

(Give credit to this website if you use it!)

 

 

Probobly a particularly niche field, but I just developed some code to parse airline routes from the website VolaWindJet.

 

I’m working on a .NET wrapper for Sage Data Object (SDO).  This is my first (working) attempt at using the Sage code in .NET (C#) to import products.