literal Databinding???

[Tim::..]

Can someone explain how I create a databinding to a Literal control! I tried doing it as shown below but the reader won't read into the control.

Thanks
...::CODE::..
Dim Myconn As New SqlConnection(ConfigurationSettings.AppSettings("s trConn"))
Dim cmd As New SqlCommand("PageDetails", Myconn)
cmd.CommandType = CommandType.StoredProcedure

Myconn.Open()

Dim objOfficeName, objID As SqlParameter
objOfficeName = cmd.Parameters.Add("@OfficeName", SqlDbType.Char)
objOfficeName.Direction = ParameterDirection.Input
objOfficeName.Value = "ISC"
Dim myReader As SqlDataReader = cmd.ExecuteReader()
importTxt = myReader
importTxt.DataBind()

myReader.Close()

Myconn.Close()

[Teemu Keiski]

Hi,

it's not databindable that way straight. Instead, you'd set its Text
property to the text you wish Literal to display.
--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
http://blogs.aspadvice.com/joteke


"Tim::.." <myatix_at_hotmail.com> wrote in message
news:1C**********************************@microsof t.com...

Can someone explain how I create a databinding to a Literal control! I tried doing it as shown below but the reader won't read into the control.
Thanks
..::CODE::..
Dim Myconn As New SqlConnection(ConfigurationSettings.AppSettings("s trConn")) Dim cmd As New SqlCommand("PageDetails", Myconn)
cmd.CommandType = CommandType.StoredProcedure

Myconn.Open()

Dim objOfficeName, objID As SqlParameter
objOfficeName = cmd.Parameters.Add("@OfficeName", SqlDbType.Char)
objOfficeName.Direction = ParameterDirection.Input
objOfficeName.Value = "ISC"
Dim myReader As SqlDataReader = cmd.ExecuteReader()
importTxt = myReader
importTxt.DataBind()

myReader.Close()

Myconn.Close()

[Teemu Keiski]

What are you trying to do with this line?

If objImpCnt Is "" Then
--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
http://blogs.aspadvice.com/joteke

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:C2**********************************@microsof t.com...

OK! I tried to do what you suggested Teemu but it just doesn't return anything! I don't even get an error! Any ideas???
Thanks

...
Dim myReader As SqlDataReader = cmd.ExecuteReader()
While myReader.Read()
If objImpCnt Is "" Then
importCnt.Visible = True
importCnt.Text = myReader("Content")
End If
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
Myconn.Close()
...

"Teemu Keiski" wrote:

Hi,

it's not databindable that way straight. Instead, you'd set its Text
property to the text you wish Literal to display.
--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
http://blogs.aspadvice.com/joteke


"Tim::.." <myatix_at_hotmail.com> wrote in message
news:1C**********************************@microsof t.com...

Can someone explain how I create a databinding to a Literal control! I

tried doing it as shown below but the reader won't read into the control.

Thanks
..::CODE::..
Dim Myconn As New

SqlConnection(ConfigurationSettings.AppSettings("s trConn"))

Dim cmd As New SqlCommand("PageDetails", Myconn)
cmd.CommandType = CommandType.StoredProcedure

Myconn.Open()

Dim objOfficeName, objID As SqlParameter
objOfficeName = cmd.Parameters.Add("@OfficeName", SqlDbType.Char)

objOfficeName.Direction = ParameterDirection.Input
objOfficeName.Value = "ISC"
Dim myReader As SqlDataReader = cmd.ExecuteReader()
importTxt = myReader
importTxt.DataBind()

myReader.Close()

Myconn.Close()