Server Error in '/' Application.

Conversion failed when converting the varchar value 'contact' to data type int.

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 the varchar value 'contact' to data type int.

Source Error:


Line 4:  var db = WebMatrix.Data.Database.Open("mvcconnection");
Line 5:  nitin nn = new nitin();
Line 6:  var item = db.QuerySingle("Select * from disease where id='" + UrlData[1].ToString().Split('.').First() + "'");
Line 7:  var item1 = db.QuerySingle("Select * from dcategories where id='" + UrlData[1].ToString().Split('.').First() + "'");
Line 8:  

Source File: g:\pleskvhosts\drsaranshjain.com\drskjain.com\disease.cshtml    Line: 6

Stack Trace:


[SqlException (0x80131904): Conversion failed when converting the varchar value 'contact' to data type int.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2586154
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039978
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +242
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +275
   System.Data.SqlClient.SqlDataReader.Read() +35
   System.Data.Common.DbEnumerator.MoveNext() +38
   WebMatrix.Data.<QueryInternal>d__0.MoveNext() +203
   System.Linq.Enumerable.FirstOrDefault(IEnumerable`1 source) +168
   WebMatrix.Data.Database.QuerySingle(String commandText, Object[] args) +100
   ASP._Page_disease_cshtml.Execute() in g:\pleskvhosts\drsaranshjain.com\drskjain.com\disease.cshtml:6
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +198
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +69
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +131
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +78
   System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContextBase httpContext) +116


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0