Feel Like an idiot!

[jemckinney]

I have been through so many different sites and asp.net books and still just cannot get this to work and feel like an idiot! What I have is a form where the user enters two fields. I need to take these two fields plus four more and display the information to the screen and also write it to another database to keep up with what the users are doing. I've been working on this gotta be simple step forever! I haven't even tried writting it to the other DB yet, just to display the information. Here's the last bit of code I have tried: (form and display items are currently separate pages):


DIM cmdSelectStudent As SqlCommand
DIM dtrStudents As SqlDataReader
cmdSelectStudent = New SqlCommand ("Select cpsstatus, lastname, firstname, ssn from @table where ssn=@ssn")
dtrStudents = cmdSelectStudent.ExecuteReader()
While dtrStudents.Read()
Response.Write(dtrStudents("lastname", "firstname", "@ssn", "cpsstatus" ))
End While
dtrStudents.Close()
conDB.Close()

This was the last one I have tried which is completely different than the other ways (which I do not have).

Please help...

 

[tgreer]

Instead of Response.Write(), you could create dynamic controls, such as the Label Controls.

Start in your form designer by dragging a PlaceHolder control to where you want the data displayed.

Then in your code-behind, query the database, collection the data from the DataReader, and then create new Labels.

Add the labels you create to the PlaceHolder.



Thomas D. Greer

http://www.tgreer.com

Providing PostScript & PDF
Training, Development & Consulting

 

[G00GLER]

how about this for a solution;

in your page just include a span or div tag with the id=message for example

in your codebeind C#
Message.InnerHtml = yourstring;

look at

http://msdn.microsoft.com/library/d...lsHtmlContainerControlClassInnerHtmlTopic.asp

let me know if this was useful

 

[ca8msm]

If you are going to use the solution by googler, you will also have to remember to add a runat="server" tag to the div/span.

Personally, I would go with a Label (or even a LiteralControl) like tgreer suggests.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[G00GLER]

I would not go with my solution either =), if you are going to use .net you should use it's tools to take advantage and not try to replicate what you can do with ASP

 

[jemckinney]

Oh yeah, Label! I will definitely try that. THANKS!!!

 

[jemckinney]

For anyone who reads this later on, the <asp:Label... /> worked like a charm! Thanks!!!