Sharepoint 2007 Connecting Site (x64) through Visual Studio 2008

1. First Open visual Studio 2008 in Administrator mode.
2. Create a new project of Template “Web Application” from New ==> Project menu selection.
3. Go to Solution Explorer: WebApplication Header ==> Properties == > Applicatoin ==> Platform Target. Change it to x64.
4. Add Microsoft.Sharepoint and Microsoft.Sharepoint.Search DDLs from Following Path. C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI\
5. Create a Web Application on IIS (on a new port number).
6. Come to Visual Studio Go to: WebApplication Header ==> Properties == > Web ==> Use Local IIS Web Server.
7. Write down the path of the Web app and virtual directory created. mark overwrite existing and Save.
8. Now in page load method you can code something like this to fetch data from your list and populate a dataset. change the path and names as your requirement.

if (!IsPostBack)
{
DataTable dtTypes = new DataTable();

dtTypes.Columns.Add(new DataColumn(“TypeID”));
dtTypes.Columns.Add(new DataColumn(“Description”));

//string webName = ConfigurationManager.AppSettings[“webName”].ToString();
// string LibraryName = ConfigurationManager.AppSettings[“LibraryName”].ToString();
//string siteURL = ConfigurationManager.AppSettings[“siteURL”].ToString();

SPUserToken userToken = null;
SPSecurity.RunWithElevatedPrivileges(() =>
{
using (SPSite site = new SPSite(“http://ablmossapp:700/”))
{
using (SPWeb web = site.OpenWeb(“AuditReportSite”))
{
userToken = web.AllUsers[“cokexsrv\\ablmossadmin”].UserToken;
}
}
});

using (SPSite site1 = new SPSite(“http://ablmossapp:700/”, userToken))
{
using (SPWeb web = site1.OpenWeb(“AuditReportSite”))
{
SPList taskList = web.Lists[“List Type”];

foreach (SPItem spitem in taskList.Items)
{

DataRow row = dtTypes.NewRow();
row[“TypeID”] = spitem[“TypeID”].ToString();
row[“Description”] = spitem[“Type Description”].ToString();
dtTypes.Rows.Add(row);
}
}

}

ddlReportType.DataTextField = “Description”;
ddlReportType.DataValueField = “TypeID”;

ddlReportType.DataSource = dtTypes;
ddlReportType.DataBind();

}
You will get the data.