Hello,
i am using Visual Studio 2008 and i am trying to connect a simple database inventory.mdb (i use microsoft office 2002) with asp.net using the following code.
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Runtime.Serialization;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class increase_stock : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button2_Click(object sender, EventArgs e)
{
//SqlConnection con = new SqlConnection("Server=You server name or comp name;Database=Yourdatabasename;Trusted_Connectopn=True");
SqlConnection con = new SqlConnection("Server=Microsoft.Jet.OLEDB.4.0;Database=c:\\inventory.mdb;Trusted_Connectopn=True"); //Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\AccessDB\MyDB.mdb;User Id=admin;Password=;")
SqlCommand cmd = new SqlCommand("select * from all_products");
con.Open();
DataSet ds = new DataSet(cmd, con);
SqlDataAdapter da = new SqlDataAdapter();
da.Fill(ds);
con.Close();
}
}
Error 1 The best overloaded method match for 'System.Data.DataSet.DataSet(System.Runtime.Serialization.SerializationInfo, System.Runtime.Serialization.StreamingContext)' has some invalid arguments J:\my_document\Visual Studio 2008\WebSites\inventory\increase_stock.aspx.cs 30 22 J:\...\inventory\ Error 2 Argument '1': cannot convert from 'System.Data.SqlClient.SqlCommand' to 'System.Runtime.Serialization.SerializationInfo' J:\my_document\Visual Studio 2008\WebSites\inventory\increase_stock.aspx.cs 30 34 J:\...\inventory\ Error 3 Argument '2': cannot convert from 'System.Data.SqlClient.SqlConnection' to 'System.Runtime.Serialization.StreamingContext' J:\my_document\Visual Studio 2008\WebSites\inventory\increase_stock.aspx.cs 30 39 J:\...\inventory\
Configuration: Windows XP Firefox 3.0.14