[問題] 簡易的行程表程式問題
我照這書上寫了簡易行程表的程式碼
我使用的是ASP.NET
但卻出現了NullReferenceException的問題
請問是哪裡寫錯了
以下是我的程式碼
Protected Sub Calendar1_DayRender(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.DayRenderEventArgs) Handles Calendar1.DayRender
Dim setting As ConnectionStringSettings =
ConfigurationManager.ConnectionStrings("Schedule")
Dim factory As DbProviderFactory =
DbProviderFactories.GetFactory(setting.ProviderName)<==就是這邊出現這問題
Using db As DbConnection = factory.CreateConnection()
db.ConnectionString = setting.ConnectionString
Dim comm As DbCommand = factory.CreateCommand()
comm.CommandText = "SELECT sid, subject, stime FROM Schedule
WHERE sdate=@sdate"
comm.Connection = db
Dim param As DbParameter = factory.CreateParameter()
param.ParameterName = "@sdate"
param.Value = e.Day.Date.ToString("yyyy/MM/dd")
comm.Parameters.Add(param)
db.Open()
Dim reader As DbDataReader = comm.ExecuteReader()
Do While reader.Read()
Dim ltrCr As New LiteralControl("<br />")
Dim link As New HyperLink()
link.NavigateUrl = "Details.aspx?sid=" & reader.GetInt32(0)
link.Text = reader.GetString(2) & " " &
reader.GetString(1)
e.Cell.Controls.Add(ltrCr)
e.Cell.Controls.Add(link)
Loop
End Using
End Sub
End Class
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.115.146.153
→
11/29 00:35, , 1F
11/29 00:35, 1F
→
11/29 00:37, , 2F
11/29 00:37, 2F
→
11/29 00:37, , 3F
11/29 00:37, 3F
→
11/29 00:37, , 4F
11/29 00:37, 4F
→
11/29 00:38, , 5F
11/29 00:38, 5F
→
11/29 00:38, , 6F
11/29 00:38, 6F
→
11/29 00:39, , 7F
11/29 00:39, 7F
→
11/29 00:57, , 8F
11/29 00:57, 8F
→
11/29 14:41, , 9F
11/29 14:41, 9F
→
12/02 02:21, , 10F
12/02 02:21, 10F