Re: Shadowcopy - C# Discussion Boards

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

ToddHileHoffer5-Jul-06 5:17

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; }

Problem with Diagnostics.Process

suguimoto5-Jul-06 3:28

suguimoto

5-Jul-06 3:28

Hello!

When I try to execute a program sometimes it doesn´t work, and if I stop the debug the program that I wanted to be executed initializes =/. It really annoys me!!
What is happening?

Process.Start(ProgrammePfad, AuftragsVerzeichnis);

or

Process p = new Process();<br />
            ProcessStartInfo startInfo = new ProcessStartInfo();<br />
            startInfo.FileName = ProgrammePfad; // Programm Path<br />
            startInfo.Arguments = AuftragsVerzeichnis; // Programm Arguments<br />
            startInfo.ErrorDialog = true;<br />
            startInfo.WindowStyle = ProcessWindowStyle.Normal;<br />
            <br />
            <br />
            p.StartInfo = startInfo;<br />
            p.Start();

Both of them sometimes work, sometimes don´t! =/
The program that I want to be executed is called InTouch WindowMaker.
Thanks!
Regards

Re: Problem with Diagnostics.Process

S. Senthil Kumar5-Jul-06 5:06

S. Senthil Kumar

5-Jul-06 5:06

suguimoto wrote:
When I try to execute a program sometimes it doesn´t work,

Are you trying to communicate with the program that you try to execute? If not, what exactly does "it doesn't work" mean?

You could try calling WaitForInputIdle[^] right after starting the process and see if it helps.

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Seeking Input value from Dialog box but not closing it

For_IT5-Jul-06 3:20

For_IT

5-Jul-06 3:20

Hi I am creasting an application where I am implementing "search and replace word" functionality. I have a dialog "SearchAndReplace" which takes two text inputs and has three buttons as "FindNext", "Replace" and "Close"

I have implemented following code in my main form:

My main class code is:

<br />
if (SearchReplaceDialog.ShowDialog() == DialogResult.OK)<br />
{<br />
     if (SearchReplaceDialog.WithReplace)<br />
     {<br />
	int c = this.Editor.Replace(SearchReplaceDialog.Search, SearchReplaceDialog.Replace, SearchReplaceDialog.Match, SearchReplaceDialog.Word, SearchReplaceDialog.Up);<br />
	MessageBox.Show(c.ToString() + " strings found and replaced");<br />
     } <br />
     else <br />
     {<br />
	bool r = this.htmlEditor1.Find(SearchReplaceDialog.Search, SearchReplaceDialog.Match, SearchReplaceDialog.Word, SearchReplaceDialog.Up);<br />
	if (!r)<br />
	{<br />
	 MessageBox.Show("String '"+SearchReplaceDialog.Search+"' not found");<br />
	}<br />
     }<br />
}<br />

SearchDialog code:

<br />
private void btnFindNext_Click(object sender, System.EventArgs e)<br />
{<br />
     Match = this.chbMatchCase.Checked;<br />
     Word = this.chbMatchWholeWord.Checked;<br />
	Up = this.chbSearchUpward.Checked;<br />
	Search = this.txtFindWhat.Text;<br />
	Replace = this.txtReplaceWith.Text = String.Empty;<br />
	WithReplace = false;<br />
<br />
	DialogResult = DialogResult.OK;<br />
}<br />

When I click Find Next, the Search and replace dialog box closes. I want to retain it on top of application and close the dialog when user closes it on Clicking "Close" button.

Can anyone please suggest my how can I achieve this?

Thanks

Re: Seeking Input value from Dialog box but not closing it

stancrm5-Jul-06 3:54

stancrm

5-Jul-06 3:54

Set the property "DialogResult" to "None" for "FindNext" Button.

Re: Seeking Input value from Dialog box but not closing it

BoneSoft5-Jul-06 4:09

BoneSoft

5-Jul-06 4:09

As stancrm me eluded, setting DialogResult to DialogResult.OK is what's closing the form. As he suggested, you can set it to DialogResult.None, or don't set it at all on Find Next.

Your question gave the impression that you also need help getting information from the dialog form. You could have it publish events to notify the using form of the information in a match on Find Next, which would help you accomplish that.

Try code model generation tools at BoneSoft.com.

How to show login prompt when accessing database? [modified]

jazzka5-Jul-06 2:32

jazzka

5-Jul-06 2:32

I would like to ask user name and password when accessing to database with login prompt but seems that there doesn't exist the same mechanisn than eg. earlier VB connection object. (like connection.Properties("PROMPT") = adPromptComplete)
This kind of login form would be useful especially in situation when I get default connectionstring with Integrated Security=SSPI and that doesn't work...
C# connection object doesn't have properties property??

-- modified at 8:35 Wednesday 5th July, 2006

Re: How to show login prompt when accessing database?

Colin Angus Mackay5-Jul-06 2:47

Colin Angus Mackay

5-Jul-06 2:47

jaskatpl wrote:
This kind of login form would be useful especially in situation when I get default connectionstring with Integrated Security=SSPI and that doesn't work...

This is not a "default" connection. It means you connect using the rights associated with the security context the calling application is running within. Typically, for a windows application, this will be the account you logged on with.

jaskatpl wrote:
C# connection object doesn't have properties property??

C# is a language, the .NET Framework has a number of connection classes. I'm assuming you are referring to SqlConnection. You can set the connection string to contain a username and password if you want. All you have to do then is to create a dialog to accept a username and password and use that when you are building a connection string.

Re: How to show login prompt when accessing database?

jazzka5-Jul-06 3:08

jazzka

5-Jul-06 3:08

Ok.. sorry about some inaccuraties but let's say that I have my default connnectionstring in my specific application. Now my "default" connectionstring have keyword Integrated Security with value SSPI and I test connection when I am contsructing object from my DataAccesLayer. The test fail and I want to use eg. sql server autentication with used id and password as "backdoor". There have been "automatic" mechanism for this earlier and now I'm wondering why it doesn't exist(or I simply could't find it)

Colin Angus Mackay wrote:
All you have to do then is to create a dialog to accept a username and password and use that when you are building a connection string.

Yes.. exaclty. It's very easy but I still would like to find some other way Smile | :)

...

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