I wanna to format any date like SQL Date without changing Regional setting? - C# Discussion Boards

First Prev Next

Re: How to display image at client site??

led mike6-Jul-06 4:45

led mike

6-Jul-06 4:45

The part that uses a HttpWebRequest to download the image file resulting in a byte array containing the image. That should be isolated and unit tested. The unit test could save the byte array to a disk file that can be verified to be correct. None of that has anything to do with your "proxyServer" and sending the byte array to the client socket. That is why it can and should be "isolated". Take some time to read about software design principles.

"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum

led mike

How to count total properties in a class.

sun255-Jul-06 6:58

sun25

5-Jul-06 6:58

How to count total properties in a class.

suneet

Re: How to count total properties in a class.

Josh Smith5-Jul-06 7:14

Josh Smith

5-Jul-06 7:14

typeof(SomeClass).GetProperties().Length

:josh:
My WPF Blog[^]

Re: How to count total properties in a class.

sun255-Jul-06 21:22

sun25

5-Jul-06 21:22

Thanks Josh..........for your help...this worked.....

suneet

VBA and .NET

rattack5-Jul-06 5:59

rattack

5-Jul-06 5:59

Hi all. I need to call a method of my .NET COM-object from Word. How can I do it?
I've written an object, checked all these "COMVisible", "register for COM Interop" etc.
In Word I can see a reference to it. After adding the reference I write the script:

Dim Ob As Object
Set Ob = CreateObject("ClassLibrary1.FOO")

On CreateObject line I get: "Run time error 429. ActiveX component can't create object".

Or if I write so:

Dim Ob As Object
Set Ob = New Classlibrary1.FOO

I get: "Run-time error -2147024894 (80070002). File or assembly Classlibrary1, or one of it's dependencies was not found".

Which dependencies? It's just a test project! Here is the source code:

using System;
using System.Runtime.InteropServices;

namespace Chapter_Code
{
[GuidAttribute("1C6CD700-A37B-4295-9CC9-D7392FDD425D")]
public interface IFoo
{
string PrintMe();
int ShowState();
void SetState(int newState);
}

[GuidAttribute("C09E2DD6-03EE-4fef-BB84-05D3422DD3D9")]
[ClassInterfaceAttribute(ClassInterfaceType.AutoDispatch)]
[ProgIdAttribute("Chapter_Code.Foo")]
public class Foo : IFoo
{
public Foo() { }
private int state = 100;

public string PrintMe()
{
return ("TEST SUCCESS");
}

public int ShowState()
{
return (state);
}

public void SetState(int newState)
{
state = newState;
}
}
}

Your help is much appreciated!

Knows where to go everyday.

Re: VBA and .NET

ToddHileHoffer5-Jul-06 6:01

ToddHileHoffer

5-Jul-06 6:01

Did you use regsvr32 on the com object?

how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06

Re: VBA and .NET

rattack5-Jul-06 23:12

rattack

5-Jul-06 23:12

it's .NET COM object, so I used "regasm CodeLibrary1.dll /codebase".
There were some little mistakes in namespace and ProgID in my code. So here is the final variant:

using System;
using System.Runtime.InteropServices;

namespace ClassLibrary1
{
[GuidAttribute("1C6CD700-A37B-4295-9CC9-D7392FDD425D"),
InterfaceType(ComInterfaceType.InterfaceIsDual)]
public interface IFoo
{
[DispId(1)]
string PrintMe();
[DispId(2)]
int ShowState();
[DispId(3)]
void SetState(int newState);
}

[GuidAttribute("C09E2DD6-03EE-4fef-BB84-05D3422DD3D9"),
ClassInterfaceAttribute(ClassInterfaceType.None)]
[ProgIdAttribute("ClassLibrary1.Foo")]
public class Foo : IFoo
{
public Foo() { }
private int state = 100;

public string PrintMe()
{
return ("TEST SUCCESS");
}

public int ShowState()
{
return (state);
}

public void SetState(int newState)
{
state = newState;
}
}
}

Now using CreateObject or New gets the same error: "Run-time error -2147024894 (80070002). File or assembly Classlibrary1, or one of it's dependencies was not found".

I wanna to format any date like SQL Date without changing Regional setting?

3DoorsDown5-Jul-06 4:35

3DoorsDown

5-Jul-06 4:35

Hi,

I wanna to format any date like SQL Date without changing Regional setting? Where I wanna 2 send a date in a field in sql-server of type date but it changes automatically 2 system format, so I must change regional setting, But I dont like this way Smile | :)

Can Anyone Help me, with a solution?

23DoorsDown

Regards,
Hisham Galal <me4webby@yahoo.com>

Re: I wanna to format any date like SQL Date without changing Regional setting?

ToddHileHoffer5-Jul-06 5:17

ToddHileHoffer

5-Jul-06 5:17

The following function will format a datetime like the old vb dateformat and return a varchar. I use this all the time to format dates in my applications.

/****** Object: UserDefinedFunction [dbo].[udf_FormatDate] Script Date: 07/05/2006 11:11:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create FUNCTION [dbo].[udf_FormatDate] (@date datetime, @format varchar(50))
RETURNS VARCHAR(50) AS
BEGIN
-------------------------------------------------------------------------------------
--
-- Name: FormatDate
--
-- Purpose: Mimics the VB Format routine for dates
--
-- Parameters:
-- @date - Date, Date to be formatted
-- @format - String, Template to format the date to
--
-- Returns: String, Date formatted to user requested template
--
-- Notes:
-- 1. Time information is not accounted for in this routine
--
-- 2. @format accepts the following values for each section of the date.
-- Day
-- dddd - Full Day Name
-- ddd - Abbreviated Day Name
-- dd - Zero Padded Day Number
-- d - Day Number
--
-- Month
-- mmmm - Full Month Name
-- mmm - Abbreviated Month Name
-- mm - Zero Padded Month Number
-- m - Month Number
--
-- Year
-- yyyy - Full 4 digit year
-- yy - 2 digit year
--
-- 3. Any unexpected characters will be returned in the string
--
-- 4. Assumes database was set up with case-insensitive collation
--
-- Example Usage:
-- All examples use the following date 2003-07-13 00:00:00
--
-- 'dddd, mmmm dd, yyyy' --> Sunday, July 13, 2003
-- 'mmddyyyy' --> 07132003
-- 'm-d-yy' --> 7-13-03
-- 'mm/dd/yyyy' --> 07/13/2003
--
-------------------------------------------------------------------------------------
DECLARE @pos AS INTEGER
DECLARE @char AS VARCHAR(1)
--
-- Replace Year
--
SET @pos = CHARINDEX('yyyy', @format)
WHILE @pos > 0
BEGIN
SET @format = STUFF(@format, @pos, 4, DATENAME(yyyy, @date))
--PRINT @format
SET @pos = CHARINDEX('yyyy', @format)
END

SET @pos = CHARINDEX('yy', @format)
WHILE @pos > 0
BEGIN
SET @format = STUFF(@format, @pos, 2, RIGHT(DATENAME(yyyy, @date) ,2))
--PRINT @format
SET @pos = CHARINDEX('yy', @format)
END
--
-- Replace Month
--
SET @pos = CHARINDEX('mmmm', @format)
WHILE @pos > 0
BEGIN
SET @format = STUFF(@format, @pos, 4, DATENAME(month, @date))
--PRINT @format
SET @pos = CHARINDEX('mmmm', @format)
END

SET @pos = CHARINDEX('mmm', @format)
WHILE @pos > 0
BEGIN
SET @format = STUFF(@format, @pos, 3, LEFT(DATENAME(month, @date), 3))
--PRINT @format
SET @pos = CHARINDEX('mmm', @format)
END
SET @pos = CHARINDEX('mm', @format)
WHILE @pos > 0
BEGIN
SET @format = STUFF(@format, @pos, 2, RIGHT(('0' + CAST(DATEPART(month, @date) AS VARCHAR(2))), 2))
--PRINT @format
SET @pos = CHARINDEX('mm', @format)
END

SET @pos = CHARINDEX('m', @format)
WHILE @pos > 0
BEGIN
-- account for MArch and deceMBer
SET @char = SUBSTRING(@format, @pos + 1, 1)
IF (@char <> 'a') AND (@char <> 'b')
BEGIN
SET @format = STUFF(@format, @pos, 1, CAST(DATEPART(month, @date) AS VARCHAR(2)))
--PRINT @format
SET @pos = CHARINDEX('m', @format)
END
ELSE
BEGIN
SET @pos = CHARINDEX('m', @format, @pos + 1)
END
END
--
-- Replace Day
--
SET @pos = CHARINDEX('dddd', @format)
WHILE @pos > 0
BEGIN
SET @format = STUFF(@format, @pos, 4, DATENAME(weekday, @date))
--PRINT @format
SET @pos = CHARINDEX('dddd', @format)
END

SET @pos = CHARINDEX('ddd', @format)
WHILE @pos > 0
BEGIN
SET @format = STUFF(@format, @pos, 3, LEFT(DATENAME(weekday, @date), 3))
--PRINT @format
SET @pos = CHARINDEX('ddd', @format)
END
SET @pos = CHARINDEX('dd', @format)
WHILE @pos > 0
BEGIN
SET @format = STUFF(@format, @pos, 2, RIGHT(('0' + DATENAME(day, @date)), 2))
--PRINT @format
SET @pos = CHARINDEX('dd', @format)
END
SET @pos = CHARINDEX('d', @format)
WHILE @pos > 0
BEGIN
-- account for DEcember, sunDAy --> saturDAy, weDNesday
SET @char = SUBSTRING(@format, @pos + 1, 1)
IF (@char <> 'e') AND (@char <> 'a') AND (@char <> 'n')
BEGIN
SET @format = STUFF(@format, @pos, 1, CAST(DATEPART(day, @date) AS VARCHAR(2)))
--PRINT @format

SET @pos = CHARINDEX('d', @format)
END
ELSE
BEGIN
SET @pos = CHARINDEX('d', @format, @pos + 1)
END
END
IF @format = '//' BEGIN
SET @format = ''
END
RETURN @format
END

how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06

Re: I wanna to format any date like SQL Date without changing Regional setting?

Colin Angus Mackay5-Jul-06 5:17

Colin Angus Mackay

5-Jul-06 5:17

I don't understand your problem. Perhaps if you posted your code it might help.

DateTime theDate = new DateTime(2006,07,05, 17, 11, 00);
SqlCommand cmd = new SqlCommand();
cmd.Connection = someConnection;
cmd.CommandText = "SELECT * FROM MyTable WHERE dateColumn = @dateValue";
cmd.Parameters.Add("@dateValue", theDate);
SqlDataReader reader = cmd.ExecuteReader();
// etc.

As you can see there is no need to format the date at all.

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: I wanna to format any date like SQL Date without changing Regional setting?

Martin#5-Jul-06 5:17

Martin#

5-Jul-06 5:17

You could only work with UTC time in your application.

DateTime.UtcNow;

DateTime.ToUniversalTime();

Hope it helps.

All the best,

Martin

Shadowcopy

kokilambal.p5-Jul-06 4:00

kokilambal.p

5-Jul-06 4:00

Hi,

I have doubt by using Shadowcopying. Please anyone give samples and explanation how shadow copy is working in .net windows forms using c#.

Thanks,
kokila.

Re: Shadowcopy

Josh Smith5-Jul-06 7:15

Josh Smith

5-Jul-06 7:15

Shadow copying is a feature of the ASP.NET runtime. It is not used in WinForms because the WinForms compilation model is not dynamic.

Josh

:josh:
My WPF Blog[^]

Re: Shadowcopy

Not Active5-Jul-06 7:49

Not Active

5-Jul-06 7:49

WinForms does use ShadowCopy. Actually, the .NET framework itself uses this method also. When an assembly is loaded from the GAC it is really using a shadowcopy, this allows assemblies in the GAC to be updated without the risk of being locked by an application.

Using the AppDomainSetup object you can set the path and whether or not to use shadowcopy when creating a new AppDomain. I have used this method to load assemblies for use in an application and allow them to be updated while the app is running. If the assembly is updated the AppDomain is unloaded and created again there by getting the newer version for use while the app remains active for the user.

Re: Shadowcopy

Josh Smith5-Jul-06 10:21

Josh Smith

5-Jul-06 10:21

Thanks for the info! I never knew that. Big Grin | :-D

:josh:
My WPF Blog[^]

Re: Shadowcopy

kokilambal.p5-Jul-06 21:21

kokilambal.p

5-Jul-06 21:21

Hi,

Thanks for your information. Please i need the sample code which you are using for shadow copying.i have tried the same.But newer version is not updated.

C# Cross-Class function calls

czell5-Jul-06 3:57

czell

5-Jul-06 3:57

I have a Windows Form (Form1 is class name) which is the GUI for my app. In Form1 class I have some methods for writing to a textbox. In the same namespace I have another class from which I would like to call Form1's method for writing to that textbox.

Question: How can I call Form1's methods from the another class. I understand how to make calls across classes using instances, but how can I do this when I dont have an instance of Form1 in the other classes? I've tried using static modifiers to Form1's textbox function but that brings up other problems.

So how can I access the Form1's members and methods from another class??

Thanks

Re: C# Cross-Class function calls

BoneSoft5-Jul-06 4:14

BoneSoft

5-Jul-06 4:14

You'd have to find a way to get a reference to the running form. Don't know how you would accomplish that unless the form is instantiating the class in question.

However, what you described sounds like a design choice you should probably reconsider. Instead of having a class that alters a text field, you might want to have that class just take some input and return a string so that any form with a text box can use that functionality.

Try code model generation tools at BoneSoft.com.

Re: C# Cross-Class function calls

Jun Du5-Jul-06 4:31

Jun Du

5-Jul-06 4:31

First, although there are other alternatives, in your case it's better for other classes to call Form1 object. Static methods are not a good option here, as you may want to handle multiple Form1 instances.

Second, Form1's data members aren't supposed to be accessed/altered directly by other classes. A better design would be adding Property to Form1. Outsiders access Form1 properties and Form1 binds these properties with its own controls.

Best,
Jun

Re: C# Cross-Class function calls

led mike5-Jul-06 6:33

led mike

5-Jul-06 6:33

Jun Du wrote:
A better design would be adding Property to Form1. Outsiders access Form1 properties and Form1 binds these properties with its own controls.

Not much better, a better design would use MVC Pattern.

How to find 24Hrs Back Time

VenkataRamana.Gali5-Jul-06 3:34

VenkataRamana.Gali

5-Jul-06 3:34

Hello alll

I need to find 24 Hrs back DateTime using C#. How to do this.

regards
GV Ramana

regards
GV Ramana

Re: How to find 24Hrs Back Time

stancrm5-Jul-06 3:39

stancrm

5-Jul-06 3:39

DateTime back = DateTime.Now.Subtract(new TimeSpan(24, 0, 0));

Re: How to find 24Hrs Back Time

MatthewAnderson5-Jul-06 3:40

MatthewAnderson

5-Jul-06 3:40

May be a little ugly but:

System.DateTime dtYesterday;<br />
dtYesterday = System.DateTime.Now.AddHours(-24);

Re: How to find 24Hrs Back Time

Guffa5-Jul-06 4:03

Guffa

5-Jul-06 4:03

Not ugly at all. The method accepts negative values becase you are supposed to use them.

---
b { font-weight: normal; }

Re: How to find 24Hrs Back Time

Guffa5-Jul-06 4:07

Guffa

5-Jul-06 4:07

Please don't cross post.

---
b { font-weight: normal; }

Last Visit: 31-Dec-99 18:00 Last Update: 29-Apr-24 21:40

Refresh

ᐊ Prev 1...11073 11074 11075 110761107711078 11079 11080 11081 11082 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.