請問Access轉SQL! |
|
小新
更新時間:2008/6/17 下午 10:37:33 |
|
Dim ads As New AccessDataSource("~/App_data/webData.mdb", "")
已經把access的資料庫轉成sql了! 原本ACCESS要改成SQL的要如何改呢? 小孩我天真的改成
Dim ads As New SqlDataSource("~/App_data/webData.mdf", "")
|
|
|
|
小新
更新時間:2008/6/17 下午 11:37:15 |
|
之後我改 Dim ads As New System.Web.UI.WebControls.SqlDataSource ads.ConnectionString = "Data Soruce=DAVID_NB; Initial Catalog=Northwind;User ID=sa" ads.SelectCommand = "select * from 討論區 where 回應=" & uid & " order by uid " Dim dv As Data.DataView = ads.Select(New DataSourceSelectingEventArgs)
卻說我DataSourceSelectingEventArgs沒宣告
哀哀哀哀!!
|
|
|
|
小新
更新時間:2008/6/18 下午 12:21:42 |
|
以解決! |
|
|
|
|
|
|
|