|
Ok , this time I think it is a logic error r smth... her eis the full code:
private void Tamam_Click(object sender, System.EventArgs e)
{
SqlCommand myCommand = null;
myCommand = new SqlCommand("INSERT INTO CES VALUES(@i_cesit,@i_uzunluk,@i_capı,@i_uzunlugu,@i_kavisi,@arayuz,@kod,@stok,@g_fiyat,@s_fiyat)",Form1.myConnection);
try
{
myCommand.Parameters.Add("@i_cesit",SqlDbType.VarChar);
myCommand.Parameters["@i_cesit"].Value = ıplık_cesıtı.Text;
myCommand.Parameters.Add("@i_uzunluk",SqlDbType.Int);
myCommand.Parameters["@i_uzunluk"].Value = ıplık_capı.Text;
myCommand.Parameters.Add("@i_capı",SqlDbType.VarChar);
myCommand.Parameters["@i_capı"].Value = ıplık_capı.Text;
myCommand.Parameters.Add("@i_uzunlugu",SqlDbType.Int);
myCommand.Parameters["@i_uzunlugu"].Value = (ıgne_uzunlugu.Text);
myCommand.Parameters.Add("@i_kavisi",SqlDbType.VarChar);
myCommand.Parameters["@i_kavisi"].Value = ıgne_kavısı.Text;
myCommand.Parameters.Add("@arayuz",SqlDbType.VarChar);
myCommand.Parameters["@arayuz"].Value = ara_yuzu.Text;
myCommand.Parameters.Add("@kod",SqlDbType.VarChar);
myCommand.Parameters["@kod"].Value = urun_kodu.Text;
myCommand.Parameters.Add("@stok",SqlDbType.Int);
myCommand.Parameters["@stok"].Value = (stok_mıktarı.Text).ToString();
myCommand.Parameters.Add("@g_fiyat",SqlDbType.Float);
myCommand.Parameters["@g_fiyat"].Value = (bırım_fıyatı.Text);
myCommand.Parameters.Add("@s_fiyat",SqlDbType.Float);
myCommand.Parameters["@s_fiyat"].Value =(bırım_fıyatı.Text); myCommand.ExecuteNonQuery();
}
catch (Exception a)
{
MessageBox.Show(a.ToString());
}
}
It keeps giving an error like :
"System.FormatException: Input string was not in a correct format.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at CES.urun.Tamam_Click(Object sender, EventArgs e) in c:\documents and settings\şirin baba.aikanaro.002\desktop\ces\urun.cs:line 587"
o.k , what can be the problem , according to the articles found in net , there is nor mistake.. Has any one any idea?
Thanks a lot..
|
|
|
|
|
Asked and answered below in your other post.
There are plenty of mistakes...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
Someone please send me a code to read a binary file. The code should then change the first 2 bytes to hexadecimal codes..... the next 4 bytes to decimal.... the rest of the file can be in any format...... It should take the name of the file as a command line parameter...
|
|
|
|
|
Sorry, you have to write it yourself. If you have a specific problem, then you can come here and ask about it. We won't write the code for you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Prakash,
Create a binary reader by passing any stream that is created on the file. (Which you recieved through command line parameter). Use the binary readers read method to read the content into a byte array. You can use the Byte array's ToString method to convert the content to the necessary format.
fs = File.OpenRead(@"your file name");
BinaryReader br = new BinaryReader(fs);
byte[] buffer = new byte[32768];
int read= br.Read(buffer,0,buffer.Length);
mybytearry[0].ToString("X")---hexa decimal
Guess this will help you.
Thanks and Regards
SGS
|
|
|
|
|
Some please send me a code to read a binary file. The code should then change the first 2 bytes to hexadecimal codes..... the next 4 bytes to decimal.... the rest of the file can be in any format......
|
|
|
|
|
Hmm.. sounds like a homework project to me.
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
In the tree of the WindowsExplorer, when we click on a node and choose 'rename', the text of that node, maybe, appear in a textbox and we can change that text.
Can u show me how to do that in C#?
Please help me!
Thank you in-advanced!
|
|
|
|
|
gyokusei wrote:
Can u show me how to do that in C#?
So, what you are saying here is that you want to simulate this effect on a listview control (or similar controls) into your application (WinForms I suppose)? Or you want access the shell?
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
Just set the LabelEdit property of your TreeView to true and you'll be able to edit it by clicking on it. If you want to trigger an Edit manually use TreeView.BeginLabelEdit().
|
|
|
|
|
this.treeTemplates.SelectedNode.BeginEdit();
GanDad
|
|
|
|
|
Hi!
I'm currently trying to improve the speed of my xml library TXML, which does not rely on any XML base classes and thus parses the XML string itself to find a certain node.
Because of this I'm interested in finding the fastest way of checking the equality of two strings. On various sites I've read that String.Equals() is supposed to be faster than the == operator, which uses String.op_Equality() under the hood. So I replaced all == comparisons in a certain method with String.Equals() comparisons. The weird thing is that the new code with String.Equals() appears to run 100 ms on average slower than the old code with ==. Can anyone explain me why?
Here's the code of the above mentioned method:
private ReaderReturnValue GetNodeContent(string masterNode, int mnIndex, string subNode, int snIndex)<br />
{<br />
int mi = 1;
int si = 1;
int mnLength = masterNode.Length;<br />
int snLength = subNode.Length;<br />
int textLength = 0;
int i = 0;
int snBegin = 0;
bool foundMn = false;<br />
bool foundSn = false;<br />
bool done = false;
<br />
if(masterNode == "")
foundMn = true;<br />
<br />
for(i = 0; i < XmlText.Length; i++)<br />
{<br />
if(XmlText[i] == '<')
{ <br />
<br />
if(foundMn == false)
{<br />
if(mnLength + 1 <= XmlText.Length - i - 1)
{<br />
if(XmlText.Substring(i + 1, mnLength + 1).Equals(masterNode + '>'))
{<br />
if(mi == mnIndex)<br />
foundMn = true;<br />
else<br />
mi++;<br />
}<br />
}<br />
}<br />
<br />
if(foundMn == true && foundSn == false)
{<br />
if(snLength + 1 <= XmlText.Length - i - 1)
{<br />
if(XmlText.Substring(i + 1, snLength + 1).Equals(subNode + '>'))
{<br />
if(si == snIndex)<br />
{<br />
foundSn = true;<br />
snBegin = i + snLength + 2;
}<br />
else<br />
si++;<br />
}<br />
}<br />
}<br />
<br />
if(mnLength + 1 <= XmlText.Length - i - 1)
{<br />
if(foundMn == true)
{<br />
if(XmlText.Substring(i + 1, mnLength + 2).Equals('/' + masterNode + '>'))
break;
}<br />
}<br />
<br />
if(foundSn == true)
{<br />
if(mnLength + 1 <= XmlText.Length - i - 1)
{<br />
if(XmlText.Substring(i + 1, snLength + 2).Equals('/' + subNode + '>'))
{<br />
done = true;<br />
break;<br />
}<br />
else<br />
textLength++;<br />
}<br />
}<br />
<br />
}
else<br />
{<br />
if(foundSn == true)
textLength++;<br />
}<br />
<br />
}
<br />
ReaderReturnValue returnValue = new ReaderReturnValue();<br />
<br />
if(done == true)
{<br />
returnValue.text = XmlText.Substring(snBegin, textLength - snLength - 2);<br />
returnValue.foundNode = true;<br />
} <br />
else<br />
returnValue.foundNode = false;<br />
<br />
return returnValue;<br />
}
|
|
|
|
|
I looked at the implementation of op_Equality and Equals. It looks like op_Equality ends up calling Equals in its implementation, after doing some null checking. I don't know why calling op_Equality is faster.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
Due to some misconfiguration in my Profiler I originally thought op_Equality() to be faster, which in fact isn't the true case. Apparently the null checking that is performed in op_Equality() makes it a little slower than Equals().
Thanks for your help!
|
|
|
|
|
i've got two form, when i clicked a button on the first, it opened the second. How could i interact with the first from the second, i mean Could i reference to a windows form from another
Thanks in advance
|
|
|
|
|
vuthaianh wrote:
Could i reference to a windows form from another
Ofourse you can. A form is a class like everything else. If you have assigned public variables or methods in the class you want to access then you can access them from any other class in your solution.
E.g. you have 2 classes, Form1 and Form2 and you want to access Form2 from Form1.
(1) First of all you create one instance of each class:
Form1 <code>myFirstForm </code>= new Form1();
Form2 <code>mySecondForm </code>= new Form2();
(2) Assuming that you have publicly available fields or methods in Form2 then you can access them from any class, including Form1. So if you wanted to call a method located inside Form2 from somewhere within Form1 you could say:
int <code>myRate </code>= mySecondForm.CalculateRate();
Hope this helps
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
One thing that Polis didn't mention was the use of events and delegates. You can hook into events that another form (i.e., FormB) exposes to notify your main form (i.e., FormA). This will allow you to maintain private methods across both forms and still transfer data.
|
|
|
|
|
Yes, Nick makes a good point there with events and delegates. I guess the rest is up to you
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
How do I execute a stored procedure in the Page_Load function of C#?
Thanks!
Illegal Operation
WannaBe and GonnaBe Systems Developer
|
|
|
|
|
|
thanks for the help.
Just one more question?
Where does the "myReader" fit into the picture? I have inserted the line:
myReader = MyProc.executeReader();
Thanks!
Illegal Operation
WannaBe and GonnaBe Systems Developer
|
|
|
|
|
|
I have an item that is a tag value to a list view, and the list view item is also contained in the object. The relationship is two way.
My question is, if i remove these objects, will it persist in memory due to the fact that they refference each other?
From what i've read of the Garbage collector, it will perform a graph search for all objects reachable from root objects. So even if my two objects DO refference each other, they will be removed if they are unreachable from the root objects.
Is this right?
Cheers
Cata
|
|
|
|
|
That's right. It will remove them.
WM.
What about weapons of mass-construction?
|
|
|
|