|
|
You might want to run a Find in your solution for "BtnOk_Click", just to be certain of that. Remember, the designer will add one event hook and hide it in the InitializeComponent() method.
This may or may not be the problem, but it's best to eliminate the easy solutions first.
|
|
|
|
|
hmmmmmmm
i did but it is showing single time only
|
|
|
|
|
Gonna have to see some code to help with this one
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
private void BtnOk_Click(object sender, EventArgs e)
{
if (TxtTotMins.Text != TxtUCmins.Text)
return;
DateTime dt = Convert.ToDateTime(System.DateTime.Now.ToString());
DateTime Wo_dt = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
DateTime mod_time=Convert.ToDateTime(System.DateTime.Now.ToLongTimeString());
string QueueId = ClientInfo.Application + "!" + Wo_dt.ToShortDateString() + "!" + TransId;
string Upload = "N";
for (int i = 1; i <= OeCnt; i++)
{
string[] Level1 = OeControl[i].Level2.Tag.ToString().Split(':');
string Level1Code = Level1[1].ToString();
string Level2Code;
string Level3Code;
if (!(string.IsNullOrEmpty(OeControl[i].Level2.Text)))
{
string[] Level2 = OeControl[i].Level3.Tag.ToString().Split(':');
Level2Code = Level2[1].ToString();
}
else
Level2Code = null;
if (!(string.IsNullOrEmpty(OeControl[i].Level3.Text)))
{
string[] Level3 = OeControl[i].Level1.Tag.ToString().Split(':');
Level3Code = Level3[1].ToString();
}
else
Level3Code=null;
string Timespent=OeControl[i].TimeText.Text;
string Query = string.Format(@"insert into SIS_OEE(T_STAMP,oper,L2_Code,L3_Code,L4_Code,time_spent,
total_time,cono,cctr,emp,job,work_date,work_shift,mod_date,mod_time,
mod_user,sfis_trans_id,queue_id,upload) values ('{0}','{1}','{2}','{3}','{4}','{5}',
'{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}',{16},'{17}','{18}')", dt, TxtOperation.Text,
Level1Code, Level2Code, Level3Code, Timespent, TxtTotMins.Text, Cono, TxtCctr.Text,
Emp, TxtJob.Text, Wo_dt, Shift, Wo_dt, mod_time, Emp, TransId, QueueId, Upload);
Utility.SFISConnection.ExecuteNonQuery(Query);
}
this.Close();
}
this is mycode inside buttonclick
|
|
|
|
|
well your query code if in a for loop so i can only assume that loop is running twice. Is this what you have indended?
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
no no
for loop running fine but
it is coming again to
{ which is the first line under btn_click event
|
|
|
|
|
and then returns after the first if statement?
if you event is being called twice then it would suggest that you hav added it to the buttons Click event more than once, are there any other events attached to the button such as MouseClick, Enter etc.
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
nowhere in my project btnOK_Click event twice, i checked in design page also.
|
|
|
|
|
Ok, well Colin's suggestion below sounds good, give that a try
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Narendra Reddy Vajrala wrote: it is coming again to
{ which is the first line under btn_click event
So what is in the call stack? It will show you what called the method. Is the call stack different from the first time the method gets called? What called the method the second time around?
|
|
|
|
|
InitializeComponent();
BtnOk.Click += new EventHandler(BtnOk_Click);
and my clickevent is
private void BtnOk_Click(object sender, EventArgs e)
{
//This Event Raising 2 times.....?
}
and design.cs
this.BtnOk.Click += new System.EventHandler(this.BtnOk_Click);
|
|
|
|
|
So like stancrm said initially, you're hooking the event twice.
You hooked it once in the designer, and another time in your design.cs. Either unhook it in the designer, or remove that line from design.cs.
|
|
|
|
|
yesssssssssssssssssssss
finally i got on deleting instance in designer.cs
so Thanks to everybody
|
|
|
|
|
 You have not provided much context for the code snippets. Where are they coming from?
Are you saying that you have
BtnOk.Click += new EventHandler(BtnOk_Click); in your form's constructor, and
this.BtnOk.Click += new System.EventHandler(this.BtnOk_Click); in your form's design.cs file?
If this is the case it looks like you have added the event handler twice to the button click event. I would recommend removing the one in the constructor because the designer will take care of the one in the form's design.cs class.
Also, what is in the call stack when the BtnOk_Click method is called? (If you don't know where to get the call stack it is probably in Debug-->Windows-->Call Stack)
|
|
|
|
|
How very javascriptish--
anyway, check your Form.designer.cs file for BtnOk.Click+=new EventHandler(object sender, Eventargs e);
and then check your Form.cs file for the same. Get rid of one.
If you want to register that EventHandler always, leave it in the designer file, if you want to attach it if some condition is met - take it out and do it in the form.
var question = (_2b || !(_2b));
|
|
|
|
|
Narendra Reddy Vajrala wrote: Please give some solution
Its quite simple...add another button in a new project, put breakpoint and check is it calling twice or not. If it is then something wrong with your windows or your mouse is dying.
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
yes,
from some other form am comming to this form and no where in my project it doesnt happend but y here only....!?
|
|
|
|
|
what are you doing to know that its calling twice ?
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
|
Dear Friends,
I have small application in C#. to insert some record in a table. I am using select max(primary key) from tablenme to get the max id and insert the record with other information.
If single person work it is running properly. But if 4-5 peoples run the same application and they try to save the record some time it gives error as "ora 00001 unique constraint (constraint name) violated"
Your quick response will be highly appriciated
Regards
Murtuza
|
|
|
|
|
How long between selecting the max key and inserting the new one?
|
|
|
|
|
I don't remember the Oracle syntax for it, but the major RDBMSes usually an auto-increment or identity field of some sort. If you use that for the ID, the database will automatically generate a new value when the record is inserted.
Failing that, a few alternatives:
1) Put it all in one DB transaction using a temporary variable. That means get the next index and insert the new record as one combined operation, so nothing can happen in between.
OR
2) Create a stored procedure on the database that inserts the record and returns the ID (If you need to know the ID). Again, keep the entire operation on the database side.
OR
3) If you must do it all on the client side, catch the exception, wait a random number of seconds or milliseconds, and repeat the operation (Checking for the next ID again). This solution is less than optimal, but it's commonly used in certain network protocols.
|
|
|
|
|
If you're using Oracle, look at harnessing the power of a Sequence. This will give you a value that you can use for your primary keys.
Usually you have one sequence per table that needs a numeric primary key.
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
I am using a rowfilter with a dataview. How can I ascertain the number of rows which are being displayed please?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
