web.confige 配置数据库字符串及读取

在web.config 中 

 <connectionStrings>
    <add name="orastring" connectionString="Data Source=TRMESTT;User ID=div_app;Password=div12app"   
    providerName="System.Data.oracleClient" />
  </connectionStrings>

 

在C#中

        string Tstring = ConfigurationManager.ConnectionStrings["orastring"].ToString();
        OracleConnection conn2 = new OracleConnection(Tstring);
        conn2.Open();
        Response.Write(conn2.State);
        OracleCommand comm2 = new OracleCommand("select * from tb_comp_lotid_mapping", conn2);
        OracleDataAdapter myda2 = new OracleDataAdapter(comm);
        DataSet myds2 = new DataSet();
        myda.Fill(myds2);
        if (myds2.Tables[0].Rows.Count > 0)
        {
            GridView2.DataSource = myds2;
            GridView2.DataBind();
        }