ASP.NET

select * from table where InvoiceDate like '02/14'
select * from table where InvoiceDate like '02'
select * from table where InvoiceDate like '02/14/2007'

--For checking day
select * from table where day( convert(datetime,yourdatetimecolumn) ) = yourday

--For checking day and month
select * from table where month( convert(datetime,yourdatetimecolumn) ) = yourmonth and day( convert(datetime,yourdatetimecolumn) ) = yourday 

select * from table where convert(datetime,yourdatetimecolumn)  = yourdate

varshavmane wrote:

The input can be anything I mean if user put 2/ then how will I use this...

siddisagar wrote:

f i want to design a Report then which one we will choose.
aspx page or CrystalReport(.rpt) if CrystalReport then how will do that?

siddisagar wrote:

Can we add any labels and TextBoxes in CrystalReport(.rpt)

manugrg wrote:

I need to populate a listbox named "subcategory" once the user clicks his desired selection in dropdownlist named "category"

if( category.SelectedItem.Text == "c++" )
{
       subcategory.items.add("polymorphism");
       subcategory.items.add("overloading");
       subcategory.items.add("something");
}

ypki wrote:

if i again click on the same link the child.aspx page show the old data

samerh wrote:

I have a case where i want to save data encrypted in sql 2005 and then show it decrypted for specific users only

<script language="javascript" type="text/javascript">
//Loop all elements and checks type of elements
//If type is checkbox
//Take ClientID (ie. GridView_101_CheckBoxID) of CheckBox and do the process based on this ID.
function CheckBoxFunction()
{
    var el=document.form1.elements;
    for(x=0;x<el.length;x++)
    {
        if(el[x].type=="checkbox")
        {
            //Change this ID 'CheckBoxIDofGrid' to your CheckBoxID,
            if(el[x].id.indexOf("CheckBoxIDofGrid") != -1)
            {
                if(el[x].checked == true)
                {
                    //do some stuff here if it is checked
                }
            }
        }
    }
}
</script>