ASP.NET

ClientIDMode="Static"

string sql = "INSERT INTO login (Username, Gender, Email, MobileNo, Category_Id, CompanyArea, CompanyName, CompanyNo, AltCompanyNo, Address)VALUES (?,?,?,?,?,?,?,?,?) ";

1. RowEditing: where you set the EditIndex property. this will load the editing template to render the row you wish to edit.
2. RowCancelingEdit: fired when edit is canceld.
3. RowUpdating: fired when you click the update command. Here you make the actual editing action.
4. RowUpdated: fired when the update is done.

public static string GuessImageMimeType(byte[] data)
{
    string result = null;
    if (data != null && data.Length > 3)
    {
        if (data[0] == 71 && data[1] == 73 && data[2] == 70)
        {
            result = MediaTypeNames.Image.Gif;
        }
        else if (data[0] == 137 && data[1] == 80 && data[2] == 79)
        {
            result = "image/png";
        }
        else if (data[0] == 66 && data[1] == 77)
        {
            result = "image/bmp";
        }
        else
        {
            for (int index = 0; index < data.Length - 2; index++)
            {
                if (data[index] == 255 && data[index + 1] == 216 && data[index + 2] == 255)
                {
                    result = MediaTypeNames.Image.Jpeg;
                    break;
                }
            }
        }
    }

    return result;
}

public static string BuildImageUrl(byte[] data)
{
    if (data == null || data.Length == 0) return null;

    var sb = new StringBuilder("data:");
    string mimeType = GuessImageMimeType(data);
    if (!string.IsNullOrWhiteSpace(mimeType)) sb.Append(mimeType);

    sb.Append(";base64,");
    sb.Append(Convert.ToBase64String(data));
    return sb.ToString();
}

<asp:Image runat="server"
    ImageUrl='<%# BuildImageUrl((byte[])Eval("visPic")) %>'
/>

<asp:Image runat="server"
    ImageUrl='<%# Eval("ID", "DisplayVisitorPicture.ashx?ID={0:D}") %>'
/>

larsp777 wrote:

Doesn't seem so stable or maybe I am doing something wrong.