I am trying to create an array list (like follows)
public static ArrayList GetVehicleInfo( int vehicleId, int quoteId)
{
ArrayList AllVehicles = new ArrayList();
I have the ArrayList delcared as follows for use in a repeater.
protected ArrayList AllVehicles = new ArrayList();
I have the following repeater declared in the Page_Load
//vehicles
rpAllVehicles.D ataSource = dataInfo.GetVeh icleInfo(inputP aram);
rpAllVehicles.D ataBind();
What I need to do is read a SQL table. In this table is personal auto vehicle information. Key is VehicleId(PK, bigint, not null). I want to select the rows that match the VehicleId and QuoteId. Then in this table is a "VehicleInf o" column that is a (varchar(8000), null). This column contains an XML stream with the highest node being <PersAutoVehicl eInfo>.
Now I need to parse through this xml and save the <Manufacturer>? ???</Manufacturer>, the <Model>????</Model>, and the <Year>9999</Year> into the Array list established previously and return "AllVehicle s"
I know this is probably simple, but I cannot figure out the syntax
public static ArrayList GetVehicleInfo( int vehicleId, int quoteId)
{
ArrayList AllVehicles = new ArrayList();
I have the ArrayList delcared as follows for use in a repeater.
protected ArrayList AllVehicles = new ArrayList();
I have the following repeater declared in the Page_Load
//vehicles
rpAllVehicles.D ataSource = dataInfo.GetVeh icleInfo(inputP aram);
rpAllVehicles.D ataBind();
What I need to do is read a SQL table. In this table is personal auto vehicle information. Key is VehicleId(PK, bigint, not null). I want to select the rows that match the VehicleId and QuoteId. Then in this table is a "VehicleInf o" column that is a (varchar(8000), null). This column contains an XML stream with the highest node being <PersAutoVehicl eInfo>.
Now I need to parse through this xml and save the <Manufacturer>? ???</Manufacturer>, the <Model>????</Model>, and the <Year>9999</Year> into the Array list established previously and return "AllVehicle s"
I know this is probably simple, but I cannot figure out the syntax