|
which version of Mozilla are you using? I will try on my machine.. i think there might be some configs to do that
|
|
|
|
|
how i can get a select statment results form a stored procedures ie select statement returns a multi set values how this can be retrived
|
|
|
|
|
how can i add child grid in to Parent Grid view and populate it
wasim khan
|
|
|
|
|
I have a TextBox in which Date Of Birth is entered...How can i calculate the AGE...Any idea is helpfull.
Thanks in Advance...
Erasers are for people who are willing to correct their mistakes.
|
|
|
|
|
Just store the DOB from the text box and use this
it would be simpler for you to calculate age in your database server
like
SELECT DATEDIFF(year, yourbirthdayfield, GETDATE()) AS Age
FROM YourTable
this will return the a field in your query that has the age.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Why simpler in database? It's pretty much the same in .net code?
|
|
|
|
|
Ok Thanks Paddy Boyd.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Vri SSK wrote: SELECT DATEDIFF(year, yourbirthdayfield, GETDATE()) AS Age
Common mistake (I've made it myself).
Today is 6 Dec 2007. If my birthdate is 5 December 1997 this returns my age as 10. If my birthday is 7 Dec 1997 this also returns my birthdate as 10.
<br />
DECLARE @myBirthday1 DATETIME<br />
DECLARE @myBirthday2 DATETIME<br />
<br />
SET @myBirthday1 = '5 dec 1997'<br />
SET @myBirthday2 = '7 dec 1997'<br />
<br />
SELECT DATEDIFF(year, @myBirthday1, GETDATE())<br />
SELECT DATEDIFF(year, @myBirthday2, GETDATE())<br />
result:
10
10
FYI the correct way to calculate this is not quite so simple (unfortunately)
<br />
(case when dateadd(year,datediff(year,[birthdate],getutcdate()),[birthdate])>getutcdate() then datediff(year,[birthdate],getutcdate())-(1) else datediff(year,[birthdate],getutcdate()) end)<br />
|
|
|
|
|
1) Parse the Text from the textbox into a DateTime .
2) Find the difference between that date and the current date in years.
|
|
|
|
|
Hi All,
Please help me how to proceed from this situation, my requirement is to present (load) data in excel file and need to access (update/delete) it, the data which is in remote server; I want to connect database using odbc connection through ASP.NET. Please suggest me how to continue.
Thanks to all in Advance.
kolags@hotmail.com
|
|
|
|
|
Hi,
I had one datagrid,i need to delete one record on condition...the condition is like If the date is less than the System date,then i can do it,other wise i need to show message like 'Unable to Delete Record'.
Vasvai
|
|
|
|
|
Use Javascript for that with Date validation and check the date is less than the system date.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
i have a stored procedure with select * from employee where empid is =some id number this statement i wrote in the storedprocedure..now i want the values of the select statement return from a stored procedure.here iam giving the id value through the stored procedure only....
|
|
|
|
|
jagadeeshkumar2106 wrote: have a stored procedure with select * from employee where empid is =some id number this statement i wrote in the storedprocedure..now i want the values of the select statement return from a stored procedure.here iam giving the id value through the stored procedure only....
The fact you use a SELECT "returns" the data. Use ExecuteReader or use a Data Adapter to Fill a DataSet in order to get the data.
|
|
|
|
|
What are you using to read the data with? If your Stored Procedure uses SELECT *, then you should use either ExecuteDataReader fill a DataSet. BTW - it is really bad practice to use SELECT *. You should always explicitly name the columns you want returning.
|
|
|
|
|
Post your Question in the suitable forum.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
How to create website project using .NET Framework 3.0 in VS 2005 ?
Regards,
Ujjaval Modi
|
|
|
|
|
Get it here
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Hi,
Error: Redirect URI cannot contain newline characters.
I get this error when i execute my code on server .
Can anybody solve my Problem.
Thanks.
Regards,
Developer_vk
|
|
|
|
|
Developer_vk wrote: Error: Redirect URI cannot contain newline characters.
you should encode the exception's Message property before using it in a URL. HttpUtility.UrlEncode or HttpServerUtility.UrlEncode would do it for you.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Hi, i have a dataset having two tables. now i want to create tables in database for these dataset tables. what will be the method.
|
|
|
|
|
In SQL you write a couple of CREATE TABLE scripts.
|
|
|
|
|
Hai,
I need one message box,after inserting a record into database.Here iam filling database on Datagrid.
Vasvai
|
|
|
|
|
|
using stored procedures how to retrive the collection of table values and how i can assign these values to a particular dataset
|
|
|
|