ASP.NET

SELECT MAX(ID) AS LastID FROM mytable

select Top 1 * from table order by id Desc

Priyagdpl wrote:

I used Update Panel, still it get refresh.

var xmlhttp;

function InitXmlHttpRequest() {

    xmlhttp = null;
    if (window.XMLHttpRequest) {
        // code for all new browsers
        xmlhttp = new XMLHttpRequest();
    }
    else if (window.ActiveXObject) {
        // code for IE5 and IE6
        xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
    }
}


function CheckDuplicateEmail(url) {

    InitXmlHttpRequest();

    var handleStateChanged = function() {
        if (xmlhttp.readyState == 4) {  // 4 = "loaded"
            if (xmlhttp.status == 200) { // 200 = OK
                try {
                    alert("message from server : " + xmlhttp.responseText);
                }
                catch (e) {
                }
            }
            else {
                //alert("Problem retrieving XML data");
            }
        }
    };

    if (xmlhttp != null) {
        xmlhttp.onreadystatechange = handleStateChanged;
        xmlhttp.open("GET", url, true);
        xmlhttp.send(null);
    }
    else {
        //alert("Your browser does not support XMLHTTP.");
    }
}

saritha_codeproject wrote:

Custom conetext menu(Custom controls) of extended gridview

sris 426 wrote:

After login,can i store userid and username (login specific details)

sris 426 wrote:

What type of data i can keep in global.ajax file

bool LoadSubIndustries = true;
public int IndustryId { get; set; }

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        Populate_Industry();
    }

    LoadSubIndustries = false;
}

private void Populate_SubIndustry()
{
    DataSet dsSubIndustries = lookupManager.GetSubIndsutryByIndustryId(IndustryId);

    ddlSubIndustry.DataSource = dsSubIndustries.Tables["Lookup_SubIndustry"].DefaultView;
    ddlSubIndustry.DataValueField = "Id";
    ddlSubIndustry.DataTextField = "SubIndustry";

    ddlSubIndustry.DataBind();
}

private void Populate_Industry()
{
    DataSet dsIndustries = lookupManager.GetIndustries();

    ddlIndustry.DataSource = dsIndustries.Tables["Lookup_Industry"].DefaultView;
    ddlIndustry.DataValueField = "Id";
    ddlIndustry.DataTextField = "Industry";

    ddlIndustry.DataBind();
}

protected void ddlIndustry_SelectedIndexChanged(object sender, EventArgs e)
{
    if (LoadSubIndustries == false)
    {
        IndustryId = (int.Parse(ddlIndustry.SelectedValue.ToString()));
        Populate_SubIndustry();
    }
}