PDA

View Full Version : خطای فرم ویوو و دیتا تیبل



صادق صدقی
چهارشنبه 22 اردیبهشت 1389, 17:33 عصر
سلام

من با دیتا تیبل کار می کنم

این خطا رو بهم می ده
لطفا کمکم کنید

Error:
System.IndexOutOfRangeException: id at System.Data.ProviderBase.FieldNameLookup.GetOrdina l(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(Str ing name) at System.Data.SqlClient.SqlDataReader.get_Item(Strin g name) at EshopeFilm_Default2.Page_Load(Object sender, EventArgs e) in k:\ASP.Net\EShopFilm\EshopeFilm\HomePage.aspx.cs:l ine 49



این هم کدمه


DataTable dt = new DataTable();
DataRow dr = null;
#region Columns
dt.Columns.Add(new DataColumn("id", typeof(string)));
dt.Columns.Add(new DataColumn("Names", typeof(string)));
dt.Columns.Add(new DataColumn("year", typeof(string)));
dt.Columns.Add(new DataColumn("director", typeof(string)));
dt.Columns.Add(new DataColumn("actor", typeof(string)));
dt.Columns.Add(new DataColumn("award", typeof(string)));
dt.Columns.Add(new DataColumn("Ganre", typeof(string)));
dt.Columns.Add(new DataColumn("coutnry", typeof(string)));
dt.Columns.Add(new DataColumn("Disc", typeof(string)));
dt.Columns.Add(new DataColumn("ImageUrl", typeof(string)));
dt.Columns.Add(new DataColumn("StarFilm", typeof(string)));
dt.Columns.Add(new DataColumn("bsubTitle", typeof(string)));
dt.Columns.Add(new DataColumn("bTopFilm", typeof(string)));
dt.Columns.Add(new DataColumn("FirstActor", typeof(string)));
dt.Columns.Add(new DataColumn("SecondActor", typeof(string)));
dt.Columns.Add(new DataColumn("bNewFilm", typeof(string)));
dt.Columns.Add(new DataColumn("ShmasiRegDate", typeof(string)));
dt.Columns.Add(new DataColumn("bdooble", typeof(string)));
#endregion Columns
SqlConnection Conn = new SqlConnection(Variable.ConnectionString);
SqlCommand cmd = new SqlCommand("sp_GetAllFilm", Conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
Conn.Open();
SqlDataReader dtr = cmd.ExecuteReader();
while (dtr.Read())
{
dr = dt.NewRow();
dr["id"] = dtr["id"].ToString();
dr["names"] = dtr["names"].ToString();
dr["year"] = dtr["year"].ToString();
dr["director"] = dtr["director"].ToString();
dr["actor"] = dtr["actor"].ToString();
dr["award"] = dtr["award"].ToString();
long Ganre = Convert.ToInt64(dtr["ganre"]);
dr["Ganre"] = GetValue.GetSubDefineName(Ganre);
dr["coutnry"] = dtr["country"].ToString() ;
dr["Disc"] = dtr["Disc"].ToString();
dr["ImageUrl"] = dtr["ImageUrl"];
sbyte star = Convert.ToSByte(dtr["StarFilm"]);
dr["starFilm"] = GetValue.GetImageStarFilm(star);
dr["bSubtitle"] = GetValue.GetStringBoolValue(Convert.ToBoolean(dtr["SubTilteFilm"])).ToString();
dr["bTopFilm"] = GetValue.GetStringBoolValue(Convert.ToBoolean(dtr["ISTopFilm"])).ToString();
dr["FirstActor"] = dtr["FirstActor"].ToString();
dr["SecondActor"] = dtr["SecondActorFilm"].ToString();
dr["bNewFilm"] = GetValue.GetStringBoolValue(Convert.ToBoolean(dtr["IsNewFilm"])).ToString();
dr["ShmasiRegDate"] = dtr["ShamsiRegDate"].ToString();
dr["bdooble"] = GetValue.GetStringBoolValue(Convert.ToBoolean(dtr["ISDooble"])).ToString();
ViewState["CurrentTable"] = dt;
//FormView2.DataSource = dt;
//FormView2.DataBind();
Conn.Close();
}
}
catch (Exception Ex)
{
Label1.Text = Ex.ToString();
}
#endregion GetInfo