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