C#

atanamir wrote:

However, after it parses the float value is 9.949999998... etc. Why does it do this, and not have it as 9.95?

gregoire.b wrote:

P.S.1. I rename the config file and put the name of myapp.config

<br />
SQLDMO.SQLServerClass sqlServer = new SQLServerClass();<br />
//login<br />
sqlServer.Connect("MYSERVER", "username", "password");<br />
<br />
// go through databases list<br />
foreach (SQLDMO.Database db in sqlServer.Databases)<br />
{<br />
	if (! db.SystemObject)<br />
	{<br />
		if(db.Name=="Northwind")<br />
		{<br />
			// Northwind found <br />
			// go through tables list<br />
			foreach( SQLDMO.Table table in db.Tables )<br />
			{<br />
				if(table.Name=="Customers")<br />
				{<br />
					// table "Customers" found<br />
					// go through columns list<br />
					foreach(SQLDMO.Column column in table.Columns )<br />
					{<br />
						// print out column name<br />
						Console.WriteLine( column.Name );<br />
						// print out column length<br />
						Console.WriteLine( column.Length );<br />
						// print out column datatype<br />
						Console.WriteLine( column.Datatype );<br />
					}<br />
				}<br />
<br />
			}<br />
		}<br />
	}<br />
}		<br />