C# Êý¾Ý»Ö¸´Kill½ø³ÌÎÊÌâ
C# code:
try
{
ofd.Filter = @"±¸·ÝÎļþ(*.bak)|*.bak|ËùÓÐÎļþ(*.*)|*.*¡±";
ofd.FilterIndex = 1;
this.textBox1.Text = ofd.FileName.ToString();
if (ofd.ShowDialog() == DialogResult.OK)
{
string DateStr = "Data Source=.;Initial Catalog=enrol;Integrated Security=True";
SqlConnection conn = new SqlConnection(DateStr);
conn.Open();
/*ɱµôËùÓÐÁ¬½ÓÊý¾Ý¿âµÄ½ø³Ì */
string strSQL = "select spid from master..sysprocesses where dbid=db_id('enrol')";
SqlDataAdapter Da = new SqlDataAdapter(strSQL, conn);
DataTable spidTable = new DataTable();
Da.Fill(spidTable);
SqlCommand Cmd = new SqlCommand();
Cmd.CommandType = CommandType.Text;
Cmd.Connection = conn;
for (int iRow = 0; iRow <= spidTable.Rows.Count - 1; iRow++)
{
//MessageBox.Show(spidTable.Rows[iRow][0].ToString());
Cmd.CommandText = "kill " + spidTable.Rows[iRow][0].ToString(); //Ç¿ÐйرÕÓû§½ø³Ì
Cmd.ExecuteNonQuery();
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
VC++¾ÍÊÇVCµÄ¸ÄÉÆ°æ£¿
ÄÇVC++ºÍC++ÓÐʲô¹ØÏµ£¬²»Ò»ÑùÄØ£¿
C#תѧC++£¬Òª×¼±¸×ÅÄÄ·½ÃæµÄ֪ʶ£¿
Ò»»áÏë¸ã java Ò»»áÏë¸ãc# Ò»»áÏë¸ãc++ , ÕâÑùÓÐÓÀÔ¶²»»á³ÉΪ¸ßÊÖµÄ
Â¥ÉÏ˵µÄ¶Ô£¬C++ÊǺÜÍ´¿àµÄ£¬ÎÒÕýÔÚ³ÐÊÜÕâÖ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
¿Í»§¶Ë£º·Ö²¼ÔÚÈ«¹ú²»Í¬µØÇø£¬²»Í¬µÄÓû§Óв»Í¬µÄÓû§ÃûºÍÃÜÂë¡£
·þÎñ¶Ë£º²ÉÓÃwebservice
Êý¾Ý¿â£º¿Í»§ÐÅÏ¢±í£¨user_info£©£¬¿Í»§ºÏͬ±í£¨user_contract£©
ÎÊÌ⣺Óû§µÇ¼֮ºóÒª²é¿´ºÏͬÐÅÏ¢£¬ÎÒÔÚ·þÎñ ......