Jquery-UI Table排序

<script type='text/javascript' src='https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js'></script>
<script type='text/javascript' src='https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.18/jquery-ui.min.js'></script>

<script type="text/javascript">

閱讀更多 »

C# DataTable Linq查詢

using System.Linq;

SqlConnection conn = new SqlConnection("連線字串");
 conn.Open();

DataTable dt = new DataTable();
using (SqlCommand com = new SqlCommand("SELECT * FROM MOC_Base", conn))
{
    SqlDataAdapter ad = new SqlDataAdapter(com);
    ad.Fill(dt);
}

  var query = from data in dt.AsEnumerable()
                    where data.Field<int>("baseId") == 1
                    select data;   //輸出欄位

foreach (var item in query)
{
      //找到物件需要做的事情
}

C# 讀取資料庫

using System.Data;
using System.Data.SqlClient;

SqlConnection conn = new SqlConnection("Data Source=IP ;Initial Catalog=DataBase ;Persist Security Info=True; User ID=ID ;Password=Pass");
conn.Open();

SqlCommand cmd = new SqlCommand("Select * FROM DataBase", conn);
cmd.ExecuteNonQuery();   //執行sql語法

Jquery 剖析 JSON

var json = "{\"aaa\":\"111\",\"bbb\":\"222\"}";
var jsonData = eval( '(' + json + ')');   //轉為json格式
 
$.each(jsonData, function (index, item) {
    alert(index + ": " + item);
});

C# Json 剖析

下載json套件

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;


string originalJson =＠ "{\"aaa\":\"111\",\"bbb\":\"222\"}";
JObject jObject = JObject.Parse(originalJson);

Dictionary<string, object> values = JsonConvert.DeserializeObject<Dictionary<string, object>>(jObject.ToString());

foreach (var value in values)
{
    string k = value.Key;
     string v = value.Value.ToString();
         
       if (v.IndexOf("[") != -1)
       {
           v = v.Substring(1, v.Length - 3);

            jObject = JObject.Parse(v);
        }
         
}            

C# 停止IE的 catch

// Stop Caching in IE
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);

Jquery AJAX

前台：
<input id="Button1" type="button" value="回復" onclick="SelectChange()"/>
function SelectChange() {
        var str1 = "test";

        var ajaxUrl = 'SelectUpdata.ashx';
        var data = { s1: str1 };
        $.ajax({
            async: false,
            type: 'POST',
            url: ajaxUrl,
            data: data,
            dataType: 'text',
            success: function (s1) {    //執行成功後接收回傳值
                alert(s1);
            },
            complete: function () {    //執行結束
                alert('OK');
             },
             beforeSend: function () {    //開始執行
                 alert('請稍等');
             }

        });

    }

後台：
.ashx
string select = context.Request["s1"];
context.Response.ContentType = "text/plain";
context.Response.Write(select );

C＃讀取 .txt檔

using System.IO;
using System.Text;

string path = "C:\\Documents and Settings\\USER\\桌面\\json.txt";
string text = "";
using (StreamReader sr = new StreamReader(path, Encoding.Default))
{
    text += sr.ReadToEnd();
}

C# 讀取excel

//限.xlsx
string filePath = @"C:\Documents and Settings\USER\桌面\各縣市彙整.xlsx";
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES\";";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter oleDBdataAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataSet dataSet = new DataSet();
oleDBdataAdapter.Fill(dataSet);

C# 連線資料庫-存入資料

strConn = @"Data Source=IP;Initial Catalog=III_PEO;Persist Security Info=True;User ID=sa;Password=sa";
using(SqlConnection SqlSvrCon = new SqlConnection(strConn))
{
    SqlSvrCon.Open();
    using (SqlCommand cmd = new SqlCommand("insert into Excel_Local_Result (city, caseId,  
    bulidingId values (@city, @caseId, @bulidingId)", SqlSvrCon))
   {
        string city = "台北"
                 caseId = "055",
                 bulidingId = "066";

        cmd.Parameters.AddWithValue("@city", city);
        cmd.Parameters.AddWithValue("@caseId", caseId);
        cmd.Parameters.AddWithValue("@bulidingId", bulidingId);
        cmd.ExecuteNonQuery();
    }

}

C＃ JSON 剖析 (root)

下載json套件

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

閱讀更多 »