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
User contributions licensed under CC BY-SA 3.0