Comments by Member 10548723 (Top 66 by date)

I need this lines , as this are errors appears
The multi-part identifier "et.EventID" could not be bound.
The multi-part identifier "vt.VolunteerID" could not be bound.
Invalid column name 'EventHelperID'.

public List<event> getEventHelper()
{
List<event> eventHelper = new List<event>();


string queryStr = "INSERT INTO EventHelper Select et.EventID, vt.VolunteerID from Event et CROSS JOIN Volunteer vt ";

string queryStr1 = "Select et.EventID, vt.VolunteerID Order By EventHelperID";

SqlConnection conn = new SqlConnection(_connStr);
SqlCommand cmd = new SqlCommand(queryStr + ";" + queryStr1, conn);
cmd.Parameters.AddWithValue("et.EventID", _ID);
cmd.Parameters.AddWithValue("vt.VolunteerID", _VID);

conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string eventtemp = dr["EventID"].ToString();
int eID = int.Parse(eventtemp);
string volunteertemp = dr["VolunteerID"].ToString();
int vID = int.Parse(volunteertemp);

//eventHelper.Add(new Event(eid , vID));


}

conn.Close();

}


return eventHelper;

}
is this correct? no need to have dr.close and dr.dispose?

public List<event> getEventHelper()
{
List<event> eventHelper = new List<event>();

int eID, vID;

string queryStr = "INSERT INTO EventHelper Select et.EventID, vt.VolunteerID from Event et CROSS JOIN Volunteer vt ";

string queryStr1 = "Select et.EventID, vt.VolunteerID Order By EventHelperID";

SqlConnection conn = new SqlConnection(_connStr);
SqlCommand cmd = new SqlCommand(queryStr + " ; " + queryStr1, conn);
cmd.Parameters.AddWithValue("et.EventID", _ID);
cmd.Parameters.AddWithValue("vt.VolunteerID", _VID);

conn.Open();
SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{
string eventtemp = dr["EventID"].ToString();
eID = int.Parse(eventtemp);
string volunteertemp = dr["VolunteerID"].ToString();
vID = int.Parse(volunteertemp);

eventHelper.Add(new Event(eventID,volunteerID));
}



conn.Close();
dr.Close();
dr.Dispose();

return eventHelper;

}

Trying to do insert eventID from event table and volunteer id from volunteer table to eventhelper table and after retrieving them in eventhelper table and display to my gridview.