|
Hi
i have this code to insert some values to database (via TableAdapter and storedProcedures) :
int? id = 0;
int? number = int.Parse(this.textBox2.Text);
string name = this.textBox3.Text;
this.adapter.Insert(ref id, number, name);
but my program has crash and then dispay an error :
An unhandled exception of type 'System.StackOverflowException' occurred in mscorlib.dll
when i check my database, i see that my code insert about 7000 record in my table which all records is the same!
why is occred and how to solve it ?
thanks
|
|
|
|
|
Your code is somehow calling itself, or in other words, a method your calling is repeatedly calling itself. This is called recursion. The technique is useful in some situations, but you haven't provided any kind of "bailout" to tell the code to stop calling itself.
You haven't provided enough information or enough of a code snippet to be of much help in solving the problem.
|
|
|
|
|
Hi Dave
here is my full code :
DsMyDbTableAdapters.t1TableAdapter adapter = new DataAccessDesigner.DsMyDbTableAdapters.t1TableAdapter();
int? id = 0;
int? number = int.Parse(this.textBox2.Text);
string name = this.textBox3.Text;
adapter.Insert(ref id, number, name);
The t1TableAdapter object has been generated with dataset designer (in viusal studio 2005).
Note : when i trace my code and execute each line via F11, it's works good and insert only 1 record.
modified on Saturday, September 13, 2008 12:27 PM
|
|
|
|
|
No, it's not. What method is this code in?? Because, like I said, this code is somehow calling itself, which makes the method that this code is in come into play.
|
|
|
|
|
no, it is just this :
private void button1_Click(object sender, EventArgs e)
{
DsMyDbTableAdapters.t1TableAdapter adapter = new DataAccessDesigner.DsMyDbTableAdapters.t1TableAdapter();
int? id = 0;
int? number = int.Parse(this.textBox2.Text);
string name = this.textBox3.Text;
adapter.Insert(ref id, number, name);
this.button1_Click(null, null);
}
my tabletable has been generated via dataSet designer.
i think problem is in Adapter.Insert() method, do you believe this ?
|
|
|
|
|
hdv212 wrote: this.button1_Click(null, null);
It's that line. You are recursively calling button1_Click, and you're not bailing out (returning).
|
|
|
|
|
Ohhh!
thanks S. Senthil Kumar.
yes. it's works.
many thanks again.
|
|
|
|
|
I have two questions.
I have a file, this file is created when I save data from my program.
How to make icon for file?
How run my program when I double click this file?
Help me please!
|
|
|
|
|
|
I created icon for file and run my program when double click the file. Thank you very much. 
|
|
|
|
|
nmhai83 wrote: I created icon for file and run my program when double click the file. Thank you very much.
That's why you voted one for my reply?
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
for validation:
I want to call a function which is in .js file,
function called in inline code by
<asp:textbox id="TextBox2" onkeypress="function name" runat="server" xmlns:asp="#unknown"></asp:textbox>
is it correct way to call ????
or any one tell me the write way to call function from javascript file
i already done following code runnable for keypress event,
<asp:TextBox ID="TextBox1" onkeypress ="
if (!((event.keyCode > 47 && event.keyCode < 58)||event.keyCode==45||event.keyCode==46||event.keyCode==110||
event.KeyCode==190||event.keyCode==8||event.keyCode==9))
{
alert('Please Enter Numbers only...');
event.returnValue = false;
}
else
{
event.returnValue=true;
}
" runat="server"></asp:TextBox>
Please tell me the way to call function in aspx inline code
or any fault in given code
|
|
|
|
|
please read this[^]
before you make a question
dhaim
programming is a hobby that make some money as side effect
|
|
|
|
|
Hi,
I have a windows application running in a LAN.
I have some reports developed by Crystal Report and a printer shared in the network.
but when I want to print in a system an error apperes about RPC and the print fails. but on the computer that is directed connetc to Printer that's OK.
Why?
Best wishes
|
|
|
|
|
Because you have some kind of problem with the installed printer driver for that printer. Sorry, it has nothing to do with your code.
|
|
|
|
|
String strSelectStatement = "SELECT EMP_NAME FROM EMPS WHERE EMP_TYPE ="MyCheckBox.Checked == true ? "1" : "0";
Error 4
Operator '==' cannot be applied to operands of type 'string' and 'bool'
And for your shock, it will work if you put true in qoutations to be "true"
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Sorry, it's just my IDE was feeling sick! It's working fine now!
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
If you are going to continue to answer your own questions I'm going to have to get your message count adjusted or something.
Glad you could be of service to yourself - oops that could be a vision I could do without!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: If you are going to continue to answer your own questions I'm going to have to get your message count adjusted or something
 I just thought it's rude to delete a question when I find the answer so instead, I post the answer! Besides, why would I care to have my message count go higher??
Mycroft Holmes wrote: Glad you could be of service to yourself - oops that could be a vision I could do without!
Ha ha ha!  Good one though 
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Your right, it is much better to post your solution rather than delete the post.
My current favourite word is: Nipple!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
It wasn't your IDE, you're just missing a "+" sign after the select statement, that's why intellisense didn't know how to parse your line. You can also omit the == true comparison if you like.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
That's poor programming practice. You should contain the comparison in parens, like so:
String strSelectStatement = "SELECT EMP_NAME FROM EMPS WHERE EMP_TYPE =" (MyCheckBox.Checked == true) ? "1" : "0";
Or, you could use string.Format:
string strSelectStatement = string.Format("SELECT EMP_NAME FROM EMPS WHERE EMP_TYPE ={0}", (MyCheckBox.Checked == true) ? "1" : "0");
Or, you could use the StringBuilder class:
StringBuilder sql = new StringBuilder("SELECT EMP_NAME FROM EMPS WHERE EMP_TYPE =");
sql.Append((MyCheckBox.Checked == true) ? "1" : "0");
No matter how you do it, you should enclose the comparison with parenthesis...
"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
|
|
|
|
|
hi
i was designed a new TableAdapter in Viusal Studio 2005 DataSet Designer(add new table and set it's CRUD command with Stored Procedures), the first column of table is pk and identity, my problem is that the insert method parameters is :
t1TableAdapter.Insert(ref int? id,int? number,string name)
first question : what is '?' ?
second question : when i insert my record by following code :
int id = -1;
int number = int.Parse(this.textBox2.Text);
string name = this.textBox3.Text;
this.adapter.Insert(ref id, number, name);
the following error message has shown me :
The best overloaded method match for 'DataAccessDesigner.DsMyDbTableAdapters.t1TableAdapter.Insert(ref int?, int?, string)' has some invalid arguments.
Argument '1': cannot convert from 'ref int' to 'ref int?'
how to solve it ?
---------------------------------------------------------------------------------
another problem is that when i declare id as int? instead of int, like this :
int? id = -1;
int number = int.Parse(this.textBox2.Text);
string name = this.textBox3.Text;
this.adapter.Insert(ref id, number, name);
this.button1_Click(null, null);
it compile and when i insert a new record, the stackOverFlow exception has occuerd, why ?
thanks
modified on Saturday, September 13, 2008 5:29 AM
|
|
|
|
|
Hi,
Any idea how can you get the icon of an exe or dll file?? say from %windir%system32\SHELL32.dll
I dont know how to do it but I'm sure C# can do it
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
modified on Saturday, September 13, 2008 4:09 AM
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
