ASP.NET (VB.NET) Database connection - How to FILL a Dataset
Posted on 2007-07-25
Hi I am very new to ASP programming, and am having problems around database connections, I have inherited aweb-site designed and maintained in Dreamweaver (which is adding to my frustrations) with the code I have being :
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data.system.data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
Sub Page_Load(Src As Object, E As EventArgs)
dim constr as string = "Persist Security Info=False;Data Source=swt005;Initial Catalog=opappslive;User ID=xxxxxx;Password=xxxxxx;"
Dim cmd As sqldataadapter= new SqlDataAdapter(mmm, cnn)
Dim ds As dataset = New DataSet()
the error I am getting is
"Overload resolution failed because no accessible 'Fill' can be called with these arguments"
with the cmd.fill line in the example above being highlighted.
Does anybody have any ideas where I am going wrong, and if so what do I need to do to resolve.