在ASP.NET中如何将HTML中的TABLE的数据导入MS SQL数据库？

Question

TABLE数据也是从数据库中取的。(是想达到将一个局域网的服务器的数据库的数据导入到网站服务器的SQL中)
这里通过DSN连接将局域网SQL的数据存放在TABLE中
CODE: 
<table cellspacing="0">  
 <tbody id="table1">  
 </tbody>  
 </table>
JS：
    <script language=javascript>  
     function replace()  
    {  
        var sql=$("sql").value;   
        if(sql=="")  
        {  
            $("msg").innerHTML="Please input a select sentence.";         
            return ;          
        }   
       $("msg").innerHTML="";  
          var sql=sql;           
          var ConnDB=new ActiveXObject("ADODB.Connection");  
          var rs=new ActiveXObject("ADODB.Recordset");   
         ConnDB.ConnectionString="DSN=mysql;uid=root;pwd=1234";   
            
           ConnDB.open()  
          rs.open(sql,ConnDB,1,1);              
           var tr=document.createElement("tr");          
           tr.style.backgroundColor="#FFE28C";       
           for(i=0;i<rs.fields.count;i++)  
           {  
               td=document.createElement("th");              
               td.innerHTML=rs.fields(i).name;           
               tr.appendChild(td);           
           }  
           $("table1").appendChild(tr);       
           var v;        
           while(!rs.EOF)  
           {  
               var tr=document.createElement("tr");              
               for(i=0;i<rs.fields.count;i++)  
               {                 
                   td=document.createElement("<td nowrap></td>");                
                   v=rs.fields(i).value;                 
                   if(v==""||v==null||v==undefined)  
                   {  
                       v="--";                   
                  }  
                   if(typeof (v)=="date")  
                   {  
                      var d=new Date(v).toLocaleString ();                      
                       v=d;                      
                   }  
                   td.innerHTML=v;               
                   tr.appendChild(td);               
               }  
               $("table1").appendChild(tr);           
               rs.MoveNext  
           }  
           rs.close();       
           ConnDB.close();       
   }  
   function clr()  
   {  
       while($("table1").childNodes.length>0)  
       {  
           $("table1").removeChild($("table1").lastChild)  
       }  
   }  
   function $(id)  
   {  
       return document.getElementById(id);  
   }  
   </script> 
现在该如何将TABLE1中的数据导入数据库？

Answer 1

把table传到下面的方法内
CreateNewRequisition.aspx是处理页面，在这里用requestor抓取然后拆分，接下来在后台处理就会了吧~function FillNameData(ob)
        {
            xmlhttp =new ActiveXObject("Microsoft.XMLHTTP");
            xmlhttp.open("Post","CreateNewRequisition.aspx?vName="+ob.innerHTML);
            xmlhttp.onreadystatechange=FillDataByName;
            xmlhttp.send(null);
        }

Answer 2

先抓取
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Net;
using System.IO;
using System.IO.Compression;
using System.Text.RegularExpressions;namespace WikiPageCreater.Common
{
    public class PageHelper
    {
        /// <summary>
        /// 根据 url 获取网页编码
        /// </summary>
        /// <param name="url"></param>
        /// <returns></returns>
        public static string GetEncoding(string url)
        {
            HttpWebRequest request = null;
            HttpWebResponse response = null;
            StreamReader reader = null;
            try
            {
                request = (HttpWebRequest)WebRequest.Create(url);
                request.Timeout = 20000;
                request.AllowAutoRedirect = false;                response = (HttpWebResponse)request.GetResponse();
                if (response.StatusCode == HttpStatusCode.OK && response.ContentLength < 1024 * 1024)
                {
                    if (response.ContentEncoding != null && response.ContentEncoding.Equals("gzip", StringComparison.InvariantCultureIgnoreCase))
                        reader = new StreamReader(new GZipStream(response.GetResponseStream(), CompressionMode.Decompress));
                    else
                        reader = new StreamReader(response.GetResponseStream(), Encoding.ASCII);                    string html = reader.ReadToEnd();                    Regex reg_charset = new Regex(@"charset\b\s*=\s*(?<charset>[^""]*)");
                    if (reg_charset.IsMatch(html))
                    {
                        return reg_charset.Match(html).Groups["charset"].Value;
                    }
                    else if (response.CharacterSet != string.Empty)
                    {
                        return response.CharacterSet;
                    }
                    else
                        return Encoding.Default.BodyName;
                }
            }
            catch
            {
            }
            finally
            {                if (response != null)
                {
                    response.Close();
                    response = null;
                }
                if (reader != null)
                    reader.Close();                if (request != null)
                    request = null;            }            return Encoding.Default.BodyName;
        }        /// <summary>
        /// 根据 url 和 encoding 获取当前url页面的 html 源代码        
       /// </summary>
        /// <param name="url"></param>
        /// <param name="encoding"></param>
        /// <returns></returns>
        public static string GetHtml(string url, Encoding encoding)
        {
            HttpWebRequest request = null;
            HttpWebResponse response = null;
            StreamReader reader = null;
            try
            {
                request = (HttpWebRequest)WebRequest.Create(url);
                request.Timeout = 20000;
                request.AllowAutoRedirect = false;                response = (HttpWebResponse)request.GetResponse();
                if (response.StatusCode == HttpStatusCode.OK && response.ContentLength < 1024 * 1024)
                {
                    if (response.ContentEncoding != null && response.ContentEncoding.Equals("gzip", StringComparison.InvariantCultureIgnoreCase))
                        reader = new StreamReader(new GZipStream(response.GetResponseStream(), CompressionMode.Decompress), encoding);
                    else
                        reader = new StreamReader(response.GetResponseStream(), encoding);
                    string html = reader.ReadToEnd();                    return html;
                }
            }
            catch
            {
            }
            finally
            {                if (response != null)
                {
                    response.Close();
                    response = null;
                }
                if (reader != null)
                    reader.Close();                if (request != null)
                    request = null;            }            return string.Empty;
        }
    }
}
截取table 信息替换特殊符号
 /// <summary>
        /// 插入SQL时替换字符
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public static string Encode(string str)
        {
            str = str.Replace("'", "''");
            str = str.Replace("\"", "&quot;");
            str = str.Replace("<", "&lt;");
            str = str.Replace(">", "&gt;");
            str = str.Replace("\n", "<br>");
            str = str.Replace("“", "&ldquo;");
            str = str.Replace("”", "&rdquo;");
            return str;
        }        /// <summary>
        /// 取SQL值时还原字符
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public static string Decode(string str)
        {
            str = str.Replace("&rdquo;", "”");
            str = str.Replace("&ldquo;", "“");
            str = str.Replace("<br>", "\n");
            str = str.Replace("&gt;", ">");
            str = str.Replace("&lt;", "<");
            str = str.Replace("&quot;", "\"");
            str = str.Replace("''", "'");
            return str;
        }
插入就正常的insert.

Answer 3

我还想问下，var ConnDB=new ActiveXObject("ADODB.Connection");   
这个只支持IE内核的浏览器，火狐不支持怎么办，像我这种：
--先将一个局域网的服务器的数据库的数据导入到另一个网站服务器的SQL中怎么处理，除了用JS通过DSN先把数据读取到客户端，再导入。还有什么方法不？