using (SqlCommand cmd = new SqlCommand(query, MyConnection)) { cmd.Notification = null; DataTable dt = new DataTable(); SqlDependency dependency = new SqlDependency(cmd); if (MyConnection.State == ConnectionState.Closed) MyConnection.Open(); var rdr = cmd.ExecuteReader(); dt.Load(rdr); if (dt.Rows.Count > 0) { name = dt.Rows[0]["ProdName"].ToString(); price = int.Parse(dt.Rows[0]["Price"].ToString()); image = dt.Rows[0]["Images"].ToString(); } dependency.OnChange += new OnChangeEventHandler (dependency_OnChange);
AttachDbFileName
User Instance=true;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)