creating html control trough sql query

[Christian Graus]

You can inject any text you like into your page, and it will render as HTML. If you want to store HTML in your database, you can. I can't imagine what purpose it serves, but it's not surprising that it works. HTML is text. Your DB stores text.

Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

[MaruBindiya]

i want somthing like shown below Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Dim con As New SqlConnection("MyConnectionString") Dim cmd As New SqlCommand("select '', * from Table1 ", con) con.Open() GridView1.DataSource = cmd.ExecuteReader GridView1.DataBind() con.Close() End If End Sub this code giving error msg "Incorrect syntax near ' />'." so result should display grid containing one colmn with textbox.

[Christian Graus]

This is a pretty retarded way of trying to inject HTML into your grid. You can't actually hope to interact with it in any way, so what's the point ? The problem is that you have your quotes messed up. I think '' does a quote in an SQL string. As it stands, it can't work out what quotes denote the edges of the constant string, and which are part of it

Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

[Paddy Boyd]

Really, why not just use the built in item template to get proper runtime use out of your textboxes? all you're doing here is making this harder for other people to maintain by trying to be 'clever'.

[MaruBindiya]

mind it i m not tring to be 'clever'. i just wanna know if there is another way of doing the same thing, if u dnt know then no need of any comments...

[Paddy Boyd]

You said in your post that you were aware that it could be done through a templated column. This would be the other way of doing it...

[MaruBindiya]

this is the 1st way i have for askd 2nd way of doing it

[Paddy Boyd]

Mmm. But there's nothing wrong with the first (recommended) way of doing it?

[MaruBindiya]

my dear frnd m not intersted to knw what u recommend......

[J4amieC]

MaruBindiya wrote:

not intersted to knw what u recommend

Then why ask a bloody question if you're not interested in the reply. Some people!