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時的額外資料傳輸量
沒有留言:
張貼留言