string Result = "";
using (SqlConnection Conn = new SqlConnection())
{
    //DB連線字串
    Conn.ConnectionString = WebConfigurationManager.ConnectionStrings["ASPNETDB"].ConnectionString;
    //SQL Command
    string SqlStr = @"INSERT INTO WebRssPath (WebName, WebRssXmlPath) VALUES (@WebName, @WebRssXmlPath)";
    SqlCommand cmd = new SqlCommand(SqlStr, Conn);
    //SQL Parameter
    cmd.Parameters.AddWithValue("@WebName", WebName);
    cmd.Parameters.AddWithValue("@WebRssXmlPath", WebRssXmlPath);
    //開啟連線
    Conn.Open();
    try
    {
        cmd.ExecuteNonQuery();
        Result = "寫入成功";
    }
    catch (Exception ex)
    {
        Result = ex.Message.ToString() + " / " + ex.StackTrace.ToString();
    }
    finally
    {
        //關閉連線
        cmd.Dispose();
        Conn.Close();
        Conn.Dispose();
    }
}
return Result;
KB-當心SqlDataReader.Close時的額外資料傳輸量
 
 
沒有留言:
張貼留言