|
The method will not work if it is not the first line in the void main() method of the application. The method is an application based not form based method.
void main()
{
Application.EnableVisualStyles();
Application.DoEvents();
Application.Run(new Form());
}
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
Hi
well I want to suggest to u fine ppl to write this at the top of these forums... PLZ LURK BEFORE YOU LEAP!!
People are often asking basic type of questions that are there in the articles and here in the forums as well
Thanks
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
|
|
Gee we never thought of that!
|
|
|
|
|
Hi again,
Now I have been told I have to finish this by Monday. What a boss ha.
They told me to not worry about sql innjection attacks at the moment because thats not what they are judging me on. This is what I am trying to do
string sql = "select * from employees where employeeID= '" + empNamecomboBox.SelectedValue.ToString() + "'";
string sql = "select * from employees where employeeID= '" + empNamecomboBox.SelectedValue.ToString() + "' select * from Role where RoleID = '" + rolecomboBox.SelectedValue.ToString() + "')";
the employees part searches, but when I na from the employee drop down and want to search on role, this statment brings up nothing for role.
Do I need to do an or or something similar? The one with the smiley face works, its just when I try to add the other drop down list queries it doesn't.
|
|
|
|
|
Hello,
falles01 wrote: hey told me to not worry about sql innjection attacks at the moment because thats not what they are judging me on.
Ok, but you really should read what Colin suggested 7hr ago:
http://www.codeproject.com/script/comments/forums.asp?msg=2196907&forumid=1649#xx2196907xx[^]
There you would find this nice example (uses 'AND'):
int uid = this.GetUserID();
string friendlyName = this.GetFriendlyName();
string sql = string.Format("SELECT Criteria FROM Favourites "+
"WHERE UserID={0} AND FriendlyName='{1}'",
uid, friendlyName);
SqlCommand cmd = new SqlCommand(sql, this.Connection);
string criteria = cmd.ExecuteScalar();
sql = string.Format("SELECT * FROM Products WHERE ProductName = '{0}'",
criteria);
SqlDataAdapter da = new SqlDataAdapter(sql, this.Connection);
da.Fill(this.productDataSet);
All the best,
Martin
|
|
|
|
|
oh can I use seperate statements?
Life for instance
string sql =
and then
sql =
do i have to use string.format? after sql = ?
Thanks
|
|
|
|
|
Excellent it works using
sql =
Thank you very much
|
|
|
|
|
Hello,
I'm glad I could help you help yourself.
All the best,
Martin
|
|
|
|
|
falles01 wrote: string sql = "select * from employees where employeeID= '" + empNamecomboBox.SelectedValue.ToString() + "' select * from Role where RoleID = '" + rolecomboBox.SelectedValue.ToString() + "')";
try an put a MessageBox.Show(sql); after you make this string and see whats being made. I think there is this extra ) at the end or this SQL Query is incomplete. I Can't understand why u'r having 2 selects in one SQL Statement.
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
This is two statements. Try running them seperately. Also, you're still passing Ids as strings, I assume this means they are strings in the DB, which is not efficient at all.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Yes you are right. I thought the following worked because I was testing them one by one, but if I want to search on the employee (being the first statement), then I can't. I can only search on division. I am guessing I need to put it in one statement. Could you show me with the correct notation how to do that? Also I was informed of the string sql from somewhere, but what do you suggest in place of that?
string sql = "select * from employees where employeeID= '" + empNamecomboBox.SelectedValue.ToString() + "' or managerID = '" + managercomboBox.SelectedValue.ToString() + "' or DivisionID = '" + divisioncomboBox.SelectedValue.ToString() + "' or RoleID = '" + rolecomboBox.SelectedValue.ToString() + "'";
sql = "select * from Role where RoleID= '" + rolecomboBox.SelectedValue.ToString() + "'";
sql = "select * from Manager where ManagerID= '" + managercomboBox.SelectedValue.ToString() + "'";
sql = "select * from Division where DivisionID= '" + divisioncomboBox.SelectedValue.ToString() + "'";
|
|
|
|
|
You were right these people are not good to work for.
I am going to leave and go back to my old job. I don't need to be this stressed.
|
|
|
|
|
I use datasets to connect to access 2003 mdb file, created an insert query to write to ole object field in one of my tables,when i want to write data which is a text file bytes, with size of more than 1 mb, only the first "1 kb" of the data is written to the field, when i get back the data from access file, i get truncated file with size of 1 kb. Why i cant write more than 1 kb to a ole object field??? i read from the help of access 2003 that the field holds up to 1gigabyte of data but i can write only 1 kb, i checked out the variables, traced parameters but i couldnt find my mistake mistake, i think there is a problem with Access.
Thank you for your concern.
---
TSTfile = File.ReadAllBytes(@OpenTSTFileDialog.FileName);
TSTfileBytes = new Byte[TSTfile.Length];
TSTfile.Read(TSTfileBytes, 0, TSTfileBytes.Length);
TSTfile.Close();
----
later i use
---
myGrupTablosuTableAdapter.grupTablosuInsertQuery(GroupNo,TSTfileBytes);
|
|
|
|
|
Hello,
I am having split container in Form application.
I am displaying another form in one pane of splitter. It is movable but it starts hiding if i want to move it across the pane of splitter.
I want to move it across the pane throughout the window.
How it is possible.
Thanks.
-- modified at 2:57 Friday 24th August, 2007
|
|
|
|
|
gajesh wrote: I am displaying another form in one pane of splitter
Is this possible?
I'm using .Net1.1 VS2003, and it's not possible to add a form to an panel container!
All the best,
Martin
|
|
|
|
|
Yes.
We can set MdiParent of form to current window and then Show().
|
|
|
|
|
Ok,
But where are you adding the SubForm.
Which one is the MDIContainer, panel (which doesn't work I guess) or mainform?
-- modified at 3:44 Friday 24th August, 2007
All the best,
Martin
|
|
|
|
|
I am sorry.
Bfore Show() we have to add form to panel.
Form1.MdiParent = this;
mButtonEmulator.Location = new(point...)
splitContainer1.Panel2.Controls.Add(Form1);
Form1.Show();
This should work.
Thanks
|
|
|
|
|
Ok,
What if you add the form to the splitcontainer.Controls instead of one of the panels?
Bring it to Front, will maybe do what you need.
All the best,
Martin
|
|
|
|
|
Have you tried Form.TopMost ?
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
All the best,
Martin
|
|
|
|
|
Setting Form.TopLevel (not TopMost) false would allow you to add it to a
Controls collection.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Ahhhh,
Thanks for the Info! (never needed it bevor)
All the best,
Martin
|
|
|
|