none
The best overload method match for 'system.convert.todouble' has some invalid arguments RRS feed

  • Question

  • hi here is my code my error is mentioned in the title can anyone help how to resolve iam defing in the code where the error is getting

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Data;
    using System.Data.SqlClient;
    using System.Configuration;

    namespace center
    {
        public partial class WebForm1 : System.Web.UI.Page
        {
            SqlConnection cn= new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());


           
            SqlDataAdapter da = null;
            SqlCommand cmd = null;
            DataSet ds = null;
            DataSet ds1 = null;
            
            
            protected void Page_Load(object sender, EventArgs e)
            {
                DataSet dd1 = get();
                DataSet dd2 = get1();
                
                g1.DataSource = ds.Tables[0];
                g1.DataSource = ds1.Tables[0];
                g1.DataBind();
                for (int i = 0; i < dd2.Tables[0].Rows.Count; i++)
                {
                    for (int j = 0; j < dd1.Tables[0].Rows.Count; j++)
                    {
                        //if ((dd1.Tables[0].Rows[i]["X"] == dd2.Tables[0].Rows[i]["X"]) && (dd1.Tables[0].Rows[i]["Y"] == dd2.Tables[0].Rows[i]["Y"]) &&
                        //    (dd1.Tables[0].Rows[i]["W"] == dd2.Tables[0].Rows[i]["W"]) && (dd1.Tables[0].Rows[i]["H"] == dd2.Tables[0].Rows[i]["H"]))
                        //{
                        //    string PageName = dd1.Tables[0].Rows[i]["PageNumber"].ToString();
                        //}
                        if (Convert.ToDouble(dd2.Tables[0].Rows[i]["X"].ToString()) == Convert.ToDouble(dd1.Tables[0].Rows[j]["X"].ToString()) && Convert.ToDouble(dd2.Tables[0].Rows[i]["Y"].ToString()) == Convert.ToDouble(dd1.Tables[0].Rows[j]["Y"].ToString()) &&
                            Convert.ToDouble(dd2.Tables[0].Rows[i]["W"].ToString()) == Convert.ToDouble(dd1.Tables[0].Rows[j]["W"].ToString()) && Convert.ToDouble(dd2.Tables[0].Rows[i]["H"].ToString()) == Convert.ToDouble(dd1.Tables[0].Rows[j]["H"].ToString()))
                        {
                            string PageName = dd2.Tables[0].Rows[i]["ADVERTISEMENTID"].ToString();
                            get2(Convert.ToDouble(dd2.Tables[0].Rows[i]["X"], Convert.ToDouble(dd2.Tables[0].Rows[i]["Y"], Convert.ToDouble(dd2.Tables[0].Rows[i]["W"], Convert.ToDouble(dd2.Tables[0].Rows[i]["H"]); // ERROR IS THE TITLE
                        }
                    }
                }
            }
            public DataSet get()
            {
                string str = "select * from tbl_Manifest";
                cn.Open();
                SqlCommand cmd = new SqlCommand(str, cn);
                da = new SqlDataAdapter(cmd);
                ds = new DataSet();
                da.Fill(ds);
                cn.Close();
                return ds;
            }
            public DataSet get1()
            {
                string str1 = "select * from tbl_Advertisement";           
                cn.Open();
                SqlCommand cmd = new SqlCommand(str1, cn);
                da = new SqlDataAdapter(cmd);
                ds1 = new DataSet();
                da.Fill(ds1);
                cn.Close();
                return ds1;
            }
            public void get2(double X, double Y, double W, double H)
            {
                string str2 = "update tbl_Manifest set ADVERTISEMENTID = ADVERTISEMENTID WHERE X='"+X+"' AND Y='"+Y+"' AND W='"+W+"' AND H='"+H+"'";
                cn.Open();
                SqlCommand cmd = new SqlCommand(str2, cn);
               // var param = new SqlParameter("ADVERTISEMENTID", SqlDbType.VarChar);
                cmd.CommandType = CommandType.Text;
                cmd.ExecuteNonQuery();
                cn.Close();
                
            }
        }
    }

    Monday, September 22, 2014 1:16 PM

Answers

  • You just forget few brackets:

    get2(Convert.ToDouble(dd2.Tables[0].Rows[i]["X"]), Convert.ToDouble(dd2.Tables[0].Rows[i]["Y"]), Convert.ToDouble(dd2.Tables[0].Rows[i]["W"]), Convert.ToDouble(dd2.Tables[0].Rows[i]["H"]));

    • Proposed as answer by CoolDadTx Monday, September 22, 2014 2:06 PM
    • Marked as answer by Dileep Kumar.K Monday, September 22, 2014 2:09 PM
    Monday, September 22, 2014 1:28 PM