Get Data

[shapper]

Hello,

I have an SQL database table with 20 fields: Field_01, Field_02, etc.
I am creating a string with StringBuilder.
I want to include in my string the fields of one record of the
database.
The SQL procedure "GetOneReco rd" gets one record when its ID is givem.

So my problem is how to access each record field and use it in my
string.
For example:

MyStringBuilder .Append("<title >")
MyStringBuilder .Append(Field_0 1) <<<< Field_01 of selected
record.
MyStringBuilder .Append("</title>")

Here is my code:

' Define connection
Dim connection As New
SqlClient.SqlCo nnection(connec tionString.ToSt ring)

' Define command
Dim command As New SqlClient.SqlCo mmand
With command
.CommandText = "GetOneReco rd"
.Connection = connection
.CommandType = CommandType.Sto redProcedure
End With

' Add command parameters
With command.Paramet ers
.Add(New SqlClient.SqlPa rameter("@Id", Id))
End With

connection.Open ()

>>>>Here I need to execute the command and use all Field_##

values in my String Builder.

connection.Clos e()

How can I do this?

Thanks,
Miguel

[Mark Rae]

"shapper" <md*****@gmail. comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .

I have an SQL database table with 20 fields: Field_01, Field_02, etc.

You can't be serious...! You call your fields Field_01, Field_02 etc...???

Surely not!!!

[shapper]

Of course not ... that was just an example.

Thatwas not even the point of my question!

Cheers,
Miguel

Mark Rae wrote:

"shapper" <md*****@gmail. comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .

I have an SQL database table with 20 fields: Field_01, Field_02, etc.

You can't be serious...! You call your fields Field_01, Field_02 etc...???

Surely not!!!

[Milosz Skalecki]

Howdy shapper,

You're asking about basics

1. use data reader

dim reader as SqlDataReader
Dim field01Value As String
Dim field02Value As Integer

Try
connection.Open ()
reader = command.Execute Reader()

If reader.Read() Then

field01Value = CType(reader("f ield01"), String)
field02Value = CType(reader("f ield02"), Integer)
' etc.

End If

Catch ex As Exception
Throw
Finally
If Not reader Is Nothing Then
reader.Close()
End If
connection.Clos e()
End Try
reader.Close()

2. Use datatable

connection.Open ()
adapter.Fill(ta ble)
Catch ex As Exception
Throw
Finally
connection.Clos e()
End Try

If table.Rows.Coun t 0 Then
Dim row As DataRow = table.Rows(0)
myStringBuilder .Append(row("Fi eld01"))
' etc
End If

3. i see you're trying to build xml using values from MSSQL database - you
may use FOR XML statement i.e.:

select Field01 as Title, Field02 as FirstName from TableName WHERE RecordId
= 2
for xml auto, ELEMENTS

hope this helps
--
Milosz Skalecki
MCP, MCAD
"shapper" wrote:

Hello,

I have an SQL database table with 20 fields: Field_01, Field_02, etc.
I am creating a string with StringBuilder.
I want to include in my string the fields of one record of the
database.
The SQL procedure "GetOneReco rd" gets one record when its ID is givem.

So my problem is how to access each record field and use it in my
string.
For example:

MyStringBuilder .Append("<title >")
MyStringBuilder .Append(Field_0 1) <<<< Field_01 of selected
record.
MyStringBuilder .Append("</title>")

Here is my code:

' Define connection
Dim connection As New
SqlClient.SqlCo nnection(connec tionString.ToSt ring)

' Define command
Dim command As New SqlClient.SqlCo mmand
With command
.CommandText = "GetOneReco rd"
.Connection = connection
.CommandType = CommandType.Sto redProcedure
End With

' Add command parameters
With command.Paramet ers
.Add(New SqlClient.SqlPa rameter("@Id", Id))
End With

connection.Open ()

>>>>Here I need to execute the command and use all Field_##

values in my String Builder.

connection.Clos e()

How can I do this?

Thanks,
Miguel

[sloan]

Shapper,

MyStringBuilder .Append("<title >")
MyStringBuilder .Append(Field_0 1) <<<< Field_01 of selected
record.
MyStringBuilder .Append("</title>")

Not to be rude, but string manipulation is the absolute WORST way to build
up xml or html.
This is very "asp-ish" and very hacky.
One way, among several different legimate methods for creating xml is
http://msdn2.microsoft.com/en-us/lib...r_methods.aspx
XmlWriter.

Or, as someone says, you can get Xml out of the database (Sql Server and
Oracle) by using their languages.

...

If you're doing HTML, then you'll use
DataGrid, Repeater, DataList in 1.1
GridView, Repeater in 2.0.
response.write "<table><tr><td >" is NOT the way to go.


"shapper" <md*****@gmail. comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .

Hello,

I have an SQL database table with 20 fields: Field_01, Field_02, etc.
I am creating a string with StringBuilder.
I want to include in my string the fields of one record of the
database.
The SQL procedure "GetOneReco rd" gets one record when its ID is givem.

So my problem is how to access each record field and use it in my
string.
For example:

MyStringBuilder .Append("<title >")
MyStringBuilder .Append(Field_0 1) <<<< Field_01 of selected
record.
MyStringBuilder .Append("</title>")

Here is my code:

' Define connection
Dim connection As New
SqlClient.SqlCo nnection(connec tionString.ToSt ring)

' Define command
Dim command As New SqlClient.SqlCo mmand
With command
.CommandText = "GetOneReco rd"
.Connection = connection
.CommandType = CommandType.Sto redProcedure
End With

' Add command parameters
With command.Paramet ers
.Add(New SqlClient.SqlPa rameter("@Id", Id))
End With

connection.Open ()

>>>>Here I need to execute the command and use all Field_##

values in my String Builder.

connection.Clos e()

How can I do this?

Thanks,
Miguel