å¦éè¿æ¥å°æ¬å°SQLï¼è¯·ç¡®ä¿SQLæå¡æ£å¸¸å¯å¨ï¼ç¶åæ§è¡å¦ä¸ä»£ç ï¼
string con, sql;
/*Integrated Security=SSPI è¿ä¸ªè¡¨ç¤ºä»¥å½åWINDOWSç³»ç»ç¨æ·èº«å»ç»å½SQL SERVERæå¡å¨ï¼å¦æSQL SERVERæå¡å¨ä¸æ¯æè¿ç§æ¹å¼ç»å½æ¶ï¼å°±ä¼åºéã
ä½ å¯ä»¥ä½¿ç¨SQL SERVERçç¨æ·ååå¯ç è¿è¡ç»å½ï¼å¦ï¼
"Server=.;Database=YouDBName;User ID=sa;Password=å¯ç "
*/
con = "Server=.;Database=YouDBName;Integrated Security=SSPI";
sql = "select * from Test";
SqlConnection mycon = new SqlConnection(con);
mycon.Open();
SqlDataAdapter myda = new SqlDataAdapter(sql, con);
DataSet myds = new DataSet();
myda.Fill(myds, "Test");
dataGridView1.DataSource = myds.Tables["Test"];
温馨提示:答案为网友推荐,仅供参考