Reading Embedded Resources

[thomson]

Hi all,
I have added a new Item in my Solution Test.sql which has got
some sql scripts and i have changed the Build Action Property of the
file to embedded Resources
private string GetSql(string Name)

{

// Gets the current assembly.

Assembly Asm = Assembly.GetExe cutingAssembly( );

// Resources are named using a fully qualified name.

Stream strm =
Asm.GetManifest ResourceStream( Asm.GetName().N ame + "." + Name);

// Reads the contents of the embedded file.

StreamReader reader = new StreamReader(st rm);

return reader.ReadToEn d();

}
}

i wrote this function to read the Embedded Resource when it executes
the Stream Reader it gives an Error
System.IO.__Unm anagedMemoryStr eam

Can any one let me know where i went wrong

Thanks in Advance

thomson

[Karl Seguin]

A quick guess. You are using Asm.GetName().N ame this returns the name of
the assembly, not necessary what you want. What you want is the
Namespace.FileN ame of your resource. Namespace will be the default
namespace you assigned your assembly. Also, make sure that Name specifies
an extension. You should also look at closing your reader.

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
http://openmymind.net/redirector.aspx?documentId=51 - Learn about AJAX!

"thomson" <sa**********@y ahoo.com> wrote in message
news:11******** *************@g 44g2000cwa.goog legroups.com...

Hi all,
I have added a new Item in my Solution Test.sql which has got
some sql scripts and i have changed the Build Action Property of the
file to embedded Resources
private string GetSql(string Name)

{

// Gets the current assembly.

Asm = Assembly.GetExe cutingAssembly( );

// Resources are named using a fully qualified name.

Stream strm =
Asm.GetManifest ResourceStream( Asm.GetName().N ame + "." + Name);

// Reads the contents of the embedded file.

StreamReader reader = new StreamReader(st rm);

return reader.ReadToEn d();

}
}

i wrote this function to read the Embedded Resource when it executes
the Stream Reader it gives an Error
System.IO.__Unm anagedMemoryStr eam

Can any one let me know where i went wrong

Thanks in Advance

thomson