how to retrieve live data from query.iqy to MS SQL without refresh

Hello Aman,

issue is not with refresh the content. my issue  once downloaded the .iqy file from sharepoint if any one updated any changes in the sharepoint I need that data automatically with out opening .iqy file and click on referesh button explictily and I dont want every time opened .iqy file and refresh . I need solution to get this updated data from sharepoint using .iqy file with out referesh.

Hope this understood for you.

Use Ajax Extension, Here is a quick example:

.aspx File

aspx.cs File - add this to the Click event of the Login Button

protected void Button1_Click(object sender, EventArgs e)
{
    string sql = "";
    SqlConnection cn = null;
    SqlCommand cmd = null;
    SqlDataReader dr = null;
    string User = username.Text;
    string Pwd = passwd.Text;
    //cn = "<< your connection string>>";
    try
    {
        cn.Open();
        // Your code

        sql = "EXEC dbo.sProc_Admin_Auth @UserNm = '" + User + "',@Pwd = '" + Pwd + "'";

        cmd = new SqlCommand(sql, cn);

        dr = cmd.ExecuteReader();

        if (dr.Read())
        {
            Session["UserId"] = dr["UserId"].ToString();
            Session["LoginId"] = User;
            Session["UserNm"] = dr["FullNm"].ToString();// "Jayasurya Satheesh";
            Session["Email"] = dr["Email"].ToString();
            Session["JoinDt"] = dr["CreateDt"].ToString();
            Response.Redirect("Index.aspx");
            LblError.Visible = false;
        }
        else
        {
            LblError.Visible = true;
            LblError.Text = "Login Failed!";
        }
    }
    catch (Exception exce)
    {
        LblError.Text = exce.Message;
    }
    finally
    {
        cn.Close();
    }
}

You can find UpdatePanel and ScriptManager under Toolbox -> Ajax Extension

Use try-catch block to handle runtime exceptions.