ASP.NET UI Control Users Wanted

# re: ASP.NET UI Control Users Wanted

I think it is not easy to use controls, until u r experinced 7/4/2009 6:09 AM | Kallis

# re: ASP.NET UI Control Users Wanted

Hi Devin,

I got your asp.net 3.5 book.
I have a small issue.

I'd like to set a query to a GridView control in order this GridView display the query result.
I do the following but I can not see the gridview,
What should I do, please advise.
Thanks,

protected void Page_Load(object sender, EventArgs e)
{
string oradb = "Data Source=LOCAL_XE;User Id=tzdl_user;Password=rans;";
OracleConnection conn = new OracleConnection(oradb); // C#
conn.Open();

OracleParameter parm = new OracleParameter();
parm.OracleDbType = OracleDbType.Decimal;
parm.Value = 777;

OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.Parameters.Add(parm);

cmd.CommandText = "select * from competence_test where id_num = :1";

cmd.CommandType = CommandType.Text;

OracleDataReader OraRecReader = cmd.ExecuteReader();

CompetenceTestGridView1.DataSource = OraRecReader;

conn.Dispose();
}
4/10/2010 2:34 PM | Ran Sitbon