I use gridview binding with contents of one table from oracle.It displays record in gridview well but i got problem while storing that record into another table in oracle.Remember my source for gridview and destination of store are different.So please help for that.My code like as...
DataTable dtlocal = new DataTable();
        dtlocal = (DataTable)GridView1.DataSource;
        dtlocal.TableName = "LOCAL";
        ds.Tables.Add(dtlocal);
        string qry = "INSERT INTO EMP1 VALUES(?,?,?,?)";
        conn.Open();
        OracleCommand ocmd = new OracleCommand(qry, conn);
        foreach (DataRow dtr in ds.dtlocal["LOCAL"].Rows)
            foreach (DataColumn dcl in ds.dtlocal["LOCAL"].Columns)
        {
                //assigning values for parameters
        }

Vish

What problems did you get? You have not provided any errors or descriptions of the problems. Perhaps showing us the code where you "//assigning values for parameters " would be helpful to obtaining an answer.

-Peter
peterlanoie.blog

My code for assigning the value as follows..
 ocmd.Parameters.Add(":p1", OracleType.Number).Value = Convert.ToInt32(dtr[dcl]);
            ocmd.Parameters.Add(":p2", OracleType.VarChar).Value = dtr[dcl];
            ocmd.Parameters.Add(":p3", OracleType.Number).Value = Convert.ToInt32(dtr[dcl]);
            ocmd.Parameters.Add(":p4", OracleType.Number).Value = Convert.ToInt32(dtr[dcl]);
            ocmd.ExecuteNonQuery();
        }
When i iterates through datatable record it give me error as Error "System.Data.DataSet' does not contain a definition for 'dtlocal'"
Plz help me to solve it.

Vish

Here you name the table LOCAL:

   dtlocal.TableName = "LOCAL";

But you are trying to use a property to get at it:

   ds.dtlocal["LOCAL"]

I think what you want is this:

   ds.Tables["LOCAL"]


-Peter
peterlanoie.blog