stop the flow the project
-
is it possible to stop the flow of the project? i get error and it is catched in try catch block... after that i don't want to continue... i want transfer the flow to my starting page... how can i do this...
-
is it possible to stop the flow of the project? i get error and it is catched in try catch block... after that i don't want to continue... i want transfer the flow to my starting page... how can i do this...
If it's a method you add for example return the the end of the catch block if there are statements outside the try-chatch structure. However, finally portion will still be executed. Then on the calling side you must handle this situation so that you don't continue there and so on.
The need to optimize rises from a bad design.My articles[^]
-
If it's a method you add for example return the the end of the catch block if there are statements outside the try-chatch structure. However, finally portion will still be executed. Then on the calling side you must handle this situation so that you don't continue there and so on.
The need to optimize rises from a bad design.My articles[^]
actually it is a connection coding... (i got error in this) i catch this but... control transfered to original form... connection coding functuion written in class file.. this connection coding function is called in remaining forms...
-
actually it is a connection coding... (i got error in this) i catch this but... control transfered to original form... connection coding functuion written in class file.. this connection coding function is called in remaining forms...
Can you post the code? It doesn't matter what you do in the code, but it's important that you model the flow so that methods exit nicely and the calling method understands not to continue with execution. But as said, it's a bit hard to say more without the code.
The need to optimize rises from a bad design.My articles[^]
-
Can you post the code? It doesn't matter what you do in the code, but it's important that you model the flow so that methods exit nicely and the calling method understands not to continue with execution. But as said, it's a bit hard to say more without the code.
The need to optimize rises from a bad design.My articles[^]
// written in class file public void mthOpenConnection() { try { string[] datasource = File.ReadAllLines("d:\\k2.txt"); if (datasource[0] != "") { objprop.connection = "Data Source=" + datasource[0] + ";Initial Catalog=Inventory_VS;User ID=sa;Password=sa"; objCon = new SqlConnection(objprop.connection); if (objCon.State != ConnectionState.Open) { objCon.Open(); } } } catch { MessageBox.Show("ENTER CORRECT DATA SOURCE NAME IN UR TEXT FILE"); } } // this is my login form here i call my open connection public DataSet mthGetLogin(Properties objproperties) { objDBconnection.mthOpenConnection(); SqlDataAdapter objDALogin = new SqlDataAdapter("sp_login", objDBconnection.objCon); objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@uname", objproperties.Username)); objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@pword", objproperties.Password)); objDALogin.SelectCommand.CommandType = CommandType.StoredProcedure; objDALogin.Fill(objDSLogin); return objDSLogin; }
-
// written in class file public void mthOpenConnection() { try { string[] datasource = File.ReadAllLines("d:\\k2.txt"); if (datasource[0] != "") { objprop.connection = "Data Source=" + datasource[0] + ";Initial Catalog=Inventory_VS;User ID=sa;Password=sa"; objCon = new SqlConnection(objprop.connection); if (objCon.State != ConnectionState.Open) { objCon.Open(); } } } catch { MessageBox.Show("ENTER CORRECT DATA SOURCE NAME IN UR TEXT FILE"); } } // this is my login form here i call my open connection public DataSet mthGetLogin(Properties objproperties) { objDBconnection.mthOpenConnection(); SqlDataAdapter objDALogin = new SqlDataAdapter("sp_login", objDBconnection.objCon); objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@uname", objproperties.Username)); objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@pword", objproperties.Password)); objDALogin.SelectCommand.CommandType = CommandType.StoredProcedure; objDALogin.Fill(objDSLogin); return objDSLogin; }
Okay, you could use for example bools:
public bool mthOpenConnection()
{
try
{
string[] datasource = File.ReadAllLines("d:\\k2.txt");
if (datasource[0] != "")
{
objprop.connection = "Data Source=" + datasource[0] + ";Initial Catalog=Inventory_VS;User ID=sa;Password=sa";
objCon = new SqlConnection(objprop.connection);
if (objCon.State != ConnectionState.Open)
{
objCon.Open();
}
}
}
catch
{
MessageBox.Show("ENTER CORRECT DATA SOURCE NAME IN UR TEXT FILE");
return false;
}
return true;
}and then
public DataSet mthGetLogin(Properties objproperties)
{
if (!objDBconnection.mthOpenConnection())
{
return null;
}
SqlDataAdapter objDALogin = new SqlDataAdapter("sp_login", objDBconnection.objCon);
objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@uname", objproperties.Username));
objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@pword", objproperties.Password));
objDALogin.SelectCommand.CommandType = CommandType.StoredProcedure;
objDALogin.Fill(objDSLogin);
return objDSLogin;
}The need to optimize rises from a bad design.My articles[^]
-
Okay, you could use for example bools:
public bool mthOpenConnection()
{
try
{
string[] datasource = File.ReadAllLines("d:\\k2.txt");
if (datasource[0] != "")
{
objprop.connection = "Data Source=" + datasource[0] + ";Initial Catalog=Inventory_VS;User ID=sa;Password=sa";
objCon = new SqlConnection(objprop.connection);
if (objCon.State != ConnectionState.Open)
{
objCon.Open();
}
}
}
catch
{
MessageBox.Show("ENTER CORRECT DATA SOURCE NAME IN UR TEXT FILE");
return false;
}
return true;
}and then
public DataSet mthGetLogin(Properties objproperties)
{
if (!objDBconnection.mthOpenConnection())
{
return null;
}
SqlDataAdapter objDALogin = new SqlDataAdapter("sp_login", objDBconnection.objCon);
objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@uname", objproperties.Username));
objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@pword", objproperties.Password));
objDALogin.SelectCommand.CommandType = CommandType.StoredProcedure;
objDALogin.Fill(objDSLogin);
return objDSLogin;
}The need to optimize rises from a bad design.My articles[^]
it works fine... but the flow didn't stoped bcz next consequetive lines needs valid open connection... (but i catch invalid connection in my try block)(contradictory) it ends in error...
-
Okay, you could use for example bools:
public bool mthOpenConnection()
{
try
{
string[] datasource = File.ReadAllLines("d:\\k2.txt");
if (datasource[0] != "")
{
objprop.connection = "Data Source=" + datasource[0] + ";Initial Catalog=Inventory_VS;User ID=sa;Password=sa";
objCon = new SqlConnection(objprop.connection);
if (objCon.State != ConnectionState.Open)
{
objCon.Open();
}
}
}
catch
{
MessageBox.Show("ENTER CORRECT DATA SOURCE NAME IN UR TEXT FILE");
return false;
}
return true;
}and then
public DataSet mthGetLogin(Properties objproperties)
{
if (!objDBconnection.mthOpenConnection())
{
return null;
}
SqlDataAdapter objDALogin = new SqlDataAdapter("sp_login", objDBconnection.objCon);
objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@uname", objproperties.Username));
objDALogin.SelectCommand.Parameters.Add(new SqlParameter("@pword", objproperties.Password));
objDALogin.SelectCommand.CommandType = CommandType.StoredProcedure;
objDALogin.Fill(objDSLogin);
return objDSLogin;
}The need to optimize rises from a bad design.My articles[^]
is anyother way available.... like goto,break,Abandon...
-
it works fine... but the flow didn't stoped bcz next consequetive lines needs valid open connection... (but i catch invalid connection in my try block)(contradictory) it ends in error...
If you added the modification to mthGetLogin that I wrote, the execution in that method won't continue because I added
return nullto it. However, this is only part of your code so you must use this idea in all places where you want to 'break' the executionThe need to optimize rises from a bad design.My articles[^]
-
is anyother way available.... like goto,break,Abandon...
goto can go only to a specific point inside a method. break exits a loop so there's no quick way to do this. One way is to throw an exception inside a catch. Then catch this exception at the level you want.
The need to optimize rises from a bad design.My articles[^]
-
If you added the modification to mthGetLogin that I wrote, the execution in that method won't continue because I added
return nullto it. However, this is only part of your code so you must use this idea in all places where you want to 'break' the executionThe need to optimize rises from a bad design.My articles[^]
s u r right... see this peace of code... this is my loging forms's button(submit) click event... when the program try to read table values error occurs... private void button2_Click_1(object sender, EventArgs e) { objproperties.Username = txtuname.Text; objproperties.Password = txtpword.Text; objDSLogin = objfunction.mthGetLogin(objproperties); if (objDSLogin.Tables[0].Rows.Count > 0) { if (objDSLogin.Tables[0].Rows[0]["status"].ToString() == "User") { objproperties.Username = txtuname.Text; objfunction.mthUsernameInsert(objproperties); this.Hide(); UserForm uf = new UserForm(); uf.Show(); } else if (objDSLogin.Tables[0].Rows[0]["status"].ToString() == "Admin") { this.Hide(); AdminForm1 af = new AdminForm1(); af.Show(); } else { label4.Text = "Login Failed... Try Again"; label4.Visible = true; txtpword.Text = ""; txtuname.Focus(); } } else { label4.Visible = true; txtpword.Text = ""; txtuname.Focus(); } }
-
goto can go only to a specific point inside a method. break exits a loop so there's no quick way to do this. One way is to throw an exception inside a catch. Then catch this exception at the level you want.
The need to optimize rises from a bad design.My articles[^]
how i can do this... guide me..
-
s u r right... see this peace of code... this is my loging forms's button(submit) click event... when the program try to read table values error occurs... private void button2_Click_1(object sender, EventArgs e) { objproperties.Username = txtuname.Text; objproperties.Password = txtpword.Text; objDSLogin = objfunction.mthGetLogin(objproperties); if (objDSLogin.Tables[0].Rows.Count > 0) { if (objDSLogin.Tables[0].Rows[0]["status"].ToString() == "User") { objproperties.Username = txtuname.Text; objfunction.mthUsernameInsert(objproperties); this.Hide(); UserForm uf = new UserForm(); uf.Show(); } else if (objDSLogin.Tables[0].Rows[0]["status"].ToString() == "Admin") { this.Hide(); AdminForm1 af = new AdminForm1(); af.Show(); } else { label4.Text = "Login Failed... Try Again"; label4.Visible = true; txtpword.Text = ""; txtuname.Focus(); } } else { label4.Visible = true; txtpword.Text = ""; txtuname.Focus(); } }
So based on the previous example I wrote, you could:
...
objproperties.Password = txtpword.Text;
objDSLogin = objfunction.mthGetLogin(objproperties);
if (objDSLogin == null)
{
return;
}
if (objDSLogin.Tables[0].Rows.Count > 0)
{
...The need to optimize rises from a bad design.My articles[^]
-
goto can go only to a specific point inside a method. break exits a loop so there's no quick way to do this. One way is to throw an exception inside a catch. Then catch this exception at the level you want.
The need to optimize rises from a bad design.My articles[^]
public bool mthOpenConnection() { try { objprop.J = 0; string[] datasource = File.ReadAllLines("d:\\k2.txt"); if (datasource[0] != "") { objprop.connection = "Data Source=" + datasource[0] + ";Initial Catalog=Inventory_VS;User ID=sa;Password=sa"; objCon = new SqlConnection(objprop.connection); if (objCon.State != ConnectionState.Open) { objCon.Open(); } } } catch (Exception ex) { MessageBox.Show("ENTER CORRECT DATA SOURCE NAME IN UR TEXT FILE"); return false; } return true; } how i can throw my exceptions....