[ASP]¶¯Ì¬°ó¶¨Êý¾ÝÔ´µÄGridViewÌí¼ÓÐÐ £¨¼¼Êõ±¸·Ý£©
GridView Ϊ¶¯Ì¬°ó¶¨ DataSet£¬½á¹û (DataSet)dt = grid1.DataSource Äò»µ½¶«Î÷£¬Ïë͵ÀÁÖ±½ÓÌí¼ÓÐв»ÐÐÁË£¬ Ö»ºÃÓÃ×µÄ°ì·¨£¬°ÑGridViewµÄ¶«Î÷µ¹³ÉDataSet£¬È»ºóÔÚDataSetÀï¼ÓÐУ¬×îºó»Ø°ógridview
tryÀïÃæµÄ
DataTable dtable = new DataTable("tb1");
DataSet ndtset = new DataSet();
for (int i = 0; i < GridView2.HeaderRow.Cells.Count; i++)
{
dtable.Columns.Add(GridView2.HeaderRow.Cells[i].Text.ToString());
}
for (int j = 0; j < GridView2.Rows.Count; j++)
{
DataRow ndr = dtable.NewRow();
for (int c = 0; c < GridView2.Rows[j].Cells.Count; c++)
{
if (GridView2.Rows[j].Cells[c].HasControls())
{
Ïà¹ØÎĵµ£º
Ò»¡¢Ð޸ĸñʽ£ºµ÷Õû±íÍ·¾Ó×ó£»
<!--ÔÀ´¸ñʽ-->
/*˵Ã÷£º°ÑÕû¸ö±íÍ·ºÍÒ³ÃæÄÚÈݾÓÖУ¬µ±Ò³ÃæÄÚÈݽϳ¤Ê±£¬±íÍ·Ò²¾ÓÖУ¬¿´ÆðÀ´Ïñ±íÍ·´íλ¡£*/
<div style="position: absolute;top:3px;">
<center>
<!--#include file="inc/glfcd.inc"-->
<br>
±êÌâ
</br& ......
<%
'//////////// GPS£ºGet Picture Size //////////////
'//////////////ÀûÓÃADODB.stream»ñȡͼƬ³ß´ç//////////////
Class GPS
Dim aso
Private Sub Class_Initialize
Set aso=CreateObject("Adodb.Stream")
aso.Mode=3
aso.Type=1
aso.Open
End Sub
Private Sub Class_Terminate
set aso=nothing
En ......
ASPͨ¹ýcookieʵÏÖ×Ô¶¯¼ÇסÃÜÂëµÄ¹¦ÄÜ
°ÑÒÔÏ´úÂë¼ÓÈëÑéÖ¤Ò³£º
<%if Trim(Cstr(request.QueryString("check")))="true" then ‘ÓÃÀ´ÅжÏÊÇ·ñÓÐÑ¡Ôñ¼ÇסÃÜÂë
Response.Cookies("UserCookie")("username") = Trim(Cstr(request.Form("username")))
Response.Cookies("UserCookie")("passwords") = trim ......
´æ´¢½ø³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢½ø³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL SERVER)¡£Èç¹ûÎÒÃÇͨ¹ý´´½¨´æ´¢½ø³ÌÒÔ¼°ÔÚASPÖе÷Óô洢½ø³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓÔÚÒ ......
Á¬½Ó´úÂë1Ö±½ÓÊäÈë
<%
Dim my_conn, sql,rs
Set my_conn = createobject("ADODB.Connection")
my_conn.open = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_ '·þÎñÆ÷Ãû
& "DATABASE=mybase;"_ 'Êý¾Ý¿âÃû
& "UID=root;PWD=111; OPTION=35;" 'Óû§ÃûºÍÃÜÂë
Set rs = Server.Crea ......