使用FormsAuthentication.SetAuthCookie
var acct = "spring"; FormsAuthentication.SetAuthCookie(acct, false);
var acct = "spring"; FormsAuthentication.SetAuthCookie(acct, false);
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;
}
}
}
var lilo = {
stitch : 'STITCH',
f: function(){
console.log(this.stitch + " 是我的家人 !!");
}
};
//調用f函式後,f內的this指向點f()前面的lilo
lilo.f();
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; }
}
}
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; }
}
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);
}
}
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; }
}
}
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);
}
@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>
public ActionResult Details(int id)
{
var album = new Album { AlbumID = id, Title = "Hello" };
return View(album);
}
@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>
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);
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");
驗證XSDstring 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);
}
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();
}
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();
}
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();
}
<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();
//}
}
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;