ASP.NET

29-Nov-07 22:24

i want to creat html textbox control using sql query.
u might get surprised n think it is not possible, but i have already used it in my last job but rite now i forgot the sql syntax, it is possible.
requirement was as follow
there was one grid in that one column containing textbox so that one can enter multiple values at a time an update it.
and this was done using sql query means i had written a sql query which was generate one colnm with textbox. mind it there wasn't any templated field.
i know it can be done through templatd control but i want that sql syntax.
roughly i can give idea og sql syntax. "select ''"

Christian Graus29-Nov-07 23:04

29-Nov-07 23:04

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 )

MaruBindiya29-Nov-07 23:18

29-Nov-07 23:18

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 Graus29-Nov-07 23:50

29-Nov-07 23:50

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

Paddy Boyd30-Nov-07 0:52

Paddy Boyd

30-Nov-07 0:52

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'.

MaruBindiya30-Nov-07 1:40

30-Nov-07 1:40

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 Boyd30-Nov-07 1:46

Paddy Boyd

30-Nov-07 1:46

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...

MaruBindiya30-Nov-07 1:53

30-Nov-07 1:53

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

Paddy Boyd30-Nov-07 1:55

Paddy Boyd

30-Nov-07 1:55

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

MaruBindiya30-Nov-07 2:00

30-Nov-07 2:00

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

Connection string of ASp.NET

J4amieC30-Nov-07 3:12

J4amieC

30-Nov-07 3:12

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!

garga129-Nov-07 22:15

garga1

29-Nov-07 22:15

Friends,

How to connect ASP.NET with MySql.?? What is the connection string for that.?

Re: Connection string of ASp.NET

varshavmane29-Nov-07 22:17

Re: Connection string of ASp.NET

29-Nov-07 22:17

http://aspnet101.com/aspnet101/tutorials.aspx?id=39

Vasudevan Deepak Kumar29-Nov-07 22:20

Vasudevan Deepak Kumar

29-Nov-07 22:20

Check out

http://www.connectionstrings.com[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Re: Connection string of ASp.NET

varshavmane29-Nov-07 22:22

How to display html text ??

29-Nov-07 22:22

Good One...

varshavmane29-Nov-07 22:06

29-Nov-07 22:06

Hi All,

I am getting the values from Database like :

Hello World

and now I have to store this in datatable as hello world.

I am using ASP.NET 2.0 (C#).

Please tell me how do I do this???

Thanks in advance...

Christian Graus29-Nov-07 23:08

29-Nov-07 23:08

Use a regex to strip the tags

varshavmane29-Nov-07 23:16

29-Nov-07 23:16

Thanks for the reply sir, can u help me with the code???

Thanks again...

Christian Graus29-Nov-07 23:20

29-Nov-07 23:20

It's a pretty common regex, I'm sure if you download Expresso, it will be in there, or you can find it with google.

<(?<tag>\w*)>(?<text>.*)>

is the tag in expresso. It seems to assume only one tag is being removed, tho. off the top of my head should find any tag.

varshavmane29-Nov-07 23:36