string str = "";
private void btnSure_Click(object sender, EventArgs e)
{
Thread th = new Thread(new ThreadStart(AddString));
th.Start();
} private delegate void InvokeCallback();
private delegate void InvokeCallbackStr(string str);
void TitleStr()
{
str += string.Format(" AND ConTitle like '%{0}%' ", txtTitle.Text.Trim());
}
void WordsStr()
{
str += string.Format(" AND KeyWords like '%{0}%' ", txtKeyWords.Text.Trim());
} void AddString()
{
str = " select ContentID,ConTitle,KeyWords from tblContent where 1=1 ";
if (txtTitle.InvokeRequired)
{
InvokeCallback call = new InvokeCallback(TitleStr);
txtTitle.BeginInvoke(call);
}
else
str += string.Format(" AND ConTitle like '%{0}%' ", txtTitle.Text.Trim()); if (txtKeyWords.InvokeRequired)
{
InvokeCallback call = new InvokeCallback(WordsStr);
txtKeyWords.BeginInvoke(call);
}
else
str += string.Format(" AND KeyWords like '%{0}%' ", txtKeyWords.Text.Trim()); string conn = "Server=(local);Database=myDB;Integrated Security=true";
DataTable dt = SqlHelper.ExecuteDataset(conn, CommandType.Text, str).Tables[0];
string strHtml = "";
strHtml += "<Table>";
for (int t = 0; t < dt.Rows.Count; t++)
{
strHtml += "<tr>";
strHtml += string.Format("<td>{0}</td>", dt.Rows[t][0].ToString());
strHtml += string.Format("<td>{0}</td>", dt.Rows[t][1].ToString());
strHtml += string.Format("<td>{0}</td>", dt.Rows[t][2].ToString());
strHtml += "</tr>";
}
strHtml += "</Table>";
if (MyBrowser.InvokeRequired)
{
InvokeCallbackStr call = new InvokeCallbackStr(GetWeb);
MyBrowser.BeginInvoke(call, new string[] { strHtml });
}
else
{
MyBrowser.DocumentText = strHtml;
}
} void GetWeb(string strHtml)
{
MyBrowser.DocumentText = strHtml;
}为什么查询出的结果时而正确时而不正确呢,我的意思是结果集和我想要的不一致,求高手解决!thread
private void btnSure_Click(object sender, EventArgs e)
{
Thread th = new Thread(new ThreadStart(AddString));
th.Start();
} private delegate void InvokeCallback();
private delegate void InvokeCallbackStr(string str);
void TitleStr()
{
str += string.Format(" AND ConTitle like '%{0}%' ", txtTitle.Text.Trim());
}
void WordsStr()
{
str += string.Format(" AND KeyWords like '%{0}%' ", txtKeyWords.Text.Trim());
} void AddString()
{
str = " select ContentID,ConTitle,KeyWords from tblContent where 1=1 ";
if (txtTitle.InvokeRequired)
{
InvokeCallback call = new InvokeCallback(TitleStr);
txtTitle.BeginInvoke(call);
}
else
str += string.Format(" AND ConTitle like '%{0}%' ", txtTitle.Text.Trim()); if (txtKeyWords.InvokeRequired)
{
InvokeCallback call = new InvokeCallback(WordsStr);
txtKeyWords.BeginInvoke(call);
}
else
str += string.Format(" AND KeyWords like '%{0}%' ", txtKeyWords.Text.Trim()); string conn = "Server=(local);Database=myDB;Integrated Security=true";
DataTable dt = SqlHelper.ExecuteDataset(conn, CommandType.Text, str).Tables[0];
string strHtml = "";
strHtml += "<Table>";
for (int t = 0; t < dt.Rows.Count; t++)
{
strHtml += "<tr>";
strHtml += string.Format("<td>{0}</td>", dt.Rows[t][0].ToString());
strHtml += string.Format("<td>{0}</td>", dt.Rows[t][1].ToString());
strHtml += string.Format("<td>{0}</td>", dt.Rows[t][2].ToString());
strHtml += "</tr>";
}
strHtml += "</Table>";
if (MyBrowser.InvokeRequired)
{
InvokeCallbackStr call = new InvokeCallbackStr(GetWeb);
MyBrowser.BeginInvoke(call, new string[] { strHtml });
}
else
{
MyBrowser.DocumentText = strHtml;
}
} void GetWeb(string strHtml)
{
MyBrowser.DocumentText = strHtml;
}为什么查询出的结果时而正确时而不正确呢,我的意思是结果集和我想要的不一致,求高手解决!thread
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货