|
Hi Guys,
I have created an audit table to record the changes made to the tables in th db.
I want to keep track of the update version by using a counter ..to know how many times the particular field has been updated/inserted.
Can you let me know how i can go about achieving this,,,Thanks
modified on Friday, January 8, 2010 8:03 AM
|
|
|
|
|
This should be in the Database[^] forum.
In your trigger you can compare values to figure out which field has been changed; then you can keep a row or another table to hold counters for each field and increment the one that's modified.
Why use triggers for this? Why not use stored procedures to control access to your tables?
|
|
|
|
|
can i repost this in the db forum?
|
|
|
|
|
I don't see a problem with it, but then again I'm not the keeper of the site  .
|
|
|
|
|
Yes, but edit your original post, e.g. "Accidentally posted to wrong forum. My apologies.", first.
|
|
|
|
|
Hi All,
I want to execute Log Parser query in my C# application.
Can any one guide me?
|
|
|
|
|
To answer with as much precision as you've asked: All you have to do is install it, configure it, and then use it.
Useful isn't it?
What's Log Parser?
|
|
|
|
|
How to export DataGridView to Excel without Microsoft.Office.Interop.Excel
|
|
|
|
|
|
And if I want a formatted report?
|
|
|
|
|
|
Thank you, but it is a hard way.
|
|
|
|
|
You can use oledb
using (OleDbConnection con = new OleDbConnection(string.Format("Data Source={0};" +
"Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;", fileName)))
[edit](split over lines to make it easier to read)[\edit]
and you just create a sheet by using the create table command, insert just like a real database - but obviously you cannot format the sheet.
Bob
Ashfield Consultants Ltd
Proud to be a Code Project MVP
|
|
|
|
|
Dear friends,
i have some small clarification.
//-----------------------------
public struct a
{
private string s;
public string Val
{ set { s = value; }
get
{ return s;
}
}
//----------------------------
public class a
{
private string s;
public string Val
{
set
{ s = value; }
get
{ return s; }
}
}
/---------------------------
the functionality will be like these....... (Asume that there are more then one variable and properties .... but no methods and functions)
tell me the best way of writting?
and where both can be used?
By
joe
|
|
|
|
|
=>Joe<= wrote: tell me the best way of writting?
There is no "best", both options have their own characteristics.
=>Joe<= wrote: and where both can be used?
I suggest you learn the difference between those two, and then you'll probably have a good idea when to use one or the other.
I could simply say that you want a class if you need to inherit things, but it just isn't that simple. A struct may inherit from an Interface. There, rule of thumb number one broken.
Start reading here.
I are Troll 
|
|
|
|
|
Dear friend ....
Thanks for reply ... given link is well explanatory... 
i am going to use class ... because as i mentioned that i have many variables..
and both of these condition made me not to use structer
-- It has an instance size smaller than 16 bytes.
-- It is immutable.
Thank You
by
Joe
|
|
|
|
|
The big differenc is that the struct version is a value type, and the class version is a reference type. In addition, a struct is a "cut-down" struct - it cannot be used as a basis for a new struct or class (it cannot be inherited).
It is realy quite important to understand the difference between value and reference types as it makes a big difference when you start passing things to methods!
The difference is a bit complex, and otheres have explianed it better than I could here, so google "value type versus reference type" and you will get a pile of descriptions.
All those who believe in psycho kinesis, raise my hand.
|
|
|
|
|
|
hi guys...i have at least 10 textboxes in my form which allow ony to enter numeric values..but some of them will be codes like phone codes and the other textbox will be the rest of phone number like 342 2222222...to make it i wrote that codes to the txtKod_Keypress event the below codes
private void txtKod_KeyPress(object sender, KeyPressEventArgs e)
{
if (!char.IsNumber(e.KeyChar))
e.Handled = char.IsLetter(e.KeyChar);
if (txtKod.Text.Length == 3)
{
e.Handled = char.IsLetter(e.KeyChar);
e.Handled = char.IsNumber(e.KeyChar);
}
}
but it allows to enter letters after i entered 3 numbers actually allows everything...i dont know what is wrong there???
and another question do u suggest me to make a method like that and call it every time i need or to create my own numeric textbox by using Component Class ??
and i searched about masked textbox but there are underlines and not exactly the thing i wanted to see...so may i change its format ?
|
|
|
|
|
Why not just use MaskedTextBox?
The code you posted has a few quarks. Why do you set e.Handled equal to e.KeyChar being a letter if it isn't a digit? And then overwrite this value two times when the length of the textbox reaches 3?
To restrict the length to 3 the handler need only contain
e.Handled = (txtKod.Text.Length == 3);
However, doing a masked input properly is a bit more work. To get it right you need to handle pasting as well as typing, accept non-alphanumerical keys like backspace, left/right arrow key, and perhaps other things.
|
|
|
|
|
I re-read your post and see you're aware of the MaskedTextBox. But apparently not of it's PromptChar property. Set it to a space if you don't want to show the underline.
|
|
|
|
|
thanks man
i will use it as u said
|
|
|
|
|
.net framework has a maskedtextbox control.
More info can be found at:
http://msdn.microsoft.com/en-us/library/system.windows.forms.maskedtextbox.aspx
modified 27-May-14 4:58am.
|
|
|
|
|
I have a big canvas on which the image is drawn. I need to leave only the picture and cut off all unnecessary.
|
|
|
|
|
Why is your canvas so big? Why not use the size of the picture when you create the Image instance? If you don't, then the only option is to create a new insatnce the correct size and redraw the image into that, then dispose the original, big version. It would be a lot quicker (and more memory efficient) to get it right first time.
All those who believe in psycho kinesis, raise my hand.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Badger | [badger,badger,badger,badger...]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/badger.gif)
