| |
DataGridѧϰһ
|
ÈÕÆÚ£º2004Äê3ÔÂ14ÈÕ ×÷ÕߣºÇå·çÍøÂçѧԺ
²é¿´:[´ó×ÖÌå ÖÐ×ÖÌå
С×ÖÌå]
|
Êý¾Ý·ÃÎÊÊÇÈκÎʵ¼ÊÓ¦ÓóÌÐòµÄºËÐIJ¿·Ö£¬¶ø ASP.NET ÌṩÁËÒ»Ì׷ḻµÄ¿Ø¼þ£¬ÕâЩ¿Ø¼þÓ빫¹²ÓïÑÔÔËÐпâÖÐÌṩµÄÍйÜÊý¾Ý·ÃÎÊ API ºÜºÃµØ¼¯³ÉÔÚÒ»Æð¡£´Ó½ñÌ쿪ʼÎÒÃǾÍÀ´Ñ§Ï°DataGridÊý¾Ý¿Ø¼þµÄʹÓá£
¡¡¡¡ÎªÁËʹҳÄܹ»·ÃÎÊÖ´ÐÐ SQL Êý¾Ý·ÃÎÊËùÐèµÄÀ࣬±ØÐ뽫 System.Data ºÍ System.Data.SqlClient ÃüÃû¿Õ¼äµ¼Èëµ½Ò³ÖС£ <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> ¡¡¡¡ÈôÒª¶Ô SQL Êý¾Ý¿âÖ´ÐÐÑ¡Ôñ²éѯ£¬Çë´´½¨ÓëÊý¾Ý¿âµÄ SqlConnection£¬´«µÝÁ¬½Ó×Ö·û´®£¬È»ºó¹¹Ôì°üº¬²éѯÓï¾äµÄ SqlCommand ¶ÔÏó,ÔÙ¹¹ÔìSqlDataReader¶ÔÏó¶ÁÊý¾Ý¡£ÈôÒªÈÃDataGrid°ó¶¨Êý¾Ý£¬ÔòÒª°ÑSqlDataReader¶ÔÏóµÄʵÀý¸³ÓèDataGridµÄDataSourceÊôÐÔ£¬È»ºó°ó¶¨Ëü¡£ ´úÂëÈçÏ£º
ÔÚaspxÎļþÀï¼ÓÈëDataGrid¿Ø¼þ£¬ÐÞ¸ÄÊôÐÔÈçÏ£º <h3><font face="ËÎÌå">DataGrid ¿Ø¼þµÄ¼òµ¥Ñ¡Ôñ</font></h3> <ASP:DataGrid id="DataGrid1" runat="server" Width="700" BackColor="#ccccff" BorderColor="black" ShowFooter="false" CellPadding="3" CellSpacing="0" Font-Name="ËÎÌå" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" EnableViewState="false"> <HeaderStyle BackColor="#AAAADD"></HeaderStyle> </ASP:DataGrid>
ÔÚaspx.csÎļþÀï¼ÓÈëÏÂÃæ´úÂ룺 Ê×Ïȵ¼ÈëSystem.Data.SqlClientÃüÃû¿Õ¼ä£» ÔÙ¼ÓÈëÏÂÃæ´úÂ룺 private void Page_Load(object sender, System.EventArgs e) { SqlConnection myConnection = new SqlConnection("user id=sa;password=;initial catalog=pubs;data source=jeff"); myConnection.Open(); SqlCommand myCommand = new SqlCommand("select * from Authors", myConnection); SqlDataReader dr = myCommand.ExecuteReader(); DataGrid1.DataSource=dr; DataGrid1.DataBind(); myConnection.Close(); }
ÉÏһƪ:DataTable¿Ø¼þµÄʹÓÃ
ÏÂһƪ:DataGridѧϰ¶þ
|
ÌØ±ðÉùÃ÷£º±¾Õ¾³ý²¿·ÖÌØ±ðÉùÃ÷½ûÖ¹×ªÔØµÄר¸åÍâµÄÆäËûÎÄÕ¿ÉÒÔ×ÔÓÉ×ªÔØ£¬µ«ÇëÎñ±Ø×¢Ã÷³ö´¦ºÍÔʼ×÷Õß¡£ÎÄÕ°æÈ¨¹éÎÄÕÂÔʼ×÷ÕßËùÓС£¶ÔÓÚ±»±¾Õ¾×ªÔØÎÄÕµĸöÈ˺ÍÍøÕ¾£¬ÎÒÃDZíʾÉîÉîµÄлÒâ¡£Èç¹û±¾Õ¾×ªÔصÄÎÄÕÂÓаæÈ¨ÎÊÌâÇëÁªÏµ±à¼ÈËÔ±£¬ÎÒÃǾ¡¿ìÓèÒÔ¸üÕý¡£
[´òÓ¡±¾Ò³] [¹Ø±Õ´°¿Ú] ×ªÔØÇë×¢Ã÷À´Ô´£ºhttp://www.abcdown.net
| |