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:)


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)

        protected void createdb(string path)
                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;

                if (!(File.Exists(fileName)))
                    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)