Save SQL Script into Resources

[Shai Goldberg]

Hi,

Is there a way to store an SQL script into a resource
file, the script contains a lot of lines, and then to
read it during run-time into a string?

Thanks,

[Cor]

Hi Shai

Is there a way to store an SQL script into a resource
file, the script contains a lot of lines, and then to
read it during run-time into a string?

Why not,

Or do you mean what is the best way, I think there is no best way, that
depends in what kind of environment you want to use it.

If you tell that a little more, than maybe we can help you?

Cor

[Armin Zingler]

"Shai Goldberg" <gs***@shamir.c o.il> schrieb

Is there a way to store an SQL script into a resource
file, the script contains a lot of lines, and then to
read it during run-time into a string?

http://msdn.microsoft.com/library/en...gResources.asp
http://msdn.microsoft.com/library/en...gresources.asp
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Herfried K. Wagner [MVP]]

* "Shai Goldberg" <gs***@shamir.c o.il> scripsit:

Is there a way to store an SQL script into a resource
file, the script contains a lot of lines, and then to
read it during run-time into a string?

Add the file to the project, set its 'Build Action' to 'Embedded
Resource', then:

\\\
Imports System.IO
..
..
..
Dim f As Stream =
System.Reflecti on.Assembly.Get EntryAssembly() .GetManifestRes ourceStream( _
"<Name of the root namespace>.test .txt" _
)
Dim st As New StreamReader(f) , s As String
s = st.ReadToEnd()
MsgBox(s)
///

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Shai Goldberg]

Hi,

I need to add a text file into a source file and to be
able to read it during run time using VB.NET

I want to know if there is a way to do so using the
VS.NET IDE and VB.NET that is to insert into a source
file a bunch of text lines that I can read into a string
during run time.

Thanks,

-----Original Message-----
Hi Shai

Is there a way to store an SQL script into a resource
file, the script contains a lot of lines, and then to
read it during run-time into a string?
Why not,

Or do you mean what is the best way, I think there is no

best way, thatdepends in what kind of environment you want to use it.

If you tell that a little more, than maybe we can help you?
Cor
.

[Shai Goldberg]

Thanks for the answer but it didn't help me, maybe I just
didn't understand, but I need to load a lot of lines and
not only one single line.

Regards,

-----Original Message-----
"Shai Goldberg" <gs***@shamir.c o.il> schrieb

Is there a way to store an SQL script into a resource
file, the script contains a lot of lines, and then to
read it during run-time into a string?

http://msdn.microsoft.com/library/en-

us/vbcon/html/vboriUsingResou rces.asphttp://msdn.microsoft.com/library/en- us/cpguide/html/cpconcreatingus ingresources.as p

--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

.

[Cor]

Hi Shai,

I saw you did get some answers in this thread if that does not fit, message
again OK?

Cor

I need to add a text file into a source file and to be
able to read it during run time using VB.NET

I want to know if there is a way to do so using the
VS.NET IDE and VB.NET that is to insert into a source
file a bunch of text lines that I can read into a string
during run time.

[Thomas A]

"Shai Goldberg" <gs***@shamir.c o.il> wrote in news:057201c3cd 49$29ca5b20
$a*******@phx.g bl:

Hi,

Is there a way to store an SQL script into a resource
file, the script contains a lot of lines, and then to
read it during run-time into a string?

Thanks,

Hi,

You can use streamreader function to read the sql text, and after that can
you make a split on 'GO'. after that can you execute the the different
parts in the script. (you can not execute the hole script including GO,
because it isnt allowed)

Thomas

[Cor]

Hi Shai,

I saw you other message, the most easiest way is to make a dataset,

I made some examples below. I did not make in the IDE so it is probably with
errors.

I think this wil fits your problem?

Cor

\\\\
dim ds as new dataset
if file.exist ("c:\test1\test xml.xml") then
ds.ReadXml("c:\ testxml.xml", XmlReadMode.Rea dSchema)
Dim dr As DataRow = ds.Tables(0).Ro ws.Find("mynumb er")
if not dr Is Nothing Then
mySQLstring = dr.item("mySqlS tring").tostrin g
else
'errormessage
Else
'errormessage
End If
////
\\\\
To create this dataset is.
dim ds as new dataset
Dim dt As New DataTable("SqlS trings")
dt.Columns.Add( New DataColumn("myS qlStringnumber" ,
Type.GetType("S ystem.Int32")))
dt.Columns.Add( New DataColumn("myS qlString", Type.GetType("S ystem.String")) )
Dim keys(0) As DataColumn
keys(0) = dt.Columns("myS qlStringnumber" )
dt.PrimaryKey = keys
ds.Tables.Add(d t)
ds.WriteXml("c: \testxml.xml", XmlWriteMode.Wr iteSchema)
///
\\\
To add the rows you can use the normal dataset instructions for that
////

[Armin Zingler]

"Shai Goldberg" <gs***@shamir.c o.il> schrieb

Thanks for the answer but it didn't help me, maybe I just
didn't understand, but I need to load a lot of lines and
not only one single line.

Resources are not limited to a single line.
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html