C# Discussion Boards - CodeProject

kralece12-Jan-09 20:51

12-Jan-09 20:51

is there any code that shows transaction history of an sql ldf file.(log file of sql) For example
10.01.2009 12:00:43 transaction=update , old value= george, new value=jack

10.01.2009 12:00:56 transaction=update , old value= marry, new value=hillary

I need also date, do you advice any software i am writing this here because you coders know softwares very well. I used apex sql but it gave some errors. I was adviced luminent log explorer but i couldnt find it. My system is sql server 2005. You can also give me some codes to be used in sql query analyzer.

Re: transaction history

Wendelius12-Jan-09 22:59

Wendelius

12-Jan-09 22:59

Have you tried: http://www.red-gate.com/products/SQL_Log_Rescue/index.htm[^]. I've never used that product, bit I'm under impression that Red Gate has good tools.

The need to optimize rises from a bad design.My articles[^]

Re: transaction history

kralece13-Jan-09 0:56

kralece

13-Jan-09 0:56

yes i tried red gate but that was only compatible with sql server 2000 and i am using 2005.in spite of adjusting my database's compatibility level to sql server 2000, it still said "this program only works with sql server 2000 databases" So i need a new one.or an sql code to run on sql analyzer.

Re: transaction history

kralece14-Jan-09 2:32

kralece

14-Jan-09 2:32

Don't you have any answer?

Where windows make temprary files?

sumit703412-Jan-09 20:26

sumit7034

12-Jan-09 20:26

hi I am using windows xp and I am running an application on c#.net.
i want to know the location where temporary files are created for this application?

like if we copy files from one drive to another first temporary files are stored and then they are written in destination drive.

Re: Where windows make temprary files?

Vikram A Punathambekar12-Jan-09 20:29

Vikram A Punathambekar

12-Jan-09 20:29

System.IO.Path.GetTempPath() will give you the current user's TEMP location.

Cheers,
Vıkram.

I don't suffer from insanity, I enjoy every moment of it.

Re: Where windows make temprary files?

sumit703412-Jan-09 21:02

sumit7034

12-Jan-09 21:02

Thanks its working.

Can we also fine the path of a dump file which is created when error is generated in application?

Unable to connect: incorrect log on parameters.

pbm41112-Jan-09 20:23

pbm411

12-Jan-09 20:23

Hi,

my report is running fine but when i try to view last page of report through the facility provided by crystalreport viewer it gives an error :-

"Server Error in '/WebSite3' Application.
--------------------------------------------------------------------------------

Error in File C:\DOCUME~1\cna-pbm\LOCALS~1\Temp\report1 {C1AAF9EA-5EEB-4955-A04A-39C97C9B5FDA}.rpt:
Unable to connect: incorrect log on parameters.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Error in File C:\DOCUME~1\cna-pbm\LOCALS~1\Temp\report1 {C1AAF9EA-5EEB-4955-A04A-39C97C9B5FDA}.rpt:
Unable to connect: incorrect log on parameters."

It works if i try to view last page by moving one by one page.

Please reply , if any of you have seen this issue and know the solution.

Re: Unable to connect: incorrect log on parameters.

thatraja10-Dec-11 17:10

thatraja

10-Dec-11 17:10

You need to set logon details at runtime in code-behind, check these

C# Crystal Reports Dynamic Logon parameters [^]

Free attachments
Understanding the Login Failed Error in Crystal Reports[^]
Troubleshooting Database Login Errors using Crystal Reports with .NET[^]

Alternate way
Using the SetDatabaseLogon() Method of the ReportDocument Class[^]
Programmatically change the datasource/database on Crystal Reports[^]
Set Database logon info to a Crystal Report at runtime[^]
ReportDocument.SetDatabaseLogon Method[^]

thatraja

My Dad had a Heart Attack on this day so don't...
Pompeyboy3 here | Nobody remains a virgin, Life screws everyone Sigh | :sigh:

Timer Class

satsumatable12-Jan-09 20:06

satsumatable

12-Jan-09 20:06

Hi,

I want to build a mechanism for Scheduling some tasks, and found that Timer class would be a right option, but if my interval is large that is let's say 2 day still Interval need to be in m.seconds?

AddHandler aTimer.Elapsed, AddressOf OnTimedEvent

aTimer.Interval = 
aTimer.Enabled = True

Thanks in advance...

Re: Timer Class

Guffa12-Jan-09 20:24

Guffa

12-Jan-09 20:24

Yes, the interval for a timer has to be milliseconds.

If you want some code to execute every two days then you should perhaps use the windows scheduler instead.

Despite everything, the person most likely to be fooling you next is yourself.

Re: Timer Class

satsumatable12-Jan-09 20:28

satsumatable

12-Jan-09 20:28

No i cant go for Windows Scheduler since i use some API mechanisms.

So it will not a be a problem right though i use interval as 2 days in Timer Interval?

Thanks ...

Re: Timer Class

N a v a n e e t h12-Jan-09 20:33

N a v a n e e t h

12-Jan-09 20:33

satsumatable wrote:
No i cant go for Windows Scheduler since i use some API mechanisms.

What does that mean? You can create a application which uses all required APIs and schedule the application executable using windows scheduler.

Navaneeth

How to use google | Ask smart questions

Re: Timer Class

J a a n s12-Jan-09 20:32

J a a n s

12-Jan-09 20:32

I don't think that timer is a good option for this. You can check the following article.
http://www.codeproject.com/KB/cs/tsnewlib.aspx[^]

*jaans

Re: Timer Class

musefan12-Jan-09 22:04

musefan

12-Jan-09 22:04

you could still use timer just store the number of minutes (or hours (or days)) elapsed by incrementing it every time the timer ticks.

i.e. if your timer interval is 60000 (60 seconds) you could increment the minute value with each tick and then process that value.

another option is you could store the scheduled time and then when the timer tick event fires every second, for example, you can check to see if the current time matches the scheduled time (or greater than). if so then do your notification code or whatever it is you plan to do.

Re: Timer Class

DaveyM6912-Jan-09 23:32

DaveyM69

12-Jan-09 23:32

The timer will be reset every time your application starts, so if your app might be closed or the computer/server that it's running on may be rebooted it's not going to work without storing the sceduled time somewhere and seeing if that has been reached/passed on restart and setting the timer accordingly.

A better approach would be to store the next scheduled time, and tick your timer every so often (how often depends on how critical the timing of 2 days needs to be) and check against the stored scheduled time in each tick.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: Timer Class

#realJSOP12-Jan-09 23:47

#realJSOP

12-Jan-09 23:47

Be a programmer and write your own timer class. It certainly isn't hard to do. I'll even help you with a starting point - the class should use a BackgroundWorker object because it can already report progress (which would be the equivalent of a timer tick.

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Re: Timer Class

satsumatable13-Jan-09 1:19

satsumatable

13-Jan-09 1:19

Thanks !! I need to get pitch into the same ...

Re: Timer Class

#realJSOP13-Jan-09 2:43

#realJSOP

13-Jan-09 2:43

satsumatable wrote:
I need to get pitch into the same ...

Whatever that means...

Inheriting a class or implementing a interface...

Benny_Lava12-Jan-09 19:49

Benny_Lava

12-Jan-09 19:49

Hi,

I have a public partial class "con_param_tou : UserControl" (standard userControl)

But i want to inherit or implement a interface of a class that i build.

So i want to maintain the designer mode of standard User Control but i also want to implement or inherit one of my classes.

My class is currently declared as public interface base_param_interface (because I know that i cannot inherit multiple classes... So what I want to do is inherit UserControl and implement one of my interfaces which has a couple of public properties and 2,3 functions...

How do I do that?

Thanks in advance!

Re: Inheriting a class or implementing a interface...

Vikram A Punathambekar12-Jan-09 20:32

Vikram A Punathambekar

12-Jan-09 20:32

Just change your class definition to read

class YourClass : SomeBaseClass, ISomeInterface
{
    // stuff goes here
}

Cheers,
Vıkram.

I don't suffer from insanity, I enjoy every moment of it.

equalent in c#

lawrenceinba12-Jan-09 19:48

lawrenceinba

12-Jan-09 19:48

wat is the equilent expression in c# for the below code

const int DICT_INVALID = 0;
const int DICT_WORD = 1;
const int DICT_NUMBER = 2;
const int DICT_CHARACTER = 3;
const int DICT_ALPHANUMERIC = 15;

thanks

the quieter u become more u hear

Re: equalent in c#

satsumatable12-Jan-09 20:12

satsumatable

12-Jan-09 20:12

Same should work ?

Lets say C# code...

const int DICT_INVALID = 5;

Re: equalent in c#

Guffa12-Jan-09 20:21

Guffa

12-Jan-09 20:21

I suppose that you mean "equivalent"? Wink | ;)

If you want to convert something, you should tell what language you are converting from. I don't know any language where that code is an expression, but perhaps you didn't mean exactly that...

You can use that code in a C# program without changing anything at all. However, it might not be the best solution in C#, it looks like something that would rather use an enumeraton for.

Despite everything, the person most likely to be fooling you next is yourself.

modified on Tuesday, January 13, 2009 7:10 AM

Re: equalent in c#

Jon Rista13-Jan-09 9:44

Jon Rista

13-Jan-09 9:44

That code will definitely work in C#, so long as those lines are wrapped in a class. I agree with Guffa, though, you should use an enumeration instead:

public enum Dict
{
    Invalid      =  0,
    Word         =  1,
    Number       =  2,
    Character    =  3,
    Alphanumeric = 15
}

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