the data entered cant be viewed in the datagrid

[geeteshss]

unable to view data in datagrid
--------------------------------------------------------------------------------

the present problem is that i am unable to display data in datagrid....... but the data is visible in database..below is the code what should i do...earlier i could view it also below this code is the code which is in my html page plz help........

private void Page_Load(object sender, System.EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                BindData();
            }
 
 
            // Put user code to initialize the page here
            OleDbDataAdapter da = new OleDbDataAdapter("SELECT *FROM CMRS_BUSINESSAREA_MASTER","Provider=MSDAORA.1;User ID=meter_reading;Password=colony;Data Source=windev;OLEDB.NET=true;" );
            DataSet ds = new DataSet();
            da.Fill(ds,"CMRS_BUSINESSAREA_MASTER");
            DataGrid1.DataSource = ds.Tables["CMRS_BUSINESSAREA_MASTER"].DefaultView ;
            DataGrid1.DataBind();
 
        }
 
 
        public void BindData()
        {
            OleDbDataAdapter da = new OleDbDataAdapter("SELECT *FROM CMRS_BUSINESSAREA_MASTER","Provider=MSDAORA.1;User ID=meter_reading;Password=colony;Data Source=windev;OLEDB.NET=true;" ); 
            DataSet ds = new DataSet(); 
            da.Fill(ds);
 
            DataGrid1.DataSource = ds.Tables[0].DefaultView ;
            DataGrid1.DataBind();
 
 
        }
        public void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs     e)
        {
            DataGrid1.EditItemIndex = e.Item.ItemIndex;
            BindData(); 
        }
 
        public void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs     e)
        {
            DataGrid1.EditItemIndex = -1; 
            BindData(); 
        }
 
        public void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs     e)
        {
            string str = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
            OleDbConnection con1 = new OleDbConnection();
            con1.ConnectionString = str;
 
 
            TextBox txtAREADESCRIPTION =(TextBox) e.Item.Cells[1].Controls[0];
            string strUpdateStmt;
 
            strUpdateStmt = "UPDATE CMRS_BUSINESSAREA_MASTER SET " + "CBM_BUSAREA_DESC = '" + txtAREADESCRIPTION.Text + "' " + "WHERE CBM_BUSAREA_CODE ='" + e.Item.Cells[0].Text +"'";
 
            cmd = new OleDbCommand(strUpdateStmt,con1);
            con1.Open();
            cmd.ExecuteNonQuery();         
            DataGrid1.EditItemIndex = -1;
            BindData();
        }
 
 
        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }
 
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    
            this.cmd = new System.Data.OleDb.OleDbCommand();
            this.con1 = new System.Data.OleDb.OleDbConnection();
            this.addbtn.Click += new System.EventHandler(this.addbtn_Click);
            this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHand    ler(this.DataGrid1_CancelCommand);
            this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHand    ler(this.DataGrid1_EditCommand);
            this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHand    ler(this.DataGrid1_UpdateCommand);
            this.Load += new System.EventHandler(this.Page_Load);
 
        }
        #endregion
 
        private void addbtn_Click(object sender, System.EventArgs e)
        {
            string str = ConfigurationSettings.AppSettings["ConnectionString"].ToString();  
 
            OleDbConnection con1 = new OleDbConnection();
            con1.ConnectionString = str;
            OleDbCommand cmd = new OleDbCommand("Insert into cmrs_businessarea_master values('"+TextBox1.Text+"','"+TextBox2.Text+"')",con1);       
            con1.Open();
            cmd.ExecuteNonQuery();
            con1.Close();
            BindData();
 
 
        }
 
 
 
 
 
 
    }
 
 
 
}

<asp:datagrid id="DataGrid1" style="Z-INDEX: 104; LEFT: 440px; POSITION: absolute; TOP: 304px"
                runat="server" Height="125px" Width="432px" OnUpdateCommand="DataGrid1_UpdateCommand" OnCancelCommand="DataGrid1_CancelCommand"
                OnEditCommand="DataGrid1_EditCommand" AutoGenerateColumns="False">
                <Columns>
                    <asp:BoundColumn HeaderText="AREA CODE"></asp:BoundColumn>
                    <asp:BoundColumn HeaderText="AREA DESCRIPTION"></asp:BoundColumn>
                    <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit"></asp:EditCommandColumn>
                </Columns>
            </asp:datagrid></form>

-------------------------------------------------------------------------------------------------------
Thanks & Regards

[radcaesar]

Its huge code and i can't play with it line by line. Debug ur code line by line and find where the bind fails.

Here is a sample

Dim conn As New OracleClient.Or acleConnection
' TODO: Modify the connection string and include any
' additional required properties for your database.
conn.Connection String = OracleConnectio n1.ConnectionSt ring '"Data Source=<oracle data source name>;Integrate d Security=yes"
Try
Dim mycommand As System.Data.Ora cleClient.Oracl eCommand
Dim myadapter As New System.Data.Ora cleClient.Oracl eDataAdapter

mycommand = New System.Data.Ora cleClient.Oracl eCommand
mycommand.Conne ction = conn
mycommand.Comma ndText = "select * from master_well_hea der where iuwi = '60804402080000 '"

myadapter = New System.Data.Ora cleClient.Oracl eDataAdapter
myadapter.Selec tCommand = mycommand

conn.Open()
myadapter.Fill( DataSet11)
DataGrid1.SetDa taBinding(DataS et11, "")

Catch ex As Exception
MessageBox.Show ("Failed to connect to data source", ex.Message)
Finally
conn.Close()
End Try