hi i need some help, i need to creat a file in access 2003 running a aplication asp.net (c#) using a sql query, if anyone knows that plz tell me:)
thanks
Jump to PostSo there are various components regarding your question. You need to be more specific. In addition, if this a homework assignment, you need to put a little more effort in describing the assignment, what you have done so far, and exactly what you are having trouble with.
So there are various components regarding your question. You need to be more specific. In addition, if this a homework assignment, you need to put a little more effort in describing the assignment, what you have done so far, and exactly what you are having trouble with.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ADOX;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;
using ADODB;
namespace WebApplication1
{
public partial class copyAbout : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
createdb("c:\\temp\\my1.mdb");
}
protected void createdb(string path)
{
try
{
string connString;
string fileName = path;
ADODB.Connection myconn = new Connection();
connString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + fileName + "; Jet OLEDB:Engine Type=5";
ADOX.Catalog myCatalog = new Catalog();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServer"].ConnectionString);
string sql = ("SELECT * FROM dbo.aspnet_rolesindir");
SqlCommand com = new SqlCommand();
com.CommandText = sql;
com.Connection = conn;
conn.Open();
if (!(File.Exists(fileName)))
{
myCatalog.Create(connString);
myCatalog = null;
}
myconn.Open(connString, "", "", 0);
myCatalog.ActiveConnection = myconn;
}
catch (Exception e)
{
Console.Write("\n" + e.ToString() + "\n");
}
}
}
}
i have this code, only create a empty database, i want create a database using a sql server query.. export a sql server table to access(mdb)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.