string location = Environment.CurrentDirectory;
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + location + "\\harita.accdb";
// get records from the Shippers table
string commandString = "Select x from map";
//create the data set command object and the DataSet
OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString, connectionString);
DataSet ds = new DataSet();
// fill the data set object
DataAdapter.Fill(ds, "map");
// Get the one table from the DataSet
DataTable dataTable = ds.Tables[0];
// for each row in the table, display the info
foreach (DataRow dataRow in dataTable.Rows)
{
// listBox1.Items.Add(dataRow["x"]);
tb.Text = Convert.ToString(dataRow["x"]);
tbb.Text = Convert.ToString(dataRow["y"]);
#region Draw Icon
if (drawicon)
{
double lon = Convert.ToDouble(tb.Text);
tb.Text = Convert.ToString(dataRow["x"]);
double lat = Convert.ToDouble(tbb.Text);
e.Graphics.DrawImage((Image)(harita1.Properties.Resources.icon), new Rectangle((int)(lon), (int)(lat), 23, 23));
}
#endregion
}
adem87 0 Newbie Poster
Momerath 1,327 Nearly a Senior Poster Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.