If you work through the article I basically do it in 2 steps. Build up the query that will service the pivot. Get your student details, the course details and your performance information into a normal result set, do not get any extra data like ID information that is not needed. Get a distinct list of the course names (either from the result set or all the courses), these will be your pivoted columns. I would do a hard coded mini query to get a feel for it, once you get a result by hard coding the pivot columns you can turn it into dynamic sql. To debug the dynamic sql print the text and try and run that. Never underestimate the power of human stupidity RAH

Hey, why did you use "ELSE IF" when "ELSE" is same??? thats like if a = 1 then "abc" else if a = 2 then "222" else "222"

thanks danish I have done in the same way as you told. kind regards learner

Learner520 wrote: My question is if I Implement 2nd option will this improve or make worse web page performance. You won't get any performance problems. Readability, maintainability and choice of design is all matters here. Also inheriting all the classes from sales just to get the common fields is not a good idea. How about a design like, Order orderid, orderdate Invoice invoiceid, invoicedate Email emailid, emaildate Sales saleid, Order, Invoice, Email, timesheetid, timesheetdate. Sales class contains references to related classes. So to get an order id from a sales object, you could write salesObject.Order.orderid. You are not repeating any properties here. BTW, I don't prefix cls to my classes. :) Best wishes, Navaneeth

thanks a lot

if (listControl.tagName=='input' && listControl.type=='checkbox' && listControl.checked) April Comm100 - Leading Live Chat Software Provider

in a transaction you can send query. then why not you use the insert query for checked checkboxes using for loop or foreach :-O

You wrote before you understand the moral of the question. People tend to be confused by the terms. What he is requesting is very easy, but because the term Intranet was said to his ears, he tend to become confound. So you thought i did not know what was intranet, come on man, go to google and google "vuyiswa maseko" instead then you would never think i dont know what is intranet. Thanks Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Do some research into parameterised queries, they will make your life so much easier. Inserting date using a string var is Ok, you just need to format it correctly, the following are valid formats for SQL Server. The important thing is to STORE it as a datetime data type in the database. yyyy/mm/dd dd/MMM/yyyy mm/dd/yyyy If you try to use a date in dd/mm/yyyy format it will create the error you are getting. MS is a US company so SQL Server used the stupid freakin US date format internally. Also you need to add additional ' around your date value. Never underestimate the power of human stupidity RAH

please, post clear question. don't just write whats running in your mind. Read Question 2-3 times before you post. Please explain clearing again, what do you want to do. Thanks, Prince Team Lead Quest Solutions www.imaginethinkact.com

Set a width to the Table E.G. 1000px. Set a width to each TD 200px, 800px. I didn't get any requirements for the signature

Are you binding the grid in page_load and binding without checking IsPostBack? Learner520 wrote: (String) ((TextBox)xItem.FindControl("TxtForeName")).Text; This is bad practice. If your item can't be found, this code will crash. First find the control, do NULL checking and ensure you have a valid object before you access Text property on it. :) Navaneeth How to use google | Ask smart questions

I really appreciate that you gave me the exact answer what I'm looking for. thnx again. actually I was doing the same as you have mentioned like register a user form Asp.net configuration and assign them roles. but I wasn't sure how to store all UserId's which belongs to Student's role into Student table as well. regards learner

So didn't you understand the answer the first time you asked? If not, try responding to the original post, not starting a new one. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

I guess your table Student should contain column which have any value from Supervisor. Your Student table have to looks like this : StudentId StudentName SupervisorId 1 john 1 2 paul 1 3 britney 3 4 Mike 5 . . . . 13 beckham 7 I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

your assumption is absolutely fine. let me try to explain this time may be better this time we have two table student and instructor number of records can be change of both student and Instructor tables lets suppose Number of students Number of Instructor 30 11 42 9 21 13 16 5 1-what we need to do we have to allocate 11 instructor to 30 students. 2- 9 instructor to 42 students. 3- 13 instructor to 21 students. 4- 5 instructor to 16 students. let suppose 1,2,3,and 4 represents 2001,2002,2003,2004. every year number of students and instructor changes and we have to allocate instructor to new students. any way I really appreciate your patience and time you gave to understand my requirements. regards learner.