|
I have a form which has more than 10 combobox controls and all should be filled from a different fields in different tables in one mySQL database. I want to do this using the code and not at design time because I have the connection setting in the registry.
what is the best way to do it (with example please) to make sure the form loadng won't be too slow..
Many Thanks,
Jassim Rahma
|
|
|
|
|
Hi jrahma,
Get the rquired fileds from Database into a Dataset or data table. Set the Datasource , DataMember, Value member properties of the combobox control to the right columns in your dataset or table.
Thanks and Regards
SGS
|
|
|
|
|
I have an MDI child for and I want it to be shown maximized with preventing the user from clicking on Max, Min or X buttons on the control box.
Jassim Rahma
|
|
|
|
|
To show MDI child as maximized, set the "WindowState" property to the value of "Maximized".
If you do not want to show the Max button, set the "MaximizeBox" property to "False".
For not showing the Min button, set the "MinimizeBox" property to "False'.
Likewise, if you do not want to show the X button (i.e., close button) on the child form, you can set the value of "ControlBox" as "False".
|
|
|
|
|
Hi Ashok,
I've tested your suggestion. But it still allows me to minimize the child form. Guess we need to do something more to prevent that.
Thanks and Regards
SGS
|
|
|
|
|
There's the SizeChanged event that will tell you when the window size has changed (minimized or maximized.) There's not a SizeChanging event to cancel the resizing that I could find, but you could immediately re-maximize your window (I don't know about flicker.)
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Use the following code (i.e., in the Load event of the Child form). It should solve your problem, as I could test in my sample program. This code will give you a child window with no Max, Mix, Close (i.e., X) buttons and with fully maximized child window, as desired by you. You can still access other child windows from the Window menu of the MDI Parent window which displays links to different child windows.
private void ChildWindow_Load(object sender, System.EventArgs e)
{
this.Dock = DockStyle.Fill;
this.FormBorderStyle = FormBorderStyle.None;
this.MaximizeBox = false;
this.MinimizeBox = false;
this.ControlBox = false;
}
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
