how to convert list to array or how to do this below code

Question

public class Emptab

{

public string rnumber;

public string sname;

public string depart;

public string active;

public string dsexecstatus;

public string dsmsg = "";

}

OdbcConnection odcon;

OdbcCommand comm;

DataTable dt = new DataTable();

string con = "Dsn=VD;uid=dba;password=sql";

public List<Emptab> insert(string[] as_connstring, List<Emptab> value)

{

List<Emptab> tDataList = new List<Emptab>();

Emptab tdata = new Emptab();

try

{

List<Emptab> arr = new List<Emptab>();

tdata.rnumber = arr[0].rnumber;

tdata.sname = arr[1].sname;

tdata.depart = arr[2].depart;

tdata.active = arr[3].active;

string ls_query="";

if (as_connstring[0] == "GET")

{

ls_query = @"insert into student values('" + arr[0] + "','" + arr[1] + "','" + arr[2] + "','" + arr[3] + "') ";

odcon = new OdbcConnection(con);

odcon.Open();

comm = new OdbcCommand(ls_query, odcon);

comm.ExecuteNonQuery();

Manas Mohapatra · Answer

Hi Durga L ist arr = new List (); tdata.rnumber = arr[0].rnumber; tdata.sname = arr[1].sname; As per your above code list index is incorrect. Means when you are writing arr[0].rnumber it displays record number 1 rnumber property. But when you write arr[1].sname - it displays record no 2 sname property value. If I am not wrong make it as arr[0].sname. Secondly if you want to convert an list array you can use Linq query: string[] name = (from test in listVar select test.rnumber).ToArray(); But it fetches only rnumbers property value. Note: If you find anything useful please accept/like my answer.