can anyone solve this - Server Error in '/' Application

-2

I'm getting following error in SQL server if anyone experience with please help me out to solve this issue,

Conversion failed when converting from a character string to uniqueidentifier. 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.Data.SqlClient.SqlException: Conversion failed when converting from a character string to uniqueidentifier.

Source Error:

Line 743:                                                 sSQL = 
"SELECT CategoryID, ContentID, thalaippu, CreatedDate, seidhikurum, 
seidhinedum, STNImage FROM tblPathivuContents WHERE CategoryID = 11 
AND ContentID = '" + TWContentID + "' ORDER BY CreatedDate DESC";
Line 744:                                             }
Line 745:                                             
dsORecordSet1 = COLTools.DB.RunQuerySql(sSQL);
Line 746:                                             strLinkUrl 
= "/showcontentnews.aspx";
Line 747:                                             for (int j 
= 0; j <= dsORecordSet1.Tables[0].Rows.Count-1; j++)

Source File: c:\inetpub\wwwroot\ponguthamil\index.aspx Line: 745

Stack Trace:

 [SqlException (0x80131904): Conversion failed when converting from 
  a character string to uniqueidentifier.]
  COLTools.SqlDB.RunQuerySql(String connectionString, String sql) 
  +273
 COLTools.DB.RunQuerySql(String sql) +63
 ASP.index_aspx.__Renderform1(HtmlTextWriter __w, Control 
 parameterContainer) in 
 c:\inetpub\wwwroot\ponguthamil\index.aspx:745
  System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter 
 writer, ICollection children) +256
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
  System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter 
  writer) +163    Version Information: Microsoft .NET Framework Version:2.0.50727.8793; ASP.NET Version:2.0.50727.8762
sql
asp.net
sql-server-2008
asked on Stack Overflow Oct 30, 2018 by prins prem • edited Oct 30, 2018 by ADyson

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0