弹出新窗体后界面卡死

ct4477xx 2014-05-22 01:21:26

public void UpdateGrid()
{
using (SqlConnection connection = new SqlConnection(_connStr))
{
using (SqlCommand command = new SqlCommand("select ID From [dbo].[Messages] where isOK=0", connection))
{
command.CommandType = CommandType.Text;
connection.Open();
SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
SqlDataReader sdr = command.ExecuteReader();
while (sdr.Read())
{
int ID = (int)sdr["ID"];
TT.ID = Convert.ToString(ID);
//
try
{
Messagescs x = new Messagescs();
x.Show();
}
catch (Exception re)
{
MessageBox.Show(re.Message);
}

System.Threading.Thread.Sleep(6000);
string updata = string.Format("update [Messages] set isOK=1 where id=" + ID);
SqlCommand upgx = new SqlCommand(updata, connection);
connection.Open();
upgx.ExecuteNonQuery();
connection.Close();
}
sdr.Close();
connection.Close();
}
}
}

public void dependency_OnChange(object sender, SqlNotificationEventArgs e)
{
UpdateGrid();
}

这是用SqlDependency 数据库监听做的一个窗体，大概想实现的效果是当有新纪录写入后isok默认是0.然后程序会监听数据库信息，监听到有0的就读取出来，然后更新为isok为1，现在的问题是打开程序后当数据库写入数据后新弹出来的Messagescs子窗体就会卡死，求指导

...全文

589 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

ct4477xx 2014-05-22

打赏
举报

引用 5 楼 wmg494005678 的回复:

关于UI的处理一定是交给UI线程来处理的

最后用ui的线程解决了问题。。

郑州高新区WPF小王子 2014-05-22

打赏
举报

定义个委托方法，用来打开窗体。提示用 this.Invoke();

於黾 2014-05-22

打赏
举报

你这是在线程1里又开了个线程2,然后线程2去开窗体,这跟在线程1里开窗体有什么区别么?

ct4477xx 2014-05-22

打赏
举报

引用 4 楼 Z65443344 的回复:

加个全局变量,告诉主线程可以开窗体了,然后在主线程的timer里弹出窗体. 或者线程间加委托,委托给主线程去开窗体. 子线程是不能直接开窗体的.

public void doTask1() { Messagescs x = new Messagescs(); x.Show(); } public void UpdateGrid() { using (SqlConnection connection = new SqlConnection(_connStr)) { using (SqlCommand command = new SqlCommand("select ID From [dbo].[Messages] where isOK=0", connection)) { command.CommandType = CommandType.Text; connection.Open(); SqlDependency dependency = new SqlDependency(command); dependency.OnChange += new OnChangeEventHandler(dependency_OnChange); SqlDataReader sdr = command.ExecuteReader(); while (sdr.Read()) { int ID = (int)sdr["ID"]; TT.ID = Convert.ToString(ID); Thread tskThread1 = new Thread(doTask1); tskThread1.Start(); // //Process ps = new Process(); //ps.StartInfo.FileName = @"Messagescs.exe"; //ps.Start(); //connection.Close(); // System.Threading.Thread.Sleep(6000); string updata = string.Format("update [Messages] set isOK=1 where id=" + ID); SqlCommand upgx = new SqlCommand(updata, connection); connection.Open(); upgx.ExecuteNonQuery(); connection.Close(); } sdr.Close(); connection.Close(); } } } 我这样写后。。提示是这样的。。

ct4477xx 2014-05-22

打赏
举报

引用 4 楼 Z65443344 的回复:

加个全局变量,告诉主线程可以开窗体了,然后在主线程的timer里弹出窗体.
或者线程间加委托,委托给主线程去开窗体.
子线程是不能直接开窗体的.

public void doTask1()
{
Messagescs x = new Messagescs();
x.Show();
}
public void UpdateGrid()
{
using (SqlConnection connection = new SqlConnection(_connStr))
{
using (SqlCommand command = new SqlCommand("select ID From [dbo].[Messages] where isOK=0", connection))
{
command.CommandType = CommandType.Text;
connection.Open();
SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
SqlDataReader sdr = command.ExecuteReader();
while (sdr.Read())
{
int ID = (int)sdr["ID"];
TT.ID = Convert.ToString(ID);
Thread tskThread1 = new Thread(doTask1);
tskThread1.Start();
//

//Process ps = new Process();
//ps.StartInfo.FileName = @"Messagescs.exe";
//ps.Start();
//connection.Close();
//

System.Threading.Thread.Sleep(6000);
string updata = string.Format("update [Messages] set isOK=1 where id=" + ID);
SqlCommand upgx = new SqlCommand(updata, connection);
connection.Open();
upgx.ExecuteNonQuery();
connection.Close();
}
sdr.Close();
connection.Close();
}
}
}