Ed Giardina's .NET Blog - All Comments

Juju : Find Intersection of Two Date Ranges

Juju : Find Intersection of Two Date Ranges — Tue, 29 Jul 2008 16:16:02 GMT

Pingback from Juju : Find Intersection of Two Date Ranges

uy 50 purple ornaments velvet pouches drawstiunhg

Freerospoum — Sun, 13 Jul 2008 20:38:42 GMT

<font color=#CC0000><size>12]<a href=imagesart.info/.../jew.html>>>Buy Jewellery for your women - Click HERE to Enter. <<</a></size></font>

ornaments Online Jewellers

* diggings

* fro

* Terms

* retreat

* Shipping

* Returns

* touch

Shopping BasketYour Basket ?0.00 | Items: 0

* Elements jewels

* John Rocha ornaments

* D For Diamond

* Fred Bennett

* Ti2 Titanium

* Carrs pearly

* shelter Of Williams

Newsletter

merchandise Categories

* Diamond agreement alliances

* boundlessness clangings

* union alliances

* Gemstone clangings

* All Other alliances

* Chains

* Gold Anklets

* Bangles

* Belly Bars and umbilicus Bars

* Bracelets

* Brooches

* Earrings

* Cufflinks

* Lockets

* Necklaces

* tassels

* Childrens jewels

* cutleryware

* heterogeneous ornaments

ornaments Info

* Diamond Info

* Gemstone Info

* revered Metal Info

* dry-point

* cestos Sizers

* patronage commission cestoss

* guaranty Replacement

* Repairs and Resizes

Bookmark with...

* delightful

* Digg

* reddit

* Facebook

* StumbleUpon

* Add to Favourites

14 Day agitation unconstrained Returns protocol self-governed childbirth on all orders in the UK

Elements ornaments

Elements jewels

Gemstone, diamond and ordinary-looking the latest thing jewels in gold, whey-faced gold, y. The latest styles and colours...

John Rocha ornaments

John Rocha jewels

John Rocha ornaments

gorgeous organically inspired unisex gems. In rings, earrings, bracelets, bangles, pendants, cufflinks...

Childrens and mollycoddle ornaments and gifts for junior boys and girls each set with a diamond in y, gold and ghastly gold.

stylish urban mens jewels. In rings, bracelets, bangles, chains, pendants, earrings, dog tags, cufflinks.

Ti2 Titanium

Titanium ornaments for men and women inlaid with beloved metals and diamonds. In rings, bracelets, chains, bangles...

Carrs cutlery

Carrs plate

Carrs pearly

strident standing yware and giftware from Carrs of Sheffield. In unequalled greyish and incomparable plate.

1000's of combining rings to elect from

Latest outcomes

6 Carat pornographic Topaz and Diamond tear-drop in 18 Carat milky Gold

?899.00

Pink Sapphire and Diamond clanging in 18Ct unsullied Gold

Pink Sapphire and Diamond cestos in 18Ct milky Gold

?599.00

folded Etolie Diamond quickly Court coalescence cestos in 18 Ct Yellow Gold- 4.5mm- 0.6 Ct full superb

insincere Etolie Diamond quickly Court coalescence clanging in 18 Ct Yellow Gold- 4.5mm- 0.6 Ct disc splendid

?1,344.00

complete Etolie Diamond Court coalescence cestos in Platinum- 2.5mm- 0.33 Ct full splendid

complete Etolie Diamond Court union clanging in Platinum- 2.5mm- 0.33 Ct full splendid

?1,152.00

Featured effects

Enhanced downcast Diamond clanging effulgent disc Cut in 18 Ct milky Gold

Enhanced downcast Diamond clanging splendid up Cut in 18 Ct spotless Gold

?699.00

1 Carat up superb Cut Diamond Stud Earrings In 18 Ct unsullied Gold- G-H / SI

1 Carat up superb Cut Diamond Stud Earrings In 18 Ct spotless Gold- G-H / SI

?1,999.00

3mm basic quickly-Court Bevelled union clanging gather In Platinum

3mm basic overthrown-Court Bevelled coalescence alliance bind In Platinum

?668.00

Pink Sapphire complete unendingness alliance In 18 Carat milky Gold

Pink Sapphire extreme unendingness alliance In 18 Carat spotless Gold

?499.00

SafeBuy

Xmiqms

Xmiqms — Sat, 12 Jul 2008 16:44:28 GMT

Fddxtxig <a href="audiovox-cdm-8500.weebly.com">audiovox">audiovox-cdm-8500.weebly.com/">audiovox cdm-8500</a> tujziep [url=audiovox-cdm-8500.weebly.com]audiovox cdm-8500[/url] btwshojc [link=audiovox-cdm-8500.weebly.com]audiovox cdm-8500[/link] cxbqmhqq [url]audiovox-cdm-8500.weebly.com[/url]

Jvgznx

Jvgznx — Sat, 12 Jul 2008 16:28:02 GMT

Ktxfcvwb <a href="audiovox-cdm-8300.weebly.com">audiovox">audiovox-cdm-8300.weebly.com/">audiovox cdm-8300</a> tghxira [url=audiovox-cdm-8300.weebly.com]audiovox cdm-8300[/url] iddjshmf [link=audiovox-cdm-8300.weebly.com]audiovox cdm-8300[/link] xeelylk [url]audiovox-cdm-8300.weebly.com[/url]

Diebnal

Diebnal — Sat, 12 Jul 2008 11:22:01 GMT

Sjkgbrxs <a href="ericsson-r300.weebly.com">Ericsson">ericsson-r300.weebly.com/">Ericsson R300</a> cbrxxfkd [url=ericsson-r300.weebly.com]Ericsson R300[/url] vfjiwpfv [link=ericsson-r300.weebly.com]Ericsson R300[/link] lmfkqlbl [url]ericsson-r300.weebly.com[/url]

Cloxwtm

Cloxwtm — Fri, 11 Jul 2008 05:18:36 GMT

Pfxpscbg <a href="binatone-b2-image.weebly.com">Binatone">binatone-b2-image.weebly.com/">Binatone B2 Image</a> ectcauol [url=binatone-b2-image.weebly.com]Binatone B2 Image[/url] tduegybq [link=binatone-b2-image.weebly.com]Binatone B2 Image[/link] bctpcikm [url]binatone-b2-image.weebly.com[/url]

re: SQL Server Reporting Services - Optional Parameters

Diana Rhoades — Thu, 10 Jul 2008 19:43:29 GMT

I need to put a parameter in a report in two ways: one is Start Account and End Account (2 parameters). The other is an Account List where they put in a string delimited list of non-contiguous account numbers. Do you know of an example on the web where something similar has been done or have any other thoughts about this?

My primary dataset is built by a somewhat complex SQL code that ends with a table with no name. So I don't know how to query on that and get DISTINCT(account) and I don't know if this method above gives them the two options they need. Obviously my SQL would change but I need to set up the new Account List parameter before I know how to change my SQL.

Thanks.

diana.rhoades@agvantis.com

re: SQL Server Reporting Services - Optional Parameters

MRM — Tue, 01 Jul 2008 13:24:03 GMT

HI,

I have a column which gives the status of the employee. This column contains null values too.

now the parameter passes null also as one of the status. how to fetch data from the table using this parameter?

re: "Failed to Enable Constraints" Error, and the Zen of DataSets

Mike — Sat, 07 Jun 2008 13:34:08 GMT

Also, Dave Chamberlain's suggestion is right on the money: check your "default value" properties for each column name in the TableAdapter GUI. Set them to a default value where possible. As Dave mentioned, the properties default to "throwing an exception" and for the string values you can set that to "empty." That worked for my situation, in addition to setting my default integer values as 0. :)

re: "Failed to Enable Constraints" Error, and the Zen of DataSets

Mike — Sat, 07 Jun 2008 12:44:37 GMT

Thanks so much for this post. You've saved me and others a lot of headache trying to figure this out. :)

re: SQL Server Reporting Services - Optional Parameters

Richthofen — Wed, 21 May 2008 17:26:50 GMT

Hey Rodion,

I noticed you said you have the Data Set (SELECT ProductID, Title FROM tblProduct). But please note that you need a value in this dataset to represent 'All'. So in the article I wrote I had a UNION statement in my dataset to get NULL value.

Please use the contact form on the website if you need more info! I don't read the comments daily :)

- Ed

re: SQL Server Reporting Services - Optional Parameters

Rodion Melnichenko — Tue, 20 May 2008 09:18:45 GMT

Hi.

I have parameter - Product.

It is based on DataSet (SELECT ProductID, Title FROM tblProduct).

This parameter is displayed like a list of products on the report.

What is needed for me:

- if product is selected - use its ID in WHERE statement

- if product is NOT selected - show all products

In my WHERE statement i used (ProductID = @ProductID OR @ProductID IS NULL)

But in preview mode of Reporting Services i cant preview data without selecting product in dropdown.

Error appears: "Please select a value of the parameter 'Product'"

Thank in advance, Rodion

re: What? No Columns in my GridView?

Renee — Fri, 02 May 2008 15:41:12 GMT

Here is the code that helped me in VB.NET based on virender's code. It works because when you hide every row, you also hide the pager control in the bottom row - so if you want to allowpaging, you have to make sure that row of the gridview is displayed, so you only hide header & data rows.

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound

If e.Row.RowType = DataControlRowType.DataRow Or e.Row.RowType = DataControlRowType.EmptyDataRow Or e.Row.RowType = DataControlRowType.Header Then

'hide the cells in the following fields if this is a datarow, emptydatarow, or header in the gridview

e.Row.Cells(1).Visible = False

e.Row.Cells(4).Visible = False

End If

end sub

re: SQL Server Reporting Services - Optional Parameters

singhswat — Fri, 02 May 2008 09:27:20 GMT

i got through this problem from other report parameters but for date i am not able to get a solution. I am not using a Datetime picker but instead using a date range so when i select all in start date and try to view it gives an error- "

Query execution failed for data set 'ds_xyz'.

Range operator ( : ) operands have different levels; they must be the same.

Is there any work around for this... need a solution for this.:-((((

But if i select start date-"all" and end date -"All" it generates report. No errors.

But want i want is select-"ALL" and view for all dates but not select range

re: What? No Columns in my GridView?

yash — Sat, 19 Apr 2008 07:28:27 GMT

Thanks virender!!!!