G
Guest
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("strConn"))
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()
Thanks
...::CODE::..
Dim Myconn As New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
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()