You probably need to call dataGridView1.DataBind() after you set the new datasource?
This works for me anyway. After I call a page, i can update the underlying table via sqplus, and then see the new data when I reselect that option.
Greg
<%@ Page CompilerOptions='/R:"d:\oracle\product\11.1.0\db_1\odp.net\BIN\2.x\Oracle.DataAccess.dll"' Language="c#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="Oracle.DataAccess.Client" %>
<%@ import Namespace="Oracle.DataAccess.Types" %>
<%@ import Namespace="System.Web.UI" %>
<script runat="server">
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
/*
CREATE OR REPLACE procedure simplerefcur( v_deptno in number,ecur out sys_refcursor) is
BEGIN
OPEN ecur for select * from emp where deptno=v_deptno;
end;
/
*/
using (OracleConnection con = new OracleConnection("data source=orcl;user id=scott;password=tiger;"))
{
con.Open();
using (OracleCommand cmd = new OracleCommand("simplerefcur", con))
{
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter p1 = new OracleParameter("p1", OracleDbType.Decimal);
p1.Value = Int32.Parse(DropDownList1.Text);
cmd.Parameters.Add(p1);
OracleParameter p2 = new OracleParameter("p2", OracleDbType.RefCursor, ParameterDirection.Output);
cmd.Parameters.Add(p2);
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
MyDataGrid.DataSource = ds;
MyDataGrid.DataBind();
}
}
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
<asp:ListItem>10</asp:ListItem>
<asp:ListItem>20</asp:ListItem>
<asp:ListItem>30</asp:ListItem>
</asp:DropDownList>
</p>
<p>
<ASP:DataGrid id="MyDataGrid" runat="server"></ASP:DataGrid>
</p>
</form>
</body>
</html>
You probably need to call dataGridView1.DataBind() after you set the new datasource?