ASP.NET

Colin Angus Mackay wrote:

That depends on what you mean by post back

Ramana. G.V wrote:

give me any test scenario.

Ramana. G.V wrote:

in my application, disabled at page level. i have 1 text box & button. 1) entered some name in text box, click on button. it maintains the state after round trip. 2) refresh the page, then textbox still contains the entered name. Here it is not supposed to maintain the name.

<br />
interface IDatabase{<br />
  public int Execute(String sqlStmt);<br />
}<br />
<br />
public class MySQLDatabase() : IDatabase{<br />
  public int Execute(String sqlStmt){<br />
      //Do something wtih MySQL datbase<br />
  }<br />
}<br />
<br />
public class OracleDatabase() : IDatabase{<br />
  public int Execute(String sqlStmt){<br />
      //Do something wtih Oracle datbase<br />
  }<br />
}<br />
<br />
public class DatabaseProxy(){<br />
 IDatabase iDb;<br />
  <br />
 DatabaseProxy(){<br />
    if(config.ReadDbSetting() == "1")<br />
        iDb = new MySQLDatabase();<br />
    else<br />
        iDb = new OracleDatabase();<br />
 }<br />
<br />
  public static int Execute(String sqlStmt){<br />
     return iDb.Execute(sqlStmt);<br />
  }<br />
   <br />
}<br />

<br />
DatabaseProxy.Execute("Statemet");<br />

DbProviderFactory factory = DbProviderFactories.GetFactory("MySample.Oracle");

DbConnection conn = factory.CreateConnection();
conn.ConnectionString = "...";
conn.Open();

DbCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM MyTable";
DbDataReader rdr = cmd.ExecuteReader();