Plz elaborate your query. do you want to create dynamic datacolumns or what? If you have any code snippet. Plz post that also. It will also the persons who wanna help you. Or the following link might help you: http://www.codersource.net/dataset_preparing_manual_data_addition.html

what datatype you are using in DB. Use Datatype as 'Nvarchar' And while sending that data through any procedure, there also use datatype as Nvarchar. Nvarchar datatype has length -- 4000. Hope it will help you.

Can you Plz be more elaborative. you need to do all these thing on server-side or on client-side.

In gridview you can do it following manner: On Rowdatabound: protected void ParentGridView_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { GridView ChildGridView = (GridView)e.Row.FindControl("NestedGridView"); } } Here "NestedGridView" is the gridview Control have created in aspx file. And "ChildGridView" object which you have created to play in .cs file. Hope This will help you.

Thanks for your reply. Your answers could have solved my problem. If I limit the no. of users. But that is the problem. No. of users will increase in coming time. So if there is any other efficient way to solve this problem. Plz tell me

Hi All, I have wrote stored procedure which calculates points for result for around 1000 users. This procedure takes no parameters from asp.net code. asp.net code is used for just for calling this procedure. But when I run this procedure from the code it gives me the timout error. while running from the sql server itself it works fine. Kindly tell me how can I overcome this problem? Below is my code, which is giving me the error. try { Helper connHLP = new Helper(false); connHLP.Retrieve("prcUpdateUsePoints", null); }catch (Exception ex) { throw ex; } ---------------------------------------------------------------------------------------------------------------------- Code for connection & retrive: private SqlConnection conn; private SqlTransaction tran; public Helper(bool TransactionRequired) { try { string strConn = string.Empty; strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString(); conn = new SqlConnection(strConn); conn.Open(); if (TransactionRequired == true) { tran = conn.BeginTransaction(); } else { tran = null; } } catch (Exception ex) { throw ex; } } public DataSet Retrieve(string ProcedureName, SqlParameter[] ParamCollection) { try { DataSet ds = new DataSet();SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; if (ParamCollection != null) SetParameters(cmd, ParamCollection); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = ProcedureName; SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(ds); return ds; } catch (Exception ex) { throw ex; } finally { conn.Close(); } } public void SetParameters(SqlCommand cmd, SqlParameter[] ParamCollection) { try { foreach (SqlParameter param in ParamCollection) cmd.Parameters.Add(param); } catch (Exception ex) { throw ex; } } ---------------------------------------------------------------------------------------------------------------------- Thnking you all in advance.