Databases
StackOverflow2013
Postsdbo
POwindows forms closing immediately when opened
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POwindows forms closing immediately when opened
    primarykey
    data
    text
    <p>When I open a new form from my login screen, it logs the user in, shows the form then instantly disappears???</p> <p>Here is my code for the relevant parts:</p> <pre><code>string checkAdmin = "select * from Logins where Name = @userName and UserType ='Admin'"; string checkUser = "select * from Logins where Name = @userName and UserType ='User'"; using (var connection = new SqlConnection(@"server=.\SQLEXPRESS; database=loginsTest;Trusted_Connection=yes")) { using (var checkAdminCommand = new SqlCommand(checkAdmin, connection)) { //guessing at the column length here. Use actual column size instead of 20 checkAdminCommand.Parameters.Add("@username", SqlDbType.NVarChar, 50).Value = userNameBox.Text; connection.Open(); if (checkAdminCommand.ExecuteScalar() != null) { adminScreen admnscrn = new adminScreen(); admnscrn.Show(); this.Close(); return; } else { } } using (var connection = new SqlConnection(@"server=.\SQLEXPRESS; database=loginsTest;Trusted_Connection=yes")) { using (var checkUserCommand = new SqlCommand(checkUser, connection)) { //guessing at the column length here. Use actual column size instead of 20 checkUserCommand.Parameters.Add("@username", SqlDbType.NVarChar, 50).Value = userNameBox.Text; connection.Open(); if (checkUserCommand.ExecuteScalar() != null) { userScreen usrscrn = new userScreen(); usrscrn.Show(); this.Close(); } else { MessageBox.Show("Invalid details, try again"); passwordBox.Text = ""; } } } </code></pre> <p>So when I open usrscrn or admnscrn, it flicks up and goes straight back off again? I've tried researching, I've used Application.Run(userScreen()); etc, it just throws an exception saying something about a second message loop?</p> <p>I have created a new screen, set it as MDI, and entered this code:</p> <pre><code> private void MDI_Form_Load(object sender, EventArgs e) { Form1 loginscrn = new Form1(); loginscrn.Show(); } </code></pre> <p>my program.cs file contains this code:</p> <pre><code> static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new MDI_Form()); } </code></pre> <p>will this work??</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStony b
    1. UStony b
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POwindows forms closing immediately when opened
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POwindows forms closing immediately when opened
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POwindows forms closing immediately when opened
      1. This table or related slice is empty.
      1. VTUpMod
    1. COwhat this this.Close(); for ? are you inside another form ?
      singulars
      1. POwindows forms closing immediately when opened
      1. USsino
    2. COHave you tried debugging??
      singulars
      1. POwindows forms closing immediately when opened
      1. USCharleh
    3. COthe form i am in (login screen) has to disappear when i open the user or admin screen, so when i open the relevant screen (userScreen usrscrn = new userScreen(); usrscrn.Show();) then it closes the login screen
      singulars
      1. POwindows forms closing immediately when opened
      1. UStony b
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload