can u please help ma?
Expand|Select|Wrap|Line Numbers
- using System;
- using System.Data;
- using System.Configuration;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- using System.Data.OleDb;
- using System.Data.OracleClient;
- public partial class _Default : System.Web.UI.Page
- {
- OracleConnection objcon= new OracleConnection("Data Source=fsoft;user=fcctest;password=fcctest");
- OracleCommand objcmd = new OracleCommand();
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- objcon.Open();
- OracleDataAdapter objda = new OracleDataAdapter(" select * from CAN_PERSONALINFO where REFERANCE_ID=" + TextBox1.Text + " ", objcon);
- DataSet objds = new DataSet();
- OracleDataAdapter objda1 = new OracleDataAdapter(objcmd);
- objda.Fill(objds);
- GridView1.DataSource = objds.Tables[0];
- GridView1.DataBind();
- objcon.Close();
- }
- protected void Button2_Click(object sender, EventArgs e)
- {
- try
- {
- OracleDataAdapter objcmd1 = new OracleDataAdapter("update CAN_PERSONALINFO SET FIRST_NAME=" + TextBox2.Text + " where REFERANCE_ID =" + TextBox1.Text + " ", objcon);
- objcon.Open();
- OracleDataAdapter objcmd2 = new OracleDataAdapter("select * from CAN_PERSONALINFO where REFERANCE_ID=" + TextBox1.Text + " ", objcon);
- objcmd.ExecuteNonQuery();
- DataSet ds2 = new DataSet();
- OracleDataAdapter objda2 = new OracleDataAdapter(objcmd2);
- objda2.Fill(ds2);
- GridView1.DataSource = ds2.Tables[0];
- GridView1.DataBind();
- objcon.Close();
- Label1.Text = "update your FIRST_NAME";
- }
- catch (Exception ex)
- {
- throw ex;
- }
- }
- }