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




What is the value of dataRow["y"] when you look at it in the debugger?

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.