You didn't alias the field. You aren't selecting the "Body" field from the
table. You're creating a new derived column from it. Use an alias for the
column:
SELECT Replace(body,char(13),'<br>') As Body from Posts
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Neither a follower nor a lender be.
"Dmitri Manushin" <dm-man@mail.ru> wrote in message
news:eubpxUwYDHA.1384@TK2MSFTNGP10.phx.gbl...[color=blue]
> hi all.
> this is my code
>
> %@ Import Namespace="System.Data" %>
> <%@ Import Namespace="System.Data.SqlClient" %>
> <script language="C#" runat="server">
> void Page_Load(Object sender, EventArgs e)
> {
> SqlConnection myConn2 = new SqlConnection("server =localhost;
> UID=***;PWD=***;database=forum");
> SqlCommand myComm2 = new SqlCommand("SELECT[/color]
Replace(body,char(13),'<br>')[color=blue]
> from Posts",myConn2);
> myConn2.Open();
> SqlDataReader myRead = myComm2.ExecuteReader();
> while(myRead.Read())
> {
> Response.Write(myRead["Body"]);
> }
> myRead.Close();
> myConn2.Close();
> }
>
> So, when i try execute this code i return error
>
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
>
> Exception Details: System.IndexOutOfRangeException: Body
>
> Source Error:
>
> Line 10: while(myRead.Read())
> Line 11: {
> Line 12: Response.Write(myRead["Body"]);
> Line 13: }
> Line 14: myRead.Close();
>
>
> Any idea?
>
> P.S.
>
> If i use datareader everything is ok.
>
> Thanks.
>
>[/color]
