You Not Grouping Properly SELECT P.ProjectID, P.userID, P.startDate, P.enddate, C.quarter,P.Cost, P.percent, COUNT(C.date) AS totalDays, ((percent/100)*COUNT(C.date)*Cost*8) AS totalcost FROM Project AS P INNER JOIN Calendar AS C ON Calendar.date >P.startDate AND Calendar.date <= P.enddate WHERE (C.isWeekday =1) AND (C.isHoliday=0) GROUP BY P.ProjectID, P.userID, P.startDate, P.enddate, C.quarter,P.Cost, P.percent ORDER BY P.ProjectID You Have No Need To It totalDays,totalCost in Group By

I ended up using a datalist instead of a repeater and was able to solve this issue. Thanks for your help!

Yes! That was my problem. I was not referencing the Master Page and ContentPlaceHolder. Thank you for pointing that out to me.

Th javascript someone gave you last time you asked, a matter of minutes ago, looks fine to me. how about sticking to one thread and asking further questions if you can't work out what to do with the answer you were given ? Christian Graus Driven to the arms of OSX by Vista.

Thank you all for helping me. Also, ToddHileHoffer, thanks for posting the link.

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { if (e.NewPageIndex == 2){ } // Disable here else{ } // Enable here GridView1.PageIndex = e.NewPageIndex; BindData(); } TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L %^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2 W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN% Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i’TV.C\y<pŠjxsg-b$f4ia> -------------------------------------------------------- 128 bit encrypted signature, crack if you can

Page 2 is obviously unrelated to the current task. Page 1, shows only items starting with A, by default. At some point, in a way you're not defining, it goes on to show all items. Right ? Refer to my first reply. The *best* way to only show items starting with a, is not to filter them somehow in your presentation layer, it's to only request those items from your data store. So, if you only want to show A or show all, you need two different requests for data, one which returns the 'a' items and one which returns all. You'd swap between them based on whatever state change it is that causes you to want to view all. I'd have assumed you'd be paging by letter, which would mean you'd write your own paging code ( and control, I would think ) and from there request each letter as required, but this is even easier. Christian Graus Driven to the arms of OSX by Vista.

Does it tell you at which line the exception occurred?

I think you can implement template field for those columns ,from where you want the data to be retrieved just like you are using the checkboxes and getting it by using row.findcontrol ,same try for this template field also.

I would suggest you need to use a pivot table, the best way to do this is to massage your data so it's in this format. If you can't do that, then a repeater is ideal, b/c what you can do is have the repeater creating columns in a table for each item of data. Christian Graus Driven to the arms of OSX by Vista.

Terick wrote: I am using is a user control that is already populated with all of the data. Why are you prepopulating the gridview. I think you should populate it when you have the user selection criteria. When you get the user selection criteria, in page load bind the gridview with selection criteria. OR Can't you rebind the gridview again when you get the user selection criteria? [Edit] By rebinding I mean clear the current datasource and set the new datasource. I hope I make it clear. :-) [/Edit]

Terick wrote: otherwise the cell will be empty Hmm.... Now i get it. string.IsNullOrEmpty(reader["size"]) ? 0 : (int)reader["size"]

validationexpression="^\w+[\w-\.]*\@DomainName.com" i hope this works Rama Charan Prasad "Be happy and Keep smiling.Thats what u want be always..:)"

Rutvik, Thank you for your suggestion of using Session. This worked exactly as I hoped. The only thing I changed was that I placed the text from Form2 in my timer_tick and it worked. Thanks again!

This won't work - in fact I don't think it will compile. 1 The return type is void but the function tries to return a string. 2 The parameter name (file) conflicts with the local variable also called file. 3 The value of y is not set but is used to construct the file name. Couple of other comments. 1 Why use the x and y variables when you have filepaths. You could just set it to Directory.GetFiles(@"C:\Desktop\Request", "*txt").Length + 1. Then use it instead of x or y. 2 This approach does not deal with deleted files. Suppose there are three files originally (text1.txt, text2.txt, text3.txt). Then text1.txt is deleted. What will the file count be? 3 The function is named filecount but it actually tries to return the next filename. 4 Read some of the suggestions carefully - there's good stuff in them that should solve the problem. Regards David R

This is what I have so far. Perhaps this can help you see what I am doing/intending to do: Form1.aspx.cs public void button_Click(object sender, EventArgs e) { string dt= string.Format("Text{0:yyyy-MM-dd_hh-mm-ss}.txt", DateTime.Now); StreamWriter sw; sw= File.CreateText(@"C:\Documents and Settings\user\Desktop\Request\" +dt); sw. WriteLine("This is the first line"); sw.Close(); string filepath = @"C:\Documents and Settings\user\Desktop\Request\" +dt; FileInfo file = new FileInfo(filepath); string filename= Path.GetFileName(filepath); } Form2.aspx.cs public void Timer1_Tick(object sender, EventArgs e) { FileStream file = new FileStream (filename, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite); StreamReader sr = new StreamReader(file); string s= null; while ((s= sr.ReadLine()) != null) { if (s.IndexOf("Current Statue: ") != -1) { lblStatus.Text = s; break; } } sr.Close(); } Because the text file is a log file, I need to continuously monitor it as it is being updated. Hence, I've placed it inside an UpdateControl and set it inside the timer so that every time the timer goes off, the file is looked into. The error I'm encountering is that the "filename" is not being recognized in the second form. Thanks