顯示具有 C# 標籤的文章。 顯示所有文章
顯示具有 C# 標籤的文章。 顯示所有文章

2014年10月24日 星期五

使用 FormsAuthentication.SetAuthCookie

使用FormsAuthentication.SetAuthCookie

var acct = "spring";
FormsAuthentication.SetAuthCookie(acct, false);

2014年10月22日 星期三

this在C#與JavaScript的不同

this in C#

class Program
    {
        static void Main(string[] args)
        {
            Lilo lilo = new Lilo();
            //lilo.strStitch 指向 類別Lilo的 public string strStitch;
            Console.WriteLine("{0} 是我的家人 !!", lilo.strStitch);
            Console.ReadLine();
        }
        class Lilo
        {
            public string strStitch;
            public Lilo()
            {
                string strStitch;
                strStitch = "STITCH";
                //this.strStitch 指向 public string strStitch;
                this.strStitch = strStitch;
            }
        }
    }

this in JavaScript

var lilo = {
  stitch : 'STITCH',
  f: function(){
    console.log(this.stitch + " 是我的家人 !!");
  }
};
//調用f函式後,f內的this指向點f()前面的lilo
lilo.f();

ASP.NET MVC Web API 資料庫處理 using

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using System.Net.Http.Formatting;
using System.Data;
using MvcMusicStore.Models;
using System.Data.Entity;
using System.Configuration;
using System.Data.SqlClient;

namespace MvcMusicStore.Controllers
{
    public class ExtJSApiController : ApiController
    {     
        public dynamic ReviewDataGet(FormDataCollection form)
        {
            string conn = ConfigurationManager.ConnectionStrings["MvcMusicStoreContext"].ConnectionString;
            DataTable dt = new DataTable();
            string strCheck = form.Get("x");
            string strAlbumID = form.Get("AlbumID");
            string strTitle = form.Get("Title");
            using (SqlConnection sqlConnection = new SqlConnection(conn))
            {
                string strSql = "SELECT * FROM Albums WHERE AlbumID LIKE @AlbumID AND Title LIKE @Title";

                SqlCommand sqlCommand = new SqlCommand(strSql, sqlConnection);
                sqlCommand.Parameters.AddWithValue("@AlbumID", "%" + strAlbumID + "%");
                sqlCommand.Parameters.AddWithValue("@Title", "%" + strTitle + "%");
                sqlConnection.Open();
                dt.Load(sqlCommand.ExecuteReader());
            }
            DataSet ds = new DataSet();
            ds.Tables.Add(dt);
            return new ApiResponse()
            {
                success = true,
                msg = "",
                ds = ds
            };
        }
        public dynamic AlbumComboGet()
        {
            DataTable dt = new DataTable();
            using (SqlConnection sqlConnection = new SqlConnection(conn))
            {
                string strSql = "SELECT AlbumID AS 'TEXT',AlbumID AS 'VALUE' FROM Albums";
                SqlCommand sqlCommand = new SqlCommand(strSql, sqlConnection);
                sqlConnection.Open();
                dt.Load(sqlCommand.ExecuteReader());
            }
            return dt;
        }
    }
    public class ApiResponse
    {
        public DataSet ds { get; set; }
        public string msg { get; set; }
        public bool success { get; set; }
    }
}


2014年9月24日 星期三

DataTable to List to Json

DataTable to List

var r = Shared.Process(this.ws, "TraBULLETINGet", form);

List<Bulletin> bulletin = new List<Bulletin>();

foreach (DataRow dr in r.ds.Tables["T1"].Rows)
 {
   bulletin.Add(new Bulletin { TITLE = dr["TITLE"].ToString(), DES = dr["DES"].ToString(), CREATE_DATE = dr["CREATE_DATE"].ToString() });
 }

var jsonSerialiser = new JavaScriptSerializer();
var json = jsonSerialiser.Serialize(bulletin);

public class Bulletin
 {
     public string TITLE { get; set; }
     public string DES { get; set; }
     public string CREATE_DATE { get; set; }
 }

.NET讀取csv檔

錯誤:不是一個有效的路徑。請確定路徑名稱是拼對的,而且檔案位於您所連接的伺服器上。

string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\;Extended Properties='text'";
using (OleDbConnection conn = new OleDbConnection(strConn))
{
   DataTable dt = new DataTable();
   using (OleDbDataAdapter adapter = new OleDbDataAdapter(@"select  * from [aa.csv]", conn))
     {
       adapter.Fill(dt);
     }
}

2014年9月14日 星期日

ASP.NET MVC (Model, View, Controller 簡單範例)

Model

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace WebApplication1.Models
{
    public class Album
    {
        public int AlbumID { get; set; }
        public string Title { get; set; }
    }
}

List Controller

public ActionResult Index()
        {
            List albums = new List();
            albums.Add(new Album { AlbumID = 1, Title = "Sting" });
            albums.Add(new Album { AlbumID = 2, Title = "Joan" });
            return View(albums);
        }

List View

@model IEnumerable<WebApplication1.Models.Album>

@{
    ViewBag.Title = "Index";
}

<h2>Index</h2>

<p>
    @Html.ActionLink("Create New", "Create")
</p>
<table class="table">
    <tr>
        <th>
            @Html.DisplayNameFor(model => model.Title)
        </th>
        <th></th>
    </tr>

@foreach (var item in Model) {
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.Title)
        </td>
        <td>
            @Html.ActionLink("Edit", "Edit", new { id=item.AlbumID }) |
            @Html.ActionLink("Details", "Details", new { id=item.AlbumID }) |
            @Html.ActionLink("Delete", "Delete", new { id=item.AlbumID })
        </td>
    </tr>
}

</table>

Detail Controller

public ActionResult Details(int id)
        {
            var album = new Album { AlbumID = id, Title = "Hello" };
            return View(album);
        }

Detail View

@model WebApplication1.Models.Album

@{
    ViewBag.Title = "Details";
}

<h2>Details</h2>

<div>
    <h4>Album</h4>
 <hr />
    <dl class="dl-horizontal">
        <dt>
            @Html.DisplayNameFor(model => model.Title)
        </dt>

        <dd>
            @Html.DisplayFor(model => model.Title)
        </dd>

    </dl>
</div>
<p>
    @Html.ActionLink("Edit", "Edit", new { id = Model.AlbumID }) |
    @Html.ActionLink("Back to List", "Index")
</p>

2014年9月3日 星期三

C#執行EXE檔加參數

C#執行EXE檔加參數
string text = "";
string strUser = "894128";
string strPath = HttpContext.Current.Server.MapPath("~/OfficeUpload/");
System.IO.File.WriteAllText(strPath + strUser + ".txt", text);
ProcessStartInfo psi = new ProcessStartInfo();
psi.FileName = Path.GetFileName(strPath + "/StockMergeRpt.exe");
psi.WorkingDirectory = Path.GetDirectoryName(strPath + "/StockMergeRpt.exe");
psi.Arguments = "-i " + strUser + ".txt -o " + strUser + ".doc";
Process.Start(psi);

2014年8月25日 星期一

DataSet 轉 XML (xml,xsd)

DataTable轉XML
DataTable dt = new DataTable("WPN");
dt.Columns.AddRange(new DataColumn[] {
   //new DataColumn("JCN",typeof(string),"",MappingType.Attribute),
   new DataColumn("ID1",typeof(string)),
   new DataColumn("ID2",typeof(string)),
   new DataColumn("NO",typeof(int)),
   new DataColumn("DT",typeof(DateTime))
  });

  dt.Columns["JCN"].MaxLength= 15;
  dt.Columns["MSNM"].MaxLength = 80;
           
  DateTime x = DateTime.Now;
  dt.PrimaryKey = new DataColumn[] { dt.Columns["ID1"], dt.Columns["ID2"]};

  dt.Rows.Add(new object[] { "WP001", "WP002", 3, Convert.ToDateTime("2014/06/25 10:16:08")});

  DataSet ds = new DataSet("WP");
  ds.Tables.Add(dt);

  ds.WriteXml("D:\\test.xml");
  ds.WriteXmlSchema("D:\\test.xsd");
驗證XSD
http://msdn.microsoft.com/en-us/library/3740e0b5(v=vs.110).aspx
string xmlFile = Server.MapPath("D:\\test.xml");
string xsdFile = Server.MapPath("D:\\test.xsd");

XmlTextReader textReader = new XmlTextReader(xmlFile);
XmlValidatingReader validatingReader = new XmlValidatingReader(textReader);
validatingReader.Schemas.Add(null, xsdFile);
validatingReader.ValidationType = ValidationType.Schema;
validatingReader.ValidationEventHandler += new ValidationEventHandler(validatingReader_ValidationEventHandler);

while (validatingReader.Read()){

}
validatingReader.Close();
public void validatingReader_ValidationEventHandler(object sender, ValidationEventArgs e)
{
   Response.Write("Error Message : " + e.Message);
}

2014年7月5日 星期六

.NET存取Oracle資料庫相關Provider說明,ODBC、OleDb、OracleClient、ODAC

使用時確認各Provider支援的Oracle版本


1).NET Framework Data Provider for ODBC:

(Open Database Connectivity,開放資料庫互連)提供了標準的API方法來存取資料庫管理系統。尚未有ODBC之前,若要開發資料庫應用程式,必須使用資料庫廠商隨資料庫產品一同發行的一些工具集來存取資料庫。微軟於1992年發表了ODBC。
using System.Data;
using Microsoft.Data.Odbc;

     {
       OdbcConnection cn;
       OdbcCommand cmd;
       string MyString;

       MyString="Select * from Customers";

       cn= new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=myOracleServer;UID=spring;PWD=spring;");

       cmd=new OdbcCommand(MyString,cn);
       cn.Open();

       MessageBox.Show("Connected");

       cn.Close();
     }

2).NET Framework Data Provider for OLE DB:

是微軟為以統一方式存取不同型別的資料儲存設計的一種應用程式介面,是一組用元件物件模型(COM)實作的介面。OLE DB Provider for Oracle Client,呼叫 Oracle 資料庫的 OLE DB 資料提供者,通常由 Oracle 原廠提供。
using System.Data;
using System.Data.OleDb;

        {
            OleDbConnection cn;
            OleDbCommand cmd;
            string MyString;

            MyString = "Select * from Customers";

            cn = new OleDbConnection("Data Source=myOracleServer;Provider=OraOLEDB.Oracle.1;User Id=spring;Password=spring");

            cmd= new OleDbCommand(MyString,cn);
            cn.Open();

            MessageBox.Show("Connected");

            cn.Close();
        }

3).NET Framework Data Provider for Oracle:

支援Oracle用戶端軟體8.1.7(含)以後版本。Visual Studio 2010後建議使用ODP.NET。
(Microsoft:The types in System.Data.OracleClient are deprecated)
using System.Data;
using System.Data.OracleClient;

         {

            OracleConnection cn;
            OracleCommand cmd;
            string MyString;

            MyString = "Select * from Customers";

            cn = new OracleConnection("Data Source=myOracleServer;User Id=spring;Password=spring");

            cmd = new OracleCommand(MyString, cn);
            cn.Open();

            MessageBox.Show("Connected");

            cn.Close();

         }

4)ODAC:

(ODP.NET:Oracle Data Provider for .NET)不同版本 Visual Studio 須搭配不同ODAC(Oracle Data Access Components)

Web.config
<add name="Default" connectionString="Data Source=myOracleServer;User Id=spring;Password=spring;providerName="Oracle.DataAccess.Client"/>
using Oracle.DataAccess.Client;

         using (OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["Default"].ConnectionString))
         {
            OracleCommand cmd;
            try
            {
              conn.Open();
              cmd = new OracleCommand();
              cmd.Connection = conn;
              cmd.CommandText = "";

              cmd.ExecuteNonQuery();
             }
             catch (Exception ex)
             {}
             //使用using不需要close與dispose
             //finally
             //{
             //    cmd.Dispose();
             //    conn.Close();
             //    conn.Dispose();
             //}    
          }

2014年7月2日 星期三

SQL SERVER 編碼


SQL SERVER各種欄位型態編碼

select data_type, character_set_catalog, character_set_schema, character_set_name,collation_catalog, collation_schema, collation_name, count(*) count from information_schema.columns group by data_type, character_set_catalog, character_set_schema, character_set_name,collation_catalog, collation_schema, collation_name;


編碼說明(In SQL SERVER)

  • Big5(cp950) : 中文字占 2Byte 
  • Unicode(UTF-16) : 中文字占 2Byte
  • UTF-8 : 中文字占 3Byte 
例:
varchar(2) : 2Byte,可放1個中文字
nvarchar(2) : 4Byte,可放2個中文字