Adding Mono

Tue, 10 Mar 2009 17:37:48 GMT

Description: This is not a snippet of code but a method in which you can add Mono to the VS enviroment. Mono and GTK# must both be installed on the system.

Link: http://www.codekeep.net/snippets/cd8aa3c4-49e2-489b-b9b0-499efa9c6190.aspx

There is no real secret to using Mono and Gtk# with Visual Studio. You don't need the Mono compiler and you don't need to set any configuration settings.

Look under your Mono install directory, probably something like C:\Program Files\Mono-1.9.1\ and look in the Global Assembly Cache, which in my install is located at

C:\Program Files\Mono-1.9.1\lib\mono\gac

Look for these assemblies at least:

atk-sharp
gdk-sharp
glib-sharp
gtk-sharp

If you like you can also add glade-sharp, pango-sharp, mono.addins, mono.cairo, and any others you might need.

*Copy and paste those into your project /bin directory
*In Visual Studio right-click your project and select Add Reference, then browse to your bin directory and include those libraries
*Then build and run your project using Visual Studio. It should run just fine.

When you distribute your app just include those .dll's in the same folder as your executable and everything should work. In Linux you will need to add the .config files (like gtk-sharp.dll.config) to the bin as well. You should be able to find those in the mono install directory under your /usr directory (I think, I'm not using Linux at the moment so I'm not positive)

At any rate, that should do it. Very easy. Just Copy/Reference/Build.

Note: I am quite certain this is not the proper way to handle this and I should reference my global cache and set the vs project settings to use the mono compiler and blah blah blah, but seeing as how there are no clear instructions on how to easily do this, I have come up with this way, which I find simple and working (well). Shipping these libraries also assures my program is using the right one, without having to worry about which version of Mono is actually installed.

Form Generator

Mon, 26 Nov 2007 00:25:20 GMT

Description: This generates a form from a table

Link: http://www.codekeep.net/snippets/a684a468-8971-4f89-b3d5-59dad6bfa9f9.aspx

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a form based on a table." %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the object is based on." %>

<%@ Assembly Name="SchemaExplorer" %>
<%@ Assembly Name="System.Data" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Data" %>
<% 

ColumnSchema thisColumn;
string colName="";
string colType="";
bool IsNullable=false;
%>
	
<div id="divAdd" class="inputForm">
<%
	for (int i = 0; i < SourceTable.NonPrimaryKeyColumns.Count; i++) { 
		thisColumn=SourceTable.NonPrimaryKeyColumns[i];
		colName=GetPropertyName(SourceTable.NonPrimaryKeyColumns[i]).Replace(" ","");
		colType=GetCSharpVariableType(thisColumn);
		IsNullable=thisColumn.AllowDBNull;
		%>
		<div class="formRow">
		<asp:label AssociatedControlID="_<%=colName%>" runat="server"><%=colName%></asp:label>
		<br />
		<%
		if(colType=="DateTime"){
		%>
			<SubSonic:CalendarControl id="_<%=colName%>" runat="server">
			</SubSonic:CalendarControl>
	
		<%}else if(colType=="string"){%>
	
		<asp:textbox id="_<%=colName%>" runat="server"
				<%if(UseMultiLine(thisColumn)){%>
				TextMode="MultiLine" Height="100px" Width="400px"
				<%}%>
				></asp:textbox>
				<%if(!IsNullable){%>
				<span class="required">*</span>
				<asp:RequiredFieldValidator id="valTxt<%=colName%>" runat="server" Display="Dynamic" 
				ControlToValidate="_<%=colName%>"
					ErrorMessage="Required"></asp:RequiredFieldValidator>
				<%}%>
	
		<%}else if(IsNumberField(thisColumn) && colName.ToLower().IndexOf("id")>0){%>
		
			<SubSonic:DropDown id="_<%=colName%>" runat="server" TableName="<%= colName.Replace("Id","")%>">
			</SubSonic:DropDown>
	
		<%}else if(IsNumberField(thisColumn)){%>
				<asp:textbox id="_<%=colName%>" runat="server"
				></asp:textbox>
			<%if(!IsNullable){%>
			<span class="required">*</span>
			<asp:RequiredFieldValidator id="valTxt<%=colName%>" runat="server" Display="Dynamic" 
			ControlToValidate="_<%=colName%>"
				ErrorMessage="Required"></asp:RequiredFieldValidator>
			<%}%>
			<asp:RangeValidator id="valNum<%=colName%>" runat="server" Display="Dynamic" ControlToValidate="_<%=colName%>"
			ErrorMessage="Invalid Number" MaximumValue="99999999" MinimumValue="0" Type="Integer"></asp:RangeValidator>
		<%}else if(colType=="bool"){%>
			<asp:CheckBox id=_<%=colName%> runat=server />
			
		<%}%>
		</div>
	<% } %>

	<div>
		<asp:Button ID="btnAdd" Runat="server" Text="Add"></asp:Button>
	</div>
</div>

		
	

		
		
		
		
		
		
		
<script runat="template">
public bool UseMultiLine(ColumnSchema column){
	bool bOut=false;
	if(column.Size>200)
		bOut=true;
	return bOut;

}
public bool IsNumberField(ColumnSchema column){
	bool bOut=false;
	string vType=GetCSharpVariableType(column);
	if(vType=="decimal" || vType=="double" || vType=="short" || vType=="int" || vType=="long" || vType=="float" || vType=="ushort" || vType=="uint" || vType=="ulong"){
		bOut=true;
	}
	return bOut;
}
public string GetProperName(string sIn)
{
	string propertyName =sIn;
	string leftOne=propertyName.Substring(0,1).ToUpper();
	propertyName=propertyName.Substring(1,propertyName.Length-1);
	propertyName=leftOne+propertyName;
		
	return propertyName;
}

public string GetPropertyName(ColumnSchema column)
{
	string propertyName = column.Name;
	string leftOne=propertyName.Substring(0,1).ToUpper();
	propertyName=propertyName.Substring(1,propertyName.Length-1);
	propertyName=leftOne+propertyName;
	
	propertyName=propertyName.Replace(" ","");
	
	return propertyName;
}
		
public string GetCSharpVariableType(ColumnSchema column)
{
	if (column.Name.EndsWith("TypeCode")) return column.Name;
	
	switch (column.DataType)
	{
		case DbType.AnsiString: return "string";
		case DbType.AnsiStringFixedLength: return "string";
		case DbType.Binary: return "byte[]";
		case DbType.Boolean: return "bool";
		case DbType.Byte: return "byte";
		case DbType.Currency: return "decimal";
		case DbType.Date: return "DateTime";
		case DbType.DateTime: return "DateTime";
		case DbType.Decimal: return "decimal";
		case DbType.Double: return "double";
		case DbType.Guid: return "Guid";
		case DbType.Int16: return "short";
		case DbType.Int32: return "int";
		case DbType.Int64: return "long";
		case DbType.Object: return "object";
		case DbType.SByte: return "sbyte";
		case DbType.Single: return "float";
		case DbType.String: return "string";
		case DbType.StringFixedLength: return "string";
		case DbType.Time: return "TimeSpan";
		case DbType.UInt16: return "ushort";
		case DbType.UInt32: return "uint";
		case DbType.UInt64: return "ulong";
		case DbType.VarNumeric: return "decimal";
		default:
		{
			return "__UNKNOWN__" + column.NativeType;
		}
	}
}


public string GetSqlDbType(ColumnSchema column)
{
	switch (column.NativeType)
	{
		case "bigint": return "BigInt";
		case "binary": return "Binary";
		case "bit": return "Bit";
		case "char": return "Char";
		case "datetime": return "DateTime";
		case "decimal": return "Decimal";
		case "float": return "Float";
		case "image": return "Image";
		case "int": return "Int";
		case "money": return "Money";
		case "nchar": return "NChar";
		case "ntext": return "NText";
		case "numeric": return "Decimal";
		case "nvarchar": return "NVarChar";
		case "real": return "Real";
		case "smalldatetime": return "SmallDateTime";
		case "smallint": return "SmallInt";
		case "smallmoney": return "SmallMoney";
		case "sql_variant": return "Variant";
		case "sysname": return "NChar";
		case "text": return "Text";
		case "timestamp": return "Timestamp";
		case "tinyint": return "TinyInt";
		case "uniqueidentifier": return "UniqueIdentifier";
		case "varbinary": return "VarBinary";
		case "varchar": return "VarChar";
		default: return "__UNKNOWN__" + column.NativeType;
	}
}

public string GetPrimaryKeyType(TableSchema table)
{
	if (table.PrimaryKey != null)
	{
		if (table.PrimaryKey.MemberColumns.Count == 1)
		{
			return GetCSharpVariableType(table.PrimaryKey.MemberColumns[0]);
		}
		else
		{
			throw new ApplicationException("This template will not work on primary keys with more than one member column.");
		}
	}
	else
	{
		throw new ApplicationException("This template will only work on tables with a primary key.");
	}
}

</script>

CodeKeep CodeSmith Feed

Adding Mono

Form Generator