System.InvalidCastException: Unable to cast object of type 'System.DateTime' to type 'System.String'.
CREATE PROC uspGetRecentLogin @UserID int,@RLoginDate datetime OUT AS BEGIN SET @RLoginDate= (SELECT TOP 1 LoginDate FROM TblLoginDetails WHERE UserId=@UserID ORDER BY LoginDate DESC) END
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Configuration; using System.Data.SqlClient; public partial class CandMaster : System.Web.UI.MasterPage { public String AppUserName; int AppUserID; DBClass db1 = new DBClass(); protected void Page_Load(object sender, EventArgs e) { if (Session["AppUserName"] != null & Session["AppUserID"] != null) { AppUserName = Convert.ToString(Session["AppUserName"]); AppUserID = Convert.ToInt32(Session["AppUserID"]); } else { } LblUserLogin.Text = AppUserName; GetRecentLoginTime(); } private void GetRecentLoginTime() { try { DBClass db1 = new DBClass(); db1.sqlcmd = new SqlCommand("uspGetRecentLogin"); using (SqlDataAdapter sda = new SqlDataAdapter()) { db1.sqlcmd.CommandType = CommandType.StoredProcedure; db1.sqlcmd.Parameters.AddWithValue("@UserID", AppUserID); db1.sqlcmd.Parameters.Add("@RLoginDate", SqlDbType.DateTime); db1.sqlcmd.Parameters["@RLoginDate"].Direction = ParameterDirection.Output; db1.sqlcmd.Connection = db1.sqlcon; db1.sqlcon.Open(); db1.sqlcmd.ExecuteScalar(); LabelLastLogin.Text = (string) db1.sqlcmd.Parameters["@RLoginDate"].Value; } } catch (Exception ex) { Response.Write(ex);} finally { } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)