it return me this error in the same line (LblExpirydate.Text = dataReader(0).ToString("d"))
Error : Conversion From Sting "d" to 'integer' is not valid
connectionString = ConfigurationManager.ConnectionStrings("conString").ToString
connection = New SqlConnection(connectionString)
connection.Open()
command = New SqlCommand("SELECT Max(Expirydate) FROM Act WHERE Skey = '" & Request.QueryString("ID") & "'", connection)
dataReader = command.ExecuteReader
dataReader.Read()
LblExpirydate.Text = dataReader(0).ToString("d")
connection.Close()
sql database
ActID int Unchecked
Skey nvarchar(100) Checked
Expirydate date Checked