I have an records near about 2.5 lac but excel sheet(sheet1) can contain maximum of 65 thousand now how can I transfer the records to the excel sheet . my application gets hang. :(

I am New to .net , in my project I am using one dropdownlist and using its (selecteditem.text)value and selectedvalue both.Now the problem is that selectedtext i.e stnno is unique but its selectedvalue is date and not unique if i select the third value from dropdown whose postback=true then it is returing the value of first record because the selectedvalue i.e date is same for both the index what can I do.???????????? Ankur

hello , my self ankur , i am very new to .net (C#) I had made an function in vb .net but same logic is not workin in C# please help. I had Written an Following Code . try { da = new SqlDataAdapter(Cmd); dt = new DataTable(); da.Fill(dt); int i=0,j=0,p=0,k=0,m=0; string[] arr = new string[((dt.Columns.Count) * 3)]; if (dt.Rows.Count <= 0) return arr; for (j = 0; j <= dt.Rows.Count - 1; j++) { if ((j == 0)) { for (i = 0; i <= dt.Columns.Count - 1; i++) { arr[i] =dt.Rows[0].ItemArray[i].ToString(); //(dt.Rows[0].Item(i)); p = i; } } if ((j == 1)) { k = p + 1; //For k = i To dt.Columns.Count - 1 for (i = 0; i <= dt.Columns.Count - 1; i++) { arr[k] =dt.Rows[1].ItemArray[i].ToString(); k = k + 1; } } if ((j == 2)) { m = k; //For k = i To dt.Columns.Count - 1 for (i = 0; i <= dt.Columns.Count - 1; i++) { arr[m] =dt.Rows[2].ItemArray[i].ToString(); m = m + 1; } //Next } }