|
Dear All, I have a database in MSSQL 2005 which i am doing DDL,DML from c# code.
i am looking for a tool in MSSQL 2005 which can i get only updated and newly inserted records in a file, that i can use through my c# code.
such a tool is available in MSSQL 2005?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
Put a date stamp on your data, and request data that's been modified or inserted since the last time you asked for it.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
would you please provide me more information
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
In fact, what i am doing is, the application which i am developing is used in multiple locations.
i have local server and multiple remote servers, I would like to send remote servers updated and newly insertd data via email to local server, and local server should get the data and update the system.
I am not going through replication.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
As Christian suggested add a date column. add one more column named flag.
Let say flag 1 is for insert and 2 is for delete 3 fro update..
Use Triggers appropiately to insert these flags and date to your extra columns.. Then you can easily compare at a leter point of time.. and should solve your problem... 
|
|
|
|
|
It is possible that we can read Devanagari Letters from Text File?
When Streamreader is used with Unicode encoding,Garbage is shown.
I want to perform some operation on that data?
Can you help me please?
... Regards]
 Live Life King Size
|
|
|
|
|
One of the constructors for the StreamReader class accepts a stream and encoding. If Devanagari is supported on your computer, it's a trivial matter to get the encoding and pass it to the StreamReader
|
|
|
|
|
In addition to what you've been already told: where is the garbage being shown? If you're displaying it on a console, you certainly won't see the Nagari characters. You'll have to write them to another file or show them in a Winforms app to see them correctly.
|
|
|
|
|
I am loading my homepage where I have a MessageBox where i either can push "OK" or "Cancel".
How can I now invoke a click on the OK buttom ?
The function where the messagebox appears is looking like:
function messagebox (){
var del = confirm("Do you want to continue?");
if (del == true){ var loc="continue.php"; window.location=loc; }
}
Best regards
Mads
|
|
|
|
|
All message boxes will return a value indicating the button clicked. In Javascript it should be a boolean (True or false). Whereas in code like C# or VB (Windows) it will be a DialogueResult Enum value which will denote the result received
|
|
|
|
|
And how can I then manipulate it to think that I clicked? SetAttribute, InvokeMember ? Or smth else?
|
|
|
|
|
On a webpage? if so you're S.O.L.
|
|
|
|
|
S.O.L. ?
But yes, it is on a webpage, which is running on a webbrowser client in my application.
|
|
|
|
|
Anybody Help me
I am using an database application, in my application thousand of data's
are save and get back from the database. so form took much more time and
at the time system was hang, how can handle this problem
At the same i want to display a loading symbol, it is possible or not
And tell what data structure is efficient to search the data in database
Please give idea or some related article
Thank you...
|
|
|
|
|
|
To keep your form responsive you need to perform the database operations on a BACKGROUND thread, this will allow you to display a progress bar (or similar) to show that the application is working.
anishkannan wrote: And tell what data structure is efficient to search the data in database
That all depends on your database design. With no information it is impossible to say. You could buy a book on database design, or use google, there are thousands of articles.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
WHEN YOU PRESS THE SAVE BUTTON YOU SHOULD OPEN THE LOADING SPLASH FORM AS A DIALOG FORM AT THE FIRST LINE OF SAVE BUTTON'S CODE AND WHEN YOUR TRANSACTION IS FULLY COMPLETED THAT MEANS AFTER LAST LINE OF YOU SAVE BUTTON'S CODE HAS BEEN EXECUTED YOU SHOULD CLOSE THE LOADING SPLASH FORM.
|
|
|
|
|
I am have an MDI application where I have several child forms that open under the parent MDI form.
When the child form is opened in the MDI parent form it flickers.
The child form has many controls on it which gets filled by querying from the database when the form loads.
Also the child form has a grid displaying all the records from database.
I am using dataset to fetch more than 2000 records from database and bind it to grid.
I am having problem during loading of this form.
I have tried using following to avoid form flickering:
> DoubleBuffering technique
> Using Datareader instead of Dataset for fetching records
> Fetching records from database after form is loaded using Form_Shown() event
and used BackgroundWorker to Asynchronously fetch records from database.
Can anyone please help me out to avoid the form flickering issue.
Thanks in advance !!!!!!!!
|
|
|
|
|
Hi all...
I'm using C#
I've some images and I want to save these images as pdf file.
can anyone help me in this problem?
Thanks...
|
|
|
|
|
There is a library called PdfSharp in sourceforge. Use it to print image to PDF.
Or you can use some free PDF printer like PdfForge.
|
|
|
|
|
Hi stancrm!
thank you for reply to me.
I'll try using it.
is there an article that show how to use PdfSharp?
thank you...
|
|
|
|
|
or you can use PDF rasterizer too... also this one is open source i believe
|
|
|
|
|
thanks stancrm
your reply was great and helpful...(^^)
|
|
|
|
|
I've created a web browser class in my project(C#) and pass a url with few parametes to it.. this whole data gets visible on clicking on View Source on context menu.
How can i disable it?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
