Comments by hany1002 - CodeProject

hany1002 23-Apr-13 5:05am View

i found the problem in this html line

<asp:Button ID="btnSave" runat="server" CssClass="bigButton2" style="color: #FFFFFF; font-weight: 700; background-color: #333333" Text="Send" Width="180px" Height="38px" onclick="btnSave_Click" />

in this code (onclick="btnSave_Click" />)

why this problem according ???

hany1002 23-Apr-13 4:55am View

Protected Sub btnSave_Click(sender As Object, e As EventArgs) Handles btnSave.Click

hany1002 23-Apr-13 4:22am View

First Column In my table

MsgID int Unchecked

hany1002 23-Apr-13 4:14am View

Deleted

First Column In my table

MsgID int Unchecked

hany1002 30-Mar-13 13:05pm View

Great thanks

hany1002 30-Mar-13 5:45am View

that is my code how can i change it

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()

hany1002 30-Mar-13 5:29am View

Error : Public member 'Substring' on type 'Date' not found.

hany1002 30-Mar-13 5:28am View

Same error

Notes :

sql database

ActID int Unchecked
Skey nvarchar(100) Checked
Expirydate date Checked

hany1002 30-Mar-13 5:23am View

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

hany1002 29-Mar-13 8:10am View

i would like to save location show the map in sql database

Comments by hany1002 (Top 10 by date)