SQL »ù±¾²Ù×÷ ɾ³ý ÐÞ¸Ä Ë¢Ð Ð޸İæ
C# Êý¾Ý¿âÖ®ÂÃ……
¼ÌÐø½ø¹¥²ã³ö²»ÇîµÄproblems
ÔÚÉÏһƪÄÚÈݵĻù´¡ÉÏ£¬ÎÒÓÖ×÷ÒԸĽø£¬ÏÖÔÚµÄÇé¿öÊÇÕâÑùµÄ£º
//In Browseuser form
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlClient;
namespace Str
{
public partial class Browseuser : Form
{
public Browseuser()
{
InitializeComponent();
}
//define Êý¾Ý¼¯¶ÔÏódsÓÃÓÚ±£´æ²éѯ·µ»ØµÄ½á¹û¼¯
DataSet ds;
private void Browseuser_Load(object sender, EventArgs e)
{
string strConnection = ConfigurationSettings.AppSettings["connectionstring"];
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
string sql = "select userid as userid,name as name from judging";
SqlDataAdapter adp = new SqlDataAdapter(sql, objConnection);
ds = new DataSet();
ds.Clear();
adp.Fill(ds, "judging");
dataGridView1.DataSource=ds. Tables[0].DefaultView;
dataGridView1.Refresh();
this.judgingTableAdapter.Fill(this.masterDataSet.judging);
}
/**********************************************************************************************/
/*ÖÁ´ËÍê³ÉÁ˽«Êý¾Ý¿âjudgingÖеÄÄÚÈÝÈ«²¿ÏÔʾÔÚÐÂform——BrowseuserÉÏ*/
/**********************************************************************************************/
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void button3_Click(object sender, EventArgs e)
{
this.Close();
}
//define a delegate instance in order to refresh
delegate void UseF();
/****************
Ïà¹ØÎĵµ£º
¡¡²Ù×÷·ûÓÅ»¯
¡¡¡¡IN ²Ù×÷·û
¡¡¡¡ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
¡¡¡¡µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵ģ¬´ÓORACLEÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
¡¡¡¡ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£ ......
ÔÚ¹¤×÷ÖÐÓöµ½Ò»¸öÎÊÌâ,ÊÇÐèÒªsqlµÝ¹é²éѯµÄ.²»¶®,ÓÚÊǵ½csdnÉÏÈ¥ÎÊ,ÄÇÀïµÄЧÂÊÕæÊǷdz£¸ß,ÎÒÒÔǰҲûÔÚÉÏÃæÎʹýÎÊÌâ.
ÎÊÌâÃèÊö:
ÎÒÓÐÒ»¸ö±í½á¹¹ÈçÏÂ:
id upperid
1 2
3 2
4 1
5 3
¾ßÌå²ã´Î²»ÖªµÀ,ÎÒÏëÓõݹésqlÓ ......
SQL Server Êý¾Ý¿â¹ÊÕÏÐÞ¸´¶¥¼¶¼¼ÇÉÖ®Ò»
2010-04-26 10:37:52 À´Ô´:TechTargetÖйú ÎÒÒªÊÕ²Ø
SQL Server 2005 ºÍ 2008 Óм¸¸ö¹ØÓڸ߿ÉÓÃÐÔµÄÑ¡ÏÈçÈÕÖ¾´«Êä¡¢¸±±¾ºÍÊý¾Ý¿â¾µÏñ¡£ËùÓÐÕâЩ¼¼Êõ¶¼Äܹ»×÷Ϊά»¤Ò»¸ö±¸Ó÷þÎñÆ÷µÄÊֶΣ¬Í¬Ê±Õâ¸öÊý¾Ý¿â¿ÉÒÔÔÚÄãÔÏȵÄÖ÷Êý¾Ý¿â³öÎÊÌâʱÉÏÏß²¢×÷ΪеÄÖ÷·þÎñÆ÷¡£È»¶ø£¬Äã± ......
1¡¢ SQL Server£ºÈëÕ¾¶Ë¿ÚΪTCP 1433£¬³öÕ¾¶Ë¿ÚΪTCPÈÎÒâ¶Ë¿Ú£¨1024¡«5000Ö®¼äµÄ¶Ë¿ÚºÅ£©£»
2¡¢ SQL Browser £ºÈëÕ¾¶Ë¿ÚΪUDP 1434£¬³öÕ¾¶Ë¿ÚΪUDPÈÎÒâ¶Ë¿Ú£¨1024¡«5000Ö®¼äµÄ¶Ë¿ÚºÅ£©£»
3¡¢²é¿´»òÐÞ¸ÄSQL2005ʵÀýµÄ¶Ë¿ÚºÅ£¬Èç¹ûϵͳÖÐͬʱ°²×°SQL 2000ºÍSQL 2005£¬SQL 2005µÄÁ¬½Ó¶Ë¿Ú¿ÉÄܲ»ÊÇ1433£¬ÎÒÃÇÐèÒª¸ü¸ÄSQL 2005 ......