http://www.w3schools.com/tags/ref_httpmethods.asp
- GET requests can be cached
- POST requests are never cached
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;
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PostDemo.aspx.cs" Inherits="PassValuesBetweenPages.PostDemo" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" method="post" action="PostDemo.aspx?p1=test456">
<div>
<input name="test" value="test123" type="text" />
<input type="submit" value="送出" />
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace PassValuesBetweenPages
{
public partial class PostDemo : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Form["test"] != null)
{
string strTest = Request.Form["test"].ToString();
string strP1 = Request.QueryString["p1"].ToString();
Response.Write("test : " + strTest);
Response.Write("p1 : " + strP1);
}
}
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="FormSubmit.aspx.cs" Inherits="PassValuesBetweenPages.FormSubmit" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
function submitform() {
document.forms[0].submit();
}
</script>
</head>
<body>
<form id="form1" method="post" action="FormSubmit.aspx">
<div>
<input name="test" value="test123" type="text" />
<a href="javascript: submitform()">Submit</a>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace PassValuesBetweenPages
{
public partial class FormSubmit : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Form["test"] != null)
{
string strTest = Request.Form["test"].ToString();
Response.Write("Form POST : " + strTest);
}
}
}
}