|
Try this query from your database:
SELECT Name from tablename where month(DOB)=month(getDate()) and day(DOB) = day(getdate())
God is always with you.
|
|
|
|
|
I will sure try this and see what I get
kagiso
|
|
|
|
|
Server: Msg 156, Level 15, State 1, Procedure GetPagedProducts_sql2k5, Line 18
Incorrect syntax near the keyword 'WITH'.
Server: Msg 195, Level 15, State 1, Procedure GetPagedProducts_sql2k5, Line 20
'ROW_NUMBER' is not a recognized function name.
|
|
|
|
|
1 - try thinking of a more intelligent subject
2 - try reading the sticky post on how to ask questions
3 - looks like this is a SQL question, so ask it there
4 - we can see that your SQL is broken. We can't see the SQL itself, so how do you expect us to help you fix it ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
This forum is for ASP.NET question only.. Are you getting this error in ASP.NET project???
-- modified at 4:51 Monday 12th November, 2007
|
|
|
|
|
we can't help you by reading the bit's and parts of your error message. what is the problem? What are you trying to do?
Regards - J O H N -
|
|
|
|
|
hi
can anybody help me in identifying the error in the following code.It am binding data to crystal reports the code follows like this:
Dim myreports As New ReportDocument
Dim dt As DataTable
dt = trackFac.ActivityFullReportCR(DropDownList1.Text, Right)
myreports.Load(Server.MapPath("CrystalReport.rpt"))
myreports.SetDataSource(dt)
CrystalReportViewer1.ReportSource = myreports
CrystalReportViewer1.DataBind()
padma
|
|
|
|
|
You don't have to do call the DataBind() method when you set the ReportSource.
Regards - J O H N -
|
|
|
|
|
ok i will try it thanks
padma
|
|
|
|
|
Hi,
I am working with crystal reports XI. When exporting the crystal reports, by default "Crystal Reports (RPT)" is selected in the FileFormat dropdownlist.
Is it possible to set this option as "Microsoft Excel 97-2000 data only (XLS)"?
Please if any one knows about it reply me.. I need the answer urgently..
Thankfully,
jm
|
|
|
|
|
Have you tried this code??
' Declare variables and get the export options.<br />
Dim exportOpts As New ExportOptions()<br />
Dim diskOpts As New DiskFileDestinationOptions()<br />
Dim excelFormatOpts As New ExcelFormatOptions()<br />
exportOpts = Report.ExportOptions<br />
<br />
' Set the excel format options.<br />
excelFormatOpts.ExcelTabHasColumnHeadings = true<br />
<br />
exportOpts.ExportFormatType = ExportFormatType.Excel<br />
exportOpts.FormatOptions = excelFormatOpts<br />
<br />
' Set the export format.<br />
exportOpts.ExportFormatType = ExportFormatType.Excel<br />
<br />
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile<br />
<br />
' Set the disk file options.<br />
diskOpts.DiskFileName = fileName<br />
exportOpts.DestinationOptions = diskOpts<br />
<br />
Report.Export()
ref: http://msdn2.microsoft.com/en-us/library/aa288404(VS.71).aspx
|
|
|
|
|
Hi Sync,
Yes I tried the code, but I could not get you what "Report" means in the code. Is this the ReportDocument Name or something else?
Also the
diskOpts.DiskFileName = fileName (filename??) what value can I give to it?
Is it the name of the xls file which is to be store the exported report? It must be set at runtime isnt it? I am not sure about it..
Can you clarify my doubts, please?
Thankfully,
jm
|
|
|
|
|
HI,
First :
Can Anybody Point's me to a good Source (i did'nt Find in Google, That's Why i'm Asking)
to Learn How To handle Pervasive in asp.net (specially using the GridView, if Availbale)
Second:
i Want to Change the gridview row style from view to Edit(in run time)
how can i do that?
Thank's in advance
Have Fun
Never forget it
|
|
|
|
|
For GridView take help of the following link:
http://www.gridviewguy.com/Articles.aspx
Hope u get help from this site???
|
|
|
|
|
THANKS
Have Fun
Never forget it
|
|
|
|
|
This is the nature my problem. Am loading some javascript on Page_Load using RegisterClientScriptBlock.
In the body of a function in my code behind, am looping through the rows in a grid view as I validate some values as follows:
For Each row As GridViewRow In MyGrid.Rows()
If row.Cells(0).Text = ""
'''''I WANT TO CALL A JAVASCRIPT FUNCTION THAT WILL DISPLAY A MESSAGE'''''
End If
Next
Help me know how I can call the javascript funtion that was loaded at Page Load. My searches on the web appear only to give me examples of how I can associate the javascript function with an event, say the click of a button.
Thanks in advance.
|
|
|
|
|
U will have to Register it on RowDataBound Event of GridView...
Check this www.gridviewguy.com/Articles.aspx site for more help...
|
|
|
|
|
Hi,
I am very fascinated towards creating Wiki. Any good article or suggestion how to it with ASP.Net. I dont have much about wiki's from where I should start??
|
|
|
|
|
Actually, there are a lot of C# Wiki engines on the net.. Why don't you pick one ?? As those are the opensource projects, you can read their source code...
Open Source Wiki Engines in C#[^]
|
|
|
|
|
Thanks!!!
You are welcome with any other suggestion also...
|
|
|
|
|
Hi
This is krishna veer singh working in a product based company.
we have made a product "xyz". This product is also available in market by some other comapnies. Now i want to fetch programmatically the price of that produt which are available in the market by some other companies. So that accordingly we can decrease and increase the price of our product. I'm using asp.net2.0.
Plese help me as soon as possible...
Thanx....
krishna veer singh
|
|
|
|
|
It depends on various factors. If some other companies (as you say) publish their selling price on the net then you can get it from your project.
|
|
|
|
|
Thank you for your reply.
Will u plese give me some idea that how i can get that price in my project?
krishna veer singh
|
|
|
|
|
krishnaveer wrote: how i can get that price in my project
Are they going to publish their prices on the net? If they are publishing their prices in RSS format, you can use RSS framework to read their feeds and show them in your project..
|
|
|
|
|
Hi Michael,
If possible please give me some links related to my problem so that i can understand that what exactly i need to do.
Thanks
krishna veer singh
|
|
|
|