Hi I have quiz project running online. and i am using sql server 2005 as backend. The controls i am using to show questions is detailsview. I need to show questions in random order. I don't know how to do it. If somebody knows pls tell me. I am in great trouble.

can i design a web based calender using css. if yes then a little code will be of great help.

i've tried something. it is working with sql server but it doesn't seem to be working with oracle.I am receiving an error.Here's the coding to save the file on the disk.HttpPostedFile filupload = FileUpload1.PostedFile; int filelength = System.Convert.ToInt32(filupload.ContentLength); byte[] data = new byte[filelength]; string name = FileUpload1.FileName.Remove(3); filupload.InputStream.Read(data, 0, filelength); string username = this.Session["username"].ToString(); //string getdir = Directory.GetCurrentDirectory(); string filename="C:\\Inetpub\\wwwroot\\website1\\data\\"+username+".xls"; filupload.SaveAs(filename); and this is the code that i used to send excel file to sql database: string conn = @" Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\website1\data\"+ sheetname+";Extended Properties=Excel 8.0;Persist Security Info=false"; string sqlconn = "Data Source=CHITRA;Initial Catalog=northwind;Integrated Security=True"; OleDbConnection xlcon = new OleDbConnection(conn); string strComand = "select * from [sheet1$A1:C3]"; OleDbDataAdapter xlda = new OleDbDataAdapter(strComand, xlcon); DataTable xldt = new DataTable(); DataSet xlds = new DataSet(); xlda.Fill(xldt); xlda.Dispose(); SqlConnection sqlcon = new SqlConnection(sqlconn); SqlDataAdapter sqlda = new SqlDataAdapter("select * from products", sqlcon); DataSet ds = new DataSet(); sqlcon.Open(); sqlda.Fill(ds, "products"); foreach (DataRow xlrow in xldt.Rows) { DataRow ordr = ds.Tables["products"].NewRow(); string productid, productname, unitprice; ordr["productid"] = xlrow[0]; ordr["productname"] = xlrow[1]; ordr["unitprice"] = xlrow[2]; //productid = xlrow[0].ToString(); //productname = xlrow[1].ToString(); //unitprice = xlrow[2].ToString(); //SqlCommand cmd=new SqlCommand("insert into products (productid,productname,unitprice)values('"+productid+"','"+productname+"','"+unitprice+"')"); //cmd.Connection = sqlcon; //cmd.ExecuteNonQuery(); ds.Tables["products"].Rows.Add(ordr); sqlda.Update(ds, "products"); } //orda.Update(ds, "products"); ds.AcceptChanges(); sqlda.Dispo

thanks for taking interest in my problem. i am having hard times because of this. chitra

hi i have a web application in which i am allowing the user to upload an excel file on my server. i want this excel file to be stored directly in my oracle server.it's not just the file. i would like to insert row by row data in my table.can anyone help me in that. pls send me the code to do this. i am making my application in visual studio 2005, .net framework 2.0 and oracle server 10g. thanks

thanks gautam that article was really good. but i need some code to use sql loader in asp.net to add data in excel file into oracle table.it will be great help if u can send me some code. regards chitra

hi i am posting my question for the first time. it will be a great help if anyone can answer this. i have an asp.net application in framework 2.0 and i am allowing my users to upload an excel file which contains a table that i need to store in oracle database. i read about sql loader that convert data in any other format. can i use sql loader with my application or if there is any other way in which it can be done,pls do let me know. i am using oracle10g enterprise edition as backend and coding with C# in asp.net. if u can send me the code that will be great. with thanks chitra