void me ()
{
string connectionString = ConfigurationManager.ConnectionStrings["myconstr"].ToString();
SqlConnection connection = new SqlConnection(connectionString);
DataSet ds = new DataSet();
string sql = "INSERT INTO clients (code, sub_code, client_name, cat, email, address," +
"contact_phone, contact_phone2, active_phone, company_id_fk," +
" procdure_id_fk, service_id_fk, procdure_date, user_id_fk," +
" creation_date, transfer_date )" +
"SELECT code, sub_code, client_name, cat, email, address," +
" contact_phone, contact_phone2, active_phone, company_id_fk," +
" procdure_id_fk, service_id_fk, procdure_date, user_id_fk," +
"creation_date, transfer_date" +
" FROM archive_clients WHERE code NOT IN (SELECT code FROM clients )";
try
{
connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
adapter.Fill(ds);
Response.Write( "Number of rows " + ds.Tables[0].Rows.Count.ToString());
connection.Close();
}
catch (Exception ex)
{
Response.Write( "Error in execution " + ex.ToString());
}
}
erorr is canot find table 0