C#

ArrayList funcs = new ArrayList();
foreach( SQLDMO.Database2 db2 in srv.Databases )
{
	foreach( SQLDMO.UserDefinedFunction func in db2.UserDefinedFunctions )
	{
		funcs.Add( func.Name );
	}
}

public static string GetScript(string hostName, string dbName, string username, string password, string prefix )
{
// Instantiate the Sql Server Object
SQLDMO.SQLServer srv = new SQLDMO.SQLServer();

// If there is no username provided, we assume that we're going to use
// a trusted connection
if( username.Length <= 0 )
{
	srv.LoginSecure = true;
	srv.Connect( hostName, "", "" );
}
// Otherwise we log in with the specified credentials
else
	srv.Connect(hostName, username, password );

// We have to set some scripting parameters before we start
SQLDMO.SQLDMO_SCRIPT_TYPE param = SQLDMO_SCRIPT_TYPE.SQLDMOScript_Default |
	// Script out indexes
	SQLDMO.SQLDMO_SCRIPT_TYPE.SQLDMOScript_Indexes |
	// Script out drop statements
    SQLDMO_SCRIPT_TYPE.SQLDMOScript_Drops |
	// Prefix the object name with the database owner
	SQLDMO_SCRIPT_TYPE.SQLDMOScript_OwnerQualify;

string script = "";
foreach(SQLDMO.Database db in srv.Databases)
{
	// Have to iterate through the list of databases to find the one that was specified
	if(db.Name!=null && db.Name.ToLower().Equals(dbName.ToLower()) )
	{
		// First search through all of the tables and locate the ones
		// with the prefix provided
		foreach( SQLDMO.Table table in db.Tables )
		{
			if( table.Name.ToLower().StartsWith( prefix.ToLower() ) )
			{
				// Append the script for the current table
				script += table.Script( param, null, null, SQLDMO.SQLDMO_SCRIPT2_TYPE.SQLDMOScript2_Default );
			}
		}
		// Next search through all of the stored procedures and locate the ones
		// with the prefix provided
		foreach( SQLDMO.StoredProcedure proc in db.StoredProcedures )
		{
			if( proc.Name.ToLower().StartsWith( prefix.ToLower() ) )
			{
				// Append the script for the current stored procedure
				script += proc.Script( param, null, SQLDMO.SQLDMO_SCRIPT2_TYPE.SQLDMOScript2_Default );
			}
		}
		break;
	}
}
return script;

}

string strSQL = "INSERT INTO Users (UserName,Name,UserPassword,Email,RoleID) VALUES (?, ?, ?, ?, ?)";