protected void Page_Load(object sender, EventArgs e) { dbConn = new DbConn(); SQL = "SELECT * FROM tblRoleAccess"; ds = new DataSet(); ds = dbConn.createDataSet(SQL); dt = new DataTable(); dt = ds.Tables[0]; //dt.Rows.Count.ToString(); Response.Write(dt.Rows.Count.ToString() + "<br/>"); for (int i = 0; i < dt.Rows.Count; i++) { Response.Write("INSERT INTO tblRoleAccess VALUES('" + dt.Rows[i][0].ToString() + "', '" + dt.Rows[i][1].ToString() + "', '" + dt.Rows[i][2].ToString() + "')<br/>"); } }