hi,

1- how can i keep connection information(response/request ip..) of client side.

2-how can i send a  page to client side on uncertain time which using connection information..

thankkss.
 
 

hai,

Please explain the problem clearly. What information you want maintain in the Client. explain with example. I will help you.

 

 

public partial class _Default : System.Web.UI.Page
{

    SqlConnection con;
    SqlCommand cmd;
    SqlDependency dep;
    SqlDataAdapter da;
    DataTable dt;

    protected void Page_Load(object sender, EventArgs e)
    {
     
        Label1.Text = DateTime.Now.ToLongTimeString();
    }
   
    protected void Button1_Click(object sender, EventArgs e)
    { 
            con = new SqlConnection("Data Source=.; Initial Catalog=deneme;User=**; Password=**; Connection Timeout=30;");
            con.Open();
            cmd = new SqlCommand("SELECT [ID],[isim] FROM dbo.deneme where Id=2", con);
            dep = new SqlDependency(cmd);
            SqlDependency.Start("Data Source=.; Initial Catalog=deneme;User=**; Password=**; Connection Timeout=30;");
           
        
            dep.OnChange += new OnChangeEventHandler(dep_OnChange);
            da = new SqlDataAdapter(cmd);
            dt = new DataTable();
            da.Fill(dt);
            
    }

    void dep_OnChange(object sender, EventArgs e)
    {
      

        Label2.Text = "merhaba";           

        System.Web.HttpContext.Current.Response.Redirect("default.aspx");               RETURNİNG ERROR :Object reference not set to an instance of an object.
        
    }



}

 

sqldependency object  is waiting for change on database. 

when the data is change  is manually "dep_OnChange" event is fired but it isN't send result page to client side.. it's just create.

and i'd like to sende a result(page) to client??

 

i guess i need to create static "HttpContext.Current" object or like this.. but i didn't solve it. 

Hi,

Please refer -

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx

The OnChange event may be generated on a different thread from the thread that initiated command execution.

 

 Hi,

You can use session objects to store values on server and client sides. based upon this data you can send the needed data there to client.

Thanks

This is due to some where in your code assign null value to other variable/object. Probably you just check whether default.aspx is in the Rootdirecory or any sub directory if it's subdirectory then wirte the code like this Response.Redirect("~//SubDir//default.aspx");

"You can use session objects to store values on server and client sides. based upon this data you can send the needed data there to client."

 

which values??

thanks