I agree. We had a dress code change after being able to wear jeans every day except Monday. It's been over a year and I haven't seen one customer in the building - So who am I dressing up for? We're a manufacturing plant.. sheesh.

I work to live, not live to work. So my vote is: Flexibility

Dirk Watkins

I am using DTSearch and it's really nice. It has APIs and does a crawl of your site. I haven't aimed it directly at a database yet but I guess the functionality is there. Otherwise, I always create some kind of webpage that the DTSearch engine can crawl. dtsearch.com/

Dirk Watkins

You're using Javascript to get the information from a database? So you're using AJAX? In either case (using AJAX or not) you need to have a server side page that will return the results. If you want to show the results with Javascript the server side db connection page will need to display the db resultset in a way that Javascript can read: either in XML or JSON or something else. JSON works really well and is bandwidth conservative: json.com/

Dirk Watkins

The ObjectDataSource.SelectCountMethod Property just gives the name of the method to get the SelectCount.. I want the actual select count. :) Here's some more information: I am getting the e.ReturnValue from the ObjectDataSource Selected event. The ObjectDataSource is hitting a Data Access Layer that returns a List of Products: public static List GetProducts(int maximumRows, int startRowIndex, string sortExpression, int categoryId) ... I'm only getting the records I need from the database by page with this DAL method. I'm then using a ObjectDataSource SelectCountMethod to get the total number of products in that category (ALL pages): public int TotalNumberOfProducts(int categoryId, string sortExpression) ... The thing I really want is to get the value of the TotalNumberOfProducts in that category without hitting the database again. I should be able to get that from the ObjectDataSources Selected event or is there somewhere else where I should be trying to get this value? Any suggestions would be very helpful! Thanks.

Dirk Watkins

You need to escape the unprintable character with a slash: newline is \n return is \r Not sure if this will help. Can you give more information if it doesn't?

Dirk Watkins

Are your database fields DateTimes or strings (varchars)? Assuming you are using DateTimes: "SELECT 8 FROM table WHERE (myDate >= CONVERT(DATETIME, '" & Date.Parse(DateCtr1) & "', 102)) AND (myDate <= CONVERT(DATETIME, '" & Date.Parse(DateCtr2) & "', 102))"

Dirk Watkins

you need to do this in the eval statement (from memory): ImageUrl='<%# "image/" + Eval("Pic") %>'

Dirk Watkins

I've been searching on this for a while and haven't found anything. How can I get the total row count from an ObjectDataSource control made up of a generic list of custom objects? I tried doing casting the e.ReturnValue to my generic object list in the ObjectDataSource Selected event to no avail: (( List < Product > )e.ReturnValue).Count Has anybody done this before? I just want to show the user how many products are in a certain category along side the GridView. I'm using C# .NET 2.0 and have a Data Access Layer doing custom paging and sorting like this article on 4GuysFromRolla. Thanks,

Dirk Watkins

I've been trying to consolidate/reuse some business logic in a recent project and doing so would require me (within a MS-SQL 2000 stored procedure) to get a dataset from a stored procedure and aggregate some data. Is there a way to get a dataset from a stored procedure and put it in a temporary table? This is not an output variable, just the regular output dataset. I'm using Microsoft SQL 2000. Help please!

USE PD9

DECLARE @RC int
DECLARE @datebegin varchar(10)
DECLARE @dateend varchar(10)

SET @datebegin = '01/01/2007'
SET @dateend = '01/15/2007'

--this is a dataset of our sales reps
DECLARE sales_cursor CURSOR
FOR
   	SELECT DISTINCT
		[ABAN8]
	FROM 
		[vF0101_RepDetails]
	ORDER BY [ABAN8]

OPEN sales_cursor

DECLARE @an8 int

FETCH NEXT FROM sales_cursor INTO @an8

WHILE (@@FETCH_STATUS <> -1)
BEGIN
   IF (@@FETCH_STATUS <> -2)
   BEGIN  
	-- i'm looping through a dataset of our sales reps
        -- now i need to get a dataset from the below sproc
        -- loop through that dataset and put it in a temp table
        -- the problem is getting the dataset from the next line - HOW??
	-- EXEC @RC = [PD9].[dbo].[usp_rs_getSalesShipments] @an8, @datebegin, @dateend
	-- print @RC
   END
   FETCH NEXT FROM sales_cursor INTO @an8
END
CLOSE sales_cursor
DEALLOCATE sales_cursor

Dirk Watkins

Keep in mind that viewstate also slows down the transmission time and increases the bandwidth usage because it makes your page larger. .NET holds the viewstate information in a hidden form field so the text for that data is sent on each page request. Because of this, the user could try to modify the viewstate and send it back - so keep sensitive data in the session or in some data store on the server.

Dirk Watkins

what?

Dirk Watkins

I second that motion. Except for the dog-kicking scene in Anchorman...

Dirk Watkins

Are there enough "issues" in that list? WTF... :)

Dirk Watkins

Yeah, you'll have to upload to the server and do something with the file there. You can't use JavaScript to read files on a client machine. I think that Flash might be able to do that.. anyone seen this lately? Dirk Watkins

I concur. Dirk Watkins

You shouldn't need to have a div around every button. That is extra markup and as you can see is actually using more markup than the table. Try something that will end up looking like this: CSS Float Test .btnlist {float:right;width:25%;background-color:#0FF;} .btnlist li {height:40px; list-style:none;}

• list box item here

• list box item here

• list box item here

• list box item here

• list box item here

-Dirk

I see. Microsoft is becoming a bit more "standards compliant" as you noted but even the msdn library doesn't come up "right" in firefox. Sometimes I get a little frustrated.. :) I would suggest looking at your firewall, virus scanner, router config, and maybe call your ISP cause something is either blocking it or there is something up with your connection. Good luck! Dirk Watkins

Maybe these: berbee.com 1and1.com Dirk Watkins

I think you have to do a delimited string and parse it out in the event handler. IE: CommandArgument='<%# DataBinder.Eval(Container.DataItem, "id1") + "|" + DataBinder.Eval(Container.DataItem, "id2")%>' Dirk Watkins