ASP.NET Discussion Boards

Re: how to convert text, from english to other language using asp.net

Sathesh Sakthivel6-Dec-07 1:26

6-Dec-07 1:26

1. The pros of "GetLocalResourceObject" and "GetGlobalResourceObject" is to help you achieve

Gloabalization and Localization easily. Cons is that writing code is a little complex than usual.
2. You can use Xml file instead of Resources, as resource itself is in xml format. I would not

suggest you use xml files, because you will lose the ability of using the build-in resource

Localization/Globalization support.
3. The captions of controls should also be get from the resource file.
4. Since .NET 3.5 hasn't been released yet, I do not know whether it will have any new feature on

this.

You can take a look at the following links for more information

http://msdn2.microsoft.com/en-us/library/ms227982.aspx[^]

http://msdn2.microsoft.com/en-us/library/c6zyy3s9.aspx[^]

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: how to convert text, from english to other language using asp.net

Michael Sync6-Dec-07 1:29

Michael Sync

6-Dec-07 1:29

You need to have the translation service for that. so, you may develop your own one or you can use the third-party translation web services....

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

How to put javascript validation on ASP .NET controls?

Rocky#6-Dec-07 0:58

Rocky#

6-Dec-07 0:58

hi everyone,

I have 4 DropDownList controls which are used to take the starting time and ending time of a business. I only take hours and minutes for the Starting time.

Now I want to put some client side validation so that the starting time is less than the ending time. I'm using 24 hour notation so AM/PM is not an issue.

How can i make use of Javascript here. plz give me some idea/guidance/code sample(if any)

Thanks in advance

Rocky

You can't climb up a ladder with your hands in your pockets.

Re: How to put javascript validation on ASP .NET controls?

N a v a n e e t h6-Dec-07 1:08

N a v a n e e t h

6-Dec-07 1:08

You can add javascript like DropDownList.Attributes.Add("OnClick","YourJS()");. Onclick is the event and can be anything applicable to dropdownlist.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Open a new window

.NET- India 6-Dec-07 0:56

.NET- India

6-Dec-07 0:56

Hello Friends,

I'm opening a small window

window.open("Default2.aspx",'','width=400,height=400,srollbars=1');

and it is opening a small window in Internet Explorer but not in Mozilla

but in Mozilla it's opening the window in a new tab but i want to open in a small window as i've described above

Re: Open a new window

Michael Sync6-Dec-07 1:24

Michael Sync

6-Dec-07 1:24

Is your Mozilla browser the latest version??

If yes then you can try this page in Mozilla.. then, click "open popup" link and see whether you got new window or not..

http://www.quirksmode.org/js/popup.html[^]

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: Open a new window

.NET- India 6-Dec-07 1:51

.NET- India

6-Dec-07 1:51

Hello Michael,

I've opened that url in Mozilla and clicked on "open popup" but it did not open a new window but being opened in a new tab in Mozilla but running great in IE.........

Now can u let me know why it's happening

Re: Open a new window

Michael Sync6-Dec-07 3:21

Michael Sync

6-Dec-07 3:21

which version of Mozilla are you using? I will try on my machine.. i think there might be some configs to do that

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

how to get a multi row result set from a stored procedures

jagan1236-Dec-07 0:54

jagan123

6-Dec-07 0:54

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

child Grid

wasimsharp6-Dec-07 0:48

wasimsharp

6-Dec-07 0:48

how can i add child grid in to Parent Grid view and populate it

wasim khan

How to Calculate AGE?

Kasi Viswanathan6-Dec-07 0:40

Kasi Viswanathan

6-Dec-07 0:40

I have a TextBox in which Date Of Birth is entered...How can i calculate the AGE...Any idea is helpfull.

Thanks in Advance... Rose | [Rose]

Erasers are for people who are willing to correct their mistakes.

Re: How to Calculate AGE?

Sathesh Sakthivel6-Dec-07 1:29

Sathesh Sakthivel

6-Dec-07 1:29

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.

Re: How to Calculate AGE?

Paddy Boyd6-Dec-07 1:41

Paddy Boyd

6-Dec-07 1:41

Why simpler in database? It's pretty much the same in .net code?

Re: How to Calculate AGE?

Sathesh Sakthivel6-Dec-07 1:51

Sathesh Sakthivel

6-Dec-07 1:51

Ok Thanks Paddy Boyd.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: How to Calculate AGE?

J4amieC6-Dec-07 2:54

J4amieC

6-Dec-07 2:54

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 />

$Shucks | :-\$

Re: How to Calculate AGE?

J4amieC6-Dec-07 2:56

J4amieC

6-Dec-07 2:56

1) Parse the Text from the textbox into a DateTime.
2) Find the difference between that date and the current date in years.

How to present database in Excel file using ODBC connection in ASP.NET

kolag6-Dec-07 0:24

kolag

6-Dec-07 0:24

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

How to delete a particular record from DataGrid.

Member 45999726-Dec-07 0:10

Member 4599972

6-Dec-07 0:10

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

Re: How to delete a particular record from DataGrid.

Sathesh Sakthivel6-Dec-07 0:13

Sathesh Sakthivel

6-Dec-07 0:13

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.

how we can return a multiple values from a stored procedure

jagan1236-Dec-07 0:03

jagan123

6-Dec-07 0:03

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....

Re: how we can return a multiple values from a stored procedure

Colin Angus Mackay6-Dec-07 0:07

Colin Angus Mackay

6-Dec-07 0:07

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.

Upcoming FREE developer events:
* Developer Day Scotland

My website

Re: how we can return a multiple values from a stored procedure

Pete O'Hanlon6-Dec-07 0:08

Pete O'Hanlon

6-Dec-07 0:08

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.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: how we can return a multiple values from a stored procedure

Sathesh Sakthivel6-Dec-07 0:09

Sathesh Sakthivel

6-Dec-07 0:09

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

Ujjaval Modi5-Dec-07 23:46

Ujjaval Modi

5-Dec-07 23:46